TDSSNIClient initialization failed with error 0x7e, status code 0x60, stopped me from connecting to SQL Server 2008. Here is how I solved it.
SQL SERVER – Few Useful DateTime Functions to Find Specific Dates
Useful DateTime functions from Vivek Jamwal: find today, yesterday, and the first and last day of the current or last week and month with DATEADD.
SQL SERVER – 2008 – Introduction to Merge Statement – One Statement for INSERT, UPDATE, DELETE
The SQL Server 2008 Merge Statement does INSERT, UPDATE and DELETE in one statement and reads the data only once. An introduction to how it works and its syntax.
GREATEST and LEAST: Find Row Extremes With NULLs
GREATEST and LEAST compare several expressions within one row. These typed decimal examples show negative numbers, ties, partial NULLs and an entirely missing row.
SQL_VARIANT_PROPERTY: Inspect Decimal Precision and Scale
SQL_VARIANT_PROPERTY makes underlying types visible. Inspect explicit decimal widths, int, Unicode capacity and a missing variant value.
SQL SERVER – How to Rename a Column Name or Table Name
How to rename a column or a table in SQL Server with sp_RENAME, with a video and a simple AdventureWorks example for each case.
Recursive CTE Performance: Index the Child Lookup
Recursive CTE performance depends on finding the next children efficiently. Compare identical rows and actual plans before accepting an index change.