A Microsoft white paper on data compression in SQL Server 2008: strategy, capacity planning, best practices, and the trade-off of I/O savings for CPU.
SQLAuthority News – SQL PASS Summit, Seattle 2009 Day 4
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.