Kevin Kline - 50 Things All SQL Server Developers Need to Know

Dmitri Korotkevitch is a Microsoft Data Platform MVP, Microsoft Certified Master of SQL Server and author of “Pro SQL Server Internals” and other books. Dmitri has more than 20 years of IT experience including years of experience working with Microsoft SQL Server as an Application and Database Developer, Database Administrator, and Database Architect.Dmitri specializes in the design, development, and performance tuning of complex OLTP systems that handle thousands of transactions per second around the clock. He blogs at: http://aboutsqlserver.com.

SQL Saturday Cork - Dmitri Korotkevitch

Summary: This session takes you through 50 of the most challenging and commonplace patterns and anti-patterns when writing SQL and Transact-SQL code and shows how to deal with them all. Loaded with live demonstrations and useful techniques, this session will teach you how to take your SQL Server queries mundane to masterful.
 
Level: 200-300
 
Abstract: What are the most problematic patterns and anti-patterns that trip up SQL Server developers on a daily basis? What sort of SQL and Transact-SQL challenges does every SQL Server developer encounter at some point in their career? This full-day, pre-conference seminar takes a tour of the most common and challenging issues that database developers face. Learn how to conquer them in the lab today so that they won’t take you surprise in the future. Loaded with live demonstrations and useful techniques, this session will teach you how to take your SQL Server queries mundane to masterful.
 
In this session, you’ll learn:
 
<OL>
<LI CLASS="MsoNormal">Internal operations of the SQL Server query optimizer and caching mechanisms and their impact on T-SQL code performance, including ways to shortcut default behavior using trace flags. </LI>
<LI CLASS="MsoNormal">Tricks, techniques, and metadata analysis needed to make T-SQL code, including queries and stored procedures, achieve top performance and maximum reliability.</LI>
<LI CLASS="MsoNormal">A variety of patterns and anti-patterns in T-SQL coding that are common challenges for all but the most advanced database developers.</LI>
</OL>
 
With these 50 tricks and techniques in your coding toolkit, you’ll be able to write T-SQL code that consumes less system CPU, memory, and IO, while being easier to maintain and offering faster performance. 
 
Prerequisites: Intermediate competence in SQL and Transact-SQL syntax, such as coding with DML, DDL, and DCL transactions, using cursors and variables, and invoking functions and procedures. Basic familiarity with reading execution plans.
 
Goal 1: Learn how to build credibility and influence within your IT team.
 
Goal 2:Discover the interpersonal and communication skills that enable you to survive and bounce back quickly from hard times.
 
Goal 3:Explore key organizational concepts that enable you to ensure your job is always safe.

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}

Kevin Kline - 50 Things All SQL Server Developers Need to Know

More events from SQL Saturday Cork - Dmitri Korotkevitch

Discover more events from SQL Saturday Cork - Dmitri Korotkevitch, from Science & Tech to other experiences you might love.

Kevin Kline - 50 Things All SQL Server Developers Need to Know

More events from SQL Saturday Cork - Dmitri Korotkevitch

Discover more events from SQL Saturday Cork - Dmitri Korotkevitch, from Science & Tech to other experiences you might love.

You might also like...

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