SQL PASS Detroit

Announcements

Thanks to the help of some great speakers, we have speakers on some great topics lined up for all but 3 of the 2018 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 of 2018.

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.

Each meeting start with a short introduction and Q & A session, where 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 (90-minute presentations will run until 8:00)
7:30 - 8:00 - Question & Answer Session

Special thanks to the following sponsors...


Next Meeting

The February meeting is on 2/8/2018.  Please make your FREE reservations for the meeting at EventBrite.  The meeting location is included on the EventBrite reservation page.

Why Defragmenting Your Indexes Isn't Helping

For years, you’ve heard that you’re supposed to reorganize your indexes to make SQL Server go faster. It sounds like it makes sense – keep things in order, right? But you keep doing it, and SQL Server isn’t getting any faster. You’ve even heard that setting fill factor will help prevent fragmentation, and you’re doing that too – but your indexes still keep getting fragmented every day, and users aren’t happy with performance.

This advice made a lot of sense at the turn of the century, but today, things are different – and we’re not just talking solid state drives. In just the first 15 minutes, you’ll have a series of ah-ha moments when you realize that your daily index maintenance jobs might just be making the problem worse instead of better. Then, you’ll learn what you need to do instead.

Speaker Bio: Brent Ozar
Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz and the SQL Server First Responder Kit, and he loves sharing knowledge at BrentOzar.com.

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