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 that I will be presenting this one. Its going to be a lot of fun …
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 …
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 forward to it. I have tuned it up a bit since the last time I …
I am planning on visiting Salt Lake City for SQL Saturday in October. Exploring the TSQL Enhancements in SQL Server 2012 Unleashing Common Table Expressions in SQL Server Using SSRS reports to analyze SQL Server health
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 basing this on a similar function to what I put together yesterday for split. which …
Using a CTE in a Function to Split Up a Query String Read more »
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. The answer is yes, but today I came across another question, how can I split …
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 …
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 YES, Common Table Expressions work great in SSRS reports, one of my favorite ways of …
Over the last week I have pitched 8 presentations for SQL Connections in Vegas at the end of October 2012. Hoping that 3 of my presentations get accepted. Here is the list so far. Using the New Analytic Functions in …
Working on my Presentations for SQL Connections Fall 2012 Read more »
I spent the day today at SQL Saturday in Vancouver BC. I met some fabulous SQL Server professionals, and presented 2 sessions. The first Session was on Unleashing Common Table Expressions in SQL Server. This was the second time …