Pittsburgh SQL Server Users Group


Next Meeting: Tue, Aug 30 2016

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

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.meetup.com/PittsburghSQL/events/233307852/



UTC : Tue, Aug 30 2016 21:30 - 23:00
Event Time : Tue, Aug 30 2016 17:30 - 19:00 Eastern Daylight Time
Your Local Time: Tue, Aug 30 2016 21:30 - 23:00


Nova Place
Pittsburgh, Pennsylvania

Direction: None

Featured Presentation

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

Speaker: Jeff Moden, Senior Database Administrator and SQL Mentor Proctor Financial, Inc.

Summary: 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. ;-)

About Jeff: With more than 47,000 posts and 3 dozen mostly 5 star articles, Jeff Moden is a strong contributor on SQLServerCentral.com where he coined the term “RBAR” (Row By Agonizing Row) and helped make the "Tally Table" a household name. 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".



Thank you to our Sponsors!







Back to Top