Kevin Kline : Internals

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)

One Week Until Louisville!

KKline — Mon, 09 Jul 2012 18:04:00 GMT

Louisville has a special place in my heart because it was my brother's home for more than 15 years. I spent a lot of time on I-65 traveling from my home town of Huntsville, AL to visit my bro in Louisville and New Albany, after he bought a place on the...(read more)

SQL Server Performance Tuning and Optimization in Jacksonville, FL on April 27th

KKline — Mon, 23 Apr 2012 13:15:00 GMT

Learn more about troubleshooting and optimizing SQL Server performance in this full-day seminar on Friday,, April 27 2012....(read more)

Microsoft Document Watch for Operational Excellence

KKline — Mon, 08 Aug 2011 19:59:00 GMT

Back when my day-to-day duties included database administration work and enterprise architecture, I became rather obsessed with the idea of operational excellence . I read everything I could on the topic. I made a list of favorites, which became somewhat...(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)

New on SQLMag.Com: Update to SP_WHOISACTIVE

KKline — Thu, 21 Apr 2011 14:12:00 GMT

I profiled Adam Machanic's ( blog | twitter ) excellent stored procedure, SP_WHOISACTIVE, back in August of 2010 in my monthly SQLMag column, Tool Time. Adam has been diligent about maintaining the tool and adding new features. Read the details on my...(read more)

How Do You SKU?

KKline — Wed, 30 Mar 2011 14:49:00 GMT

I’d like your opinion here. Follow my logic here for a moment as I walk through a couple rhetorical questions. Have you ever had a friend developed an application entirely on SQL Server Developer Edition? (Not that YOU would ever do such a thing, but...(read more)

Back in Atlanta! Wed, Feb 9 2011

KKline — Mon, 07 Feb 2011 17:04:00 GMT

I always enjoy spending time with my friends from Atlanta, as well as meeting folks and making new friends. If you live in the Atlanta area, I hope you'll join me on the evening of Wednesday, February 9th, 2011. Details are at the Atlanta SQL Server user...(read more)

New on KEK.com - Presentation: SQL Server for Oracle DBAs

KKline — Mon, 02 Aug 2010 12:23:00 GMT

Back in late May, my pal Buck Woody ( blog | twitter ) and I presented SQL Server for the Oracle DBA . Buck played Jerry Lewis' role, while I played the straight man a la Dean Martin. You can see the recording and slide deck here . Since both Buck and...(read more)

Two Free Training Webcasts Open for Registration

KKline — Mon, 24 May 2010 20:59:00 GMT

We've got two sessions that you need to sign up for right away. The upcoming webcast for Oracle-oriented folks has huge registration numbers. So get in while you still can before we hit the limit of what LiveMeeting can handle. Pain of the Week: SQL Server...(read more)

Join Me May 19th for 24 Hours of PASS

KKline — Mon, 26 Apr 2010 14:16:00 GMT

Check out all the great SQL Server sessions you can attend for FREE in this on-line event....(read more)

April Omnibus

KKline — Tue, 20 Apr 2010 15:20:00 GMT

I freely admit it - I'm a sluggard. I should be blogging a couple times per week and tweeting in between. But, for some unknown reason, April has been a tough month to get this in gear. Hence, I'm putting out an omnibus post to cover all of the stuff...(read more)

Old Performance Tuning Recommendations Die Hard

KKline — Tue, 23 Jun 2009 14:19:00 GMT

It’s interesting to me that old and inaccurate performance tuning recommendations seem to have a life of their own. In some ways, old performance tuning recommendations are like the Undead from some kind of cheesy, 1970’s zombie movie – no matter how...(read more)

Excellent new books for SQL Server professionals

KKline — Tue, 09 Jun 2009 15:53:00 GMT

Hello from Vancouver, BC! I'm enjoying the proceedings at the annual DevTeach conference and looking forward to some great sessions today.

I was recently given the privilege to tech review a new book put out by Manning Publications, written by Rod Colledge, called SQL Server 2008 Administration in Action. I liked the book so much that I was thrilled to be given the chance to write the forward for the book. Let me assure you that this admin book is unlike any other admin book for SQL Server that you might normally reach for. Unlike other reference books, this one provides a sort of very conversational set of best practices and collected wisdom, much like you might get if you were able to yell a question over the cube wall to a much more experienced DBA/mentor. The book itself is not free, but several of the chapters are free. I believe the book is absolutely worth the money. But at a minimum, grab the free chapters.

Another free SQL resource you might want to consider is the new 485-page e-book written by Jacob Sebastian called SQL Server XML Schema Collections. It explains XSD and XML schema collections in great detail, something that has always mystified me. Take some time to pull this one down and add it to your library.

Cheers,

-Kev

Twitter @ kekline