DBCC PAGE is no longer an option, with Azure databases
SQL
There are two ways to change the MAXDOP value, within SSMS. How does that work?
Changing the name of a SQL Mail Profile
Ensure your SQL Server Audit isn’t changed without a notification being raised
Using Undocumented Stored Procedures to change settings no longer accessible with SSMS in an Azure Managed Instance
Showing how the DELETE CASCADE clause works and why you might not want to be tempted by it
As part of the security standards required in my area there is a need to track several areas of database and SQL Server activity. Whilst using a much earlier version of SQL Server, we had a hand-crafted solution. Now we are using the latest version of SQL Server, it is time to use the tried …
Subtitle – Distributed AG, the Gift That Keeps on Giving Overview Unexpectedly, we had a connection timeout/failure between a couple of nodes of our Availability Group (AG). None of the documented causes of this (that we could find) were responsible for this, until somebody asked a very simple question….
Moving TempDB files isn’t as painful as some people would lead you to believe.
Safeguard your rollback by storing the changes to data as they happen, not as a seperate step.
Notes on SQL 