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 » administration   (RSS)
Showing page 1 of 2 (12 total posts)
  • 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
  • Using the catalog views : clearing out a "botched" schema

    A user on StackOverflow had populated a custom schema with a bunch of tables, and needed to replace them with a new set of tables due to various changes. But he couldn't just drop them all in any arbitrary order, because there were foreign keys in place. His workaround was to just run a ''drop all tables'' script multiple times until there were no ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 7, 2011
  • 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