Compare Azure SQL Database Schema Using sqlpackage
Learn how to compare two Azure SQL Database Schema effectively and generate delta scripts for…
SSRS Migration Case Study: Migrating SSRS Reports in a Disconnected Environment
Migrating SQL Server Reporting Services (SSRS) reports to AWS can be challenging, especially when the…
Download all SSRS Reports from Report Server
If you are working with SQL Server Reporting Services (SSRS), one of the most common…
Connect Python Azure Function to Azure SQL Using Managed Identity
An Azure Function is a lightweight, serverless compute option in Azure that lets you execute…
Data Agent in Microsoft Fabric – Here’s How it Works
In this post, I’ll walk you through how I built a Fabric Data Agent on…
Transferring Sensitive Data During SSIS Catalog Migrations to Another Server
Migrating your SQL Server Integration Services (SSIS) Catalog to a new server or instance is…
How to Migrate SSRS Reports from One Server to Another (Step-by-Step)
In this guide, we’ll walk through the ssrs report migration process and share best practices…
SSMS 21 Copilot: Here’s How It Works
SQL Server Management Studio (SSMS) version 21 introduces native Copilot integration, enhancing SQL development. Users…
Cross Database Query in Azure SQL Database
In modern cloud architectures, it’s common to distribute data across multiple Azure SQL Databases. While…
Azure Analysis Services Model Missing
In this article, we will see how to fix Azure Analysis Services model missing issue.
How to Delete Stale Delta Files in Microsoft Fabric Lakehouse
This article describes how to delete delta files from fabric lakehouse using python code and…
Automate Databricks Infrastructure as Code with Terraform
This article describes how to Implement Infrastructure as Code Databricks with Terraform.