February 2017 - Posts

• 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 | 25 Comments Filed under: Documentation, Maintenance, SQL Server, Administration, 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 | 12 Comments Filed under: Documentation, TSQL, Developer, Administration

• 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 1, 2017 9:33 AM by Andrew Kelly | 2 Comments Filed under: Documentation, Maintenance, SQL Server, Administration, Updates