Kevin_Kline.jpg

Kevin Kline

Kevin Kline is a noted database expert and software industry veteran currently serving is the Director of Engineering Services at SQL Sentry, a leading vendor of database and business intelligence tools. A Microsoft SQL Server MVP since 2004, Kevin was a founding board member and former president of PASS. He has written or co-written tweleve books including the best-selling SQL in a Nutshell.  Kevin contributes monthly columns to SQL Server Pro and DBTA magazines.  Kevin is a noted trainer and thought leader on IT leadership skills, database management technology and practices, and SQL Server performance tuning and optimization.  Kevin is a top-rated speaker at conferences worldwide. He is on Twitter, Facebook, and LinkedIn at @kekline and blogs at http://KevinEKline.com.

http://KevinEKline.com http://feeds.feedburner.com/KevinEKline

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.
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.
Tuning disk subsystems for optimal SQL Server performance is typically the domain of very experienced, enterprise DBAs. This session will short-cut you past years of hard-won experience straight to the essentials of IO tuning for 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!
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
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.
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
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.
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.

Blog posts RSS

ICYMI: Parameter Sniffing, Friends with Partition Benefits, and SELECT INTO Parallelism – SQL Server Performance 06 Apr 2015
Great topics for further reading about tuning SQL Server performance: Exploring SQL Server 2014 SELECT INTO Parallelism Joe Sack (b | t) provides us with a peak into the performance improvements and new behaviors of SQL Server 2014 in the way it can now parallelize large SELECT INTO ...

Advice to New Bloggers 31 Mar 2015
PREAMBLE If you’ve been reading my blog for a while, you know that I travel and speak quite a lot. A frequent question I’m asked at these events is “I want to start blogging, but don’t know where to start. What do you recommend?” This is a such a common and natural ...

ICYMI: Partitioning Advice, Purging Data Bloat, and an example of TVF Misbehavior – SQL Server Performance 30 Mar 2015
Here are some oldies, but goodies that I recommend you read: Two Partitioning Peculiarities and Aggregates and Partitioning Most of us know that partitions are one of the best ways to scale very large databases or very large IO workloads.  However, there are risks, two of which are explored in ...

ICYMI: Query Optimization Phases, Observer Overhead, and Secrets of SP_Updatestats – SQL Server Performance 23 Mar 2015
Cool and informative articles about SQL Server performance relating to query optimization phases, observer overhead due to monitoring, and secret behaviors of SP_Updatestats. The post ICYMI: Query Optimization Phases, Observer Overhead, and Secrets of SP_Updatestats – SQL Server Performance ...

ICYMI: Troubleshooting CPU, Logging Myths, Missing Indexes, and Query Tuning Examples 16 Mar 2015
Great Articles at SQLPerformance.com There are so many good articles from SQLPerformance.com this ICYMI article that it’s hard to know which are best to highlight in the limited space. So, I’ll be arbitrary and simply choose a few of my favorite entries as well look back: Troubleshooting SQL Server ...