One more year is behind us, and unfortunately, we are all still in the COVID-19 regime. But SQLShack Community continuous to grow and we are thankful for that to all our readers!
SQLShack Community team was diligent this year and make an effort to brought to you the best content on the network. We’d like to thank all of the authors for their contribution to spreading the knowledge around the SQL community. We couldn’t have done it without you all!
This year winner of the Best author award in 2021 is… Esat Erkec! Congrats!
He is the author of hundreds of authoritative articles on SQL Server, SQL Performance, Monitoring, Database development and design, Business Intelligence and related technology. He is a SQL Server Microsoft Certified Solutions Expert. Most of his career has been focused on SQL Server Database Administration and Development. He can be found on LinkedIn.
| Author | Views | |
| 1 | Esat Erkec | 730004 |
| 2 | Rajendra Gupta | 351769 |
| 3 | Nisarg Upadhyay | 307544 |
| 4 | Aveek Das | 249023 |
| 5 | Hadi Fadlallah | 105819 |
| 6 | Ahmad Yaseen | 84278 |
| 7 | Gauri Mahajan | 78274 |
| 8 | Rahul Mehta | 70140 |
| 9 | Dinesh Asanka | 47441 |
| 10 | Ben Richardson | 33801 |
In 2021, Esat wrote the articles that are rated as most popular on our blog. His article SELECT INTO TEMP TABLE statement in SQL Server was viewed by more than 135 000 times! That is impressive!
Here is the list of the top 10 most popular articles in 2021:
| Article | Author | Views | |
| 1. | SELECT INTO TEMP TABLE statement in SQL Server | Esat Erkec | 135006 |
| 2. | SUBSTRING, PATINDEX and CHARINDEX string functions in SQL queries | Rajendra Gupta | 118260 |
| 3. | Learn MySQL: The Basics of MySQL Stored Procedures | Nisarg Upadhyay | 94856 |
| 4. | Working with SQL NULL values | Esat Erkec | 90564 |
| 5. | Transactions in SQL Server for beginners | Esat Erkec | 86040 |
| 6. | Azure Data Factory Interview Questions and Answers | Ahmad Yaseen | 61375 |
| 7. | Using Stored Procedures with Return Values | Esat Erkec | 54731 |
| 8. | SQL SELECT TOP statement overview and examples | Esat Erkec | 53003 |
| 9. | Setting up a PostgreSQL Database on Mac | Aveek Das | 46038 |
| 10. | SQL Server ORDER BY performance tips | Esat Erkec | 42457 |
On the list of the most written articles, we have another winner, and that is no surprise, Rajendra Gupta – congrats! Rajendra wrote more than 80 articles which put him on the top spot, again! Excellent job, Raj!
As an MCSA certified and Microsoft Certified Trainer, Rajendra works for various large companies focusing on performance optimization, monitoring, high availability, and disaster recovery strategies and implementation. He is the author of hundreds of authoritative articles on SQL Server, Azure, MySQL, Linux, Power BI, Performance tuning, AWS/Amazon RDS, Git, and related technologies that over 10 million readers have viewed. And he was two times the winner of the Best author award at SQLShack!
Raj is always interested in new challenges, so if you need consulting help on any subject covered in his writings, you can reach him at rajendra.gupta16@gmail.com.
| Author | Articles | |
| 1 | Rajendra Gupta | 85 |
| 2 | Gauri Mahajan | 51 |
| 3 | Aveek Das | 43 |
| 4 | Esat Erkec | 43 |
| 5 | Nisarg Upadhyay | 42 |
| 6 | Dinesh Asanka | 25 |
| 7 | Hadi Fadlallah | 20 |
| 8 | Rahul Mehta | 19 |
| 9 | Manvendra Singh | 15 |
| 10 | Daniel Calbimonte | 6 |
| Haroon Ashraf | 6 |
And that is not all, folks! We have one more surprise! This year, we have one more winner in the Best new author award category – Manvendra Singh. Congrats!
Manvendra is a database enthusiast. He loves to talk and write about database technologies. He has led and delivered many projects from designing to deployments on Migrations to the cloud, heterogeneous migrations, Database consolidations, upgrades, heterogeneous replication, HA / DR solutions, automation, and performance tuning projects. You can find him on LinkedIn.
Special gratitude from the SQLShack team goes to Gauri Mahajan – our copy-editor and writer. She did a fantastic job! Her help and advice are so precious to all of us! Thank you, Gauri!
Congrats to all authors who made it to the top 10, and say our gratitude to all authors who contributed to our community. We couldn’t do it without all of you!
Sincerely,
SQLShack team
- Best author award in 2021 - January 3, 2022
- Best author award in 2020 - January 5, 2021
- Best author award in 2019 - January 3, 2020