I blocked internet access on my Azure SQL Server VM with an outbound rule and started seeing PREEMPTIVE_HTTP_EVENT_WAIT. Here is one possible cause of this wait.
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.
SQL SERVER – Huge Size of SSISDB – Catalog Database SSISDB Cleanup Script
SSISDB grew huge on a client’s server. Here is my cleanup script for the SSISDB catalog database, and why I avoid scripts that modify system objects.