In 2013 I took on a slightly different approach to writing by putting more into each article with content, length and defining either what the topic was on or how the troubleshooting methods are taken. This, of course, meant my average blog count per month was way down in 2013 from 2012. In all, only 3.5 blogs per month. In 2012, I was averaging over 7. Value in the content does take more effort though. That is what I set out to manage and I feel the accomplishment was made. This seems to have shown in the number of unique visits and value the articles have provided as well. Just in the last few months, I had 10 articles that blew the 10,000 visit mark away. To me, the number of posts is a cool thing to have but if one article holds more value for a free technology resource over 15 that are so-so, I think I’ve helped just a little more.

Something that I noticed from this change in writing is the average views per visit going higher – 4248. That’s a great deal of people I’m reaching and helping. With that, I’ve reached out to just under 1.5 million people that are interested in SQL Server or needed a specific problem and fix. This is a far cry from some of the others in the SQL Server Community but a great accomplish for myself noentheless.

I had a great deal of focus in 2013 on the cloud. This shows in much writing as well as the work I’ve been managing. I made a tweet recently that stated, “I’m a cloud believer”. I wasn’t joking either. When I accomplished a full architecture in Windows Azure with near real-time availability and performing very well, I found the reasoning for the strength the cloud has much more. With that, 2014 will probably bring much more on the cloud and how SQL Server fits into it. SQL Server 2014 is also in the pipeline and over 20 articles are already in draft, waiting to be thrown out. Unlike many of my co-sql community writers, I like to wait and fully understand, break and fix, new releases of SQL Server. This means, I publish articles on the new versions a little later. Although late, I feel I can write a much fuller and valued article on the topics you will all be putting into production.

Here is a rundown of the numbers and my 2013 year in writing. I hope they have provided many of you with insight and assistance in either fixing unique problems or making critical decisions on how to manage your own database architectures.

Article Title

Visits

Managing Transaction Log Growth

29857

SQL Server Services fail to start – FAIL_PAGE_ALLOCATION

23368

SQL Server Configuration Manager Remote Procedure Call Failed

19237

Which loads faster – 2008, 2008 R2 or 2012

18819

Automated Job Activation with Mirroring and Availability Groups

18525

Enable TDE when Replication is in use

18507

Replication requires the actual server name Incorrect server name

15881

SQL Server Baseline Collection

14514

Buffer Latch Error Restoring SQL Server Database

13141

Missing index suggestion Duplicate Index

12228

SQL Azure Log Space Errors 40552

10599

Loading Large Volumes of Data into SQL Azure with SSIS

8958

SQL Agent Job High Availability – Availability Groups

5351

Async replica loss causes transactional replication to fail

4712

A Glance of Plan Explorer Pro’s Deadlock Analysis

4061

What makes a successful SQL Server Pro?

3639

So you want a Windows 8 Phone?

3634

Define Microsoft Business Intelligence for me?

3578

Do not disable foreign keys

3542

SQL Sentry – Providing Performance and Knowledge

3497

Database Designing With Performance in Mind

3131

Setting up Mirroring to SQL 2012 Availability Groups Encryption Error

3076

Import Wizard – Microsoft.ACE.OLEDB 12.0 provider is not registered

3005

Can I recover from a secondary replica COPY_ONLY full backup?

3003

A big loss to our community

2879

Driving Predictive Analytics

2840

A Week of SQL Server

2595

Direction of Intelligent Computing

2567

Success in Your Career

2447

Creating statistics manually Duplicate Statistics

2359

When do statistics update?

2328

Windows 8 for the Enterprise Event – Tuesday, April 16th

2291

Microsoft Isn’t the Devil

2280

ACL added security for Availability Group Listener in Azure

2151

Red Gate Releases SQL Backup Pro 7.3

1858

T-SQL Tuesday #41 – Presenting

1837

Windows and SQL Server 2012 Test Setup

1766

BlueMetal Architects Chicago and the Data Practice

1324

Mentoring, Ambition, and Your Career

1139

I hope you enjoyed reading on LessThanDot.com in 2013.  We’re looking to meet and exceed all of this in 2014.