Bellingham SQL Server Users Group

Next Meeting

Wednesday,

October

14

October Chapter Meeting

  • In-Person @ 709 West Orchard Drive #4 Bellingham, Washington, United States (map)
  • 18:00 - 20:00 Pacific Daylight Time
  • Language: English

The October meeting of the Bellingham SQL Server Users Group (PASS Chapter) will be held on October 14th at 6:00pm.

The agenda for the meeting will be:

- Welcome and Pizza
- Chapter news and announcements
- Technical presentation
- Socialize and networking

We are still looking for a pizza sponsor for the meeting, if anyone would like to have their company sponsor the event, please contact (Steve@Stedman.us).

The chapter meeting will be at the following address. Thanks to Derrick Bovenkamp for providing the location for this meeting.

709 West Orchard Drive #4
Bellingham, WA 98225

For any questions, please contact Steve Stedman, Steve@Stedman.us. (360)610-7833

Featured Presentation:

Advanced Common Table Expressions and Recursive Queries

Steve Stedman, Managing Technology Partner SQL Data Partners

You might have been introduced to Common Table Expressions (CTEs) and understand the WITH syntax, but want to know more. Learn how recursive queries work with CTEs and how to display hierarchical data. Did you know that you can INSERT, UPDATE, and DELETE data from CTEs? This session covers some common use cases for CTEs, including finding holes in patterns, finding and removing duplicate data, string parsing, and more. Get an in-depth understanding of the performance behind a CTE and learn when a CTE is the right (or wrong) solution. Finally, take a look at some classic recursive algorithms and how they can be implemented with CTEs.

About Steve:
Steve Stedman is the Leader of a PASS Chapter in Bellingham WA USA. Steve runs his own SQL consulting firm Stedman Solutions, LLC. He has 26 years of programming and SQL experience. He has written the book on SQL Common Table Expressions. He teaches, speaks at conferences, writes, and has taught SQL server classes at Western Washington University. Steve has previously spoken at PASS Summit, TechEd, DevTeach Vancouver, many SQL Saturdays, and more.