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
Classes
Notes from SQL Server Classes
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.
3 Sessions submitted to SQL Saturday in Salt Lake City
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… Read More »3 Sessions submitted to SQL Saturday in Salt Lake City
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?
Working on my Presentations for SQL Connections Fall 2012
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… Read More »Working on my Presentations for SQL Connections Fall 2012
Cumulative Distribution Function (CDF) – Analyzing the Roll of Dice with TSQL
After the last post on Cumulative Distribution Function (CDF) or as it is known in TSQL CUME_DIST(), I realized that although I showed how to… Read More »Cumulative Distribution Function (CDF) – Analyzing the Roll of Dice with TSQL
More TSQL 2012 Analytics CUME_DIST – Cumulative Distribution
Continuing on the TSQL 2012 Analytic Series now on to the CUME_DIST function SQL Server 2012 introduces another new analytic function. The Cumulative Distribution Function… Read More »More TSQL 2012 Analytics CUME_DIST – Cumulative Distribution