SQL Saturday #265 in Portland Oregon
I will be attending SQL Saturday #265 in Portland Oregon on November 16th 2013. This will be my second time attending SQL Saturday in Portland,… Read More »SQL Saturday #265 in Portland Oregon
Classes
Notes from SQL Server Classes
Working on my sessions for DevTeach in Vancouver in December.
The two sessions I will be presenting at DevTeach in Vancouver BC will be the following: Using FILESTREAM and FILETABLES in SQL Server – Configuring… Read More »Working on my sessions for DevTeach in Vancouver in December.
Advanced CTEs Slides and Samples
Today I presented on Advanced CTEs at SQL Saturday Denver. Here are my slides and sample code for download: Advanced CTEs Denver Thanks to everyone… Read More »Advanced CTEs Slides and Samples
In Denver for SQL Saturday
I will be speaking at SQL Saturday Denver, presenting on Advanced Common Table Expressions. This presentation should be a lot of fun. I will be… Read More »In Denver for SQL Saturday
Sessions Accepted for DevTeach Vancouver BC
Today I learned that two of the sessions that I proposed for Vancouver DevTeach were accepted. This event taking place on December 2nd to 4th 2013… Read More »Sessions Accepted for DevTeach Vancouver BC
I’m Speaking at SQL Saturday #190 in Denver
One of my sessions was accepted for SQL Saturday #190 in Denver this year. Please come see my CTE presentation. Common Table Expressions –… Read More »I’m Speaking at SQL Saturday #190 in Denver
What is a Common Table Expression – Video
Related Common Table Expression Links Sample Database for Common Table Expressions Writing Your First Common Table Expression with SQL Server Video: Writing Your First… Read More »What is a Common Table Expression – Video
End of June Summary
June was an exciting month for me with Beta 6 of the Database Health Reports releasing at the beginning of the month, and this being… Read More »End of June Summary
What Do You Use CTEs for?
There are many great reasons to use Common Expressions, from derived table query re-use, to doing recursive queries and creating hierarchies to doing data paging,… Read More »What Do You Use CTEs for?
CTE Data Paging in a Procedure
Day 15 of Common Table Expression Month (June) at SteveStedman.com, today we will be taking a look at data paging with CTE’s in a function. Yesterday… Read More »CTE Data Paging in a Procedure