In this episode of Dear SQL DBA, I talk about how Redgate runs “Down Tools Week,” what I’m working on as part of the project, and how this has inspired me to approach creative work in the future.
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
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 that even the spelling and capitalization of the name is a topic of disagreement.
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.