SQL Homework – January 2017 – Inspect an Execution Plan
It’s a new year and yet education never ends. So this month let’s take a look at an important part...
2018-01-10 (first published: 2018-01-03)
2,499 reads
It’s a new year and yet education never ends. So this month let’s take a look at an important part...
2018-01-10 (first published: 2018-01-03)
2,499 reads
It’s the first T-SQL Tuesday of the year! Arun Sirpal (b/t) is our host this month. Thanks, Arun! The subject...
2018-01-09
307 reads
T-SQL Tuesday. Each month a different blogger hosts Adam Machanic’s (b/t) blog party. The host comes up with a topic...
2018-01-01 (first published: 2017-12-12)
1,697 reads
I was doing some research on impersonation the other day, and among other things, I ran across a forum question...
2017-12-27
797 reads
Happy holidays everyone! Ok, this isn’t even remotely related to SQL Server but it sounded fun. I found someone playing...
2017-12-20
964 reads
SQL Server login ids may not be the most secure thing in the world but they are likely to be...
2017-12-18 (first published: 2017-12-06)
1,723 reads
tl;dr: When using a windows or active directory authenticated id you do not put the username or password into your...
2017-12-18
709 reads
One of the really cool things about the cloud is how quickly you can spin up a new machine to...
2017-12-14
527 reads
Doing a database restore may not be the most common task a database professional will ever do, but it’s a...
2017-12-07 (first published: 2017-11-27)
7,129 reads
Last homework of the year. Last month was to create a view. This month it’s time to take a look...
2017-12-04
316 reads
Most apps that call an LLM send every request to the same model. That...
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
Hello everyone , I am planning to migrate a database from SQL Server 2014...
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Comments posted to this topic are about the item Another Model, More Data Loss
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers