Generic Backups
I support developers. In our dev/QA environment, people add, delete, and change the recovery model of databases all the time without telling me. How do I keep track of which databases need to be backed up? I don’t. I back up everything. Master has information...Thanksgiving Gluttony
Yum, Nagios gluttony! I’m donating Nagios monitoring to a couple of nonprofits, and this brings up how Nagios configurations grow. In short, you learn over time what you need to keep an eye on. For example: On one nonprofit, someone forgot to renew the domain...Your Halloween Scare
South Carolina Department of Revenue hacked: South Carolina state officials announced Friday evening that the social security numbers of some 3.6 million state residents and 387,000 credit and debit card numbers were exposed in a data breach. The SSNs were stored...The Broad Universe Sampler
It’s got me and a lot of other awesome women in it, and it’s FREE. Check out Broad Spectrum: The 2012 Broad Universe Fiction Sampler. My story starts: Last time this happened, I was Orpheus. Ethan was lost, pale, gone in a haze of Zoloft and Lithium and...What Faeries Did in the Renaissance
Seekrit Message to a Friend
You didn’t get this from me. You downloaded it off the internet. In fact, why don’t I turn that bunch of scripts into a series of jobs and give it to you as one big lump? (Download.) How to use: Load file into SQL Server Management Studio. Replace all...Never throw away a script!
You never know when you’re going to have to plagiarize yourself. Seriously, I just repurposed the “migrate databases to new drives” script to be a “migrate databases to a new server” script. Rather than starting from scratch, I changed a...Downloadable scripts
It has come to my attention that WordPress has replaced my quotes with smart quotes, which causes EPIC SCRIPT FAIL. Therefore, I’ve uploaded downloadable versions of the scripts. Smart quotes inserted, Script fails upon copy-paste. “Smart quotes”...Windows Internal Database Maintenance
“Windows Internal Database,” is basically SQL Server with network access and the maintenance tools turned off. You might want to do maintenance on whatever’s in there, anyway. I use Windows Task Scheduler for that, at least until I move the...Subscribe
