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.

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.

How to use Jupyter Notebook in VSCode

Learn how you can create and use a Jupyter Notebook in VS Code.

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.

Notebook Jobs in Azure Data Studio

This next article in the series looks at notebook jobs in ADS.

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.