SQL Saturday 166 Olympia
I am looking forward to SQL Saturday #166 in Olympia on November 10th. Close enough to home that I can drive, but far enough away that I can make a weekend out of it. I have prepared the following four …
I am looking forward to SQL Saturday #166 in Olympia on November 10th. Close enough to home that I can drive, but far enough away that I can make a weekend out of it. I have prepared the following four …
Here are a few links to some of the other CTE examples used during my Common Table Expressions presentation. Using a CTE in a Function to Split Up a Query String Using a CTE to Split a String Into Rows …
What a great day at Code Camp today. Click here to download the slides and sample code from the presentations. The first presentation that I attended was Accelerating your Development Workflow presentation by Ian Davis. What a great presentation, it touched …
I am headed to Code Camp in Redmond WA today. I ended up with 3 sessions that I will be presenting, and I am really looking forward to the day. I am looking forward to attending the Accelerating your Development Workflow presentation …
SQL Saturday 166 in Olympia WA on November 10th was announced, and that one is close enough to drive to. I have submitted 2 sessions for this event. What’s New in TSQL 2012 By November, this with be the …
June 16th 2012 in Redmond. What’s New in TSQL 2012 This presentation was a lot of fun. Although, I wish I had about 30 minutes longer. Here is the zip file with all the TSQL and the slides from the …
Here are the sessions that I will be presenting at Code Camp in two weeks.. What’s New in TSQL 2012 This is the first time that I will be presenting this one. Its going to be a lot of fun …
Today I started the day early with a great presentation for the SQL Lunch UK group on Common Table Expressions. For those who attended the presentation here is the Zip file with the Powerpoint and the SQL code from the …
Its about time, MySQL has had a feature LIMIT which is similar to the usage of OFFSET and FETCH for years. Now in SQL Server 2012 Microsoft introduces OFFSET and FETCH. The OFFSET and FETCH functionality is used to achieve …
SQL Server 2012 introduces 8 new analytic functions. This post will cover 2 of them LEAD and LAG, which can be used to reference a value in the row before or the row after the current row. If you have …