Video walkthrough of renaming or “flipping” databases to minimize down time during a refresh. Most commonly when moving a copy from prod to dev.
My Pluralsight courses for new SQL Server DBAs
Thanks for reading!
video
Getting Started With SQL Server Maintenance
My second Pluralsight course for Junior and Accidental DBAs is finally released!
This course covers many of the SQL Server Maintenance items I do every day, week, and month for my servers:
My first course is a good (but not required) starter, covering history, installation, some configuration and the SQL Server tools:
I’d love to get your opinions, questions and ratings for either or both of these. I’m already planning the next one!
Pluralsight courses require a paid subscription.
If you want some FREE training, check out my YouTube channel.
Thanks for watching!
SQL Server Identity Skipping
My Pluralsight course for new SQL Server DBAs
SQL Server may skip 1000 numbers on an Identity column if the server crashes. Here’s why:
Too long, didn’t watch version:
SQL Caches 1000 numbers at a time to boost insert performance. In a crash and recovery, those numbers are gone.
SQL 2016 and earlier – use instance-wide trace flag 272 to turn off this behavior (performance might suffer).
SQL 2017 and later – its now a database scoped config item:
use MyDB; go ALTER DATABASE SCOPED CONFIGURATION SET IDENTITY_CACHE = OFF GO
Video shows a walk-through of before and after each fix, plus a “Two guys walk into a bar” joke when I disappeared to troubleshoot a broken demo…
Thanks for reading and/or watching!
My Pluralsight course for new DBAs
Unboxing Azure Data Studio
Watch me embarrass myself by completely failing to find things in my first look at ADS:
Comments? Put them on the video…but be nice 🙂
Thanks for watching!
Video: SQL Server HA/DR Overview
This is meant to be a high-level overview, not an exhaustive setup guide. I skip over some relevant bits so the main points don’t get buried.
In my DBA Fundamentals pre-conference, we spend a good hour going over the various High Availability and Disaster Recovery options available in SQL Server. From simple Backup/Restore up to Distributed Availability Groups.
This video is a more succinct version of that conversation. Enjoy!
If you have questions or comments, please add them in the YouTube comments, so I’ll see them more quickly.
Thanks for reading!
Video: Moving SQL Server Data Files
If you are like me, when you look at certain pieces of SQL Server documentation the sheer volume of information can be a little overwhelming.
ALTER DATABASE is one of those documents, due to the number of things that can be ALTERed. The documentation has been improved since I was a young newbie DBA, but still…
Anyway, here is a simple video showing me moving a LOG file from my D drive to the C drive:
If you have comments or questions, please leave them on the video, or ping me on Twitter.
Thanks for watching!