SQL PASS Detroit


At long last, the SPID chapter reboot is complete. We're trying to revive the group and starting to meeting regularly again.  This site is updated and the meeting archives are restored.

We also have some very good material lined up for 2018.


We have meetings on the second Thursday of every month.
We also have a new home - at the Pet Supplies Plus Headquarters in Livonia.

At the 11/8/2017 meeting, we were informed that the Microsoft Office in Southfield was closing on 11/21/2017. Sadly, we've had our last meeting at that location, but are excited about moving to our new home.

Each meeting will start with a short Q & A session.  We'll have chapter news and may also have job announcements.  The normal schedule for each meeting is:

6:00 - 6:30 - General Q & A and Announcements
6:30 - 7:30 - Presentation(s)
7:30 - 8:00 - Question & Answer Session

Next Meeting

The December meeting is on 12/14/2017.

Crosstabs and Pivots - High Performance Reporting
Presented by Jeff Moden

Don't let the "Intermediate" rating of this session scare you beginners away because we start at the ground floor and work our way up to some very high performance code. Even if you already know how to use PIVOT or CROSS TABs, you won’t want to miss this one.

This session covers and compares the PIVOT operator to an ancient but very high performance pivoting method known as CROSS TABs. Single and double column pivots will be covered and the "secret" to quickly making CROSS TABs is "Copy’n’Paste" easy. We’ll also introduce a couple of "Black Arts" techniques called "Pre-Aggregation" and "Divide’n’Conquer" to build a quarterly report for 1 year from 10 years and 10 MILLION rows of data in just half a second.

We’ll also discover that you can very quickly format reports as pretty as you’ll see in SSRS without using SSRS as well as a ton of ancillary learning throughout the presentation. 

Contact Info

Please send any questions, concerns, etc to detroit@pass.org.

If you have any questions about the group please drop us a line. If you're interested in speaking we're especially interested to hear from you.

Back to Top