Recently Microsoft quietly let us know that TDE (Transparent Data Encryption) will be available in the Standard Edition of SQL Server 2019. If you don’t follow SQL topics on...
2019-11-12 (first published: 2019-11-05)
2,560 reads
No, the answer isn’t because you’re a DBA. This isn’t a technical post about databases, but rather a discussion of a statistical paradox that I read about recently. Statistics...
2019-10-01
24 reads
If you’ve read about the Accelerated Database Recovery feature in SQL Server 2019 you could be forgiven for thinking it’s just about speeding up database recovery time in case...
2019-10-09 (first published: 2019-09-25)
770 reads
This is something I touched on back in 2017 a little after the Live Query Statistics feature was introduced with SQL 2016, but I was using the functionality this...
2019-09-26 (first published: 2019-09-18)
575 reads
This month for T-SQL Tuesday Kevin Chant asks us what our fantasy SQL feature would be. https://www.kevinrchant.com/2019/09/03/t-sql-tuesday-118-your-fantasy-sql-feature/ I think it’s appropriate to give a shout-out to Microsoft at this...
2019-09-11
62 reads
There are so many options for running SQL Server now. It can feel a little intimidating. You’ve spent years gaining experience with SQL running on Windows Server. On bare...
2019-09-03 (first published: 2019-08-22)
497 reads
One of the powerful aspects of Query Store is the ability to directly query the DMVs for details of historical executions and performance. A key view for this is...
2019-09-04 (first published: 2019-08-21)
230 reads
I had a server that looked like it had been suffering from memory contention. I wanted to see what queries were being run that had high memory requirements. The...
2019-08-14 (first published: 2019-07-31)
588 reads
Last week a question came up about adding a column to a table, and giving that column a default constraint. Would that default value be assigned to all existing...
2019-07-24 (first published: 2019-07-16)
406 reads
Here’s my round-up for this month’s T-SQL Tuesday. Thanks to everyone who contributed last week. It was great reading your posts and seeing the different ways you interpreted the...
2019-05-21
82 reads
By Steve Jones
Last week went a little crazy, and I learned something: don’t post a Zoom...
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
By kleegeek
Resource pools are used to hierarchically partition available CPU and memory resources, and are...
Hi all, My need is to insert random value from predefined list of possible...
The University of Leeds
Today’s tip is to Immerse yourself in a new book, TV show, or podcast....
Ask SSC