SQL PASS Detroit

Announcements

At long last, the SPID PASS Chapter "reboot" is complete.  Although the December 2017 and all 2018 meetings are scheduled for the 2nd Thursday of every month, we had a great opportunity to enlist a guest speaker on the 8th of November and had a great turnout of 22 people not including the Chapter Officers! 

Thanks to the help of some great speakers, we also have speakers on some great topics lined up for all but 4 of the next 13 meetings and we're working on those!  Special thanks go out to the wonderful folks at Pet Supplies Plus Corporate Headquarters in Livonia, Michigan, we have a new home for all 13 meetings.

Also, our Chapter President, Ed Wagner, worked with the wonderful folks at PASS and has been able to restore all previous meeting archives!

Welcome

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

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.  Please make your FREE reservations for the meeting at EventBrite.  The meeting location is included on the EventBrite reservation page.

Special thanks to the following sponsors...


Crosstabs and Pivots - High Performance Reporting

Speaker:     Jeff Moden
Duration:     ~90 minutes
Track:          Application & Database Development
Level:          Intermediate

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.

Speaker Bio:
Jeff Moden
Senior Database Administrator and SQL Mentor, Proctor Financial, Inc., Troy, Mi, USA
VP of the “SPID” (SQL People In Detroit) SQL Server User Group, Livonia, MI 48152

With more than 45,000 posts, 3 dozen 5 star articles and 430 thousand “likes”, Jeff Moden is a strong contributor on SQLServerCentral.com where he coined the term “RBAR” (Row By Agonizing Row).  Jeff has more than 2 decades of experience with SQL Server and is mostly self-trained in what he calls the “Black Arts” of T-SQL.  He’s known worldwide for his informative articles, high performance T-SQL coding methods, and methods of mentoring.  His dedication to helping others earned him the MS SQL Server MVP award for nine years and the RedGate Exceptional DBA Award in 2011.  His mantra is "Performance is in the code".

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
cage-aids
cage-aids
cage-aids
cage-aids