Andrew Kelly

sp_spaceused Alternative

Andrew Kelly — Fri, 17 May 2013 20:35:00 GMT

I don’t know why but for some reason I have never liked using sp_spaceused. It probably started a long time ago when the results were often inaccurate due to the meta data being out of date. I am pretty sure that was fixed somewhere along the line but...(read more)

Speaking at University of Virginia

Andrew Kelly — Mon, 05 Nov 2012 17:37:00 GMT

The University of Virginia is having a fall conference that is free and open to the public on Tuesday November 13th. My good friend Andy Leonard and I will be speaking on various SQL Server related topics so if you are in the area and available that day...(read more)

Backup File Naming Convention

Andrew Kelly — Fri, 05 Oct 2012 19:41:00 GMT

I have been asked this many times before and again just recently so I figured why not blog about it. None of this information outlined here is rocket science or even new but it is an area that I don’t think people put enough thought into before implementing....(read more)

Speaking at SQL Saturday #146

Andrew Kelly — Tue, 25 Sep 2012 14:49:06 GMT

For any of you up in the New England area that are looking for some good and free SQL Server training you may want to check out the SQL Saturday this fall in southern NH. More specifically the event will be held in Nashua NH on October 20th 2012....(read more)

Speaking in Raleigh NC 9-20-2011

Andrew Kelly — Thu, 15 Sep 2011 13:54:05 GMT

If you are in the area I will be speaking at the Triangle SQL Server Users Group meeting on Tuesday the 20th of September 2011. The session is on TempDB Best Practices and all of the details for the topic, directions etc. can be found here . ...(read more)

Speaking at the Charlotte Users Group

Andrew Kelly — Sat, 27 Aug 2011 00:33:55 GMT

I will be giving a presentation in between Earthquakes and Hurricanes in Charlotte NC. this Wednesday the 31st of August on Understanding Indexes in SQL Server 2008 . If you are in the area please drop by and say hello. You can find out more information...(read more)

Finding IP Addresses With CMS

Andrew Kelly — Mon, 25 Jul 2011 20:14:29 GMT

I was just tasked with putting together a list of all the IP Addresses of the SQL Servers that one of my clients deals with on a daily basis. In this case there was over 30 of them and while I could ping each one individually I found an easier...(read more)

Speaking in Richmond VA

Andrew Kelly — Thu, 14 Jul 2011 12:59:37 GMT

I meant to blog about this many days ago but such is life right . In a few hours I will jump into my truck (wish it was the Harley) and drive up to Richmond Va. to see my good friend Andy Leonard and the other folks at the Richmond SQL Server...(read more)

The latest edition of the SolidQ Journal is now available

Andrew Kelly — Mon, 11 Jul 2011 23:57:44 GMT

The SolidQ Journal is published monthly by SolidQ and packed with lots of good information related to SQL Server and related topics. If you haven’t already signed up to get these each month then have a look here . It’s a free resource that...(read more)

Speaking in Columbia SC

Andrew Kelly — Mon, 13 Jun 2011 17:34:22 GMT

I just wanted to let anyone in the area that I will be presenting a session at the Midlands PASS Chapter in Columbia SC. on Tuesday night the 14th of June 2011. The title is “Understanding Indexes in SQL Server 2008” and you can find more...(read more)

SQL Server 2008 R2 Analysis Services Operations Guide

Andrew Kelly — Wed, 01 Jun 2011 22:03:00 GMT

Some members of the SQL CAT Team just released an Operations Guide for SQL 2008 R2 Analysis Services that can be found here . While I am not a SSAS person by any means this looks pretty cool and worth while for anyone who does work with it so have a look....(read more)

New Book on the Query Optimizer

Andrew Kelly — Sat, 09 Apr 2011 22:30:04 GMT

A friend of mine Benjamin Nevarez has written a book on the inner workings of the Query Optimizer and it was just released. I read a preview and was definitely impressed so I expect the full version to be just as good. More details can be found...(read more)

Practical Performance Monitoring and Tuning

Andrew Kelly — Sat, 09 Apr 2011 20:54:33 GMT

My next performance class will be in San Francisco, CA on May 9th thru the 11th. I haven’t been to San Francisco in about 10 years and I am looking forward to getting back there. The material is a bit refined over the first class and I added a...(read more)

System Center Advisor Collection Details

Andrew Kelly — Thu, 07 Apr 2011 03:39:26 GMT

The System Center Advisor team (formally Project Atlanta) now lists some pre-release documentation on exactly what information they collect and how you can view it before it gets uploaded. So if you are wondering what they collect you can have...(read more)

Speaking at SQL Saturday #71

Andrew Kelly — Wed, 30 Mar 2011 22:54:48 GMT

I am getting prepped to head up to Boston on Friday the 1st for the SQL Saturday #71 . I am really looking forward to seeing the New England folks as it has been a few years since I left. I just hope this crazy Noreaster storm doesn’t...(read more)