SQL Server sa Account Security: Rename, Disable & Best Practices
In the Windows administration world, it's pretty much a standard practice to rename the local administrator...
2026-08-19 (first published: 2026-08-05)
521 reads
SQL Server gMSA: Why DBAs Still Aren't Using It in 2026
Group Managed Service Accounts (gMSAs) solve the classic service-account password problem - just look at...
2026-08-18
135 reads
SQL Server instance metadata inventory with PowerShell and SMO
The purpose of this article is to introduce a PowerShell script that I wrote and published on...
2026-06-19 (first published: 2026-05-29)
472 reads
Track SQL Server Configuration Changes Using the Error Log
If you work with SQL Server long enough, you or someone will eventually want to know, “Did...
2026-05-29 (first published: 2026-05-14)
388 reads
Beware of Generic SQL Server License Keys (What to Use Instead)
I (think) realize that content here is probably more applicable to mid-to-large organizations than small...
2026-05-01 (first published: 2026-04-22)
446 reads
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026)
Originally published in 2023, this post never made it into Google's index, so I'm republishing it...
2026-04-03 (first published: 2026-03-26)
556 reads
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes
After tempdb, msdb is often the most abused system database, growing unchecked until it tanks...
2026-02-11 (first published: 2026-01-30)
584 reads
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022
If you’ve spent any time tuning SQL Server, you’ve probably heard “Turn...
2026-02-09 (first published: 2026-01-27)
350 reads
Dry-run xp_delete_file Before Actually Deleting Files?
xp_delete_file doesn’t really have a built-in dry-run option to preview which files it would remove. But there’s a simple workaround,...
2025-12-10 (first published: 2025-11-27)
530 reads
Writing Better Dynamic SQL
This updated and "sort" of a style guide is for SQL developers and, to some extent, DBAs, essentially anyone daring (and sometimes...
2025-11-18
344 reads
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Security has long been a problem for me. Every time I think I understand...
Comments posted to this topic are about the item BIT_COUNT() V
Comments posted to this topic are about the item How We Reduced SQL Server...
What does this return on SQL Server 2025?
select bit_count(null)See possible answers