Something smells rotten in Denmark (it’s probably all that cheese). This past weekend I started thinking about what it really means to have your databases hosted in the cloud. My first thought was that it struck me as being exactly the same as an Application Service Provider. I mean, MS SQL is an application, right? And … Read more
Last week I attended another Hands-On-Lab at the MTC center in Waltham, MA. One of the new SQL 2008 features I was able to kick around was SQL 2008 SQL Server Audit. Truthfully, I did not even know about this feature until I was handed the lab sheet. Fortunately I was already planning on spending the day … Read more
So yesterday we were researching some deadlocks and decided to produce a deadlock graph in order to have a visual understanding of the situation because pictures are always easier to work with, just ask Einstein. Anyway, we were not able to produce the graph from Profiler because we were doing something crazy, which was filtering … Read more
I seemed to have struck a minor chord with my hatred for database triggers. I had very few comments, but a handful of emails and exchanged even more tweets on the subject. But one thing was made clear to me and that is people wanted to hear about why I disdain NULL values. Fortunately for me … Read more
I know what you are thinking, how could I, someone who is not attending the MVP Summit, possibly recap the events without being there? From the twitter stream, of course. Turns out that geeks love gadgets. What’s more, they love to talk (tweet) about their gadgets, or the gadgets they are looking at right now. … Read more
I hate database triggers. Whew. It feels good to get that out in the open. I have been holding that in for almost ten years. It got harder to admit after I became a DBA, and as time went by it started to feel as if I was trapped in a story by Edgar Allen … Read more
