SQLBits 2013
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
Stereotypes abound for different types of people in the IT world. Developers think DBAs are
control freaks. DBAs think developers are unruly cowboys. How do we overcome these differences?
If you’re a developer, your best strategy is to manage your DBAs’ anxieties and demonstrate your
competence and credibility. 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.
This session will answer questions like:
What’s the most common Transact-SQL programming mistake and how do I fix it?
How do database designers cause problems for future generations of application developers and
database administrators?
Why do inexperienced database administrators make their own job more difficult and less
efficient?
-
There are a short list of mistakes that, if you know of them in advance, will make your life much easier.
These mistakes are the “low hanging fruit” of application design, development, and administration.
Once you apply the lessons learned from this session, you’ll find yourself performing at a higher level of
efficiency and effectiveness than before.
control freaks. DBAs think developers are unruly cowboys. How do we overcome these differences?
If you’re a developer, your best strategy is to manage your DBAs’ anxieties and demonstrate your
competence and credibility. 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.
This session will answer questions like:
What’s the most common Transact-SQL programming mistake and how do I fix it?
How do database designers cause problems for future generations of application developers and
database administrators?
Why do inexperienced database administrators make their own job more difficult and less
efficient?
-
There are a short list of mistakes that, if you know of them in advance, will make your life much easier.
These mistakes are the “low hanging fruit” of application design, development, and administration.
Once you apply the lessons learned from this session, you’ll find yourself performing at a higher level of
efficiency and effectiveness than before.
Speakers
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.