Month: November 2021

sql server table corruption

Schedule DBCC CHECKDB

Do you schedule DBCC CHECKDB for all of your important databases? Scheduling database integrity checks ranks right up there with backing up your databases when it comes to glamorous activities in the life of a DBA. That is to say, it’s not glamorous at all. Integrity checks don’t bring the same internal swagger as say…
Read more

sql server details matter

Don’t Sweat the Small Stuff, Except with SQL Server

Don’t sweat the small stuff, they say. That’s good advice. Much of the time. But with SQL Server, the small stuff is worth sweating. In fact, the small stuff can be big. Letting the small stuff go In life, the small stuff can weigh you down. Worrying about things that don’t really matter can strip…
Read more

SQL Server host folder

How to Use a Docker Host Folder for a SQL Server Database

In Getting Started with SQL Server in a Docker Container, I shared my SQL Server Docker container configuration. I described how to copy database backup files from your host to the container and then restore them in the container. That’s my usual approach. But what if you wanted the database to reside on the host…
Read more