DWWTWT?: December 29-31

In the second of my annual indulgences, I’m “treating” you to a summary of my commuting life this year. A note to the uninitiated: there has been a hidden feed on this blog since I started my position in the SQL CoE in June of 2006.  My office was a mile and a half from…

0

Feedback is a Gift; Thanks, Kalen!

The law of unintended consequences is an amazing thing. When I posted Dirk Gubbels’ holiday greeting last week, I very quietly snuck in a new format for displaying source code, a formatting plug-in that was recommended in an internal discussion group.  It was decidedly not what I was looking for (I want more of a…

1

DWWTWT?: December 22-26

After spending six hours in Orlando airport with Zach on Monday waiting for his two hour flight to take off, I got called into work.  The remainder of the week was non-competitive, spent basking in the glow of my family: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 109…

0

A Seasonal Query

UPDATED 29 Dec 2008: Back to the tried-and-true source code formatting method, per Kalen’s comment and my response.  UPDATED 24 Dec 2008: I got this from a couple of different sources, so I didn’t realize when I drafted this post that Dirk wrote this query.  Yesterday.  Dirk is obviously a genius with a huge spirit. …

12

SQL Server 2005 SP3 CU1 Is Now Available

Hot on the heels of the initial SQL Server 2005 SP3 release, Cumulative Update 1 for SQL Server 2005 SP3 is available for download here. From the Knowledge Base article: Cumulative Update 1 for SQL Server 2005 Service Pack 3 contains only hotfixes that were released in Cumulative Update 10 for SQL Server 2005 Service…

0

DWWTWT?: December 15-19

The working year ends with a full week of telecommuting from balmy central Florida: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 108 Walked 218 Walked to the Bus 17 Drove 191 None (did not compete) 128 Other Transportation Employed Airline Segments Flown 11 The remainder of the year…

0

May Glad Tidings be Upon You

UPDATED 20 Dec 2008 to fix links It’s that time of year again, when I disappear from the blogosphere for a couple of weeks to contemplate the blessing of home and family.  Before I do that, I’d like to use the blog’s 700th post for my annual holiday indulgence (the first of two indulgent posts…

3

It’s Here! SQL Server 2005 Service Pack 3 Now Available for Download

As discussed here, SQL Server 2005 Service Pack 3 is now available for download here.  The following information is taken verbatim from the Data Platform Insider: SQL Server 2005 SP3 is now available for download and includes the following updates: Roll-up of Quick Fix Engineering (QFE) updates completed since SQL Server 2005 SP2, as well…

5

Linchi Shea Makes an Interesting Point About Hints

I had a couple of extra minutes today and found this post on Linchi Shea’s blog; I wanted to commend to all of you who’ve taken in the programming methodology and set-based thinking discussions in this little corner. While I disagree some with the point in the main post about views (JOINing views, to my…

2

Database Programming: OBJECT_ID Takes Three-Part Identifiers

This is another one of those tricks that’s been available since the earth was cooling, but I just discovered it recently. So, here’s a history lesson in the form of a small T-SQL script, with the moral contained in the title of this post: set nocount on use master select  object_id(‘sysobjects’) as ObjectIdFromMaster go use…

2