fn_get_sql() and DBCC INPUTBUFFER will be deprecated. Use sys.dm_exec_query_stats and sys.dm_exec_sql_text to see each recently executed T-SQL query.
VALUES Type Inference: Cast Before Combining Rows
VALUES type inference chooses a common column type. Preserve formatting-sensitive text by making source conversions explicit before combination.
Connecting PHP to SQL Server
Connecting PHP to SQL Server means choosing SQLSRV or PDO_SQLSRV, binding parameters, validating TLS, and keeping web queries efficient.
SQL SERVER – Interesting Observation – Query Hint – FORCE ORDER
A junior developer used the FORCE ORDER query hint without knowing what it does. Here is how it works and how much this one hint can change performance.
geography Point: Latitude Comes Before Longitude
geography Point uses latitude, longitude and SRID arguments. Its coordinate order differs from POINT text, so inspect both returned properties.
Rotating the TDE Certificate
Rotating the TDE certificate protects recovery only when the new private key is backed up and old backups still restore.
SQL SERVER – SQL Server Management Studio and Client Statistics
Query cost does not tell you how much data a query returns. Client statistics in SQL Server Management Studio do, and there are three ways to turn them on.