Greater Lansing Area for SQL Server (GLASS)

Greater Lansing Area for SQL Server

We are a group of professionals who like to get together to talk about Microsoft SQL Server and related technologies. Meetings are open and free of cost to the public but will require an RSVP so we can get an accurate count for food. 


1. Facilitate networking and create opportunities for our members
2. Deliver quality content for in-depth learning and professional development
3. Encourage community growth and development

Contact Information

1. Mailing list signup:
2. Twitter:
3. LinkedIn:


Next Meeting




The Secret to High Performance Code...The Devil’s in the Data

  • In-Person @ Lansing, Michigan, United States (map)
  • 17:30 - 19:30 Eastern Daylight Time
  • Language: English

5:30-6:00 Networking and Food 

6:00-6:15 Announcements 

6:15-7:15 Presentation 

7:15-7:30 Q&A 

7:30 Cheers! 

*Food this month is provided by the PASS summit referrals. Thanks to those who used the code last year!

Speaker: Jeff Moden 

The Secret to High Performance Code...The Devil’s in the Data

You found code you need in a “Holy Grail” article complete with test data and tests across several methods “clearly” identifying the best one to use.  Excited at your good fortune, you quickly download the code, rerun the tests on your Dev box . It “passes” with flying colors.  You promote the code to production and go home on time for a change.

The next day, your boss and the DBA are waiting for you in your cube and, look, the DBA has a bat with your name on it because your code brought the server to its knees and the code failed.

How is that possible?  The answer is, “The Devil’s in the Data”.

Whether you’re an SQL “Newbie” or seasoned veteran, this “Black Arts” session will teach you most of what you need to know to build large quantities of just about any test data you might imagine and more quickly than you ever dreamed.  It’ll also show you how to avoid the well hidden pitfalls that lead to the DBA with the bat. ;-)  You'll be surprised at how one simple and very common mistake can make your performance testing actually come out exactly backwards leading you to selecting the wrong code to promote to production.

As always with these code intensive sessions, there will be a ton of ancillary learning.



Back to Top