ONLINE operations in SQL Server were simple to understand for years — we got ONLINE index rebuilds in SQL Server 2005. That was it for a while. Then, things got more complicated: we got more types of indexes. We got ONLINE options for schema changes that don’t involve indexes. We got more options for managing things like blocking, because online operations are really only mostly online — generally there’s going to be at least a short period where an exclusive lock is needed to update metadata. We now have some RESUMABLE operations coming in, too, for those big operations that are tough to handle. Along the way, I fell behind. Because these features have steadily come out over a period of time, my brain simply didn’t register them all, or possibly I missed seeing them amid other announcements. Having realized this, I did a little inventory: here’s my rundown of…

Chocolatey is a package manager that helps you install, upgrade, and uninstall packages (applications) on Windows quickly and easily from the command line. Spoilers: The command I show in the video is simply: choco install sqltoolbelt Fun fact, you can also upgrade: choco upgrade sqltoolbeltAnd uninstall: choco uninstall sqltoolbelt The rest of the 6.5 minutes is about related tools you may want to install, and why this is all needed. Links from the video — check these out while you watch https://chocolatey.org/products#fosshttps://chocolatey.org/packages/SqlToolbelt Gists with sample commands for useful installs for Microsoft Data Platform database folks: Aaron Nelson’s ListKendra’s List (forked from Aaron’s to track my own preferences)Rob Sewell’s List Video explaining Chocolatey and showing how to install SQL Toolbelt (6.5 minutes) Transcript Hello and welcome to this live stream episode. My name is Kendra Little and I am a DevOps Advocate at Redgate. Today I’m going to show you something…

I created a cheat sheet for the Git Command Line Interface to go along with my Git tutorial for SQL Change Automation video. I find the Git CLI to be very friendly and easier to learn than a GUI interface. Setup Download git CLI: https://git-scm.com/downloads git clone <url> Clone a remote repo (maybe an empty one) into your local directory. Ref. git init If not cloning, you might initialize a fresh repo locally. Ref. .gitignore file I often show people how to use Git with Redgate’s SQL Change Automation. For that tool, you can download and unzip the .gitignore file to the folder where your .sqlproj file lives: https://documentation.red-gate.com/display/sca4/Version+control. Another great resource for figuring out what to ignore is http://gitignore.io/ Essentials git status Lists modified or added files, with status as to whether they are staged. Ref. git add . Stages all modified or added files. You must stage before…