Learn how the main system views connect through object_id, schema_id, index_id, and column_id so catalog joins stay accurate.
SQL SERVER – Fix: Error: HResult 0x2, Named Pipes Provider: Could not open a connection
Fix for HResult 0x2, Named Pipes Provider: could not open a connection to SQL Server. Enable TCP/IP and Named Pipes in SQL Server Configuration Manager.
SQL SERVER – Fix : Error 2501 : Cannot find a table or object with the name . Check the system catalog.
Error 2501, cannot find a table or object with the name, is a common beginner error. Check the database with USE, the spelling and case, and the owner name.
REGEXP_LIKE in SQL Server 2025: Validating Codes, Emails and Phone Numbers
Validate codes, email shapes and phone numbers with REGEXP_LIKE in SQL Server 2025, using clear patterns and CHECK constraints.
SQL SERVER – 2005/2000 Examples and Explanation for GOTO
How the GOTO statement jumps to a label in the same T-SQL batch. My explanation for GOTO covers the syntax, the rules and when I still use it.
SQL SERVER – Creating Comma Separate Values List from Table – UDF – SP
Three ways to build a Comma Separate Values List from a table: COALESCE, a smart SELECT, or a cursor. Written for SQL Server 2005 with VARCHAR(MAX).
SQL SERVER – UDF – Function to Convert List to Table
A UDF, udf_List2Table, to convert list to table with any delimiter you choose. Written for SQL Server 2005 with VARCHAR(MAX), and easy to adapt for 2000.