by Katherine Villyard | Aug 31, 2012 | scripting
“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...
by Katherine Villyard | Aug 21, 2012 | scripting
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...
by Katherine Villyard | Jul 30, 2012 | monitoring
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...
by Katherine Villyard | Jul 27, 2012 | monitoring
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...
by Katherine Villyard | Jul 21, 2012 | monitoring
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...
by Katherine Villyard | May 28, 2012 | monitoring
Awesome webcast by Brent Ozar. There’s more here. I’d say more, but I’m busy enjoying Memorial Day.
by Katherine Villyard | May 25, 2012 | sysadmin
Happy Memorial Day! Plant is going to hold their annual George Forman Memorial Cookout in your server room this weekend. Tom Limoncelli explains why here. When your pager goes off and you call them to tell them the AC failed again this year, tell them the least they...
by Katherine Villyard | May 13, 2012 | monitoring
Do you know about Write or Die? It’s described as “putting the prod into productivity” and is for procrastinating writers to force themselves to write. (Writers procrastinate. It’s a thing. You can spend hours surfing the web for baby name...
by Katherine Villyard | May 6, 2012 | scripting
This isn’t the entire thing, it’s bits and pieces, but it’s enough for you to bend, fold, spindle, and mutilate for your own purposes. I was given 70,000+ tab delimited lines that were output dumped from a program and asked to find out what version...
by Katherine Villyard | Apr 29, 2012 | monitoring
You may be asking yourself, “Self, why should I cough up cash for SQL Monitor or spend time (or pay someone to spend time) setting up Nagios?” The answer, of course, is: Do you want to know something is wrong now, or when a customer calls you and says...