A client with SQL Server memory issues saw Event ID 2004, Resource Exhaustion Diagnosis Events, naming sqlservr.exe for low virtual memory. Here is what it means.
SQL SERVER – SSIS – Package Error: “ODBC Source” Failed Validation and Returned Validation Status “VS_NEEDSNEWMETADATA”
A client’s SSIS package failed: “ODBC Source” failed validation and returned validation status “VS_NEEDSNEWMETADATA”. I explain which metadata and the fix.
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.
How to STOP the Usage of SELECT * For Views? – Interview Question of the Week #193
How do you stop people from using SELECT * in views? A slow query in a Health Check came from SELECT * over a wide view, so here is one way to prevent it.
SQL Server – Formatted Date and Alias Name in ORDER BY Clause
Format a date with CONVERT, then use its alias in ORDER BY, and the rows come back in a different order. Here is a simple example of this formatted date surprise.
SQL SERVER – Selecting Random n Rows from a Table
To select random-looking n Rows, I can sort by NEWID and use TOP. A developer wanted ten AdventureWorks Product rows.
How to Escape a Single Quote in SQL Server? – Interview Question of the Week #192
How do you escape a single quote in SQL Server? A college student asked me at a Bangalore user group, a few people laughed, and here is the simple answer.