Deprecation, Trace and Execution Plans

SQL Server 2005, SQL Server 2008, SQLServerPedia Syndication, TSQL
As I’m sure you know, Microsoft occasionally changes it’s mind. Or, it makes bad decisions and then rectifies them. Or, it even reinforces bad decisions. Regardless of the purpose, the means by which these changes are implemented when they involve taking things away is deprecation. Usually in SQL Server the deprecation process is supposed to be over three releases. So while seeing something on the deprecation list can be cause for concern if it’s something you like, you certainly don’t need to panic. I’ve finally had a chance to start working with Denali and the place that concerned me most was in the areas of deprecation. I want to make sure that when I suggest a particular approach, that the approach isn’t going to disappear in a version or two.Which…
Read More

Seacoast SQL Users Group

Misc
Tomorrow is the Seacost SQL Server User's Group inaugural meeting. I'll be presenting a session called "Understanding Execution Plans." It's my introductory session on execution plans and I love giving it. Please come by and support this new user group. Mike Walsh (blog | twitter), the new user group president, is under the impression I draw a big crowd. While that isn't true, please show up anyway just so that Mike has a successful first meeting. I promise a bit of free stuff. Remember, interactivity is bribed encouraged.
Read More

Hey, ho, where’d you go…

PASS, SQLServerPedia Syndication
Ohio? I'm presenting on Thursday to the Columbus SQL Server Users Group, home of the newly minted MVP, Jeremiah Peschka (congrats again). It's to be a virtual presentation through live meeting. The topic is a Understanding Execution Plans. This time I hope that one of us remembers to hit the record button unlike last time when I did this presentation for the PASS AppDev Virtual Chapter. If you're in the area, come on down and meet me, virtually. Show runs from 6:30-8:30, although all that time is not my presentation, so I suspect Jeremiah has some more fun planned.
Read More

SQL Server Execution Plans Published… Again

SQLServerPedia Syndication, TSQL
My first book is finally in print. OK. I know. It sounds funny. But my first book was printed in only a limited print run from Red Gate, most of which they gave away at Tech Ed last year. Then they offered it for free in an electronic form. Very few people got a printed copy. Well, if you were waiting around for the dead tree version, it's here! Thanks again to Tony Davis & Brad McGehee for all the work they did. It just wouldn't have been possible without them.
Read More