Joe Webb

Musing and observations about SQL Server, other technogies, and sometimes just life in general
posts - 85, comments - 857, trackbacks - 0

My Links


This blog has moved!

Click here for the new location.

Follow me on Twitter
Add to Technorati Favorites

Search this Blog


Post Categories

About me

May 2008 Blog Posts

The 33 languages of SQL Server

I was recently perusing the the MSDN SQL Server forums and noticed a question about localization of Microsoft SQL Server messages. I replied to the post with a mention of the sys.messages table - the table where SQL Server messages are stored. I blogged about this system table a few months ago. Afterward I started playing around some more with the sys.messages table. I started with the following basic query.   The first thing to notice is that each message_id has one or more languages associated with it. Message_id 21, for example, has a row for language_id 1033, 1031, 1036,...

posted @ Friday, May 30, 2008 3:54 PM | Feedback (6) | Filed Under [ T-SQL SQL Server ]

DevTeach/SQLTeach wrap-up and review

Over the years, I've had the opportunity to attend, and even speak at, many technical conferences both here in the United States and abroad. Some of the conferences had only a couple of hundred attendees while others boasted of attendance figures in 5 digit range. For the two of the six years I spent on the PASS (Professional Association for SQL Server) Board of Directors, I served as Director of Logistics and Conference Operations. I arranged meeting space and selected food, contracted for wireless and bought conference bags. My final years of the Board was spent serving as the Executive...

posted @ Monday, May 19, 2008 9:34 AM | Feedback (0) | Filed Under [ Current Events Community ]

SQLTeach - Writing better queries presentation

Here's a presentation that I gave yesterday afternoon at DevTeach/SQLTeach. It's called Tips & Tricks for Writing Better Queries. It's very similar to the presentation I gave a month or so ago at the Nashville SQL Server User Group meeting. To everyone who attended the session - thanks for spending a part of your day with me. I hope it was worth your while. Please feel free to email me if you have any additional questions or comments. And please remember to login to your SQLTeach account and submit your session evals. Cheers! Joe

posted @ Thursday, May 15, 2008 9:37 AM | Feedback (9) | Filed Under [ T-SQL Current Events Community ]

Identifying Performance Bottlenecks

Thanks to everyone who attended my "Identifying Performance Bottlenecks" session this morning at DevTeach/SQLTeach. As promised, here is the PowerPoint slide deck I used during the presentation. Regarding the question of on the performance of LINQ, Bob Beauchemin recently posted a series of blogs entries on the topic. Here's a link. And here's a link to series of posts on the Dynamic Management Views (DMVs) that Louis Davidson authored. Cheers! Joe

posted @ Wednesday, May 14, 2008 10:47 AM | Feedback (5) | Filed Under [ SQL Server Current Events Community ]

What's the difference in a GDR, a Cumulative Update, and a Service Pack?

The nomenclature used for referencing software releases and updates can be quite confusing. Let's consider an example to illustrate what the various terms mean. As a new version of a product is being developed, it may be made available to select customers and community members for early testing. This is sometimes called alpha builds of the product. As development progresses and the product becomes more and more polished, it's provided to a wider audience. This used to be called beta releases; for example beta 1, beta 2, etc. However a few years ago Microsoft changed the terminology for SQL Server pre-releases. They...

posted @ Wednesday, May 07, 2008 11:11 AM | Feedback (9) | Filed Under [ SQL Server Misc ]

Finding Notification Services Instances

As most you already know, Notification Services is not part of Microsoft SQL Server 2008. I think this is a shame since SSNS is really a great product. It may be rather complex at first glance, but it's a great product nonetheless. I'll probably devote a blog to it's abrupt deprecation at some point in the future. In the meantime, if you're preparing to upgrade to SQL Server 2008, you should verify that you don't have any rogue SSNS instances running on any of your servers. I hope your environment is more controlled than that, but I've seen more...

posted @ Tuesday, May 06, 2008 3:31 PM | Feedback (0) | Filed Under [ T-SQL Notification Services ]

Powered by:
Powered By Subtext Powered By ASP.NET