Archive
2021 blogging in review (Thank you & Happy New Year 2022 !!!)
Happy New Year 2022… from SQL with Manoj !!!
As WordPress.com Stats helper monkeys have stopped preparing annual report from last few years for the blogs hosted on their platform. So I started preparing my own Annual Report every end of the year to thank my readers for their support, feedback & motivation, and also to check & share the progress of this blog.
As I mentioned in my last year’s annual report I could not dedicate enough time to blog in year 2019 & 2020, so it also continued in 2021 with fewer posts. Thus, due to inactivity of 2-3 years, the blog hits are remaining below ~1k hits per day which is very low from what I was getting earlier (around 3k to 3.5k hits per day). So, you can see a drastic decline of hits in 2021 year in the image below.
–> Here are some Crunchy numbers from 2021:
The Louvre Museum has a foot fall of ~10 million visitors per year. This blog was viewed about 245,470 times by 194,886 unique visitors in 2021. If it were an exhibit at the Louvre Museum, it would take about ~50 days for that many people to see it.
There were 18 pictures uploaded, taking up a total of ~1 MB. That’s about ~1 pictures every month.
–> All-time posts, views, and visitors:
–> Posting Patterns:
In 2021, as I mentioned the reason above there were just 14 new posts, growing the total archive of this blog to 577 posts.
LONGEST STREAK: 4 post in April 2021
–> Attractions in 2021:
These are the top 5 posts that got most views in 2021:
0. Blog Home Page (30,424 views)
1. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE (12,151 views)
2. Reading JSON string with Nested array of elements (10,527 views)
3. Windows could not start SQL Server, error 17051, SQL Server Eval has expired (6,032 views)
4. Using IDENTITY function with SELECT statement in SQL Server (5,960 views)
5. SQL Server blocked access to procedure ‘dbo.sp_send_dbmail’ of component ‘Database Mail XPs’ (5,268 views)
–> How did they find me?
The top referring sites and search engines in 2021 were:
–> Where did they come from?
Out of 210 countries, top 5 visitors came from India, United States, United Kingdom, Canada and Australia:
–> Followers: 442
WordPress.com: 180
Email: 260
Facebook Page: 1,454
–> Alexa Rank (lower the better)
Global Rank: ~1m (as of 31st DEC 2021)
Previous rank: 835,163 (back in 2020)
–> YouTube Channel:
– SQLwithManoj on YouTube
– Total Subscribers: 19,675
– Total Videos: 80
–> 2022 New Year Resolution:
– Write at least 1 blog post every week or two.
– Write on new features in SQL Server 2022 and SQL/Data world.
– Started writing on Microsoft Big Data Platform, related to Azure Data Lake and Databricks (Spark/Scala), CosmosDB, etc. so I will continue to explore more on this area and write.
– Post at least 1 video every week on my YouTube channel
That’s all for 2021, see you in year 2022, all the best !!!
Connect me on Facebook, Twitter, LinkedIn, YouTube, Google, Email
2020 blogging in review (Thank you & Happy New Year 2021 !!!)
Happy New Year 2021… from SQL with Manoj !!!
As WordPress.com Stats helper monkeys have stopped preparing annual report from last few years for the blogs hosted on their platform. So I started preparing my own Annual Report every end of the year to thank my readers for their support, feedback & motivation, and also to check & share the progress of this blog.
In year 2019 & 2020 I could not dedicated much time here, so there were very few blogs posted by me. In mid 2019 something strange happened and my blog hits started declining day by day. Usually I used to get daily ~3.5k hits and within few months hits were reduced to just half. As the daily hits were under ~1.5k so I checked the SEO section in WordPress-admin, and I was surprised to discover that my blog & meta info was missing in Google webmaster.
I re-entered the meta info and since last 1 year the blog hits are stable at ~1k hits per day which is very low from what I was getting ~2 years back. Thus, you can see a drastic decline of hits in 2020 year below.
–> Here are some Crunchy numbers from 2020
The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 281,285 times by 213,447 unique visitors in 2020. If it were an exhibit at the Louvre Museum, it would take about 40 days for that many people to see it.
There were 22 pictures uploaded, taking up a total of ~1 MB. That’s about ~2 pictures every month.
–> All-time posts, views, and visitors
SQL with Manoj all time views
–> Posting Patterns
In 2020, there were 10 new posts, growing the total archive of this blog to 561 posts.
LONGEST STREAK: 4 post in Oct 2020
–> Attractions in 2020
These are the top 5 posts that got most views in 2020:
0. Blog Home Page (49,287 views)
1. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE (12,870 views)
2. Windows could not start SQL Server, error 17051, SQL Server Eval has expired (8,498 views)
3. Reading JSON string with Nested array of elements (8,016 views)
4. SQL Server 2016 RTM full and final version available (7,714 views)
5. Windows could not start SQL Server (moved Master DB) (6,988 views)
–> How did they find me?
The top referring sites and search engines in 2020 were:
SQL with Manoj 2020 Search Engines and other referrers
–> Where did they come from?
Out of 210 countries, top 5 visitors came from United States, India, United Kingdom, Canada and Australia:
SQL with Manoj 2020 top Countries visitors
–> Followers: 442
WordPress.com: 180
Email: 262
Facebook Page: 1,480
–> Alexa Rank (lower the better)
Global Rank: 835,163 (as of 31st DEC 2020)
Previous rank: 221,534 (back in 2019)
–> YouTube Channel:
– SQLwithManoj on YouTube
– Total Subscribers: 17,1700
– Total Videos: 70
–> 2021 New Year Resolution
– Write at least 1 blog post every week
– Write on new features in SQL Server 2019
– I’ve also started writing on Microsoft Big Data Platform, related to Azure Data Lake and Databricks (Spark/Scala), so I will continue to explore more on this area.
– Post at least 1 video every week on my YouTube channel
That’s all for 2020, see you in year 2021, all the best !!!
Connect me on Facebook, Twitter, LinkedIn, YouTube, Google, Email
2018 blogging in review (Happy New Year – 2019 !!!)
Happy New Year 2019… from SQL with Manoj !!!
As WordPress.com stats helper monkeys have stopped preparing annual report for any of their blogs, so I’ve prepared my own Annual Report for this year again.
–> Here are some Crunchy numbers from 2018
SQL with Manoj 2018 Stats
The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 793,171 times by 542,918 unique visitors in 2018. If it were an exhibit at the Louvre Museum, it would take about 17 days for that many people to see it.
There were 68 pictures uploaded, taking up a total of ~6 MB. That’s about ~6 pictures every month.
This blog also got its highest ever hits/views per day (i.e. 3,552 hits) on Sept 25th this year.
–> All-time posts, views, and visitors
SQL with Manoj all time views
–> Posting Patterns
In 2018, there were 26 new posts, growing the total archive of this blog to 546 posts.
LONGEST STREAK: 6 post in Feb 2018
–> Attractions in 2018
These are the top 5 posts that got most views in 2018:
1. Download & Install SQL Server Management Studio (SSMS) 2016 (62,101 views)
2. SQL Server 2016 RTM full & final version available – Download now (31,705 views)
3. Getting started with SQL Server 2014 | Download and Install Free & Full version (20,443 views)
4. SQL Basics – Difference b/w WHERE, GROUP BY and HAVING clause (16,113 views)
5. SQL Basics – Difference b/w TRUNCATE, DELETE and DROP? (13,189 views)
–> How did they find me?
The top referring sites and search engines in 2018 were:
SQL with Manoj 2018 Search Engines referrers
–> Where did they come from?
Out of 210 countries, top 5 visitors came from India, United States, United Kingdom, Canada and Australia:
SQL with Manoj 2018 top Countries visitors
–> Followers: 407
WordPress.com: 160
Email: 247
Facebook Page: 1,358
–> Alexa Rank (lower the better)
Global Rank: 221,534
US Rank: 139,012
India Rank: 46,758
Estimated Monthly Revenue: $1,320
Actual Monthly Revenue: $300
SQL with Manoj 2018 Alexa ranking
Alexa history shows how the alexa rank of sqlwithmanoj.com has varied in the past, which in turn also tells about the site visitors.
–> 2019 New Year Resolution
– Write at least 1 blog post every week
– Write on new feaures in SQL Server 2017 & 2019
– Also explore and write blog post on Azure Data Platform
– Post at least 1 video every week on my YouTube channel
That’s all for 2018, see you in year 2019, all the best !!!
Connect me on Facebook, Twitter, LinkedIn, YouTube, Google, Email
2017 blogging in review
Happy New Year 2018 from SQLwithManoj !!!
This time again like previous year (in 2016) WordPress.com stats helper monkeys didn’t prepare annual report for any of their blogs for year 2017. So I prepared my own Annual Report.
–> Here are some Crunchy numbers from 2017
The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 741,708 times by 490,460 unique visitors in 2017. If it were an exhibit at the Louvre Museum, it would take about 17 days for that many people to see it.
There were 38 pictures uploaded, taking up a total of 3.1 MB. That’s about 3 pictures every month.
This blog also got its highest ever hits/views per day (i.e. 3295) on Nov 16th this year.
–> All-time posts, views, and visitors
–> Posting Patterns
In 2017, there were 30 new posts, growing the total archive of this blog to 509 posts.
LONGEST STREAK: 8 post each day, in June 2017
–> Attractions in 2017
These are the top 5 posts that got most views in 2017:
1. Download & Install SQL Server Management Studio (SSMS) 2016 (61,566 views)
2. SQL Server 2016 RTM full & final version available – Download now (38,368 views)
3. SQL Basics – Difference b/w TRUNCATE, DELETE and DROP? (15,407 views)
4. SQL Basics – Difference b/w WHERE, GROUP BY and HAVING clause (15,378 views)
5. Passed 70-461 Exam : Querying Microsoft SQL Server 2012 (13,022 views)
–> How did they find me?
The top referring sites and search engines in 2016 were:
–> Where did they come from?
Out of 210 countries, top 5 visitors came from India, United States, United Kingdom, Canada and Australia:
–> Followers: 352
Wordpress.com: 138
Email: 214
Facebook Page: 1,180
–> Alexa Rank (lower the better)
Global Rank: 236,536
India Rank: 44,871
Estimated Monthly Revenue: $172
Alexa history shows how the alexa rank of sqlwithmanoj.com has varied in the past, which in turn also tells about the site visitors.
That’s all for 2017, see you in year 2018, all the best !!!
Connect me on Facebook, Twitter, LinkedIn, YouTube, Google, Email
2016 blogging in review
Happy New Year 2017 from SQLwithManoj !!!
This time WordPress.com stats helper monkeys didn’t prepare annual report for any of their blogs for year 2016. So I prepared my own Annual Report.
–> Crunchy numbers
The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 640,749 times by 396,212 unique visitors in 2016. If it were an exhibit at the Louvre Museum, it would take about 20 days for that many people to see it.
There were 117 pictures uploaded, taking up a total of 3.1 MB. That’s about 2-3 pictures per week.
The most popular post blogged in 2016 was SQL Server 2016 RTM full and final version available viewed 25,829 times.
–> Posting Patterns
In 2016, there were 52 new posts, growing the total archive of this blog to 416 posts.
LONGEST STREAK: 10 post each day, in March 2016
–> Attractions in 2016
These are the top 5 posts that got most views in 2016:
1. Passed 70-461 Exam : Querying Microsoft SQL Server 2012 (25,946 views)
2. SQL Server 2016 RTM full and final version available (25,829 views)
3. DB Basics – What are Candidate, Primary, Composite & Super Keys (17,189 views)
4. What is SQL, PL/SQL, T-SQL and difference between them (12,966 views)
5. SQL Basics – Difference between TRUNCATE, DELETE and DROP? (11,694 views)
–> How did they find you?
The top referring sites and search engines in 2016 were:
–> Where did they come from?
Out of 210 countries, top 5 visitors came from India, United States, United Kingdom, Canada and Australia:
That’s all for 2016, see you in year 2017, all the best !!!
Connect me on Facebook, Twitter, LinkedIn, YouTube, Google, Email
Current Visitors
StatCounter …since April 2012
Leisure blog: Creek & Trails
- An error has occurred; the feed is probably down. Try again later.
SQL with Manoj 