Browse by Tags

• 2008 R2
• Administration
• 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 & Tricks
• Tips &amp
• Tricks
• Trivia
• TSQL
• Updates
• Utilities

• SQL Updates Newsletter–May 2017

  I missed posting the last few months of these but here is the latest update about the monthly newsletter that a good friend of mine (Fany Carolina Vargas) from Microsoft puts together each month. This shows a whole host of goodies related to SQL Read More... Posted Thursday, June 01, 2017 10:29 AM by Andrew Kelly | 0 Comments Filed under: Administration, Documentation, Maintenance, SQL Server, Updates

• New Cumulative Updates for SQL Server 2014

  Microsoft announced two new CU’s for SQL Server 2014 yesterday. Below are the links to the KB’s and some quick facts for each CU. Cumulative Update 12 for SQL Server 2014 SP1 SQL Server 2014 Service Pack 1 Cumulative Update #12 Quick Facts 12 Issues Read More... Posted Tuesday, April 18, 2017 9:45 AM by Andrew Kelly | 1 Comments Filed under: Administration, Documentation, Maintenance, Updates

• Latest SQL Server 2014 CU Updates

  Microsoft released a few more Cumulative Updates for SQL Server 2014 as listed below. There are a number of interesting fixes so I highly recommend if you have SQL Server 2014 to take a look at the list of hotfixes included in each update. SQL Read More... Posted Wednesday, February 22, 2017 8:30 AM by Andrew Kelly | 0 Comments Filed under: Administration, Documentation, Maintenance, SQL Server, Updates

• Stopping Execution of Future Batches

  There is a command that as far as I can tell has been in the product since SQL2008 but I was woefully unaware of. Actually I find many others are unaware as well and hence the blog post. The command is SET NOEXEC which has options for ON or OFF.  Read More... Posted Friday, February 17, 2017 3:09 PM by Andrew Kelly | 11 Comments Filed under: Administration, Developer, Documentation, TSQL

• SQL Updates Newsletter – January 2017

  Here is the latest update about the monthly newsletter that a good friend of mine (Fany Carolina Vargas) from Microsoft puts together each month which shows a whole host of goodies related to SQL Server which include but are not limited to the Read More... Posted Wednesday, February 01, 2017 9:33 AM by Andrew Kelly | 0 Comments Filed under: Administration, Documentation, Maintenance, SQL Server, Updates

• Latest SQL Server Updates

  There are some new updates for SQL Server 2012 and SQL Server 2016 that were released today. I am not sure what happened to SQL 2014 but I suspect those will be out shortly as well. Here are the links and the associated KB’s. SQL Server 2012 Service Read More... Posted Wednesday, January 18, 2017 2:29 PM by Andrew Kelly | 0 Comments Filed under: Administration, Documentation, SQL Server, Updates

• SQL Updates Newsletter – December 2016

  Another friendly reminder about the monthly newsletter that a good friend of mine (Fany Carolina Vargas) from Microsoft puts together each month which shows a whole host of goodies related to SQL Server which include but are not limited to the Read More... Posted Tuesday, January 03, 2017 10:02 PM by Andrew Kelly | 1 Comments Filed under: Documentation, SQL Server, Updates

• SQL Server 2014 CU3 for SP2 and CU10 for SP1 are Available

  Just an FYI for those of you on SQL Server 2014 SP2 that there is a new CU available for download can can be found here . Also if you are still on SP1 for SQL Server 2014 you can get CU10 as well here. https://www.microsoft.com/en-us/download/details.aspx?id=51186 Read More... Posted Wednesday, December 28, 2016 5:18 PM by Andrew Kelly | 0 Comments Filed under: Administration, Documentation, Maintenance, Updates

• SQL Updates Newsletter – November 2016

  This is a friendly reminder about a monthly newsletter that a good friend of mine (Fany Carolina Vargas) from Microsoft puts together each month which shows a whole host of goodies related to SQL Server which include but are not limited to the Read More... Posted Thursday, December 01, 2016 8:44 AM by Andrew Kelly | 0 Comments Filed under: Administration, Best Paractices, Documentation, Maintenance, SQL Server

• SQL Updates and More

  A good friend of mine (Fany Carolina Vargas) from Microsoft puts together a fantastic blog post each month which shows a whole host of goodies related to SQL Server which include but are not limited to the following: Recent Releases and Announcements Read More... Posted Monday, October 31, 2016 12:01 PM by Andrew Kelly | 0 Comments Filed under: Best Paractices, Documentation, SQL Server, Tips & Tricks, Trivia, Updates

• SQL 2016 CU2 is now Available

  Microsoft just announced that Cumulative Update 2 for SQL Server 2016 is now available for download here . There are a number of fixes including one I have been looking forward to regarding the Query Store. See here for more details on that one. Read More... Posted Thursday, September 22, 2016 12:13 PM by Andrew Kelly | 0 Comments Filed under: Administration, Documentation, SQL Server, Updates

• Updated File & Wait Statistics Procedures

  Please note that I have a newer version of these procedures that you can find here http://sqlblog.com/blogs/andrew_kelly/archive/2015/09/02/revised-file-wait-statistics-procedures.aspx . For many years I have been using a set of stored procedures to capture Read More... Posted Thursday, February 13, 2014 6:23 PM by Andrew Kelly | 2 Comments Filed under: DBA, Documentation, Performance, SQL Server, TSQL, Utilities 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: Central Management Servers, Documentation, Tips & Tricks, Trivia

• 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 | 1 Comments Filed under: Documentation, SolidQ Journal, Tips & Tricks

• 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: 2008 R2, Best Paractices, Documentation