System-Assigned vs User-Assigned Managed Identity in Azure
Learn the difference between system-assigned and user-assigned managed identities in Azure, including lifecycle, sharing, Azure SQL, Key Vault, and common use cases.
Deploy Azure SQL External Tables Using an Azure DevOps CI/CD Pipeline
Quick answer: To deploy Azure SQL external tables through an Azure DevOps pipeline, replace hardcoded credential and data source values with SQLCMD variables, store the
SSRS Permissions: How to Grant Content Manager Access
Learn how to grant SSRS permissions using the Content Manager role, configure report server item-level security, manage role inheritance, and troubleshoot access issues.
Send email from SQL Server using Power Automate Desktop
Power Automate Desktop (PAD) comes free with Windows 10 and 11, and it is one of the most underused tools sitting on most people’s machines.
DP-700 Exam Preparation Guide: Microsoft Fabric Data Engineer Associate
Prepare for Microsoft DP-700 with the latest exam skills, Fabric architecture, ingestion and transformation techniques, monitoring, optimization, hands-on labs, and a practical study plan.
Migrate SSRS Reports to Power BI Report Server
Learn how to migrate SSRS reports to Power BI Report Server, including report content, data sources, subscriptions, folder mapping, validation, and automated migration options.
SSRS vs Power BI Report Server: What’s the Difference?
Compare SSRS vs Power BI Report Server, including report types, interactive analytics, deployment, licensing, SQL Server 2025 changes, migration, and when each platform fits.
Download All SSRS Reports from a Report Server
Learn how to download and export all SSRS reports and related objects from a report server using the SSRS Reports Migration Wizard and SRMW files.
Compare Azure SQL Database Schema Using SqlPackage
Learn how to compare Azure SQL Database schemas with SqlPackage and DACPAC files, generate a deployment script, review differences, and automate schema comparisons.
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 source and target environments are disconnected or air-gapped. Many organizations
Cross Database Query in Azure SQL Database
In modern cloud architectures, it’s common to distribute data across multiple Azure SQL Databases. While this promotes modularity and scalability, it can pose challenges when
SSMS Copilot: SSMS 21 vs 22, Azure OpenAI and GitHub Copilot
SQL Server Management Studio (SSMS) version 21 introduces native Copilot integration, enhancing SQL development. Users can connect to Azure OpenAI for efficient query generation and debugging in read-only mode. Copilot aids in writing, fixing, and optimizing SQL queries without executing modifications, ensuring control and security over data.