An abstract from SQL Queries 2012 Joes 2 Pros Volume 1 on query writing strategy, a simple habit that makes the errors drop for beginner SQL students.
SQL SERVER – Beginning SQL 2012 – Shred XML with the nodes() Method – Abstract from Joes 2 Pros Volume 5
An abstract from Joes 2 Pros Volume 5 that shows how to shred XML into nodes with an XPath and the nodes() method, without OPENXML or numbered handles.
SQL SERVER – Beginning SQL 2012 – Basics of CONVERT FORMAT Function
Basics of the CONVERT FORMAT Function in SQL 2012: compare FORMAT with the older CONVERT tricks and grab just the part of a date you need for reports.
SQL SERVER – Beginning SQL 2012 – Spatial Unions and Collections
Aggregates are not just for sales totals. Much like a jigsaw puzzle, spatial unions assemble land coordinates together. Learn spatial unions and collections in SQL 2012.
SQL SERVER – Beginning SQL 2012 – Aggregation Functions – Abstract from Joes 2 Pros Volume 2
An abstract from Beginning SQL 2012, Joes 2 Pros Volume 2, on aggregation functions and why GROUP BY limits your result set to aggregated data.
SQL SERVER – Beginning SQL 2012 – Why we use Code Comments – Abstract from Joes 2 Pros Volume 1
Why we use code comments: SQL Server lets you keep words in a query window off the record, so they are ignored at run time. An abstract from Joes 2 Pros.
SQLAuthority News – Memories at Anniversary of SQL Wait Stats Book
A year ago I published my second book, SQL Server Wait Stats. On the first anniversary of SQL Wait Stats book, here are some memories from that journey.