WordPress.com presents
SQL Server Journey with SQL Authority
2012 in blogging
Annual Report
Happy New Year from WordPress.com!
About the fireworks
Each rocket represents a post published on this blog in 2012. And because we like to share, we made the fireworks available as a jQuery plugin on Github.
Some browsers are better suited for this kind of animation. In our tests, Safari and Chrome worked best. Your overall score is not known (details).
We made beautiful, animated fireworks to celebrate your blogging! Unfortunately this browser lacks the capability. We made a slide show to fill in but we hope you will come back to this page with an HTML5 browser. In our tests, Safari or Chrome worked best.
To kick off the new year, we’d like to share with you data on SQL Server Journey with SQL Authority’s activity in 2012. You may start scrolling!
Crunchy numbers
3,200,000 people watched the Mars Rover land. This blog was viewed about 19,000,000 times in 2012. If this blog were a video of the Rover landing, it would take about 6 days for that many people to see it.
In 2012, there were 373 new posts, growing the total archive of this blog to 2,373 posts. There were 32 pictures uploaded, taking up a total of 451 KB. That's about 3 pictures per month.
The busiest day of the year was October 9th with 80,693 views. The most popular post that day was SQL SERVER - Insert Data From One Table to Another Table - INSERT INTO SELECT - SELECT INTO TABLE.
Attractions in 2012
These are the posts that got the most views on SQL Server Journey with SQL Authority in 2012.
- 1 SQL SERVER - Insert Data From One Table to Another Table - INSERT INTO SELECT - SELECT INTO TABLE 643 comments August 2007
- 2 SQL SERVER - Retrieve Current Date Time in SQL Server CURRENT_TIMESTAMP, GETDATE(), {fn NOW()} 442 comments June 2007
- 3 SQL SERVER - Convert Text to Numbers (Integer) - CAST and CONVERT 408 comments July 2007
- 4 SQL SERVER - FIX : ERROR : (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: ) 436 comments May 2009
- 5 SQL SERVER - Insert Multiple Records Using One Insert Statement - Use of UNION ALL 856 comments June 2007
How did they find this blog?
The top referring sites in 2012 were:
Some visitors came searching, mostly for sqlauthority, sql interview questions, sql server interview questions, and sql server interview questions and answers.
Where did they come from?
That's 234 countries in all!Most visitors came from The United States. India & The United Kingdom were not far behind.
See you in 2013
Thanks for flying with WordPress.com in 2012. We look forward to serving you again in 2013! Happy New Year!
WordPress.com
SQL Server Journey with SQL Authority
… but wait, there’s more!
2013 is going to be even better on WordPress.com…
Who were they?
The most commented on post in 2012 was SQL SERVER - 2 T-SQL Puzzles and Win USD 50 worth Amazon Gift Card and 25 Other Prizes
These were the 5 most active commenters on this blog: