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

Join us for the August Pittsburgh SQL Server user group meeting with speaker: Jeff Moden. Jeff will be presenting remotely for us this month. We will still be meeting for networking and free pizza.

About the session:
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 pitfalls that lead to the DBA with the bat. ;-)

Speaker: Jeff Moden
Senior Database Administrator and SQL Server Mentor at Proctor Financial, Inc., Troy, Mi.
With more than 40,000 posts and 3 dozen articles on high performance techniques, Jeff Moden is a strong contributor on SQLServerCentral.com where he coined the term “RBAR” (Row By Agonizing Row). Having two decades’ experience, Jeff is mostly self-trained in what he calls the “Black Arts” of T-SQL and is known worldwide for his informative articles, high performance T-SQL coding methods, and mentoring. His dedication to helping others has earned him the MS SQL Server MVP award for the last eight years.