Code Camp in Redmond Today
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… Read More »Code Camp in Redmond Today
CTE
Sessions Submitted for SQL Saturday – Olympia
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… Read More »Sessions Submitted for SQL Saturday – Olympia
Sessions for Code Camp in 2 weeks
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… Read More »Sessions for Code Camp in 2 weeks
SQL Lunch UK
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… Read More »SQL Lunch UK
SQL Lunch UK presentation next week.
On May 8th at 4:30am (Lunchtime UK) I will be presenting my Unleashing Common Table Expressions in an online webcast type presentation. I am looking… Read More »SQL Lunch UK presentation next week.
Using a CTE in a Function to Split Up a Query String
The question came up as to how do I parse a query string using TSQL. So here you go, using a common table expression, and… Read More »Using a CTE in a Function to Split Up a Query String
Using a CTE to Split a String Into Rows
One of the common questions that comes up in my CTE class/presentation asks can you use the CTE inside of a function or stored procedure.… Read More »Using a CTE to Split a String Into Rows
TSQL 2012 – OFFSET and FETCH
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… Read More »TSQL 2012 – OFFSET and FETCH
Can we use CTEs use in SSRS?
One of the common questions that I get asked after my Unleashing CTE Presentation is “Can we use CTEs in SSRS reports?” The answer is… Read More »Can we use CTEs use in SSRS?
A great day at SQL Saturday in Vancouver BC
I spent the day today at SQL Saturday in Vancouver BC. I met some fabulous SQL Server professionals, and presented 2 sessions. The first… Read More »A great day at SQL Saturday in Vancouver BC