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   (RSS)
Showing page 1 of 17 (161 total posts)
  • SSMS 17.2 is now available

      The newest version of SQL Server Management Studio is now available for download. Lots of new features and fixes. The details and download links can be found here. Happy managing, Andy Kelly
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on August 7, 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
  • 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
  • Finding When Someone Last Ran a DBCC

      The other day someone on Twitter asked how to find out when or who last ran a DBCC FREEPROCCACHE command on their SQL Server instance. Since this is not an unusual request I figured I would post a few examples of how to find DBCC commands or even many similar commands or events. If you had a regular or Extended Event trace going you could ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on June 28, 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
  • 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 SSMS Download (16.5.3)

      There was a slight issue with the SSMS version that was released a few days back (16.5.2) which has been fixed and replaced with release 16.5.3. If you want the latest SQL Server SSMS 2016 release or if you already loaded the 5.2 version you should get this one. SSMS 2016 Version 16.5.3 Andy
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on January 27, 2017
1 2 3 4 5 Next > ... Last »
Privacy Statement