Add sensitivity classification to reviewed columns, inspect stored labels, and keep discovery separate from encryption and access controls.
SQL SERVER – Finding User Who Dropped Database Table
A client wanted to know who dropped a table. Here is how to find the user who dropped a database table from the default trace.
SQL SERVER – You Are Not Logged on as the Database Owner or System Administrator
A developer creating a table in SSMS got a pop-up: You are not logged on as the database owner or system administrator. Here is what the message means.
SQL SERVER – Azure Key Vault Deletion Error – Vault ‘ProdRecoveryVault’ Cannot be Deleted as There are Existing Resources Within the Vault
Not an Azure Key Vault after all: a Recovery Services vault that would not delete. The AzureRM script is retired, and soft delete waits 14 days.
SQL SERVER – How to Change Authentication Mode Using T-SQL Query
A software vendor shipped SQL Express with Windows-only login by mistake. Here is how to change the authentication mode to mixed mode with a T-SQL query.
Azure Virtual Machine – You Must Change Your Password Before Logging On The First Time
Remote Desktop to my Azure Virtual Machine said: you must change your password before logging on the first time. Here is the workaround I used.
SQL SERVER – Error: 45207 – SQL Server Managed Backup to Microsoft Azure Cannot Configure the Database Because a Container URL was Either not Provided or Invalid
After a cleanup on my Azure SQL VM, I hit Msg 45207: SQL Server Managed Backup to Microsoft Azure cannot configure the database. Here is how I fixed it.