Category Archives: T-SQL
SQL Server MVP Deep Dives
I’m not a SQL Server Most Valuable Professional anymore[1], but I was when this amazing project got underway, and I am proud to contribute as an author on SQL Server Integration Services. SQL Server MVP Deep Dives is a unique … Continue reading
T-SQL Fundamentals is (Almost) Here!
Not too long ago I posted about Itzik Ben-Gan’s excellent book Inside Microsoft SQL Server 2005: T-SQL Querying and how valuable I’ve found it. Well, Itzik has just completed work on his next book: Microsoft SQL Server 2008 T-SQL Fundamentals. … Continue reading
Buy This Book, or Your Database Gets It!
At last night’s VDUNY meeting I talked about a whole bunch of new features in SQL Server 2008 for database developers. And because this is a favorite topic of mine[1] a lot of the discussion revolved around Transact-SQL. And you … Continue reading
One More Reason to Attend
I’ve posted a few times already[1] about the SSWUG Business Intelligence vConference that I have been helping to organize. Well, the conference is now less than a month away, and there is more news to share: We’re giving away a … Continue reading
Visual Developers of Upstate New York
I apologize for the late notice (I’ve know for weeks, but have kept forgetting to post) but I will be speaking next Wednesday, August 27th, at the VDUNY user group in Rochester, New York. This user group meets on the … Continue reading
Handling Delimited Fields
I’m working with a set of input data that has multiple logical values “encoded” within a single field for each record. The source system allows users to select multiple values from a list, and then crams all of these values … Continue reading
More Dating Advice
There must be some sort of synchronicity at work – just this morning I was blogging on how to convert different string and integer date representations into “real” datetime values, and then this afternoon I found myself needing to include … Continue reading
