Huge thanks to everyone who responded to my invitation to blog on Encryption and Data Protection for this month’s T-SQL Tuesday. I got what I hoped for, which was...
2023-10-30 (first published: 2023-10-17)
270 reads
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any doubt that’s for October 2023, I’m posting this invitation a little early as I got...
2023-09-29
13 reads
Having up to date statistics is vital for getting the best performance out of your queries. Even though SQL Server automatically updates statistics in the background for you, you...
2023-09-06
13 reads
I’ve mentioned previously how not having up to date statistics can cause problems in query performance. This post looks at something called the Ascending Key Problem which can badly...
2023-07-21
80 reads
In previous posts we've looked at a number of aspects of Always Encrypted and how it works. I think it's very useful to understand how it actually works in...
2023-07-03 (first published: 2023-06-15)
231 reads
Statistics objects are important for allowing the SQL Server Optimizer to make good estimates and form efficient execution plans. Related to that it's useful for us to understand when...
2023-06-28
129 reads
Parameter Sensitive Plan (PSP) optimization is a new feature in SQL Server 2022 that aims to improve the performance of parameterized queries. It is part of the Intelligent Query...
2023-06-26 (first published: 2023-06-08)
276 reads
Statistics are vitally important in allowing SQL Server to find the most efficient way to execute your queries. In this post we learn more about them, what they are...
2023-06-21
259 reads
Always Encrypted was a new encryption feature added to SQL Server with the 2016 version of the product. Initially it was just available in enterprise edition, but from SQL...
2023-06-21 (first published: 2023-06-05)
308 reads
In this short post we look at the ability to be able to have (or not) indexes on columns encrypted using Always Encrypted.
2023-06-20
116 reads
By Steve Jones
As I’ve aged, I find myself struggling to read many things in my life....
For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a pretty simple...
By Kevin3NF
In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles...
Comments posted to this topic are about the item The Fake Speakers
Comments posted to this topic are about the item Stairway to Database DevOps Level...
The installation of SQL Server 2008 R2 Express on a virtual machine takes around...
Ask SSC