T-SQL window functions talk summary and sample scripts

Yesterday, I spoke to the Steel City SQL User group on T-SQL window functions. Below is a short summary and links to the sample scripts and database. The T-SQL window functions came about in SQL Server 2005, but you really want SQL Server 2012, because many functions were added and also because support for PARTITION … Continue reading T-SQL window functions talk summary and sample scripts

SQL Saturday #342 in Mobile is tomorrow

Here is a summary of my session, at 3 PM in "Room 2" (that just sounds too easy...) Of course, you really want to sign up for the other speakers, but just maybe at 3 PM my session will appeal to you. P.S.: Bring your family to Mobile! Tomorrow they can get free admission to … Continue reading SQL Saturday #342 in Mobile is tomorrow

Presenting at TechDays San Francisco only two weeks away

On June 5-6, the Pacific IT Pros user group is hosting their TechDays San Francisco event. There is still time to register, and for 2 days of training from recognized speakers (and me too) the price is a bargain. Head over to http://techdays.org and register today. Below is a summary of the sessions I will … Continue reading Presenting at TechDays San Francisco only two weeks away