Katherine’s Excellent Log-Shipping Adventure
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,...Log-Shipping SQL Express with 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...Peachtree Road Race
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.“Underworld” now available!
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!Squee!!!
As of yesterday, I’m a Microsoft MVP in Enterprise Security. 😀Rename a lot of databases with PowerShell
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...Art is never finished, only abandoned.
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...SQL Server Express Maintenance
Don’t you love looking at your old scripts? I’ve rewritten all of our maintenance jobs, including the jobs in task manager that handle SBSMonitoring. I’ve rid myself of Windows Internal Database, but was still using the script I wrote for it. Not...Backups FTW!
I could say it’s because I’m a DBA and SysAdmin and it’s an occupational hazard, and frequently do. I could also say it’s because I’m neurotic. 😉 But it’s probably the most honest to say, “Because I once experienced a...Subscribe
