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.

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.