PASS Summit Seattle 2009 Day 4: Kevin Kline honored for 10 years of service, a great keynote by Dr. David DeWitt, eight meetings and lots of swag.
SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 3
My third day at SQL PASS Summit 2009: a late start after the parties, breakfast with Solid Quality Mentors and an entertaining keynote full of demos.
SQLAuthority News – SQL PASS Summit, Seattle 2009 Day 2
PASS Summit Seattle 2009 Day 2 began with Twitter bingo, then breakfast with SQL friends, a karma lesson about a borrowed pen, and keynote notes.
SQLAuthority News – SQLPASS Summit, Seattle 2009 – Day 1
Day 1 at SQLPASS Summit 2009 in Seattle, told mostly in photos: the city tour, registration, sessions and the SQL friends I met along the way.
FIRST_VALUE IGNORE NULLS: Find the First Available Value
FIRST_VALUE IGNORE NULLS selects the first present value through the current row. Preserve source rows and distinguish first from latest.
SQL Authority News – Advanced T-SQL with Itzik Ben-Gan – Solid Quality Mentors
My review of the Advanced T-SQL course with Itzik Ben-Gan: I had taught a similar course in India, yet I learned a lot of new things in five days.
Preventing Overlapping Date Ranges in a Table
Detect overlapping date ranges with joins and window queries, use half-open endpoints, and enforce the rule with a multirow trigger.