14
Since 2024 is coming to an end, I figured I should make a round-up, similar to Brent Ozar’s, outlining the most popular blog posts this year.
Most popular blog posts by views
- Script to delete extra tempdb data files
- How apps cause ASYNC_NETWORK_IO waits in SQL Server
- Script to measure write speeds in SQL Server
- Recreate a default shared folder in QNAP
- Finding Long Values Faster – my solution to Brent’s exercise
Most popular blog posts by likes
This list is based on post likes on my blog, not on social media platforms such as LinkedIn.
Excluding posts that already show up in the “most viewed posts” list.
- Plagiarism and a lesson in hotlinking images
- Export SQL Server query results to HTML table via PowerShell
- Export XML files from SQL Server using PowerShell
- Create a SQL Server container with Podman
- The curious case of the truncating NVARCHAR(MAX) variable
Honorable mention – posts by comments
Excluding posts that already show up in the above two categories.
- Automate SQL Server installation using PowerShell
- Script to decode Asus router configuration backup file
Conclusion
I find it interesting and encouraging that some of my non-SQL Server blog posts have also gotten attention.
In case you’re wondering how I got the data for the above lists: I just queried a fresh backup of my blog’s database.
You can find the queries I’ve used in my GitHub repo.
Thanks for reading my blog and have a happy new year!