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.
2023-06-20
119 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
119 reads
If you under promise and overdeliver then you will always have happy clients.
2023-06-19
19 reads
Here we look at a common query "anti-pattern" that can create performance problems - and how you work around it.
2023-06-14
373 reads
Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and talked out new feature. In this post we'll just take a brief look at it,...
2023-06-14 (first published: 2023-05-31)
582 reads
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...
2023-06-13
17 reads
In SQL Server you can also compress your encrypted backups. Unlike TDE this has been possible with Backup Encryption since the feature was first made available, and there have...
2023-06-12 (first published: 2023-05-24)
335 reads
There is a scenario I have seen again and again. A company has developed a nice piece of software which many clients are running with happily. Then along comes...
2023-06-12
11 reads
Script to identify the most expensive queries on your database server using the Query Store DMVs. This allows you to look at data from a specific time frame, as...
2023-06-07
119 reads
In this post we're going to go through the steps to set up Always Encrypted and create an encrypted column. As with my last post we're looking at the...
2023-06-06
24 reads
Unlike TDE, there is some extra CPU overhead when you take an encrypted backup as the data has to be encrypted before being written to disk – whereas with...
2023-06-05 (first published: 2023-05-22)
241 reads
In the realm of data science, SQL (Structured Query Language) reigns supreme. It's your...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
The below code works for backup files only from local drives. When replaced with...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers