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.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.