THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Andrew Kelly

  • Latest SolidQ Journal Plus Giveaways


    You can find the latest edition of the SolidQ Journal here that is always good reading but if you register over the next 3 weeks you may be eligible for a prize including: 

    One $500 Amazon gift card and 5 $150 gift cards; books from Itzik Ben-Gan, Greg Low, and Erik Veerman/Jay Hackney/Dejan Sarka; and chats with MarkTab and Kevin Boles. 

    The deadline for the giveaway is January 7th and you can register for it HERE .  So be a good little boy or girl and maybe Santa will bring you a gift Smile

    Andrew J. Kelly

  • Practical Performance Monitoring and Tuning Event


    For any of you who may be interested or know of someone in the market for a performance Monitoring and Tuning class I have just the ticket for you. It’s a 3 day event that will be held in Atlanta Ga. on January 25th to the 27th 2011. For those of you that know me or have been to my sessions you realize I like to provide more than just classroom theory and like to teach real world and above all practical methodology when it comes to performance in SQL Server. This class covers all the essentials when it comes to getting a handle on your environment and determining how to address the issues and problems that you find. I am looking forward to a fun and informative class and hope to see you there. More details and registration can be found here:

    Practical Performance Monitoring and Tuning

    Andrew J. Kelly

  • White Paper on Parallel Processing


    I just ran across what I think is a newly published white paper on parallel  processing in SQL Server 2008 R2. The date is October 2010 but this is the first time I have seen it so I am not 100% sure how new it really is. Maybe you have seen it already but if not I recommend taking a look. So far I haven’t had time to read it extensively but from a cursory look it appears to be quite informative and this is one of the areas least understood by a lot of dba’s. It was authored by Don Pinto and Eric Hanson  with a supreme case of technical reviewers as well. So here’s more bedtime reading Smile


    Andrew J. Kelly

  • SQL Server 2008 R2 System Views Map Poster


    The latest SQL Server 2008 R2 systems views map poster is available here: 2008 R2 Poster

    It’s available in a pdf or xps format so have fun with it.



  • [OT] Being Thankful

    I know this is off topic and not really in character for me to begin with but here goes. I have recently been going thru a stressful period in my life with the week of PASS probably being the most stressful of my life that I can recall. For one I have recently experienced 3 deaths in my family including my mother. And my wife who was just getting over a bout with cancer that required some pretty extensive reconstructive surgery was diagnosed with another spot the week before PASS. We will know Friday how extensive it is when they operate. On top of that I have just had a series of very stressful events that all seemed to hit at once and for a while it broke me down. Now the intent of sharing this with you is NOT to invoke feelings of sorrow or to elicit  your well wishes. Don’t get me wrong I truly appreciate what I know the community would have to offer and I have already had many friends do just that for which I am very thankful. You see that is the real point of this post. As bad as I felt for a while there are many many more people out there who have it much worse than I do and I need to remember that. It sort of hit me this morning at the gym when I had a great workout.  I was able to up my weights across the board and did 4.5 miles of cardio and I still felt great when I was done. At 49 ears of age I think I can honestly say I am in better shape physically than a good portion of the population (at least here in the states) at half my age or younger even with my pinched nerve. So that got me thinking of the bigger picture and that lead to this post. No matter what you are going thru there is probably someone else going thru worse times and we need to stop and realize there are always things to be thankful for. One of the them for me is the SQL community that I have been part of for so many years now. There are a lot of good people out there of which I am proud to call my friends. Thanks everyone and remember to look up and past the bad times when they come around and enjoy life.


  • SQL Server Backup Simulator

    The SQL Server support team just announced the release of a backup simulator. Many 3rd party utilities that do backup like IBM Tivoli, Symantec BackupExec, Quest Litespeed, Redgate SQL Backup etc. use the sqlvdi.dll to communicate to SQL Server and this allows you to simulate that activity. So if you want to test how your system reacts or more importantly need to troubleshoot issues associated with this activity or dll this is the answer. Have a look:  Backup Simulator

    Andrew J. Kelly

    Solid Quality Mentors

  • Speaking at SQL Saturday #48


    The schedule for SQL Saturday #48 is now up at .  There will be a bunch of good speakers and sessions in Columbia, SC. on October 2nd 2010 so check it out.

  • Speaking in Raleigh NC for SQL Saturday #46


    I hope to see a bunch of you in Raleigh on the 18th of September for SQL Saturday #46. I will be giving a presentation on Query Plan Reuse but there will be tons of good sessions from lots of great speakers. Check it out here:


  • MySQL Migration Assistant Now Available


    Microsoft just announced the availability of a utility to allow you to migrate from MySQL to SQL Server. I know I have been asked about this for some time so there should be some happy people out there :). More details can be found here:

                                          MySQL Utility

    Happy migrations.

    Andrew J. Kelly

  • Clustering Utility Made Available by Microsoft


    The CSS team just made me aware of a new utility for cluster’s called the Remote Desktop Connection Manager. I don’t want to just repeat what has already been said so go ahead and have a look here for the details:

  • Updates for Some 2008 Tools

    There have been a few releases over the last few days for some SQL Server 2008 tools that you may be interested in. The first one is the 2008 R2 Best Practices Analyzer found here:

    And the second one is the 2008 R2 update for the developers training kit found here:

    Have fun,

    Andrew J. Kelly

  • Speaking in Raleigh NC June 15th

    Just a heads up to those in the area that I will be speaking at the (TriPASS) Raleigh SQL Server user group on the 15th of June 2010. The topic is Storage & I/O Best Practices. The abstract is listed below:

    SQL Server relies heavily on a well configured storage sub-system to perform at its peak but unfortunately this is one of the most neglected or mis-configured areas of a SQL Server instance. Here we will focus on the best practices related to how SQL Server works with the underlying storage subsystem and what you can do to maximize the relationship between the two.  The core topics will include discussions on SANs vs. Direct Attached storage, Raid Groups, Caching, Types of I/O, Number of Files & their placement and more. 

    I am looking forward to seeing you there.

    Andrew J. Kelly

  • Free Online Performance Tuning Event

    On June 29th 2010 I will be showing several sessions related to performance tuning for SQL Server and they are the best kind because they are free :).  So mark your calendars. Here is the event info and URL:

    June 29, 2010 - 10:00 am - 3:00 pm Eastern

    SQL Server is the platform for business. In this day-long free virtual event, well-known SQL Server performance expert Andrew Kelly will provide you with the tools and knowledge you need to stay on top of three key areas related to peak performance in SQL Server. You'll gain a better understanding of which bottlenecks might be affecting your system, along with the knowledge of how to address them once you find them. Together, these three sessions will give you a solid basis from which to start tackling the performance bottlenecks in SQL Server.

    Register Here

    Hope to see you all there.

    Andrew J. Kelly

    Solid Quality Mentors

  • Also Speaking at SQL Saturday #33


    It appears that the SQL Saturday in Charlotte NC on March 6th will be a real whopper of an event. There are going to be a ton of speakers with many of them MVP’s from all over the country. I have two sessions with one on File & Wait stats and another on Plan reuse. If you are in the area that day I highly recommend you register and stop by. The below link has details of the event.

    Hope to see you there.

  • What 3 events Brought Me Here


    I am a few weeks late getting to this but here we go. Paul Randal tagged a few people including me with this challenge to state what 3 events got us to where we are today. Here is my story:

    Event 1

    I suppose the first event was when I decided to join the United States Marine Corps almost a full year before I graduated high school. I wanted to get into electronics and I wasn’t properly prepared for college so I decided to get my education in the military. I graduated top in my all my classes and was able to choose my final school which was one of the only component level technical tracks in the Marines. This is where I got my initial interest in so called personal computers. The first one I owned was a TI-99 which had a whopping 4K of memory and used a cassette recorder for the hard drive. I slowly migrated to newer, faster, better computers etc. over the years since then but this was my start in my technical and professional career.

    Event 2

    While electronics was my bill paying career I started to learn various forms of programming languages on both Unix and Windows platforms and mostly related to databases. It was mostly a hobby and pretty much everything I learned about programming to that point was self taught with non paying or personal projects but the fascination grew more each day.  When MS released Visual FoxPro 3.0 I started to really get into that tool. I was actually hooked on it and got pretty proficient at it as well. I was becoming less and less satisfied with my current job and the fact that I had to constantly atone to customers for features promised to customers that we had yet to develop. I saw this as an opportunity to venture into consulting doing something I loved such as programming and still have some control over which projects I worked on and promises made. Eventually the projects required a more enterprise level database and that led me to SQL Server.

    Event 3

    The final event that really shaped my career was when I became a Microsoft SQL Server MVP back in 2001. The direct access to the SQL development team and the inside access surrounding the next versions of the product was simply invaluable in my growth of the knowledge related to SQL Server. With this insight I was able to perform my duties as a SQL Server performance and scalability consultant with confidence and skills that may not have been gained as quickly without it. Sometimes we just need to take advantage of breaks such as these to get the most out of your situation. I believe this was instrumental in getting me to where I am today.

This Blog


Privacy Statement