I used to be able to do the Common Table Expression in a single 1 hour session, but after writing the book on Common Table Expressions, I discovered that I just can’t fit it into an hour with the detail that Common Table Expressions deserve. I would rather go into depth so that everyone can master CTEs rather than just breezing …
It was a great day at SQL Saturday today. I was able to preview my Common Table Expressions Book at my Common Table Expressions presentation. The presentation was great, the room was packed, and there were lots of great questions. Here is the lineup for the room that I presented in. Just before me was Rick Morelan presenting on SQL …
I will be presenting at SQL Saturday #212 in Redmond tomorrow. My presentation will be on Common Table Expressions, and it is the first CTE presentation since my Common Table Expressions book released. I have updated the presentation to include a number of new things relating to CTE’s that I figured out while writing the book. This will be my …
Presenting at SQL Saturday #212 in Redmond Tomorrow Read more »
My Common Table Expression presentation was accepted for SQL Saturday 212 in Redmond WA. This is the session that I am the most familiar with, and that I have presented the most times. I think this will be the 8th time I have presented this session, and after every previous presentation it has been improved. Over the last several months …
Common Table Expression accepted for SQL Saturday 212 in Redmond WA Read more »
SQL Server 2012 adds a new stored procedure called sp_describe_first_result_set. This new procedure returns metadata for the result set returned from a query. The metadata is information about what the results will look like. sp_describe_first_result_set is an alternative to sp_columns, and appears to perform much better than sp_columns. The information here has been extracted from my SQL Saturday presentation on Whats New in TSQL …
T-SQL 2012 Procedure sp_describe_first_result_set Read more »
# The key to twitter is to follow the right hash tags. What hash tags do you follow related to Microsoft SQL Server? Here are a few of the twitter hash tags that I follow: #SQLServer The generic SQL Server hash tag. Most anything goes on this hash tag. #SQLHelp The #SQLHelp hash tag is great when you need to …
What twitter hash tags do you follow for SQL Server? Read more »
I am at SQL Saturday in Vancouver BC today. Here is the download of my presentation. Download zip file. Here is the presentation outline. OVER Clause Enhancements ROWS PRECEDING, FOLLOWING, UNBOUNDED RANGE PRECEDING, FOLLOWING, UNBOUNDED IIF – Immediate IF or Inline IF (from Access) CHOOSE (from Access) OFFSET / FETCH FORMAT CONCAT SEQUENCE (from Oracle) sp_describe_first_result_set New Date and Time …
There are 2 upcoming SQL Saturday events that I have pitched presentations at. These are Vancouver SQL Saturday 198, and Redmond SQL Saturday 2012. If they are anything like last year these should be a blast. One of the new presentations that I have prepared for Redmond is the following: Getting Started as a Technical Speaker Have you considered speaking …
I had so much fun at SQL Saturday in Vancouver BC last year, I have decided to go again. The sessions submitted are: The “Run Faster” Switch The NO_LOCK hint is often believed to be the “Run Faster” switch, but in reality can cause some very inconsistent results. Explore alternatives to the NO_LOCK hint to get your queries to run …
Coding on the Database Health Reports project, making notes in my Quest Software notebook, with a pencil from Redgate SQL in the City, wearing my Confio t-shirt, refilling my SQLSentry plastic pint glass with a Nalgene bottle from Quest Software, storing data on my Redgate thumb drive, overwhelmed with all the swag from the last several conferences. Oh and …