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
267 reads
Matthew McGiffen DBA
What is Transparent Data Encryption?
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)
402 reads
Setting the Sample Rate for Automatic Statistics updates
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)
365 reads
Viewing the Statistics Objects Used to Create an Execution Plan
Use trace flag 8666 to view the statistics objects that the optimizer used to generate your execution plan.
2021-03-01
15 reads
Automatic Sample Sizes for Statistics Updates
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)
326 reads
Manually updating Statistics
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
Book Review: Learn dbatools in a Month of Lunches
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)
427 reads
Reminder: SQL Server Agent and the clocks going forward
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
Statistics and the Ascending Key Problem
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
168 reads
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...
2021-03-24 (first published: 2021-02-01)
384 reads
Blogs
Being a script magpie
Last month (I ran just a little bit late writing this, it was meant...
Community Tools Month 2022 - dbatools
By alevyinroc
The Prompt In July, Brent Ozar (blog | twitter) asked us to make September...
Storytelling with Data – Enertia User Conference 2022
By DataOnWheels
Thank you to everyone who attended my session at the Enertia User Conference in...
Forums
Missing weekend data to Zero
Hi All, I have a requirement that if there is no weekend data then...
Alight Motion is safe for users?
Description: Alight Motion edits application that allows you to edit videos in the Android smartphone....
How to calculate orders historically, during month
Good Morning There, CREATE TABLE Customers ( CID int NOT NULL PRIMARY KEY, GroupName...
Ask SSC