At my 10th PASS Summit, Bert Wagner and I recorded a video on how to troubleshoot a slow performing SQL Server. Here it is, with a little of the story behind it.
SQL Authroity News – Optimizing Lazy Spool – PASS Blog
A sneak preview of my SQLPASS sessions: I wrote about optimizing Lazy Spool on the PASS blog, and here are the first two paragraphs with a link to the rest.
SQL SERVER 2016 – Creating Clustered ColumnStore with InMemory OLTP Tables
While preparing my SQLPASS session on SQL Server 2016, I explored creating clustered ColumnStore with InMemory OLTP tables. Here is what I learned.
SQL SERVER – Interesting Observations Using MONEY Datatype
Five interesting observations about the MONEY datatype in SQL Server, like four digit scale, rounding, and accepting commas and currency symbols.
SQLAuthority News – Presented on Database Worst Practices at SQLPASS 2014 in Seattle – November 5, 2014
I presented Database Worst Practices at SQLPASS 2014 in Seattle on November 5. Here is the title and abstract of the session in case you missed it.
SQL SERVER – SQLPASS 2013, Charlotte Memories – Book and Book Signing – Part 2
SQLPASS 2013 Charlotte memories, part 2: our book signing, where we gave away hundreds of SQL Server books for free, plus a few photos from the event.
SQL SERVER – SQLPASS 2013, Charlotte Memories – Friends and Technology – Part 1
SQLPASS 2013 moved from Seattle to Charlotte, North Carolina. Here are my memories of the event in pictures, with old friends and new ones.