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

Posted in Best Practices, Book, Conference, SQL Server, SSIS, T-SQL | 3 Comments

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

Posted in Book, Katmai, SQL Server, T-SQL | Leave a comment

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

Posted in Best Practices, Book, SQL Server, T-SQL | Leave a comment

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

Posted in Beginners, Best Practices, BI, Conference, Data Mining, dev, Katmai, Office 2007, Performance, Presentation, SQL Server, SSIS, T-SQL, Training, Webcasts | Leave a comment

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

Posted in dev, Katmai, Presentation, SQL Server, T-SQL | Leave a comment

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

Posted in BI, SQL Server, SSIS, T-SQL | 2 Comments

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

Posted in SQL Server, T-SQL | Leave a comment