• subscribe


Kevin Kline

Kevin Kline is the director of technology for SQL Server Solutions at Quest Software and a founding board member of the international PASS. He is the author of SQL in a Nutshell, 3rd edition (O’Reilly).
Email: kevin_e_kline@yahoo.com

My Latest Content
My Latest Comments



Author Articles

Free Tool Review: Scripted PowerShell Automated Deployment Engine

By Kevin Kline, 01/13/2012

The Scripted PowerShell Automated Deployment Engine is a free, remote install and configuration tool for SQL Server that streamlines remote deployment and simplifies complex ...

SQL Server Compression Estimator

By Kline, Kevin, 09/15/2011

Use this free tool to figure out the best compression algorithm for databases that contain many objects.

Free Tool: SQL Sentry's Plan Explorer

By Kevin Kline, 09/06/2011

This free tool’s readability and usability features help you easily decipher SQL Server execution plan details.

Microsoft System Center Advisor

By Kevin Kline, 06/23/2011

This robust cloud service lets DBAs inventory all their SQL Server systems and quickly resolve problems or avoid them altogether.

SQL Server Query Hash Statistics

By Kevin Kline, 04/14/2011

This free tool lets you collect query performance metrics, then generate report details to analyze and visualize performance information.

SQL Server FineBuild

By Kevin Kline, 01/10/2011

Use this free tool to easily install and configure SQL Server and the accompanying services packs, cumulative updates, hotfixes, community tools, and best practice configurations.

SQL Server 2008 Spatial Tools

By Kevin Kline, 11/09/2010

Use the two executables included in the SQL Server 2008 Spatial Tools to extract and load spatial data more easily.

Microsoft Network Monitor

By Kevin Kline, 09/22/2010

Use this free tool to capture, view, and analyze detailed information about your network traffic.

AutoAudit

By Kevin Kline, 07/20/2010

Dynamically create audit trail triggers using this set of T-SQL scripts.

SP_WhoIsActive

By Kevin Kline, 05/05/2010

Use this stored procedure to quickly retrieve information about users’ sessions and activities.

Efficiently Clone Databases

By Kevin Kline, 02/22/2010

Follow the SQL Server CSS team’s step-by-step instructions for using SSMS scripts to clone databases.

Get a clue! A SQLClue, that is!

By Kevin Kline, 01/18/2010

Kevin tells you about a new SQL Server tool for DBAs who want to capture institutional knowledge

Tool Tip - The Awesomeness of RoboCopy

By Kevin Kline, 01/12/2010

Perform smarter copies or ... there will be trouble.

Join the DOTNETStories Contest

By Kevin Kline, 12/17/2009

Kevin points you to a cool contest from Microsoft for developers.

Upgrade to DTLoggedExec

By Kevin Kline, 11/30/2009

A new release is available from Davide Mauri

More Good Tools to Check Out

By Kevin Kline, 11/16/2009

Kevin points you to an update on Ola Hallengren's popular scripts, plus some new tools.

SQL Server PowerShell Extensions

By Kevin Kline, 11/04/2009

Automate even the most difficult SQL Server administrative tasks using this free PowerShell script set.

SQL Sets

By Kevin Kline, 10/27/2009

A new data collection tool from Mike Morris

Disk2Vhd, the Physical to Virtual Converter

By Kevin Kline, 10/09/2009

Kevin points you to a free tool from Microsoft, Disk2Vhd

Database Growth Tracker

By Kevin Kline, 10/08/2009

Track database growth across multiple SQL Server instances using this CLR stored procedure.