Category: SQL Saturday

By Posted on Posted in CTE, SQL Saturday 2 Comments Tagged with , , , , ,

Thanks to everyone who attended my CTE presentation at SQL Saturday in Olympia Washington today.   Have a great rest of the day.  As promised I have posted the slides and sample TSQL queries here.  If you have any questions, please get in touch with me on Twitter  @SqlEmt  Remember to follow me on Twitter to stay informed of future presentations. Download the Presentation Here: Unleashing …

Unleashing CTEs in SQL Server – Slides and Sample Code – Olympia SQL Saturday Read more »

By Posted on Posted in SQL 2012, SQL Saturday 2 Comments Tagged with , , , ,

I just finished the Exploring the TSQL Enhancements in SQL Server 2012 presentation at SQL Saturday 166 in Olympia Washington. Thanks everyone who attended, I hope that you learned something useful. Here is the slides and sample code to download: Whats New in TSQL 2012 If you have any questions, please get in touch with me on Twitter  @SqlEmt  Remember to follow me …

Exploring the TSQL Enhancements in SQL Server 2012 – Slides and Sample Code Read more »

By Posted on Posted in CTE, SQL Saturday 2 Comments Tagged with , , , , , ,

Thanks to everyone who attended my CTE presentation at SQL Saturday in Portland Oregon today.   Have a great rest of the day.  As promised I have posted the slides and sample TSQL queries here.  If you have any questions, please get in touch with me on Twitter  @SqlEmt  Remember to follow me on Twitter to stay informed of future presentations. …

Unleashing Common Table Expressions in SQL Server – Slides and Sample Code Read more »

By Posted on Posted in CTE, SQL Saturday No Comments Tagged with , , , , , ,

Its going to be a great day!   Ready for SQL Saturday 172 in Portland today, looking forward learning lots, and sharing my CTE Presentation with those who want to learn about Common Table Expressions. Please come to my CTE if you are interested in any of the following: 1.What is a Common Table Expression 2.Simple CTE 3.CTE – Subquery …

SQL Saturday #172 in Portland Oregon Read more »

By Posted on Posted in CTE, SQL Saturday No Comments Tagged with , , , ,

On the next two Saturdays I will be presenting the Unleashing Common Table Expressions presentation at SQL Saturday 172 in Portland Oregon, and SQL Saturday 166 in Olympia Washington. As part of refreshing the presentation I have added a few more examples of how CTE’s can be used in common practice. Using a CTE to parse a Query String. Using …

Unleashing Common Table Expressions Read more »

By Posted on Posted in CTE, SQL 2012, SQL Saturday No Comments Tagged with , ,

I just found out that two of the sessions that I proposed for SQL Saturday #166 in Olympia next month have been accepted.  These presentations are: Exploring TSQL Enhancements in SQL Server 2012 Unleashing Common Table Expressions in SQL Server These are both presentations that I have given before and have had lots of fun with.   This should be a good …

2 Sessions Accepted for SQL Saturday 166 in Olympia Next Month. Read more »

By Posted on Posted in Code Camp, CTE, SQL 2012, SQL Saturday, TSQL 2012 No Comments Tagged with , ,

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 for this event.   What’s New in TSQL 2012 By November, this with be the fourth or fifth time presenting this one.  Its going to be a lot of fun working with the new features …

Sessions Submitted for SQL Saturday – Olympia Read more »