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.
How to Insert Line Break in SQL Server String? – Interview Question of the Week #139
How do you insert a Line Break in a SQL Server string? Just press Enter inside the string, and switch SSMS results to text to see it. Here is how it works.
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.
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.