Learn how to safely remove a SQL Server .ndf data file without any downtime using DBCC SHRINKFILE (EMPTYFILE). This hands-on tutorial walks through real-world Azure-based setup, data redistribution, and storage cleanup — ideal for DBAs managing enterprise SQL Server environments.
2025-05-16
1,103 reads
2024-08-05
332 reads
2022-09-02
551 reads
2022-08-26
467 reads
2022-09-02 (first published: 2022-08-23)
9,365 reads
2022-08-19
678 reads
2020-02-17
1,006 reads
In this tip look at the undocumented command DBCC WRITEPAGE to corrupt a SQL Server database and then use the command to undo the corruption.
2018-10-03
2,545 reads
2018-08-31
755 reads
2018-08-24
974 reads
I was sick of changing context in Azure Data Studio while cleaning up things...
By Zikato
The crime spree in Digitown is not ending. This time 20 cars have been...
By Steve Jones
One of our mission statements in the Book of Redgate says: attempt to do...
Comments posted to this topic are about the item Shining a Light on Shadow...
Hi, I would love to hear if anyone can tell me why a CAST...
hi, one of our sister division's erp extract view is going thru at least...
In SQL Server, when the buffer manager write pages to disk, page protection is added to the pages. There are two types of protection: torn page protection and checksum page protection. What happens with regards to concurrency with page protection during writes?
See possible answers