SQL Server 2025 Standard Developer Edition
Learn about the new Standard Developer Edition of SQL Server 2025.
2026-01-19
19,696 reads
alzdba
- Interests: family, mantrailing / dogs, riding my motorbike, volleyball
- Twitter: @forget this one @alzdba
SQL Server 2025 Backup Compression Algorithm
Learn about the new ZSTD compression algorithm in SQL Server 2025.
2025-12-29
2,420 reads
Windows Clustered MSDTC and SQL Server 2019 mishap
Introduction As you may know, in the early days of SQL Server Clustering, Microsoft advised to provide each clustered SQL Server instance with its own Microsoft Distributed Transaction Coordinator (MSDTC) resource. Since SQL Server 2012 this advice has been withdrawn. Microsoft now recommends to provide your instance with its own MSDTC resource, once you notice the […]
2025-04-04
3,476 reads
Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events
Intro In 2008 I wrote an article called “Scope: The drastic caveat with Logon Triggers.” Ever since, we have been using Event Notifications to capture logins for our SQL Server instances. Issues were only very rare, usually on servers that had an extreme load of many connections. In such a case, we stopped this continuous monitoring and […]
2021-10-29
5,126 reads
Restoring Master on a Windows 2019 / SQL Server 2019 Cluster
Howto restore master database on a Clustered SQL Server 2019 Instance
2021-04-08
4,775 reads
Scripting SQL Server databases with SMO using EnforceScriptingOptions
Obscure impact of switch EnforceScriptingOptions to scripting a SQL Server database.
2014-12-08
4,660 reads
Instant File Initialization and restores
Instant file initialization also has its advantages when you restore a SQLServer database. This article will show you why.
2012-05-21
4,644 reads
Me, myself and Powershell
Why should any SQLserver administrator, DBA, or Developer be interested in Powershell? Johan Bijens presents a few reasons today.
2011-12-06
7,752 reads
2011-09-05 (first published: 2007-01-25)
3,950 reads
Reset count for all alerts
To see the frequency of alerts in use, you can reset their fire count.
Restart count from zero for all alerts using the propre stored procedures.
2009-12-22 (first published: 2003-01-14)
490 reads
Blogs
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Rambling about Data on Wheels – origins, branding, expansion
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Think Twice Before Enabling Fabric’s Inbound Network Protection
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Forums
Alamat Kontak Bank BCA KCP Riau Telp:08218154392
WA CS (08218154392) Jl. Laks Jl. L. L. R.E. Martadinata No.92, Cihapit, Kec. Bandung...
Alamat Kontak Bank BCA KCP Banda Telp:08218154392
WA CS (08218154392) Jl. Banda No.39, Citarum, Kec. Bandung Wetan, Kota Bandung, Jawa Barat...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Question of the Day
DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers