Fabric has CI/CD built in, but if you've tried to use it for database deployments, you've probably already run into its limits. It's still very much in its infancy. The moment you change a column's length, drop a column, or remove a table that already contains data, the deployment fails — Fabric throws up a safety precaution and refuses to proceed. That's a reasonable default, but it stops real schema changes in their tracks. There could be ways around it — third-party tools

Index maintenance has always meant nightly jobs and a window you have to defend. Azure SQL’s new Automatic Index Compaction targets page density directly — so I tested it.

When managing large databases or high-transactional databases, the performance of your underlying storage system is crucial, whether it...

Recently, one of my clients was experiencing performance issues with their SQL Server. Although the server was not underpowered from a...

Working with large databases, multi-terabyte in size, I've had clients who have wanted to move to the cloud. However, after testing and...

Your Cloud Provider is experiencing an outage! Your websites and databases are all down! When local data centers were the primary source...

After several discussions with the Microsoft team and chatting with Sunil Sabat about the testing I was conducting, the conclusion was...

Sorry to disappoint you. In this post, we won't test Microsoft Fabric directly. We will compare Azure Data Factory (ADF) to Microsoft...

To quickly summarize where we are, we started testing Microsoft Fabric with a 10GB tar file, which took over 20 hours to extract, and now...

Shortly after Microsoft Fabric came out a few months ago, I created an account and started playing around. I love to push technology to...

Since I first used Azure Data Factory, I looked for the 'disable' option on an activity, and it wasn't there! I quickly went to the ideas...

At the end of 2021, I started using the new SFTP preview feature on Azure Data Lake Storage Gen 2. It was a great new addition to the...

I am excited and honored to have been asked to be an Octopus Insider for Octopus Deploy. This is a new program for those passionate about...

Bottom line? Don't use it! At least don't use it for a SQL cluster directly. Recently I stumbled on a configuration using S2D (Storage...

I recently performed an analysis of some data I pulled from my Octopus Deploy database using PowerBI Desktop. The reports I created,...