If you take the normal approach to create a linked server to SQL Azure Database, then you would end up in below error message.
SQL SERVER – Removing Duplicate String Characters with Ordered Aggregation – Part 2
I can Remove Duplicate characters while preserving their first-occurrence order. This second method uses explicit positions and ordered aggregation.
SQL SERVER – Unable to Get Listener Properties Using PowerShell – An Error Occurred Opening Resource
A client could not change listener properties with PowerShell and got “An error occurred opening resource”. Here is the T-SQL query I shared and what fixed it.
SQL SERVER – How to Find UNIQUE Key Columns? – sp_special_columns
Want to know which columns uniquely identify a row in a table? The system stored procedure sp_special_columns tells you. Here is a quick demo.
SQL SERVER – System Procedure to List Out Table From Linked Server
The System Procedure sp_tables_ex lists table metadata from an existing linked server. I check its provider and login mapping separately.
ROWCOUNT and PAGECOUNT: Faking a Big Table to Test Plans
You can tell the optimizer a three-row table has 10 million rows and watch the plan change. Here is how, and how to undo it.
SQL SERVER – Different Methods to Know COMPATIBILITY LEVEL of a Database
Different methods to find the compatibility level of a database, from sp_helpdb to sp_dbcmptlevel, with a quick note on what the setting means.