Part 1 of this article introduced four new T-SQL functions available in SQL Server 2012. Part 2 has the rest.

Dynamic SQL lets you create a query string based off of user input. SQL Server allows you to create dynamic SQL statements. The statements use a SQL string varchar data type, then you execute the ...

This guide provides step-by-step instructions with examples how to extract a substring in Excel using various text functions.

SQL window functions provide extremely powerful and useful features that let you work with observations more easily. Different types explained here.

How To Validate Input in PowerShell Functions, Part 2 As Brien demonstrates, string validation is not the only type of input validation that PowerShell can perform.