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.

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:

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.

Migrate a SQL Server Database to a PostgreSQL Database

Learn about various options to migrate an entire SQL Server database to a PostgreSQL database.

Microsoft Fabric, the Land of Wizards and Trolls

In my previous article (What is Microsoft Fabric All About) I explained what Microsoft Fabric is, how it came about and whether it brings anything new to the data insights domain.

Using Query Store to Identify CPU Intensive SQL Queries and Creating Proper Indexes

Learn how to use SQL Server Query Store to identify what resources are using CPU to help fine-tune queries and reduce the processing load.

Deleting Documents from a MongoDB Collection

So far in this series, we’ve looked at different ways that you can add, retrieve, and update documents in a MongoDB collection. This article continues that discussion by explaining how to use MongoDB Shell to delete documents from a collection.

Configure Microsoft Fabric Database Mirroring for Snowflake

In this tip, we explore how to configure mirroring for a Snowflake database to be available in Microsoft Fabric.