Showing posts with label SQLAdmin. Show all posts
Showing posts with label SQLAdmin. Show all posts

2026-01-01

Top-ten posts 2025

2025 was with way les posts than several prior years. That could partly due to a new focus in my daily job activities such as more abstract architecture and non-technical challenges.

This is the top-ten list of my posts on the 2025 statistics.

RankMoveRank 2024TitleViewsCreated
101 SqlBulkCopy with PowerShell9942017-07-30
2> 9> 10 xp_readerrorlog 5782020-01-07
3-12 ISO 8601 date formatting using PowerShell 4142008-08-14
4+3 7 MSDTC Operations4072022-11-29
5-23 Audit Log for Analysis Services3562014-01-08
6+2 8 xp_instance_regwrite syntax 2822010-09-15
7-2 5 Add SQL Agent job step with tokens in output file name 2712023-02-14
8-26 DBCC CHECKDB with PowerShell 2442014-10-09
9+48 Start shared HTA with PowerShell 2582012-09-13
10(N/A) Set Windows dump file1802025-06-01

With a total of 70400 views in 2025 the top-ten posts is with 3966 views about 6 % of the views this year. The all time number of views is 473292.

This year there are both repeats and new posts on the top-ten. The number one post on SqlBulkCopy with PowerShell is sovereign again this year.

Former Top-ten

My first post on this blog was published 2008-08-13, and many posts are irrelevant today. But I still think it is a good exercise to write each post as it gives me a option to review, refine and improve a description or solution.

 

2025-01-01

Top-ten posts 2024

2024 was a year with fewer posts than planned - again. As each post is like a personal refined note on a specific situation this signals that I am working less with specific technical incidents. My day is more filled with long-term considerations and actions.

This is the top-ten list of my posts on the 2024 statistics.

RankMoveRank 2023TitleViewsCreated
101 SqlBulkCopy with PowerShell18502017-07-30
2+13 ISO 8601 date formatting using PowerShell3342008-08-14
3+710 Audit Log for Analysis Services2842014-01-08
4+48 Start shared HTA with PowerShell2582012-09-13
5> 6> 10 Add SQL Agent job step with tokens in output file name2382023-02-14
6+17 DBCC CHECKDB with PowerShell2102014-10-09
7> 4> 10 MSDTC Operations1172022-11-29
8> 3> 10 xp_instance_regwrite syntax1752010-09-15
9> 2> 10 Database version1242009-09-26
10-55 SQL Server Agent schedule owner982010-02-08

With a total of 39500 views in 2024 the top-ten posts is with 3748 views about 9 % of the views this year. The all time number of views is 402741.

This year there are both repeats and new posts on the top-ten. The number one post on SqlBulkCopy with PowerShell is sovereign again this year. There must be a link somewhere… I am surprised to see the post Database version as it is both rather old and on a very specific and rare subject.

Former Top-ten

My first post on this blog was published 2008-08-13, and many posts are irrelevant today. But I still think it is a good exercise to write each post as it gives me a option to review, refine and improve a description or solution.

Pages

TitleViews
DBA SQL Server Tools184
DBA Security64
DBA Litterature52
Microsoft Resources45

I think that the blog pages should be migrated to the SQLAdmin DK site. I am rewriting the entire site, and might take this migration into the rewrite.

2024-01-01

Top-ten posts 2023

2023 was – again – a year with far less posts than planned. Fortunately some elder posts still generate some activity on this blog.

The top-ten 2023 post list is something like Top-ten posts 2022.

RankMoveRank 2022TitleViewsCreated
101SqlBulkCopy with PowerShell1.9502017-07-30
2>9>10High performance script timer8142020-01-03
3+14ISO 8601 date formatting using PowerShell4792008-08-14
4>7>10ISO 4217 Currency list4252012-06-26
5+38SQL Server Agent schedule owner3602010-02-08
6>5>10Team Foundation Server on a single server3502018-09-19
7-16DBCC CHECKDB with PowerShell3062014-10-09
8>3>10Start shared HTA with PowerShell2712012-09-13
9>2>10VLF count2472011-01-11
10010Audit Log for Analysis Services2042014-01-08

This year there are several new items on the Top-ten. My personal biggest surprise is the item on ISO 4217.
But – still my favority ISO is 8601. The oldest post is more than ten years old, which is I find both interesting and disturbing.

The posts in this blog are personal notes rather than public presentations. This is why I am fine with the low number of views.