Kevin Kline : Tips

Squishy Limits in SQL Server Express Edition

KKline — Thu, 28 Mar 2013 12:19:00 GMT

Do you use Express Edition? Then you might not know that the published memory limits are not set in stone....(read more)

Learn More About SQL Server IO and Query Tuning in These Webcasts

KKline — Fri, 14 Dec 2012 18:50:00 GMT

Join database expert Kevin Kline in two new webcasts for SQL Server users: Storage IO Best Practices and Query Tuning Best Practices....(read more)

Quick Tip - Speed a Slow Restore from the Transaction Log

KKline — Wed, 14 Nov 2012 15:59:00 GMT

Here's a quick tip for you: During some restore operations on Microsoft SQL Server, the transaction log redo step might be taking an unusually long time. Depending somewhat on the version and edition of SQL Server you've installed, you may be able to...(read more)

The Zombie PerfMon Counter That Never Dies! Quick Tip

KKline — Mon, 08 Oct 2012 11:55:00 GMT

Learn the Performance Monitor counters to avoid and those to exploit for the latest versions of Microsoft SQL Server from database expert Kevin E. Kline....(read more)

Two New Slide Decks. Plus, the Week in Colorado.

KKline — Mon, 20 Aug 2012 15:03:00 GMT

Kevin provides two new session slide decks and tells about his week presenting sessions in Colorado from August 14-17, 2012....(read more)

New Developments at SQLServerPedia.com

KKline — Tue, 17 Jul 2012 17:07:00 GMT

Kevin details how to join SQLServerPedia as a syndicated blogger and what's next for the popular website and wiki....(read more)

Flexibility When Waiting on Locks

KKline — Thu, 17 May 2012 13:29:00 GMT

An attendee at a recent performance tuning session wanted ideas to more flexibly react to locks on blocks than using the WITH (NOLOCK) hint....(read more)

Dev Advice: Make a Tiny Dev Database Act Like a HUGE Prod Database

KKline — Fri, 16 Mar 2012 14:30:00 GMT

If you're struggling with doing development on a big SQL Server database, learn the ropes on cloned databases asap! ...(read more)

Must-Have Resources - SQL Server Backup & Recovery

KKline — Thu, 08 Dec 2011 20:36:00 GMT

The industry's best resources for maximizing Microsoft SQL Server backup and recovery. Don't get burned!...(read more)

Information Hoarder No More!

KKline — Wed, 02 Nov 2011 14:16:00 GMT

Kevin tells you how he is now keeping up with the thousands of blog posts, newsreader feeds, e-newsletters, and social media entries in his information hoard....(read more)

Simplifying CSV Data Loads

KKline — Thu, 27 Oct 2011 17:55:00 GMT

Data files containing comma separated values, or CSV, are some of the most common data formats used for data representation and storage outside the database. When it comes to loading CSV data into the database, many options exist, however, few make it...(read more)

Troubleshooting Repeated Login Failures on SQL Server

KKline — Fri, 21 Oct 2011 13:05:00 GMT

I’d recently experienced a situation where I was getting repeated login failures to a SQL Server where I knew that I had the correct user name and password. Each time, I’d get error 18456 in response. "Login failed for user '<user_name>'. (Microsoft...(read more)

What I'm Reading, July 22 2011

KKline — Thu, 21 Jul 2011 14:43:00 GMT

I read too much, and that, my friends, is an entirely separate topic for a blog post. But I thought I'd share with you a little more about what I'm reading because sometimes, if I'm lucky, it might be something you'd enjoy too. So I'm going to start sharing...(read more)

Microsoft Windows Platforms Blog Watch

KKline — Wed, 20 Jul 2011 14:44:00 GMT

Remote Desktop Services Component Architecture Poster Grab your own poster! A visual guide to key Remote Desktop Services technologies in Windows Server 2008R2 Virtually Free Get the latest update rollup package for the Hyper-V role in Windows Server...(read more)

Pulling real-time data from Twitter using StreamInsight and Other Scandinavian Treasures

KKline — Tue, 03 May 2011 15:43:00 GMT

On my recent trip to SQLBits with subsequent visits to Dublin, Cologne, and Malmo (southern Sweden), I enjoyed a chance to meet several SQL Server MVPs, including Peter Larsson and Thomas Ivarsson. Among them, I enjoyed Johan Ahlen's article on Pulling...(read more)