Our new book has arrived

Although I’m away from home this week (teaching in Hyderabad) I’ve heard that the first advance copies of Dan Sullivan’s and my new SQL Server 2005 book, A Developer’s Guide to SQL Server 2005, have made their appearence. Earlier than expected. Although we RTM’d before SP1, printing takes about 3 weeks and the service pack […]

TechEd Boston 2006…I’ll be there

As you can see, I’m trying to catch up on my blogging. Here’s one I missed. I’ll be at TechEd 2006 in Boston in June. It will be good to return to the location of my first-ever data processing job (yes, it was called data processing then, in the year 1977. and no, I’d don’t […]

Using WMI and SQL Agent Alerts (part 2)

This one ought to be titled "Your error message is such a tease". I've always liked the fact that SQL Server 2005 error messages are verbose (modulo security considerations for login error for example). I always point out at least one during classes, start to read the message…and about 50 words or so later, tell students […]

Using WMI and SQL Agent Alerts (part 1)

Lately I've been working on using WMI events in conjunction with SQLAgent alerts and jobs to notify operators, queue up notifications for the DBA's resolution offline, and other uses. Setting up the alert and the job is fairly straightforward, where I stumbled at first is referencing WMI variables (and even knowing what variables were available) […]

What’s fixed in SP1?

You've likely heard by this time that Service Pack 1 for SQL Server 2005 was released earlier today/yesterday depending on what timezone you're in. Rather than go into how to get it, there's two KB articles that are really useful, KB 913090 – A List of bugs that have been been fixed and KB 916940 […]

And I’m on DNR-TV tomorrow

Since we were on a roll the SQL Server 2005 discussion, Richard and Carl had me back this week on dnr-TV. It’s a combination of podcasting and demonstrations using Visual Studio, and I obliged with an hour demonstration of using SQLCLR with Visual Studio. I also talk about some of the things to watch out […]

I’m on DNR next week

I had the good fortune to be able to spend an hour or so (may have been a bit longer chatting with Richard and Carl last week on .NET Rocks! about SQL Server 2005 and the state of the world in general. This episode should be available on Tuesday, Apr 18 at the usual places, […]

Technet Webcast Series for the ITPro – Part 6

I just finished my second talk in the “designing and managing scalable systems with SQL Server 2005” webcast series. I got to talk about one of my favorite features in SQL Server 2005, the Service Broker. Some DBA may still think that Service Broker is a developer-only feature, but after you've seen what you can […]