Skip Main Navigation
Page Content
This event has ended

50 Things All SQL Server Developers Need to Know - Pre-con with Kevin Kline, Microsoft MVP

Microsoft Business Intelligence South Florida User Group (MSBISF)

Friday, June 13, 2014 from 9:00 AM to 5:00 PM (EDT)

50 Things All SQL Server Developers Need to Know -...

Ticket Information

Ticket Type Sales End Price Fee Quantity
50 Things All SQL Server Developers Need to Know
50 Things All SQL Server Developers Need to Know by Kevin Kline
Ended $125.00 $7.24

Who's Going

Loading your connections...

Share 50 Things All SQL Server Developers Need to Know - Pre-con with Kevin Kline, Microsoft MVP

Event Details

50 Things All SQL Server Developers Need to Know

Speaker: Kevin Kline, SQL Server MVP  and Director of Engineering at SQL Sentry

Kevin Kline

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.

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.

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.

Speaker Bio:

Kevin Kline is a well-known database expert and software industry veteran. A long-time Microsoft SQL Server MVP and noted leader in the IT industry, Kevin is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a top-rated speaker at industry trade shows worldwide, has a monthly column at DBTA magazine, and regular webcasts at SSWUG.Org. He tweets at @kekline and blogs at http://KevinEKline.com, as well as at http://ForITPros.com for issues of IT leadership. Kevin is the Director of Engineering Services at SQL Sentry, a leading vendor of database and business intelligence tools.

Have questions about 50 Things All SQL Server Developers Need to Know - Pre-con with Kevin Kline, Microsoft MVP? Contact Microsoft Business Intelligence South Florida User Group (MSBISF)

When & Where


Nova Southeastern University
Carl DeSantis Building
3301 College Ave
Fort Lauderdale, FL 33314

Friday, June 13, 2014 from 9:00 AM to 5:00 PM (EDT)


  Add to my calendar

Organizer

Microsoft Business Intelligence South Florida User Group (MSBISF)

The Microsoft Business Intelligence User Group of South Florida (MSBISF) is dedicated to helping BI professionals advance their career through free educational, training, and networking opportunities offered every second Wednesday of each month.  Membership is free of charge and the group meets at the Carl DeSantis building at Nova Southeastern University campus in Davie, Florida.  For more information, please contact David Ortiz at dortiz@allegient.com or Marilyn Rousseau at sqldudette@gmail.com.

  Contact the Organizer

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.