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 » maintenance   (RSS)
Showing page 1 of 6 (57 total posts)
  • Getting Excited about my Practical Performance Monitoring Pre-Con

      I was working on the demo’s for my Practical Performance Monitoring Pre-Con at this years IT / Dev Connections in San Francisco and I have to admit I got a little giddy.  The session is geared towards helping a DBA get started in monitoring their SQL Server Instances, especially when they don’t have the ability to buy a 3rd party ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on July 2, 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
  • 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 Resolved ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on April 18, 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 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 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
  • Managing the errorlog file

    I frequently see recommendations to regularly run sp_cycle_errorlog, so that the errorlog doesn't become huge. My main concern with that is that the errorlog contains valuable information. When I do a health check on a SQL Server machine, I want a few months worth of errorlog information available. I typically use my own scripts for this, ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on October 22, 2015
  • Ola Hallengrens Maintenance Solution now supports mirrored backup

    You probably know that you can mirror a backup to several destinations, assuming you are on a supported edition (Enterprise or Developer). This is not the same as striping; you can compare striping to RAID 0, and mirroring to RAID 1. Ola now supports mirroring in his maintenance solution, found here. A couple of examples: EXECUTE ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on November 3, 2014
1 2 3 4 5 Next > ... Last »
Privacy Statement