How Paranoid Are You About Backups?
Sometimes just running a backup isn't enough, especially in this era of ransomware. Steve has a few thoughts on backup strategies and recovery skills.
2021-08-09
435 reads
Editorials
Celebrating Lives
Steve is asking for others to contribute to the sqlmemorial site for our #sqlfamily.
2021-08-06
278 reads
Do as I say, not as I do
Steve wishes that Microsoft would follow some of their own advice on SQL Server development in their other software.
2021-08-04
267 reads
Interconnected Temp Files
Links between systems can become a problem if an issue in one system affects the others.
2021-08-02
288 reads
Deploying SQL Server Automatically
I've had to install SQL Server many times over the years. Often it has felt that most of these installs were one-offs, a dev server, a new QA instance, a production server for a brand new application. A few times I've had to recover from disaster, including restoring master, but often, I just installed SQL […]
2021-07-31
479 reads
Your MTTR
There are a lot of metrics you can track and many ways to use them to improve how you build and manage software. Steve has a few thoughts on MTTR and similar metrics.
2021-07-30
344 reads
Leading without Managing
Learning to lead is a valued skill to have, and you can do this no matter what your role. You don't need to be a manager to become a leader.
2021-07-28
290 reads
Do You Have ALL the YAML?
There are lots of data exchange formats, and one of them that has become popular is YAML. However, are you sure you have the entire file?
2021-07-26
1,396 reads
Define All The Steps Up Front
After 23 years in one place, I'm pulling up stakes and moving. We're selling our house in one state in the US and we're buying a house in another state about half a continent away. To say it's a stressful and exhausting process is an understatement. The worst part is that no one has defined […]
2021-07-24
207 reads
How Often Do You Patch?
Patching is a chore that any system administrator needs to deal with. As SQL Server 2016 moves out of mainstream support, Steve asks if you have a plan and how often you ensure systems are patched.
2021-07-23
273 reads
Blogs
Microsoft announces new cybersecurity AI multi-model
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
DBCC CHECKDB Limits III
Comments posted to this topic are about the item DBCC CHECKDB Limits III
CROSS APPLY Fundamentals: Part 1
Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1
Question of the Day
DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers