$129

50 Things All SQL Server Developers Need to Know

Event Information

Share this event

Date and Time

Location

Location

UCSD Extension

6256 Greenwich Drive

San Diego, CA 92122

View Map

Refund Policy

Refund Policy

No Refunds

Friends Who Are Going
Event description

Description

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:

  1. 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.

  2. Tricks, techniques, and metadata analysis needed to make T-SQL code, including queries and stored procedures, achieve top performance and maximum reliability.

  3. 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 (@kekline) is responsible for expanding SentryOne's technical sales and marketing initiatives and is also heavily involved in product design activities. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell.

Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, Google Author, and long-time blogger at sqlblog.com and at kevinekline.com. As a noted leader in the IT industry, Kevin's blog covers Microsoft SQL Server features and best practices, third-party software, trends in the IT industry, and professional development for IT professionals.


FAQs

What is the refund policy?

Once purchased, tickets are non-refundable. Tickets are transferrable.

What does the ticket include?

The ticket for the event includes the following:

  • Access to Session Material for the Pre-Conference Workshop
  • Continental Breakfast, Lunch and Snacks are included. If you have any dietary restrictions please let us know at sqlsaturday661@sqlsaturday.com


What should I bring to the event?

There will be a lot of information presented at the event so you will likely need something to take notes. If you have a laptop with SQL Server installed you may be able to follow along with demos or try techniques on your own databases

Where on campus is the event located?

Detailed instructions on the exact location of the classroom for your event will be sent closer to the day of the event in addition to information on parking.

Does this register me for the SQL Saturday event the next day?

No. If you are plannig on attending the main SQL Saturday event the next day, please be sure to register on the main SQL Saturday site: https://www.sqlsaturday.com/661/register.aspx.

What if I have Questions?

Please email us at sqlsaturday661@sqlsaturday.com.

Share with friends

Date and Time

Location

UCSD Extension

6256 Greenwich Drive

San Diego, CA 92122

View Map

Refund Policy

No Refunds

Save This Event

Event Saved