Applying a Lock to an Azure SQL Server can protect the databases in that SQL Server because child resources inherit locks from their parent, but…
Tag: SQL Server Management Studio
Aim: To capture SQL Agent job history to a table. Following on from the previous blog post about adjusting the size of the SQL Agent…
Aim: To adjust the size of the SQL Agent job history log to retain more or less history as required. On some SQL Servers with…
As highlighted in a number of Connect items, attempting to run SQL Server Management Studio 2016 as another user (e.g. by using Shift + right-click)…