Fabric has CI/CD built in, but if you've tried to use it for database deployments, you've probably already run into its limits. It's still very much in its infancy....
2026-07-10
26 reads
Index maintenance has always meant nightly jobs and a window you have to defend. Azure SQL’s new Automatic Index Compaction targets page density directly — so I tested it.
2026-07-10 (first published: 2026-06-30)
257 reads
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday, and everything that went right—and wrong—along the way.
2026-06-26 (first published: 2026-06-06)
133 reads
SQL Server 2025 In my previous blog post, we briefly covered the new compression being introduced in SQL Server 2025. After some...
2025-08-26
4 reads
Compression was introduced in SQL Server version 2008. While it helped, the compression ratios were frequently too low to justify the...
2025-08-13
7 reads
Calling APIs directly from SQL Server has been available in Azure SQL DB since 2022, but now it's available in on-prem in SQL Server 2025...
2025-07-03
6 reads
Calling an API has been in Azure SQL since 2022, but it was only recently added to SQL Server 2025 Preview. This new feature...
2025-07-01
8 reads
When managing large databases or high-transactional databases, the performance of your underlying storage system is crucial, whether it...
2025-06-18
5 reads
Recently, one of my clients was experiencing performance issues with their SQL Server. Although the server was not underpowered from a...
2025-06-17
2 reads
Working with large databases, multi-terabyte in size, I've had clients who have wanted to move to the cloud. However, after testing and...
2025-06-12
5 reads
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
By Zikato
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...
WA:08218154393 Jl. Burangrang No.44, Burangrang, Kec. Lengkong, Kota Bandung, Jawa Barat 40262
WA:08218154393 JL. JENDRAL SUDIRMAN NO. 18A RT.007 RW.000, BANTUL WARUNG, DESA. KEL. BANTUL, KEC....
Comments posted to this topic are about the item The SQL Server 2016 Plan
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers