Compare Azure SQL Database Schema Using sqlpackage
Learn how to compare two Azure SQL Database Schema effectively and generate delta scripts for seamless deployment.
Compare Azure SQL Database Schema Using sqlpackage Read More »
Azure
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 small chunks of code in response to events or schedules without managing servers. When connecting Azure Functions to Azure SQL Database, you need a secure way to authenticate without storing credentials. That’s where Managed Identity steps in. Managed Identity allows
Connect Python Azure Function to Azure SQL Using Managed Identity Read More »
SSMS 21 Copilot: Here’s How It Works
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.
SSMS 21 Copilot: Here’s How It Works Read More »
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 you need to access data across these databases. Fortunately, Azure SQL’s external tables feature allows for seamless cross-database querying without data duplication. This feature is also known as Elastic Query
Cross Database Query in Azure SQL Database Read More »
Azure Analysis Services Model Missing
In this article, we will see how to fix Azure Analysis Services model missing issue.
Azure Analysis Services Model Missing Read More »
Automate Databricks Infrastructure as Code with Terraform
This article describes how to Implement Infrastructure as Code Databricks with Terraform.
Automate Databricks Infrastructure as Code with Terraform Read More »
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.
Deploy DACPAC to Azure SQL Database Read More »
Create Python Azure function in Visual Studio Code
Azure Functions is a serverless computing service that enables developers to deploy small pieces of code without the need to manage the underlying infrastructure. It supports various programming languages, including .NET, Python, JavaScript, TypeScript, Java, PowerShell, and C#, providing flexibility and versatility for various applications. This article describes how to create Python Azure function in
Create Python Azure function in Visual Studio Code Read More »
Parse JSON in SQL Server
JSON (JavaScript Object Notation) is a lightweight data-interchange format that has become a standard for data exchange in web and database applications. With the rise of JSON’s popularity, SQL Server introduced built-in support for JSON starting with SQL Server 2016. In this article, we will explore how to parse JSON in SQL Server and extract
Parse JSON in SQL Server Read More »
Databricks VACUUM Command
Databricks is a unified big data processing and analytics cloud platform for transforming and processing vast volumes of data. Apache Spark is the building block of Databricks, an in-memory analytics engine for big data and machine learning. In this article, we will see how to use the Databricks VACUUM command to remove unused files from
Databricks VACUUM Command Read More »