One big gotcha that teams often encounter when automating deployments for databases is that it’s difficult (or sometimes impossible) to ensure that all changes to the production database are performed through the automation pipeline.
These out-of-band changes case the production database to “drift” away from the schema as defined in version control.
SQL Server’s Developer Edition installs with a different default network protocol configuration than Standard Edition and Enterprise Edition.
Fixing this has gotten more complicated because it’s become common for the SQL Server Configuration Manager to not be installed on a developer’s workstation in an easily accessible way.
I’m not an expert on collation in SQL Server, but there are a few important facts which I’ve had to learn the hard way. In this episode I share the basics, along with helpful resources to learn more.
No matter what I write in this post, some of y’all are going to tell me I’m wrong. That’s inevitable, because I’m writing about tempdb: a database so complex and mysterious in SQL Server, that even the spelling and capitalization of the database name is a topic of great disagreement.
You might think, “This is easy, just check Microsoft’s documentation to find the answer.”
I’m excited to begin moving over courses from SQL Workbooks and making the material available here. The first course up for grabs is The Dirty Secrets of NOLOCK.
I’m working on a project where it’s useful to automate environment setup and teardown for testing some devops deployment scenarios for databases using transactional replication.
Thanks to the support of Redgate, I’ve launched a new course which teaches you the basics of T-SQL. The course is totally free, no logins required: we don’t even ask for the email address.
The course is here:
https://www.red-gate.com/hub/university/courses/t-sql/tsql-for-beginners
Each week has an embedded video for the course, along with a link to the syllabus and scripts. The videos also have a timeline in case you wish to jump to a particular part of the discussion.
Copyright (c) 2025, Catalyze SQL, LLC; all rights reserved. Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.