THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Allen White

PASS Pre Conference (Monday)

On Monday I attended Itzik Ben-Gan's pre-conference session on Transact-SQL. I've attended a couple of his sessions in the past, and was looking forward to a full day session with him. I wasn't disappointed. His code to concatenate strings using FOR XML was an eye-opener, and using the log functions to create multiplicative aggregates was pure genius. Those were just two examples that jump out the morning after the session. I recommend checking out his books ( and his blog (

The final article of my three-part series has also been published, and is up on the Simple Talk website. Here's the link: Automate your Database Integrity checks using SMO

Today I plan to attend Gert Drapers' pre-conference session on Data Dude (Visual Studio Team System for Database Professionals.) I've extracted database projects for documentation and played with the tool a bit, but am looking forward to the deep dive to see how to really use it.

Oh, and thanks to Lara Rubbelke and Cindy Gross for some great advice. The conversation was enjoyable and enlightening.


Published Tuesday, September 18, 2007 8:36 AM by AllenMWhite


No Comments
New Comments to this post are disabled

About AllenMWhite

Allen White is a consultant and mentor for Upsearch Technology Services in Northeast Ohio. He has worked as a Database Administrator, Architect and Developer for over 30 years, supporting both the Sybase and Microsoft SQL Server platforms over that period.

This Blog


Privacy Statement