Today I had the need to find tables in a database that did not have a clustered index defined. Why would I have such a need? That’s a great question.
Anyway, I set about with a few basic questions for myself such as “Self, how many tables are there?” So I did what I normally do [...]
About a year ago I blogged on how I thought Chris Hansen would make a great DBA. A few people said they liked that blog post and I loved the idea of getting Chris Hansen involved but he has yet to return my phone calls, emails, or telepathic messages.
Anyway, as I [...]
During the 2008 PASS Summit I took part in a breakfast seminar on “Automating DBA Processes”. It was my first, and last, breakfast seminar that I have been asked to participate in so I can only imagine I offended somebody with my requests for more bacon to be brought to our table. I don’t recall [...]
Last week I talked about creating a ‘customer advisory board’ that would be dedicated to help providing feedback to and from the PASS Board of Directors. Since that blog post went out I have had a handful of conversations about the idea, including about a 15 minute talk with the Board during our meetings earlier [...]
I just knew I was going to coach college basketball. No doubt in my mind, I knew that I would be working the sideline on a Saturday afternoon somewhere. I also knew that most of the jobs went to people that were former players (regardless of coaching ability), or to people that were connected to [...]
There are more than a handful of days that I can say “I remember where I was when…”, and today you are going to be lucky enough to add this day to that list. For today is the day that I give to you an image of an invention so bold, so unique, so magnificent, [...]
I know what you are thinking. You are sitting there, reading this blog post and saying to yourself “Wait a minute, there *is* no SQL Server user group in Hartford!”
Well, up until about a week ago, you would be right. But come April 7th we will be having the inaugural meeting of a brand new [...]
The other day Aaron Bertrand pointed out that a recent tip I wrote had a rather nasty oversight. You can read more about the discussion over at his blog.
The short of it is this: what I wrote in the tip is cot very clear, and is most likely going to be interpreted wrongly. Aaron’s post [...]
…would be a slightly misleading title to this post. After all, there are at least five states with a town or city named ‘Hollywood’, so how do you know where I will be? Well, I’ll tell you, that’s how.
Starting Monday morning I will be in Hollywood, Florida, for a meeting of the PASS Board of [...]
It’s official, I will be presenting at SQL Saturday #39 on April 24th in New York City. My talk will be on SQL Server 2008 Audit and I am gearing it for people that are not familiar with that feature of SQL 2008.
I’ve been to SQL Saturday’s before, I’ve been to Manhattan before, and I’ve [...]