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 that even the spelling and capitalization of the name is a topic of disagreement.
Redgate Evangelist YouTube Channel: Tutorials on Database DevOps -New videos each week – Watch
Redgate Streamed – a 3 day free virtual conference on the Microsoft Data Platform – Watch here
Level Up Your Deployments for SQL Source Control – Watch
Key findings from the 2020 State of Database DevOps Report – Watch
Managing and Automating Test Datasets for DevOps with Jeffrey Palermo – Watch
How to Make Your 2020 Monitoring Strategy a Success, with BMW’s Tony Maddonna – Watch
Essential Practices for High Performing Database DevOps Teams – Watch
Fast and Reliable Development with Redgate Solutions for SQL Server – Watch
Implementing Data Masking for NIST Compliance – 1 hour – Watch
How Developers and DBAs Collaborate in a DevOps World – 40 minutes – Watch
How DevOps Keeps DBAs Safe from Being Automated Out of a Job – 1 hour – Watch
DevOps: What, who, why and how? – 1 hour – Watch
Can This Team Succeed at DevOps? Panel discussion – 1 hour – Watch
Learning Git can be daunting for DBAs. In this 20 minute episode, I discuss why learning a VCS is necessary for DBAs, then give three tips on scoping your project, choosing the right tools, and making sure the project is successful.
I’m not at all a fan of “stacking” multiple SQL Server Instances into one Windows Installation in production, but it’s helpful for some testing scenarios.
In this post I explain how to automate this with Chocolatey and PowerShell.