Creating an AlwaysOn availability group listener in SSMS failed with error 19486: this TCP port is already in use. Here is what the ERRORLOG showed.
SQL SERVER – Convert Decimal to Time Format in String
A very strange question I received the other day in an email about how to convert decimal to time format string.
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.