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.
Connect Python Azure Function to Azure SQL Using Managed Identity
Learn how to connect a Python Azure Function to Azure SQL Database using managed identity and Microsoft Entra authentication without storing database credentials.
Microsoft Fabric Data Agent: How It Works, Setup, Security, and Use Cases
Learn how Microsoft Fabric Data Agent works, how to create and configure one, supported data sources, security, runtimes, MCP, Python SDK, and practical use cases.
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 a common administrative task, but it often brings with it
How to Migrate SSRS Reports from One Server to Another
Learn how to migrate SSRS reports between servers, including reports, datasets, data sources, subscriptions, permissions, connection strings, comparison, validation, and automated migration with SSRS Reports Migration Wizard.
Azure Analysis Services Model Missing: How to Fix It
Learn how to fix an Azure Analysis Services model missing issue by checking the server, administrator access, model roles, and deployment target.
How to Fix Stale Delta Files in a Microsoft Fabric Lakehouse
Learn how to troubleshoot non-empty Delta table locations in a Microsoft Fabric Lakehouse, including managed versus external tables and safe OneLake file cleanup.
Automate Databricks Infrastructure as Code with Terraform
This article describes how to Implement Infrastructure as Code Databricks with Terraform.
CS2001 Missing AssemblyAttributes.cs when executing SSIS package deployed to the server
How to resolve error : CS2001 Missing AssemblyAttributes.cs when executing SSIS package deployed to the server.
SSIS Error: “The Specified Provider Is Not Supported” — Fix
If you encounter an error in SQL Server Data Tools (SSDT) for Visual Studio while working with SQL Server Integration Services (SSIS), it could be due to the missing OLE DB or ADO.NET provider on your machine. This missing component prevents SSIS from establishing a connection, leading to the following error message:
Deploy DACPAC to Azure SQL Database
This guide will walk you through the process of deploy DACPAC to Azure SQL database directly from Visual Studio.
SQL Server 2025: What’s New, Features, and Changes
Explore SQL Server 2025 features and changes, including native vectors, AI, JSON, regular expressions, performance, Fabric integration, edition changes, and discontinued features.