-
What are Statistics in SQL Server?
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 and how they are used. Read more
-
Indexes and Statistics with Always Encrypted
In this short post we look at the ability to be able to have (or not) indexes on columns encrypted using Always Encrypted. Read more
-
Under Promise and Overdeliver
If you under promise and overdeliver then you will always have happy clients. Read more
-
What Happens in the Background when Executing Queries with Always Encrypted
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 practice, so in this post we’re going to look at what happens in the background when you execute a query. Read more
-
Avoid “Constants” in T-SQL
Here we look at a common query “anti-pattern” that can create performance problems – and how you work around it. Read more
-
Executing Queries Using Always Encrypted
In this post we’ll look at how you interact with data that is encrypted using Always Encrypted. The examples here will show how you run queries from SSMS, in later posts we’ll look at stored procedures and application code – as well as what happens in the background when you execute a query. For these Read more
