Skip Main Navigation
Page Content

Save This Event

Event Saved

50 Things All SQL Server Developers Need to Know

SQLSaturday Nashville

Friday, January 12, 2018 from 8:30 AM to 4:00 PM (CST)

50 Things All SQL Server Developers Need to Know

Ticket Information

Ticket Type Sales End Price Fee Quantity
Regular full-day:   more info Jan 10, 2018 $129.00 $9.25
BOTH Days (1 half-day & 1 full-day | 1.5 days of training)   more info Jan 10, 2018 $165.00 $11.25

Who's Going

Loading your connections...

Share 50 Things All SQL Server Developers Need to Know

Event Details

50 Things All SQL Server Developers Need to Know

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:

  • 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.
  • Tricks, techniques, and      metadata analysis needed to make T-SQL code, including queries and stored      procedures, achieve top performance and maximum reliability.
  • A variety of patterns and      anti-patterns in T-SQL coding that are common challenges for all but the      most advanced database developers.

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.

Kevin Kline

Kevin Kline is a noted database expert and software industry veteran is a senior member of staff at SentryOne, a leading vendor of database tools. A Microsoft Data Platform MVP since 2003, Kevin was a founding board member and former president of the Professional Association for SQL Server. He has authored more than ten books, including the best-selling SQL in a Nutshell. Kevin contributes a monthly column to Database Trends magazine. Kevin is a top-rated speaker on technology and professional development topics at conferences worldwide such as Microsoft Ignite/TechEd, the PASS Summit, DevTeach, Oracle OpenWorld, and IT/Dev Connections. He tweets at @kekline and blogs at http://KevinEKline.com.

 

Don't forget to visit www.sqlsatnash.com for details about SQLSaturday Nashville!

Have questions about 50 Things All SQL Server Developers Need to Know? Contact SQLSaturday Nashville

Save This Event

Event Saved

When & Where


MTSU *Business & Aerospace Building (BAS) Room S274
1301 East Main Street
Mufreesboro, TN 37132

Friday, January 12, 2018 from 8:30 AM to 4:00 PM (CST)


  Add to my calendar
50 Things All SQL Server Developers Need to Know
Things to do in Mufreesboro, TN Class Science & Tech

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.