St. Louis SQL Server User Group

Welcome to the St. Louis SQL Server User Group (STLSSUG)   

Join Our Group Online!

PASS Summit 2019 Seattle, WA November 6-8
Use code LGDIS7RW6 to receive a $150 discount off your PASS Summit 2019 registration



Next Meeting




STLSSUG December 10th Meeting

  • In-Person @ 3 City Place Drive, 11th Floor, Room #2 St. Louis, Missouri, United States (map)
  • 13:00 - 16:00 (UTC-06:00) Central Time (US & Canada)
  • Language: English

Supplementary Materials

The following event attachments are available to you:

December 10th 1:00- 4:00 p.m. cdt
The next St. Louis SQL Server User Group meeting on December 10th from 1 – 4 p.m cdt  .    Please RSVP, so that we can have a count for the lunch order, by sending an email to:    
Also, please feel free to forward this meeting announcement to anyone who may be interested in attending.
This will also be broadcasted as a lync meeting.  Lync meeting link is listed below
Location: Microsoft St. Louis Office, Three City Place Drive, Suite 1100, St. Louis, MO  63141.  Parking is in the garage behind / next to the building.  There is an entrance to the building from the 2nd floor in the garage.
12:30 – 1:00    Registration - Lunch Provided by Convent Technology Partners
1:00                 STLSSUG Organization Voting

1:15                Clayton Groom, Covenant Technology Partners – Simplifying and improving your SQL queries with CTE's and Windowing Functions 

2:30                Multiple STLSSUG Members – SQL Bytes
4:00                 Raffle Drawing –  Apress, Wrox, McGraw-Hill, Murach, Wiley, O'Reilly/MS Publishing Books and more!
Clayton Groom
Is a veteran SQL Server Data Architect, with a deep background in both OLTP and Business Intelligence applications. He has worked with SQL Server for 20 years, and is still learning it and amazed at what is possible with the product.
twitter: cgroom  or sqlmonger
Simplifying and improving your SQL queries with CTE's and Windowing Functions 
Too busy to learn the new capabilities of SQL Server? This session will cover several of the new features of the T-SQL language, specifically Common Table Expressions (CTE's) and Windowing Functions. This will be an code-heavy session with examples that you can readily leverage in your solutions.

The focus will be on techniques to shape and manipulate your data for easier consumption by your application, and to leverage your SQL Server to avoid writing code in your application.

A basic to intermediate understanding of  T-SQL is required.
SQL Bytes
St. Louis User Group members will be giving a mixture of 10-15 minute presentations 
Join by phone
+13149941870 (USA, Saint Louis)          English (United States)
Conference ID: 354896
Microsoft Lync Meeting can be used to record meetings.
By participating in this meeting, you agree that your communications may be monitored or recorded at any time during the meeting. 




Back to Top