2010 in review

Summary of how we did in year 2010



The Blog-Health-o-Meter™ reads Wow.

Crunchy numbers

The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 140,000 times in 2010. If it were an exhibit at The Louvre Museum, it would take 6 days for that many people to see it.

In 2010, there were 81 new posts, growing the total archive of this blog to 220 posts. There were 46 pictures uploaded, taking up a total of 5mb. That's about 4 pictures per month.

The busiest day of the year was January 25th with 1709 views. The most popular post that day was Happy Republic Day.

Where did they come from?

The top referring sites in 2010 were google.co.in, google.com, en.wordpress.com, stackoverflow.com, and yandex.ru.

Some visitors came searching, mostly for sql server 2005 interview questions, republic day, dba responsibilities, error 18456, and system databases in sql server 2005.

Attractions in 2010

These are the posts and pages that got the most views in 2010.

1

Happy Republic Day January 2009
6 comments

2

How to change SQL Server Instance Name? September 2008
4 comments

3

SQL Server 2005 Interview Questions May 2008
62 comments

4

SQL Server 2008 Active-Passive/Active-Active Cluster Installation October 2009
14 comments

5

DBA Roles and Responsibilities December 2008
46 comments

Articles Posted on MSSQLTips.com

Database Administration

Remote Desktop Error - The terminal server has exceeded the maximum number of allowed connections (4/9/2010) Remotely Shutdown, Restart or Log Off the local or network computers (5/17/2010) SQL Server Database Migration Checklist (2/5/2010) SQL Server restart validation checklist (7/30/2010) Start, Stop, Pause and Query Windows SQL Server Services Remotely (8/26/2010)

Dynamic Management Views\Functions

New DMF for SQL Server 2008 sys.dm_fts_parser to parse a string (12/3/2010)

Monitoring

Monitor, Start and Stop SQL Server services using xp_servicecontrol (6/11/2010)

Security

How to check SQL Server Authentication Mode using T-SQL and SSMS (12/24/2010) SQL Server Login Issue With Default Database (10/7/2010)

SQL Server Management Studio

Issues with Using Run As to Start SQL Server Management Studio with a Different Login (11/12/2010)

Tools

Insert Extended Characters into a SQL Server Table Using OSQL and T-SQL (3/2/2010)