SQL Server with Mr. Denny

Dec 28 2016   12:34AM GMT

2016 By The Numbers

Denny Cherry Denny Cherry Profile: Denny Cherry



Well 2016 was a hell of a year for blogging. I recorded just under 285k page views (284,553 as of writing this the afternoon of December 27th), which is up about 40k or so from 2015.

This years top 10 posts look a bit different from last years.  There’s actually 7 repeats but the top two were written in SQL Server 2016.

  1. Fixing a storage pool that doesn’t have an read-write server
  2. SQL Server on Linux?!?!?!
  3. What exactly is MSDTC, any when do I need it? (Number 2 in 2014, Number 2 in 2015)
  4. SQL Server 2014 Licensing (Number 1 in 2015)
  5. Big Announcements in SQL Server 2016
  6. Difference Between An Index and a Primary Key (Number 3 in 2015)
  7. What Does WITH (NOLOCK) Actually Mean (Number 5 in 2015)
  8. How To Configure MSDTC On Windows 2008 (Number 1 in 2014, Number 4 in 2015)
  9. The Process Could Not Execute sp_replcmds on x (Number 7 in 2015)
  10. Calculating Fibre Latency Correctly Is a Must When Trying To Determine Storage Performance Numbers (Number 6 in 2015)

This year was another first for my blogging. I had a single post this year hit not just 20k page views, but 30k page views.  That’d be #1 on this list which topped out at 30,749 page views (plus a few more in the last 3 working days of the year).  Number 2 up there had 14,337 while the MSDTC post had 11,643.

I review these numbers every year (I actually look at them through out the year as well) because it gives me some insight into what people are looking for. New posts obviously get some traffic (especially when I’m able to get blog posts written and posted within minutes of the announcement) but I find it interesting that a lot of these older posts continue to get a lot of traffic, like the MSDTC post up there which has been a top three post by page views for 3 years in a row.  Not bad for 15+ year old technology or a 3 year old blog post.

So based on this multi-year trending of data, I need to keep writing about random errors that I get when working on clients systems, and keep blogging about Microsoft announcements 5 seconds after they are announced.  That was pretty much my plan for 2017 anyway. 🙂

Don’t forget to check out DCAC’s Ascending to Azure webcast on January 5th, 2017 where we’ll talk about some of the successful migrations we’ve done from on-premises to Microsoft Azure.


6  Comments on this Post

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.
  • BGunderson
    Some really good information in those posts! Keep up the great knowledge sharing!
    10 pointsBadges:
  • agonzalez
    SQL Server on Linux is going to be big! But will it provide same enterprise level capabilities available in windows version and 3rd party product integration with backup and disaster recovery? I think it will take some time till all vendors can backup and adopt it.

    270 pointsBadges:
  • UniFrid
    Who would have thought MS would come full circle from trying to limit Linux market share years ago to porting their applications to another platform - what next?
    10 pointsBadges:
  • Denny Cherry

    As we don't have the final build of SQL Server on Linux we don't know all the features that are going to be included or not. I'm sure that Microsoft is working on making the features between the Windows and Linux versions as close as possible to the same (things like FILETABLE probably won't be there as that wouldn't work in a Linux environment).

    My gut tells me that we can expect to see the Linux version be basically the same as the Windows version.

    Now the third party tools issue is going to be a very different thing, but that's up to the tools vendors to solve, not Microsoft.

    69,130 pointsBadges:
  • joeywatson
    Nice one and thanks for sharing this informative post.
    1,250 pointsBadges:
  • joeywatson
    SQL Server on Linux goes to be big! however can it give same enterprise level capabilities out there in windows version and third party product integration with backup and disaster recovery? i believe it'll take it slow until all vendors will backup and adopt it.
    1,250 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: