Displaying Sorted Hierarchies (SQL Spackle)

Learn how you can query a hierarchy of data and also return the results in an ordered fashion. A handy T-SQL skill that you will use over and over again.

Making Temporal Databases Work. Part 2: Computing Aggregates Across Temporal Versions

In this part 2 we discuss what kind of aggregates can be obtained from a temporal database and how to express these aggregations in the SQL language.

Redgate Summit: The Database Landscape - New York

Join Redgate at the last Redgate Summit event of the year! This series of events is hosted across the globe for data professionals who want to improve their skills and knowledge about Database DevOps, learn about topics surrounding the Cloud, AI, and working across multiple databases.

What happens when we drop a column on a SQL Server table? Where's my space?

You have dropped a column and wondering why you haven't recovered any space? Let's take a look.

Using Registered Servers in SSMS

One of the features in SQL Server Management Studio (SSMS) that I find very useful is to have a list of registered servers and databases in SSMS. This lets me quickly pick from a number of servers rather than flipping the drop down in the connection dialog. This post looks at this feature and how […]

Getting Started with Azure CLI to Manage Azure Resources

Learn about Azure CLI and how to manage your Azure resources using commands instead of using the Azure portal.

PASS Summit Futures Scholarship

In celebration of their 25th anniversary in 2024, Redgate, as the host of PASS Summit, is thrilled to introduce the PASS Summit Futures Scholarship. This initiative aims to empower the next generation of data professionals from diverse backgrounds.

Applications are open internationally to students and early-career professionals. Each of the 10 lucky winners will be awarded:

Getting Started With Azure Cosmos DB for PostgreSQL

This article shows how to get started with the PostgreSQL API in Azure Cosmos DB.

It’s a recovery strategy, not a backup strategy

I’ve talked about it before; you shouldn’t have a backup strategy, you should have a recovery strategy.

An Alternative (Better?) Method to UNPIVOT (SQL Spackle)

Normalizing or UNPIVOTing data may be improved by using this lesser known approach in SQL Server 2008 or later.