Name: SQL Server Black Arts - High Performance Tools and Techniques
Start: 2018-09-28T09:00:00-04:00
End: 2018-09-28T17:00:00-04:00
Location: Pittsburgh Technical College: Official

SQL Server Black Arts - High Performance Tools and Techniques

Pittsburgh SQL Server Users Group

You already know how to write good, high performance code using the right kind of joins, effective criteria, and proper indexing, but then there are those “special” problems that you just won’t find the answers to in “Books Online”. Or, maybe you’re a beginner and want to see “what’s possible” but don’t know where to even begin on the Internet. That’s where Black Arts SQL comes in.
Black Arts SQL is thought to be the arcane, overly-complicated stuff that’s beyond understanding by anyone except for a select few. In reality, nothing could be further from the truth. It’s simply an approach to solving problems that lets the database engine do what it does best to achieve high performance.
This full-day pre-conference to SQL Saturday #770  by Jeff Moden (the guy that coined the term “RBAR”) and Ed Wagner (another set-based heavy hitter on <A HREF="http://www.sqlservercentral.com/" TARGET="_blank" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">http://www.sqlservercentral.com/</A>) will introduce a set of tools and techniques used to write high-performance code. You’ll learn the art of counting and why it’s important, the best type of functions to use, how to build mountains of test data in seconds, some indexing tricks, and several high-impact performance techniques. We’ll also look at measuring performance, temporal and other math shortcuts, several things that actually kill performance, and many ancillary topics, as well.
The seminar is very code-centric and includes lots of example scenarios and solutions. You’ll walk away from it with many tools for your toolbox but, even better than that, you’ll have the knowledge to look at some pretty complex problems in the future and build your own tools to solve them.
A hot lunch will be provided and the presentation and all code used in the presentation will be provided on a thumb drive to each attendee.  And parking is FREE.
 
Speaker Bio: 
<DIV CLASS="fn panel_border">
<DIV CLASS="note">
Jeff Moden is a mostly self-taught DBA, Database Developer, and 8 year SQL Server MVP. He's also a heavy hitter on SQLServerCentral.com and has 40,000 posts and 33 mostly 5 star articles on the Black Arts of T-SQL.  Jeff has nearly 20 years of experience with SQL Server and T-SQL and has been writing and teaching computer related courses since 1977. His articles have made many an advanced technique, like the Tally or Numbers Table, household terms and he coined the world-known term “RBAR”, which is a “Modenism” for “Row By Agonizing Row”.
Ed Wagner is also a mostly self-taught DBA with 24 years experience in database design, development and administration.  He's a frequent poster on SQLServerCentral.com and has two very well received published articles.  Ed's also a big believer in "performance by design" and you'll see that in the code in the presentation.  He specializes in high-performance and "black arts" SQL and actually enjoys it.
 
</DIV>
</DIV>

Pittsburgh Technical College: Official

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

SQL Server Black Arts - High Performance Tools and Techniques

More events from Pittsburgh SQL Server Users Group

Follow organizers to get events picked for you

SQL Server Black Arts - High Performance Tools and Techniques

More events from Pittsburgh SQL Server Users Group

Follow organizers to get events picked for you

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.