Searching an Encrypted Column

This article examines the challenges with searches on encrypted data and presents a possible solution that you might use to speed up those queries.

Getting a List of Names

SQL GROUP BY Alias - An Oracle feature that would be great in SQL Server

Learn about using an alias in the GROUP BY clause for complex SQL Server code instead of having to rewrite the code in the GROUP BY.

Who Still Uses SP_ for Naming?

You shouldn't use sp_, and you should use DevOps.

Window Function Basics - PARTITION BY

This article looks at the basics of the OVER() clause and how the PARTITION section works.

A Partial Count

Zero Statistics Sampling

An Incomplete Window Definition

Time Series Data Mining Example with T-SQL when Adding New Data

Learn about working with time series data using T-SQL code and how to add additional data to the data set for more in-depth data mining.

Unpivoting Multiple Sets of Columns in SQL Server using CROSS APPLY

Learn how to unpivot data or sets of data with SQL Server queries using CROSS APPLY.