Laden...
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Full Azure SQL Database Backup Frequency | |
How often does the Azure platform run a full backup of your Azure SQL Database or Managed Instance databases? | |
Think you know the answer? Click here, and find out if you are right. |
Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
Exporting Masked Data I have some data that is protected by a Dynamic Data Mask. If my user (Joe_User) queries this data, they see this: This user tries to execute this code from a command line: sqlcmd -S Aristotle -U Joe_User -d ddmtest -Q "select ProductName, UnitPrice from orderdetail where orderid = 4" -o order4.txtWhat will they see in the output file? Answer: The same data that they see in SSMS Explanation: Dynamic Data Masking is unaffected by how the user queries the data. If they do not have the Unmask permission, they will see the same results in SSMS and SQLCMD and all other client applications. Ref: Dynamic Data Masking - https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-ver15 Moving Dynamic Data Masked Data to New Locations - Step 5 of the Stairway to Dynamic Data Masking - https://www.sqlservercentral.com/steps/moving-dynamic-data-masked-data-to-new-locations |
Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Development |
Calculate field in SQL statement - How we can achive from sql for balance field. I have attacted png file to expain. I will try my best to expain here For first month balance is 4476.55 - 2867.00 = 1609.55 For second month balance is 6468.61 - ( first month of balance which is 1609.55 - trans out which is 2997.49) […] |
SQL Server 2016 - Administration |
Extract Images from database - Hello! I am exporting images from database to the network path using SSIS - Export Column, I have two fields in the database that have images, this works as expected as long as both the fields have image. But sometimes one of the field might have image or not, how to use export Column in […] |
SQL Server 2016 - Development and T-SQL |
Converting XML to SQL - My company uses a reporting tool that basically sits on top of SQL Server (and generally makes my life miserable, but that's another post...). Anyway, one thing this software does is provides a GUI for "business users" (non-SQL-savvy users) to create SQL queries. But internally it actually stores those queries as XML, which it then […] |
Administration - SQL Server 2014 |
How is he seeing all the databases - Hi, I have a user that doesn't have access to a database but yet he can see it and query it in SSMS. He is not a member of sysadmin roles or any other roles (there are no custom roles). I disabled his windows auth account and he was then unable to log in - […] |
Development - SQL Server 2014 |
T-SQL Pivot Question - I am familiar with T-SQL's Pivot Operator, I've used it to convert rows of financial data into columns like one would find in a 12 Month Income Statement. What I've never tried before and am not sure if its even possible is using Pivot when the end results will have 2 (not just 1) set […] |
case when with count ms sql - how can I achieve this result below? | id | id_status | rate | | --- | ----------- | ------ | | 25 | X |62.5% | | 15 | Y |37.5% | having tried this SELECT COUNT(tab.id) AS id, tab.status AS […] |
SQL Server 2019 - Administration |
Distributed AG - Hello, Please I have question about distributed AG. In normal AG is redo thread per database for sync. Is this same also for Distributed AG (I think yes) or is somehow together in one? I cannot find some good article where is written. Thanks |
SQL Server 2019 - Development |
simple sp - Hi I have 2 tables in 2 different DBs, I need to have all the rows of the second table in second DB when a filed(column)is "100" in the first table in the first DB. Should I use Trigger, If Yes, Would you please tell me how? Thank you. |
SSMS removed debugging features so I am debugging in VS. Fetch takes like 30 sec - First I can't stress how angry I am with Microsoft for removing debugging from SSMS. Second, I am using Visual Studio to debug now. When I build a cursor, the fetch command takes about 30 seconds to complete. Does anyone know why? Thanks. |
Does Server Collation Sequence overide Database Collation Sequence for VS publis - Hi there We have a Server where the collation Sequence has been set to Latin1_General_CS_AS (Case Sensitivity) In this server , we have a database for which the Colllation Sequence has been set to Latin1_General_CI_AS (Case Insensitive) Now Ive been trying to update the database in question from a project in Visual Studio but its […] |
Flattening of hierarchy - I was wondering if anyone has any sql code samples where they have had to flatten a hierarchy of nodes without the use of a CTE. For example, consider an organizational hierarchy tree with the CEO is at the top and all levels of management down to the lowest levels. So, if the structure of […] |
SSIS Error when trying to configure Connection Manager in a SQL Server Agent Job - I've exported some SSIS Packages from one environment to another. I created a sql server agent job to run the package and I want to modify the Configuration Parameters to point to the SQL Server that I'm now trying to run this package. I'm getting the following error: The property 'ParameterName' contains invalid characters as […] |
Amazon AWS and other cloud vendors |
AWS Lambda provisioned concurrency vs EC2 - I am looking to host an intensive computation app on AWS, and can't afford to wait for Lambda cold starts. The app needs to be able to handle up to 300 users without losing in performances, but it won't be having 300 users at all time, so it needs to be able to scale up […] |
Powershell |
The term 'New-SqlColumnEncryptionSettings' is not recognized as the name of a cm - Created powershell script using SSMS to setup Always Encrypted on a column. Getting this error, "The term 'New-SqlColumnEncryptionSettings' is not recognized as the name of a cmdlet, function, script file, or operable program", when I try to run it. I do have Import-Module SqlServer right before the $encryptionChanges and I have installed the SqlServer Module […] |
Integration Services |
SSDT installation fails with error message incorrect function(0x8007001) - I have installed SQL Server 2019. Trying to install SSDT 2017. It throws error message SSDT installation fails with error message incorrect function(0x8007001). please let me know how can resolve this |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Laden...
Laden...
© 2025