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 » sql server » Administration   (RSS)
Showing page 2 of 5 (42 total posts)
  • SQL Nexus 5.5.0.1

      The SQL Nexus set of utilities are some of the most under utilized tools available to the SQL Server community. I used and touted the RML utility for many years to help people analyze trace information very fast and easily. Eventually XE traces were added to the list along with much more.  This blog post link will give you a pretty ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on November 20, 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
  • New Cumulative Updates Released for SQL Server 2014

      Microsoft just announced a couple of CU’s for SQL Server 2014 that you may be interested in as shown below. Happy updating.   Cumulative update 9 for SQL Server 2014 SP1 – KB3186964   Cumulative update 2 for SQL Server 2014 SP2 – KB318878   Andy
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on October 18, 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
  • SSMS release 16.4 is now available

      The newest release of SQL Server Management Studio (SSMS) is now available. The details and download link can be found here. If you haven’t already downloaded or tried the new SSMS I highly recommend getting it and giving it a whirl. With the new release cycles we will see new features and bug fixes on a regular basis. Enjoy. Andy
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on September 20, 2016
  • SQL Server 2008R2 / 2012 Standard & Backup Compression

    This is something that is totally overlooked, in my experience, with SQL Server 2008 R2 and SQL Server 2012. On the contrary to what happens with SQL Server 2008, the Standard version of SQL Server 2008R2 & SQL Server 2012 supports backup compression: SQL Server 2008 R2 BOL ...
    Posted to Davide Mauri (Weblog) by manowar on March 25, 2013
  • Book review: Microsoft System Center Enterprise Suite Unleashed

    I know, I know – what’s a database guy doing reading a book on System Center? Well, I need it from time to time. System Center is actually a collection of about 7 different products that you can use to manage and monitor your software and hardware, from drive space through Microsoft Office, UNIX systems, and yes, SQL Server. It’s that last part I ...
    Posted to Buck Woody (Weblog) by BuckWoody on May 6, 2010
  • 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
  • Create and Track Your Own License Keys with PowerShell

    SQL Server used to have  cool little tool that would let you track your licenses. Microsoft didn’t use it to limit your system or anything, it was just a place on the server where you could put that this system used this license key. I miss those days – we don’t track that any more, and I want to make sure I’m up to date on my licensing, so I ...
    Posted to Buck Woody (Weblog) by BuckWoody on April 15, 2010
  • PowerShell PowerPack Download

    I read Jeffery Hicks’ article in this month’s Redmond Magazine on a new add-in for Windows PowerShell 2.0. It’s called the PowerShell Pack and it has a some great new features that I plan to put into place on my production systems as soon as I finished learning and testing them. You can download the pack here if you have PowerShell 2.0. I’m ...
    Posted to Buck Woody (Weblog) by BuckWoody on April 7, 2010
Privacy Statement