THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Administration » DBA   (RSS)
Showing page 1 of 6 (56 total posts)
  • 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
  • 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
  • DBTA - Russian Hackers Steal 1.2b Internet Credentials: Or, Why the Heck Does this Keep Happening?!

    I'm decidedly old-school in a few of my habits. My morning routine, barring anything out of the ordinary, is one such example. Typically, I'll get up between 6:30 to 7:00 am, grab my first cup of coffee, and then chat with my daughters for a few minutes before seeing them off to school. Next, I make a bowl of oatmeal (a great choice for diabetics ...
    Posted to Kevin Kline (Weblog) by KKline on July 1, 2015
  • Mission Critical Performance Enhancements in SQL Server 2014 on

     Microsoft has three major feature sets that they are advancing with SQL Server 2014 (SQL2014). One is called “Mission Critical Performance.”  Microsoft wants to stake out this ground not only as performance enhancements in the relational engine, but also those features which support better data availability, performance, security, and ...
    Posted to Kevin Kline (Weblog) by KKline on November 28, 2014
  • SQL Server 2014 Overview on

     Haven't upgraded late? Well, SQL Server 2014 is a great place to start! Perhaps this is your first time reading my column on or you don’t know much about SQL Server. If either of those are true, then it might be a surprise to you that Microsoft has accelerated the release cadence for SQL Server to around one new release every ...
    Posted to Kevin Kline (Weblog) by KKline on November 25, 2014
1 2 3 4 5 Next > ... Last »
Privacy Statement