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...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...I am a winner!
I went to the Atlanta PowerShell Users Group tonight. The topic was tips and tricks. My trick was this script, which task scheduler reads to me in the morning. Assuming you use Hiveminder–and you should, because it’s awesome–you only have to edit...Fun with Exchange Management Shell
I’m really digging the Exchange Management Shell. It’s FUN FOR THE WHOLE FAMILY! Okay, maybe not the whole family. 😉 Short example: someone wanted to know if I could tell them how many emails someone sent in a specific time period. Short answer:...Subscribe
