For me, I want to see persisted data masking in SQL Server. Right now it supports Dynamic Data Masking, which applies a mask just as the data is returned by a query, and that's a great start.

SQL Server Design: No Code Necessary . Data pro Thomas LaRock dives into the intricacies of SQL Server design, emphasizing the power of smart datatype decisions. By Gladys Rama, Chris Paoli; 09/05 ...

How to Build a Query String in T-SQL. ... Click "Microsoft SQL Server," then click "SQL Management Studio" to open the database programming software that comes with your ... and software design.

In SQL Server 2017, when the query optimizer encounters code with a multi-statement TVF, the query optimizer will pause optimization, execute the TVF subtree to get a very accurate cardinality ...

However, there are any number of queries in any application that SQL Server may never see again (at least in, for example, the next 24 hours). The plans for these "one-time" queries are taking up ...