Setting up Transparent Data Encryption (TDE)
Transparent Data Encryption (TDE) is one of the easiest ways of encrypting your data at rest. In my prevous post we looked at what TDE is and how it...
2021-04-12
266 reads
Transparent Data Encryption (TDE) is one of the easiest ways of encrypting your data at rest. In my prevous post we looked at what TDE is and how it...
2021-04-12
266 reads
In this post we look at Transparent Data Encryption (TDE) in SQL Server. What it is - and how it works.
2021-04-07 (first published: 2021-03-29)
400 reads
I talked a few posts ago about Automatic Sample Sizes for Statistics Updates. From SQL 2016 CU4 we've been able to override that. You can manually update a statistics...
2021-03-11 (first published: 2021-03-09)
363 reads
Use trace flag 8666 to view the statistics objects that the optimizer used to generate your execution plan.
2021-03-01
15 reads
Looking at how SQL Server samples your data when doing auto-stats updates. Part of a series on understanding statistics, to help you achieve optimal performance of your queries on...
2021-03-02 (first published: 2021-02-24)
324 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...
2021-02-16
214 reads
If you work in the world of SQL Server you’ve almost certainly heard of dbatools. For those who haven’t, it’s an open source PowerShell module for automating literally hundreds...
2021-04-20 (first published: 2021-02-15)
421 reads
For most of us in the Northern Hemisphere the clocks go foward next month and we get to look forward to longer, sunnier evenings. This post is a reminder...
2021-02-17 (first published: 2021-02-10)
441 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...
2021-02-09
165 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...
2021-03-24 (first published: 2021-02-01)
383 reads
By James Serra
There were a number of data platform announcements at Microsoft Build yesterday that I...
Information — in the form of data — usually stored as binary 1s and...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
The powers that be have commanded that we implement data classification because... well, to...
Is there any script task in SSIS to find the zip files under each...