Your Halloween Scare
South Carolina Department of Revenue hacked: South Carolina state officials announced Friday evening that the social security numbers of some 3.6 million state residents and 387,000 credit and debit card numbers were exposed in a data breach. The SSNs were stored...Seekrit Message to a Friend
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...Never throw away a script!
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...Windows Internal Database Maintenance
“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...A Script for Migrating SQL Data (and Log) Files
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...True Confessions
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...Clearly, you’re doing it wrong.
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...Tracking total file usage, DBs only.
Yes, I’ve been bad about updating. I was traumatized by a bunch of friends getting laid off from a former employer, and then I had two very busy weeks. This system of tracking total file usage, DBs only, came up talking to someone recently (Eric, are you...Perfmon Link
Awesome webcast by Brent Ozar. There’s more here. I’d say more, but I’m busy enjoying Memorial Day.Subscribe
