Creating a Node Table

Switching Database context in transaction

Stable Marriages Using SQL Server

In this article, we see how SQL can be used to determine matches between two groups, given a set of preferences.

Choosing the Column

Introduction to Gaps and Islands Analysis

T-SQL window functions simplify solving many complex queries. In this article, Edward Pollack demonstrates how the functions can be used to find gaps and islands in a dataset.

More Choice

CHOOSing a value

Default Schemas

The End of 2019

Do You Have REFERENCES?

The logic for referential integrity can be implemented in application code, but to make sure that it is enforced, include foreign key constraints in the database design instead. In this article, Joe Celko talks about the history of references in SQL and the options available today.