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 15 (144 total posts)
  • 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
  • Query Store - Forced Doesn’t Always Mean Forced

      The new Query Store feature in SQL Server 2016 is a great new addition that we have been anticipating for many years now. There are already a bunch of articles out there that explain what it is even how to go about using it so I won’t repeat that here. However there is one aspect of the feature that has been poorly documented and even a ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on September 18, 2016
  • SQLSentry does it Again – Plan Explorer is Completely Free

     Many of us have used the free version of Plan Explorer from SQLSentry for a long time to help tune and explore query plans in a way that SSMS can only dream of. Unlike most free tools this one still had plenty of useful features that served the community well. The Pro version did however contain a bunch of great features that many ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on September 8, 2016
  • The free #eBooks series #SQLServer and .NET Blog

    The series of free eBooks ''The SQL Server and .NET Blog eBook Series'' by Artemakis Artemiou (@artemakis) collects dozens of articles explaining how to solve practical problems in these areas: Database DevelopmentDatabase AdministrationPerformance Tuning Developing SQL Server (The SQL Server and .NET eBook Series)This ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on November 16, 2015
  • DBTA - StretchDB, a Cool New Feature in vNext SQL Server

    Originally appearing in my monthly column at Database Trends & Applications magazine. When it comes to cloud-based database management, there are really only two players: Amazon, the value leader, and Microsoft, the innovation leader. Amazon has carved out a niche as the value leader in cloud-based database management, ...
    Posted to Kevin Kline (Weblog) by KKline on August 5, 2015
  • DBTA - IT Employers Must Adapt to the Looming DBA Shortage

    Originally appearing in my monthly column at Database Trends & Applications magazine. In the first of this three-part series, I described some of the findings contained in an intriguing new survey published by Unisphere Research, a division of Information Today, Inc. In that article, I covered the macroeconomic and general ...
    Posted to Kevin Kline (Weblog) by KKline on July 29, 2015
  • DBTA - Does the Looming Shortage in DBAs Spell Opportunity?

    Originally appearing in my monthly column at Database Trends & Applications magazine. In my last column, available online, I described some of the findings contained in an intriguing new survey sponsored by Ntirety, a remote database administration service provider, and published by Unisphere Research. You can read the full survey with ...
    Posted to Kevin Kline (Weblog) by KKline on July 22, 2015
  • DBTA - Delayed Durability—The SQL Server 2014 Transaction Log Hack!

    Originally appearing in my monthly column at Database Trends & Applications magazine. Delayed durability was announced late in the SQL Server 2014 development cycle, but offers something that many SQL Server professionals have wanted for years—the ability to disable transaction logging.Why turn off the transaction log? It is the main ...
    Posted to Kevin Kline (Weblog) by KKline on July 15, 2015
  • DBTA - For #SQLFamily, a Most Wonderful Time of the Year!

    Originally appearing in my monthly column at Database Trends & Applications magazine. It’s the holiday season, a time for cheer and goodwill towards men. That got me thinking about the whole “most wonderful time of the year” tune playing in the background and how that has some special implications for the SQL Server world. ...
    Posted to Kevin Kline (Weblog) by KKline on July 8, 2015
1 2 3 4 5 Next > ... Last »
Privacy Statement