|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Breaking Dynamic Data Masking | |
I have a table where there is a date of birth column (dob) with the date datatype that is protected by Dynamic Data Masking and the default mask in SQL Server 2019. If this non-privileged (without the UNMASK permission) user runs this query and there is a row with this date in it, what is returned?
SELECT dob FROM dbo.DDMTest AS dt WHERE dob = '1967-04-01' GO | |
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) |
ADF Mapping Data Flow with Multiple Inputs I am working in Azure Data Factory (ADF) and I am building a mapping data flow. I have two inputs, and which of these is NOT a valid way to work with the data in those inputs? In other words, how can I relate the data these two inputs together? Answer: NOT EXISTS Explanation: As you can see in the documentation, I can handle multiple inputs in the following ways:
Not Exists is not an option. Ref: Managing the mapping data flow graph - https://docs.microsoft.com/en-us/azure/data-factory/concepts-data-flow-manage-graph |
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 |
JSON String invalid - Hi All, Have query regarding a nested array in JSON file, previously raised a ticket on how to retrieve the data but due to the number of JSON files involved using JSON_VALUE is leading to poor performance. Decided to try to name the array myself in the JSON string but coming across problems, below is […] |
SQL Server 2016 - Administration |
Login failed for user windows user and SQL user - Hi. windows authentication administrator and SQL authentication SQL user both are not able to login, please suggest How to login SQL instance? "sa" account was disabled after SQL server installed. >sqlcmd -S localhost -U sa -P Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Login failed for user 'sa'.. >sqlcmd -S localhost […] |
Administration - SQL Server 2014 |
Connect SQL Server using local IP - Dears ! Good Day ! I have using SQL Server. I write the server name for login as "192.168.10.2\SQLSRVR2008" but I want to use server name only as "192.168.10.2" How can I do so ? Anybody plz help me in this matter. |
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 […] |
SQL Server 2019 - Administration |
Minimum Permissions for Conflict Viewer - Hi, I'm looking to find the minimum permissions necessary to give a user access to the Replication Conflict Viewer and allow user to view and resolve conflicts in Management Studio. |
Possible conflict bug in Merge replication. - I'm running into a strange problem. Example A change is made on the publisher, when it's moved to the subscriber it generates a conflict and is rolled back. However nothing was changed on the subscriber, it seems to be an erroneous conflict and possible bug. Has anyone else seen this, or have any guidance? |
SQL Server 2019 - Development |
Simple Query Question Help - Hello all, I am stuck on something that should be very easy but struggling on this. I have the following records in a table: Customers CustomerId MatchTypeId 1 1000 1 […] |
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. |
Working with Oracle |
backup database in SQL Server VS Oracle - I would like to know the difference of full back up between Oracle and SQL server. In SQL server, for a medium size database, If I do a full backup, then I can use to restore to another database that is exactly the same as the original database. I don't need to do online transaction […] |
Amazon AWS and other cloud vendors |
Taking both snapshots and AMIs for backup? - Our architect is set on taking both AMIs and snapshots at a regular interval. His reasoning is that in case the snapshots don’t work, he wants another method to fall back to. I’ve been arguing against this as AMIs are essentially snapshots at their core (minus the drive mappings and permissions) and this would greatly […] |
General Cloud Computing Questions |
Programming skills for learning cloud computing - What programming concepts are needed for a career in cloud computing for a cloud engineer or cloud architect role? Or does it depend? |
SSRS 2014 |
Dividing Integers behaviour - I am trying to find documentation or an explanation as to the behaviour when dividing one integer by another . Take my code as example: declare @WeightInGrams int set @WeightInGrams = 164 select @WeightInGrams, @WeightInGrams/1000 AS [NoCast], CAST(@WeightInGrams AS decimal(18,3))/1000 AS [CastColumnOnly], @WeightInGrams / CAST(1000 AS decimal(18,3)) AS [CastValueOnly], CAST(@WeightInGrams AS decimal(18,3)) / CAST(1000 AS […] |
Integration Services |
SCD in SSIS - Hello, I am new to ssis and i am a little bit confused about the SCD_Start_Date and SCD_End_Date when we use the SCD dimension wizard. on many examples that i have searched online people always use the "system start time" or "system container " start time. but i am implementing a data warehouse from a […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |