Buy vs. Build

It’s the classic question faced by everyone in Information Services. I know how to do this and I could build software to do it, but I’m a lazy b_____d so I’d rather just pick up a piece of software that does it for me. I love working for large companies because I can usually get […]

Read More

A Lack of Excitement

I usually use all the problems, crashes, and issues that I run into at work as grist for my mill, aka, material to blog about. But lately, we haven’t been crashing & burning much <knock wood, turn three times, throw salt over my left shoulder, spit>. But it was suggested that may be I should […]

Read More

How do -You- use SQL Server

I’ve been tagged by a misplaced yankee, uh, New Englander, whatever. The question is, how do I/we use SQL Server where I work. That’s a tough one. It would make a much shorter, and easier,¬†blog post to describe the things we don’t use it for. However, keeping with the spirit of these tags, I’ll try […]

Read More

Characters

No, I’m not talking about a Dickens novel. I’m talking about the number of characters in a string. I had a painful time recently because of the word “characters.”¬† If you take a look at the dynamic management view sys.dm_exec_sql_text you can get the queries that have been run on your system that are still […]

Read More

Operations Manager Feedback

If you’re involved with maintaining Microsoft Operations Manager, you probably have a few things you’d like to tell the developers, such as, couldn’t you get some sort of override manager/explorer built into the system? Well, they’ve built a new feedback mechanism through the updated Connect interface. Get on over there and ...

Read More

Tom LaRock on Reports In Operations Manager

Tom has published a great article on reporting in Operations Manager over at Simple-Talk. In case you don’t know, Tom is one of the best when it comes to OM on SQL Server. He’s presented at PASS on these topics for the last two years and has written other articles as well.

Read More

Sign Me Up!

I am joining the battle. It’s the Battle Against Lawless Database Design (BALD-D or baldy). Because, after all, enough is enough. I encourage you too to join the battle. Cross your arms, join the battle cry! Enough is enough!

Read More

SQL Server Management Pack Resources

There aren’t any. That’s not entirely true. There is the SQL Server Management Pack Guide from MS. It gives you the basics. After that you have to fall back generic documentation and help for the most part. If you haven’t already, get a copy of System Center Operations Manager 2007 Unleashed. It doesn’t cover the […]

Read More

Operations Manager 2007 SQL Collection Article

It took me a while to find all the little pieces to put together a custom rule that used data collected through TSQL. In fact, because it took so much work to pull all the little pieces together, I wrote an article describing how I did it. This isn’t a wonderful new invention. It’s just […]

Read More