There are two ways to change the MAXDOP value, within SSMS. How does that work?
sql server
Changing the name of a SQL Mail Profile
Using Undocumented Stored Procedures to change settings no longer accessible with SSMS in an Azure Managed Instance
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….
Notes on SQL 