How do you start a database in a single user mode when there is corruption? Here are simple steps in SQL Server Configuration Manager, one by one.
Backup to URL Hangs on PREEMPTIVE_HTTP_EVENT_WAIT in an Azure VM
Backup to URL hangs on PREEMPTIVE_HTTP_EVENT_WAIT when an outbound rule denies internet access on an Azure virtual machine. I saw it after blocking the internet on my own VM. An outbound rule that allows the Storage destination fixed it.
SQL SERVER – SQL Server Agent Missing in SQL Server Management Studio (SSMS)
A client could not see the SQL Server Agent node, it was missing in SQL Server Management Studio. Here are the possible causes, starting with sysadmin rights.
Tagging Personal Data Columns With ADD SENSITIVITY CLASSIFICATION
Add sensitivity classification to reviewed columns, inspect stored labels, and keep discovery separate from encryption and access controls.
SQL SERVER – 5061: FIX Error: ALTER DATABASE failed because a lock could not be placed on database ‘Database Name’. Try again later.
Trying to take a test database offline, we hit Msg 5061: ALTER DATABASE failed because a lock could not be placed on database. Here is how to fix it.
SQL SERVER – OLE DB Provider ‘Microsoft.ACE.OLEDB.12.0’ for Linked Server ‘(null)’ Returned Message ‘Unspecified Error’
Reading Excel through OPENROWSET failed: the OLE DB provider for linked server (null) returned message ‘Unspecified error’. Here is how I fixed it.
How to Grow All Files in a File Group Equally? – TRACE FLAG 1117 – Interview Question of the Week #201
How do you grow all files in a file group equally? The answer is Trace Flag 1117, plus the AutoGrow option that SQL Server 2016 brought for filegroups.