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
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.
Creating a Distributed AG can have some issues. This article covers the problems that we encountered.
Duplicating an AG to another environment, for migration purposes.
Background For some investigative work that I had to do, I required an Availability Group (AG) that I could destroy and rebuild without impacting anybody else. Hyper-V was an obvious solution and this article describes the steps required.
Using a synonym to move a table to another database, without changing any queries.
Notes on SQL 