THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Administration » Documentation   (RSS)
  • 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 2014 SP1 CU11 SQL 2014 SP2 CU4 Happy patching, Andy
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on February 22, 2017
  • 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.  Normally this is OFF by default and the issue I was trying to solve was this: I have a ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on February 17, 2017
  • 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 following: Recent Releases and Announcements Recent White Papers, E-Books, Training and ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on February 1, 2017
  • 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 Pack 2 CU16 – KB3205054 SQL Server 2012 Service Pack 3 CU7   – KB3205051 SQL ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on January 18, 2017
  • 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  There are a number of interesting fixes but one in particular ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on December 28, 2016
  • 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 following: Recent Releases and Announcements Recent White Papers, E-Books, Training and ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on December 1, 2016
  • 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. But overall it appears this is an update you should seriously consider if you are running QSL ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on September 22, 2016
  • The Dark Sides of Consolidation

    Consolidation, as it applies to databases, is simply putting more databases or SQL Server Instances on less hardware. This is a good thing, normally, because it allows you to save on hardware costs and use what you have at it’s highest capacity. It also saves on energy costs, floor and rack space, and in some cases even licensing and ...
    Posted to Buck Woody (Weblog) by BuckWoody on December 10, 2009
  • SQL Server Best Practices: Protect CmdExec

    In SQL Server, there are times that you need to do things in the operating system, and to allow that there is a feature called CmdExec. This is not always a good thing –whenever you leave the confines of SQL Server and go out to the operating system, you can cause issues, not the least of which are security-related. This best practice is ...
    Posted to Buck Woody (Weblog) by BuckWoody on December 3, 2009
Privacy Statement