MOAR sp_DatabaseRestore

vaultboy_sick
Testing…Someone’s gotta do it

people are talking about me again… o_o

However instead of plots to overthrow my kingdom, or curses that would cause me to eat pie and lose weight, or saying my name three times in a mirror so that I become summoned and forced to bust a cap…instead of stuff like THAT…they are props for working on some code!

I made some new changes and fixed an embarrassing bug in my previous contribution for the sp_DatabaseRestore.  In an ideal world I would just skip the part of this post where I point out my mistakes and explain what they were, however Github does a great job at keeping history so…

Continue reading “MOAR sp_DatabaseRestore”

Automated Restore Fun (ARF)

2197863-walker_of_the_mojave
Script it…then walk away…

Over the last a couple of weeks I started reviewing an automated restore solution I had been playing around with for a couple years.  RedGate SQL Backup had thrown some errors and since we couldn’t go without backups while waiting on RedGate support we decided to move ALL backup operations to Ola Hallengren’s scripts.  We also decided to ditch RedGate because they sent us back a list of reported bugs we had submitted and told us they aren’t going to fix it. So in other words “despite the fact that you have multiple licenses of multiple softwares across many servers, we feel your issues as a customer aren’t important to us as a software company.” With that we decided to roll our own solutions that we can customize for our environment…

Continue reading “Automated Restore Fun (ARF)”

Automation for DBAs – PerfMon Presage

15_The_Superhuman_GambitI”m a pretty big fan of PerfMon. Most seasoned DBAs are adept with ready it and scheduling out collector sets in order to grab graphically aesthetic globs (GAGs) of information. I’m also a pretty big fan of Alerts. Most of you (if not all) should be familiar with how and when to setup alerts on SQL Server, if not then review this article from Brent Ozar and get alerting!

Continue reading “Automation for DBAs – PerfMon Presage”