A friend using certificates on workgroup machines saw Connection Handshake Failed on every mirroring login attempt. The witness ERRORLOG showed a missing mirroring endpoint permission, and one GRANT statement fixed it.
SQL SERVER – SSMS – Script Out Multiple Objects
Do you script objects one at a time in SSMS out of habit? There is a quicker way to script out multiple objects in one go, and here is how.
SQL SERVER – Installation Error – [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Patching SQL Server 2005 on a cluster failed with ‘Data source name not found and no default driver specified’. What caused it for a reader and the fix.
SQL SERVER – Fix Error Msg 13603 working with JSON documents
Msg 13603 appeared when I used a custom path with FOR JSON PATH, because the column alias had an invalid character. Here is how to fix it.
Nullable Foreign Keys: Optional Relationships and Outer Joins
A nullable foreign key lets a row say no relationship yet. I show what the constraint checks, why an inner join drops those rows, and where WHERE bites.
SQL SERVER Puzzle – Conversion with Date Data Types
Converting values with CAST can round in ways you don’t expect. A puzzle on Date Data Types: guess the output of each query before you run it.
SQL SERVER – Cannot initialize the data source object of OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server
Cannot initialize the data source object of OLE DB provider Microsoft.ACE.OLEDB.12.0 showed up only from the client machine. Here is why and the fix.