by Katherine Villyard | Oct 8, 2012 | scripting, sysadmin
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...
by Katherine Villyard | Sep 23, 2012 | scripting
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...
by Katherine Villyard | Sep 14, 2012 | haiku
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”...
by Katherine Villyard | Aug 31, 2012 | scripting
“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...
by Katherine Villyard | Aug 24, 2012 | cons
I’ll be reading at the Broad Universe Rapid Fire Reading at Dragoncon on Sunday, September 2, at 5:30pm in Greenbriar. Woe, my current story is 23,000+ words long and conflict-poor. It needs some serious, serious editing. But I was not writing at...
by Katherine Villyard | Aug 21, 2012 | scripting
Suppose that you’ve been asked to migrate 166 databases’ .mdf files from one drive to another. How would you do that? I’d generate a list based on the .mdf files (the databases are all named the same thing as the .mdf. If this wasn’t the...
by Katherine Villyard | Jul 31, 2012 | writing mysticism
I was doing 250 words a day as a goal, but Jen and I signed up for stickK together. It looked like a time commitment would work better with their site than a wordcount commitment, so I said ten minutes a day/an hour a week. This works a lot better than I expected. I...
by Katherine Villyard | Jul 30, 2012 | monitoring
I run Nagios at home. It texts me when my machines need patches. I told this to a charming gentleman who was my dinner companion for the evening and he gave me a look that implied that I was not all there. (He’s a Nagios admin, too, but not willingly.) I...
by Katherine Villyard | Jul 27, 2012 | monitoring
So, I have this friend. (No, really, it’s my friend, it’s not me, I set up my own Nagios server.) She’s a DBA with no responsibility for anything outside of a bunch of SQL Servers. Nagios wakes her up in the middle of the night if the web server...
by Katherine Villyard | Jul 23, 2012 | procrastination
We interrupt your regularly scheduled computer geekery to bring you tea. I’ve been really getting into tea lately. Also, caffeine abuse is a vital component of geek culture, and tea is relatively neglected (unless you’re steampunk). So. Loose leaf, my...