Browse by Tags

• 2008 R2
• Best Paractices
• Books
• Central Management Servers
• DBA
• Developer
• I/O
• Maintenance
• Parallelism
• Performance
• Query Optimizer
• SolidQ Journal
• SQL Server
• Storage
• System Center advisor
• Tips & Tricks
• Tips &amp
• Tricks
• Trivia
• TSQL
• Utilities

• Updated File & Wait Statistics Procedures

  For many years I have been using a set of stored procedures to capture and report on both the file and wait statistics inside of SQL Server and I just recently did some minor modifications that I want others to be aware of. Since many of you have received Read More... Posted Thursday, February 13, 2014 6:23 PM by Andrew Kelly | 2 Comments Filed under: Documentation, DBA, Performance, TSQL, Utilities, SQL Server Attachment(s): FileWaitProceduresFeb132014.zip

• Finding IP Addresses With CMS

  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... Posted Monday, July 25, 2011 5:14 PM by Andrew Kelly | 2 Comments Filed under: Documentation, Tips & Tricks, Trivia, Central Management Servers

• The latest edition of the SolidQ Journal is now available

  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... Posted Monday, July 11, 2011 8:57 PM by Andrew Kelly | 0 Comments Filed under: Documentation, Tips & Tricks, SolidQ Journal

• SQL Server 2008 R2 Analysis Services Operations Guide

  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... Posted Wednesday, June 01, 2011 7:03 PM by Andrew Kelly | 0 Comments Filed under: Documentation, Best Paractices, 2008 R2

• New Book on the Query Optimizer

  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... Posted Saturday, April 09, 2011 7:30 PM by Andrew Kelly | 0 Comments Filed under: Documentation, Query Optimizer, Books

• System Center Advisor Collection Details

  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... Posted Thursday, April 07, 2011 12:39 AM by Andrew Kelly | 0 Comments Filed under: Documentation, Best Paractices, System Center advisor

• Project Atlanta Has a New Name

  Brad Anderson just completed a keynote in Las Vegas at the Microsoft Management Summit 2011 and announced the new name for what was originally called Project Atlanta. Dot da da dah… And the new name is:  System Center Advisor .  You can Read More... Posted Tuesday, March 22, 2011 2:57 PM by Andrew Kelly | 0 Comments Filed under: Documentation, Maintenance, Best Paractices, Utilities

• The January 2011 Edition of the SolidQ Journal is Out

  The latest edition of the SolidQ Journal is now available online at http://www.solidq.com/sqj/Pages/Home.aspx . Enjoy, Andrew J. Kelly Read More... Posted Monday, January 17, 2011 2:21 PM by Andrew Kelly | 1 Comments Filed under: Documentation, Tips & Tricks, SolidQ Journal

• 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 Read More... Posted Friday, December 17, 2010 3:34 PM by Andrew Kelly | 0 Comments Filed under: Documentation, SolidQ Journal

• 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 Read More... Posted Friday, December 10, 2010 11:24 AM by Andrew Kelly | 0 Comments Filed under: Documentation, Performance, Parallelism

• 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.   Andy Read More... Posted Wednesday, December 08, 2010 9:21 PM by Andrew Kelly | 2 Comments Filed under: Documentation, Trivia, Developer, 2008 R2

• 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: http://blogs.msdn.com/b/sqlreleaseservices/archive/2010/06/19/sql-server-2008-r2-best-practices-analyzer-is-now-available.aspx Read More... Posted Sunday, June 20, 2010 12:03 AM by Andrew Kelly | 3 Comments Filed under: Documentation, Best Paractices, Developer, 2008 R2

• Trace Flag Groupings

  I just saw a news group post by Paul Randal in which he explained how trace flags were grouped into certain categories and thought others may find this interesting as well. Please note that Paul stated that these are from memory so they may not be 100% Read More... Posted Sunday, June 21, 2009 12:56 PM by Andrew Kelly | 0 Comments Filed under: Documentation, Trivia

• What time do you have?

  The way in which SQL Server has treated Time has been a very misunderstood subject for as long as I can remember. The largest part of that was the fact that SQL Server was only accurate to 3.33ms. I would like to point you to an excellent article on this Read More... Posted Saturday, December 20, 2008 9:12 AM by Andrew Kelly | 6 Comments Filed under: Documentation, Performance, Developer

• Debug button in SSMS 2008

  How many people are tired of accidentally hitting the toolbar button with the green triangle on it when trying to run a query in the Query Editor only to get into the debug mode?  If you are like me then I bet a lot of you:).  It only seems Read More... Posted Wednesday, September 17, 2008 5:44 PM by Andrew Kelly | 6 Comments Filed under: Documentation, Trivia