Decoding the Code

Getting results using less T-SQL

There is usually more than one way to write a query. In this article, Edward Pollack explains a few ways to write simpler T-SQL code.

Using T-SQL over PoSh

When do you choose to use one tool or language over another. Steve discussed T-SQL vs. PowerShell.

Removing Text From All Rows

Using Collation in SQL Server

The Greatest of All

The basic T-SQL SELECT statement

The SQL language is used across many relational database platforms. Greg Larsen explains the basics of the SELECT statement for SQL Server.

Use Cases for WHILE and GOTO Loops with T-SQL for Time Series Data

In this article we cover situations where using a loop in T-SQL to process data for time series analysis is beneficial to get the desired results.

Checking the Type Code

A Virtual FROM Source