by Katherine Villyard | Feb 2, 2016 | scripting, sql
Google informs me that my post on Windows Internal Database Maintenance is popular. It’s not what I’m currently using, however. I’ve switched over to Ola Hallengren’s scripts. If you download and run the installer script, it creates a series...
by Katherine Villyard | Jan 25, 2016 | monitoring, powershell
I wrote these in PowerShell to run with nrpe/nsclient. They query Dell OpenManage’s command line and return a Nagios-readable result. (There are plugins available on Nagios Exchange, but they all seemed to be… more than I wanted. I just wanted to know,...
by Katherine Villyard | Jan 14, 2016 | short fiction
Did I really not post here about my latest story? My story “Minotaur” is available in the Alien Abduction anthology. Only $5 for the Kindle version, and my aliens are pretty alien. If you heard me read at the Broad Universe Rapid Fire Reading at...
by Katherine Villyard | Jan 12, 2016 | monitoring, powershell, sql
Or, Log-Shipping over 1200 databases automagically. The Problem Question: How many SQL Server databases can you put on one server? Answer: It depends on how fast you need them restored if something terrible happens. Because Dude, if your server crashes most heinously,...
by Katherine Villyard | Sep 23, 2015 | powershell
Someone on Server Fault asked a question about which versions of SQL Server support log shipping. He uses Express. Log shipping uses SQL Agent, and Express doesn’t come with SQL Agent, but you can still manually log ship with PowerShell and Task Scheduler. Use...
by Katherine Villyard | Jul 6, 2015 | running
For those of you not in the know, the Peachtree Road Race is a ginormous (60,000 runners) 10K held every July 4th in Atlanta. This was my third Peachtree. Anyway, this is what I did for the 4th of July.
by Katherine Villyard | Jan 7, 2015 | short fiction
My story “Underworld” is now available at Fantastic Stories of the Imagination. Check it out! There’s a great illustration of young Dion the wizard, Semele, and Thanatos! I love it!
by Katherine Villyard | Jan 2, 2015 | career
As of yesterday, I’m a Microsoft MVP in Enterprise Security. 😀
by Katherine Villyard | Nov 21, 2014 | powershell, scripting
I was given the task of renaming a bunch of databases named something like “name,” “name_1,” “name_2,” etc., to “nameold,” “nameold_1,” “nameold_2,” etc. Our convention is for the database name...
by Katherine Villyard | Apr 27, 2014 | short fiction
I expect that I’m about to frustrate a lot of people, but that’s the way it is. Back in 2007, I started a “Hurricane Katrina” story. I wandered around in my post-apocalyptic Probably New Orleans, got lost, deleted 5,000 words, rewrote it a...