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 ...

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 ...

I have a test server hosting several sites using SQL Server Express and SQL Management Studio Express. I've seen one site have an occasional issue where queries to a particular table (the ...