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 » SQL Server » Maintenance   (RSS)
Showing page 1 of 2 (12 total posts)
  • New Servicing Model for SQL Server

      Microsoft just announced a new serving model for SQL Server starting with SQL 2017. The link below goes into much more detail so I won’t duplicate that here. However in a nutshell this means that there will be no more service packs, only CU’s (Cumulative Updates) and GDR’s (General Distribution Release).  A GDR contains only security ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on September 29, 2017
  • Latest CU’s for SQL Server 2016

      There are a couple of new CU’s for SQL Server 2016 that you should be aware of as it looks like there are a number of nasty looking bugs fixed. There is CU5 for 2016 SP1 and CU8 for 2016 RTM.         SQL Server 2016 SP1 CU5         SQL Server 2016 RTM CU8 Happy ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on September 18, 2017
  • SQL Updates Newsletter – July 2017

        SQL Updates Newsletter – July 2017 It has been a few months since my last post on 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 Server which include but are not limited to ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on August 6, 2017
  • 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 Server which include but are not limited to the following: Recent Releases and ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on June 1, 2017
  • 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
  • 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
  • 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 Server 2016 SP1 is now Available

      Some big news today in the world of SQL Server and Visual Studio announced at Connect.  One of the announcements that will spark the interest of most of the people here on this blog is that SP1 for SQL Server 2016 is available for download now.  Why is this important? Well there are a ton of changes related to what features are ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on November 16, 2016
  • Backup those keys, citizen

    Periodically I back up the keys within my servers and databases, and when I do, I blog a reminder here. This should be part of your standard backup rotation – the keys should be backed up often enough to have at hand and again when they change. The first key you need to back up is the Service Master Key, which each Instance already has built-in. ...
    Posted to Buck Woody (Weblog) by BuckWoody on April 20, 2010
  • Backup Meta-Data

    I'm working on a PowerShell script to show me the trending durations of my backup activities. The first thing I need is the data, so I looked at the Standard Reports in SQL Server Management Studio, and found a report that suited my needs, so I pulled out the script that it runs and modified it to this T-SQL Script. A few words here - you need ...
    Posted to Buck Woody (Weblog) by BuckWoody on March 30, 2010
1 2 Next >
Privacy Statement