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...The Career Venn Diagram
Every now and then, people ask me for career advice. Or, you know. They start complaining about their careers and I annoy them with unsolicited advice. 😉 Either way, my advice for choosing a career comes down to: Things you can do that people will pay you to do...Subscribe
