2010 in review – courtesy WordPress.com

The stats helper monkeys at WordPress.com mulled over how this blog did in 2010, and here’s a high level summary of its overall blog health:

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

Crunchy numbers

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

 

In 2010, there were 52 new posts, growing the total archive of this blog to 1118 posts. There were 40 pictures uploaded, taking up a total of 2mb. That’s about 3 pictures per month.

The busiest day of the year was September 29th with 5,457 views. The most popular post that day was Scheduling SSIS Packages with SQL Server Agent.

Where did they come from?

The top referring sites in 2010 were google.co.in, google.com, stackoverflow.com, google.co.uk, and social.msdn.microsoft.com.

Some visitors came searching, mostly for al32utf8, oracle update from another table, the user is not associated with a trusted sql server connection, sql server 2008 schedule save, and deploy ssis package to sql server 2005.

Attractions in 2010

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

1

Scheduling SSIS Packages with SQL Server Agent September 2008
18 comments

2

Update data in one table with data from another table January 2007
2 comments

3

Deploying SSIS Packages in SQL Server 2005 September 2008
31 comments

4

Functional difference between “NOT IN” vs “NOT EXISTS” clauses January 2007
3 comments

5

Finding the Port Number for a particular SQL Server Instance January 2008
2 comments

Happy 4th of July

Wish our readers a very Happy 4th of July.

Happy Holi

We wish all of our readers in India (or of Indian Origin) a very Happy Holi.  For folks who are not familiar with this festival, this is the festival of colors and celebrates the triumph of good over evil.  Here are two links which will give you more information in case you are interested in learning more:

http://en.wikipedia.org/wiki/Holi

http://www.holifestival.org/

Happy New Year – 2010

We wish all of you and your loved ones a very Happy New Year.  May all your dreams and aspirations come true in a wonderful way this year … and always.

Best wishes for a joyous, prosperous, healthy and peaceful 2010 to all of you.

- From Decipher Staff

Merry Christmas

We wish all of our readers a very Merry Christmas.  May the upcoming year bring a lot of joy and happiness to you and your loved ones.

Best wishes from the Decipher Team.

A very Happy Thanksgiving

To all our readers in the USA, we wish you and your loved ones a very Happy Thanksgiving.  To the readers around the world, here is the link from Wikipedia to learn more about this festival:

http://en.wikipedia.org/wiki/Thanksgiving

Happy 4th of July

We wish all of our readers in the USA a very Happy 4th of July.  Happy Independence Day.

For our readers in India: HAPPY HOLI

For our readers who are from India, wish all of you guys a very HAPPY HOLI.  At Decipher, we have folks from different parts of the world – US, India, Iran, Mexico and Germany and we celebrate all festivals.

A little history about the festival:

• Wikipedia Entry – here.
• Holiday Spot’s article on Holi – here.
• Holi Festival Site – here.
• India Festivals Site article – here.

New Page and Blog Roll

We have added a new Page called “Whitepapers” to the blog and have also added a blog roll on the side. We will be posting many more in the weeks to come. Another one to come up next is one on SQL Server 2008 install. Watch this space…

The blog roll has the links that we use a lot for our day to day work and are blogs from experts like Tom Kyte (of the asktom.oracle.com fame) or Chetan Sharma (Wireless Expert who writes the blog named AORTA) or sites like GigaOm and others.

Microsoft Certified Partner

Just wanted to mention that we became Microsoft Certified Partner last week with our specialization area being Data Management Solutions (Database Management and Business Intelligence). We are also aiming for the Gold Certified Status and hope to have that in place soon – once our product has been tested and we get an ID back from Microsoft.