SQLBits 2015

Practical T-SQL Tips & Tricks to coding problems

In this demo-packed session, you’ll learn practical tips and tricks for SQL code tuning from experienced SQL Server MVPs Aaron Bertrand and Kevin Kline as they walk you through some of the most problematic and troublesome SQL coding problems.

In this demo-packed session, you’ll learn practical tips and tricks for SQL code tuning from experienced Microsoft SQL Server MVPs Aaron Bertrand and Kevin Kline (author of SQL in a Nutshell) as they walk you through some of the most problematic and troublesome SQL coding problems. Using both free and paid tools from SQL Sentry, you’ll learn tips and tricks you can take home and immediately apply to your SQL code. You’ll learn things like what’s the best way to write a cursor, a quick trick that can save you 20-30% processing times
on your big stored procedures, some major T-SQL bad habits, and even some new SQL Server 2014 features. And, you might end up seeing something in the free tools that will significantly improve the way that you work!

SentryOne's previous sessions

Practical T-SQL Tips & Tricks to coding problems

In this demo-packed session, you’ll learn practical tips and tricks for SQL code tuning from experienced SQL Server MVPs Aaron Bertrand and Kevin Kline as they walk you through some of the most problematic and troublesome SQL coding problems.

Top Tools for Tuning SQL

In this demo-packed session, you’ll learn practical tips and tricks for SQL code tuning from experienced Microsoft SQL Server MVPs Aaron Bertrand and SQL in a Nutshell author Kevin Kline

Monitoring and Performance Tuning for AlwaysOn

SQL Sentry will present their revolutionary new software which provides enhanced visibility and manageability for advanced AlwaysOn topologies.

SQL Trivia Bowl

Let’s have some fun! Using a game show style presentation, Kevin will test your knowledge of IT pop culture, IT history, computers, database technology, and – of course – SQL Server. Winners get prizes!

Memory Management for Analysis Services with SQL Sentry

Learn how to monitor Analysis Services with SQL Sentry Performance Advisor. Get tips on best practices, monitoring counters and options plus improve your understanding of how Analysis Services uses memory and where it differs from SQL Server.

Expert Query Analysis with SQL Sentry

Kevin Kline's other proposed sessions for 2026

Query Tuning Internals for the Advanced SQL Developer - 2026

Query Tuning Telemetry for the Advanced SQL Developer - 2026

Kevin Kline's previous sessions

How to Conduct a Transact-SQL Code Review

Learn a collection of important best practice for Transact-SQL code and how to integrate them into your code acceptance testing for better performance and efficiency.

Shift-Left: A DevOps and Database Story

Database code often works well in a test environment, but end up causing significant performance issues when rolled out to production. In turn, these performance issues lead to lost productivity, excess resource consumption, and lost time spent troubleshooting the issue. But what if we could catch those issues during development? Join Kevin Kline to learn how SolarWind's SQL Sentry can shift performance tuning left to the dev cycle so those issues never occur on production systems in the first place.

SQL Horror Stories

Join Kevin Kline as he takes you on a guided tour of some of the worst and most horrible SQL coding experiences. Some were intention and some were accidental. But all of them will make you wince and laugh! Learn new SQL coding tips and tricks from these cautionary tales.

De-risk Your Azure SQL Migration: 5 Critical Considerations

The session takes you through the most critical considerations for moving your on-premise data and databases into the Azure cloud, with a focus on the steps leading to the migration and immediately afterwards.

Pitch Perfect-Presenting Ideas That Win Executive Support

You want to make your IT organization better, new software or hardware, new team process, or other significant change? Is you organization’s management are prone to saying ‘No’ to things like this in the past. How do you move forward successfully?

Optimizer Secrets: Debugging using 860x Trace Flags

Learn about the powerful 8600 series of trace flags which additional details about how the query optimizer behaves as it processes a query.

Ten 10 Query Tuning Techniques Every SQL Programmer Should K

Learn how to assess query performance, ensure consistent and reliable query tuning, and avoid ten all-too-common performance killers in SELECT statements running on Microsoft SQL Server.

Top 10 Mistakes of New IT Leaders

New IT leaders are rarely trained in the soft skills needed to be successful when put in charge. This one-hour session will explore the ten most frequent and challenging mistakes that new IT leaders make, as well as discuss methods for combating thos

An End-to-End Troubleshooting Checklist for SQL Server

Microsoft ships a multitude of tools to help detect, diagnose and resolve problems inside of SQL Server. But which is best to use and when? This session teaches attendees how to tackle the troubleshooting process to achieve repeated, optimal results.

Practical T-SQL Tips & Tricks to coding problems

In this demo-packed session, you’ll learn practical tips and tricks for SQL code tuning from experienced SQL Server MVPs Aaron Bertrand and Kevin Kline as they walk you through some of the most problematic and troublesome SQL coding problems.

Top Ten Crucial Dev Skills to Make Your DBA Happy

Attend this session to learn about 10 techniques that developers can apply to their code which will calm your DBAs’ fears and earn their admiration

Top 10 Administrator Mistakes on Microsoft SQL Server

Microsoft SQL Server is one of the easiest database to setup and administrate. But that doesn't mean it's problem free. Find out the most common DBA mistakes on SQL Server so that you can make sure not to make them!

Understanding and Preventing SQL Injection Attacks

SQL Injection attacks are one of the most common hacker tricks used on the web. Learn all about SQL Injection attacks in this perennially favorite session.

Understanding and Preventing SQL Injection Attacks

SQL injection can happen to you! But SQL injection is also very easy to prevent. Learn the ins and outs of SQL injection so that you don't become a victim.

Aaron Bertrand's previous sessions

New T-SQL Capabilities in SQL Server 2016 & v.Next

Discover the ins and outs of some of the newest capabilities of our favorite data language, and walk away with a long list of reasons to consider upgrading to the latest version - or the next version.

T-SQL : Bad Habits & Best Practices

Come learn how bad habits develop, what kind of problems they can lead to, and how you can avoid them - leading to more efficient code, a more productive work environment, and - in a lot of cases – both.

Five Ways to Write More Effective Triggers

Many triggers are inefficient and violate best practices, but it doesn't have to be this way. Join this session and learn how to improve your triggers and keep them off the list of potential scapegoats for your SQL Server performance woes.

Practical T-SQL Tips & Tricks to coding problems

In this demo-packed session, you’ll learn practical tips and tricks for SQL code tuning from experienced SQL Server MVPs Aaron Bertrand and Kevin Kline as they walk you through some of the most problematic and troublesome SQL coding problems.

T-SQL : Bad Habits & Best Practices

Come to this session to learn how bad habits develop, the problems they lead to, and how you can avoid them.

T-SQL : Bad Habits & Best Practices

This session will cover a collection of minor bad habits that can occasionally lead to major problems, and a set of best practices that you should always have in mind.

T-SQL : Bad Habits to Kick

This session will explore a handful of T-SQL practices - why they happen, why they're bad, and how we can work around them.