Notes from SQL Server Classes
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, and it is looking to be a great event. There are some great speakers on the line up that I am looking forward to learning from. I will be presenting 2 sessions on Common Table …
The two sessions I will be presenting at DevTeach in Vancouver BC will be the following: Using FILESTREAM and FILETABLES in SQL Server – Configuring and Using FILESTREAM and FILETABLES in SQL Server Developers love to use SQL Server to store files, but this causes headaches for the DBA, finally a reasonable solution for file storage in SQL Server FILETABLES …
Working on my sessions for DevTeach in Vancouver in December. Read more »
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 who attended, I hope you enjoyed the presentation. Don’t forget to try out the Database Health Reports. Here is what some people are saying about it: Raving Fans
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 covering all the advanced and fun CTE features that I haven’t had time to fit into my introduction to CTE session in the past. Here is the outline of the session: 1.Recursive CTEs. 2.Hierarchical CTEs. …
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 at the Vancouver Sheraton Wall Center Hotel. It will have 3 full days of main conference (Dec. 2-4). Don’t miss this Vancouver DevCon! The first session: Using FILESTREAM and FILETABLES in SQL Server Steve Stedman …
One of my sessions was accepted for SQL Saturday #190 in Denver this year. Please come see my CTE presentation. Common Table Expressions – Introduction Have you ever wanted to create a recursive query, but didn’t see how to do it. With the Common Table Expressions session you will learn everything needed to start using CTE’s for recursive queries, …
Related Common Table Expression Links Sample Database for Common Table Expressions Writing Your First Common Table Expression with SQL Server Video: Writing Your First CTE with SQL Server Common Table Expressions – Terminating the Previous Statement CTE Scope Introduction to Recursive CTEs Recursive CTE for Dates In A Year Expanding on Recursive Dates CTE Multiple CTEs in a Query …
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 CTE Month at SteveStedman.com to mark the release of my Common Table Expressions book. CTE Month Summary CTE Month postings started with the basics on June 1st, and grew throughout the month to include more …
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, cleaner code, or de-duplication of data. I am curious what you are using CTE’s for? Please post a reply with the top things you use CTE’s for. Thanks!!
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 we took a look at CTEs for Data Paging, today we will build on what we used yesterday. These queries will be using that database that was set up in a previous posting on the CTE_DEMO …