In our last post in this series, I talked about why you should be using Ola Hallengren's maintenance script for backups and sp_DatabaseRestore for faster restores. These two tools have implications for how you build, back up, recover, and fail over your SQL Server.
There's a saying in the cloud: treat your servers like cattle, not like pets.
When I first started out as a SQL Server DBA, I thought things were going well as long as the backup jobs ran successfully. I'd go into SQL Server Agent every now and then, make sure they were still running, and ... that was the end of it. I figured if disaster ever struck, I'd just do a restore. How hard could it be? I was missing the entire point.
At your company, walk into the VP of Sales's office and ask them how many salespeople they have. NO, I mean, don't actually DO that, because he's going to ask you why the sales app is so slow. But I mean, imagine if you COULD walk into his office and ask him that. I bet…
Foreword: 8 years ago, I launched an email series with a 6-Month DBA Training Plan. I sent one email per week, bringing people up to speed on the most important topics that nobody taught 'em along the way. It's hard to believe it's been 8 years! This month, I'm revisiting the emails, updating their content,…
