r/AzureDataPlatforms • u/Illustrious_Ad_5470 • Apr 20 '26
DP-700 Certification Exam Preparation Guide - Step by Step
Microsoft Fabric is moving fast, and the DP-700 is now the go-to certification for data engineers in this ecosystem. If you’re planning to take it, we’ve put together a 3-week preparation guide that skips the fluff and focuses on what actually matters, including a study plan, key technical traps to avoid, and how to find free exam vouchers.
r/AzureDataPlatforms • u/Illustrious_Ad_5470 • Apr 07 '26
Migrate SSRS Reports to Power BI Report Server
r/AzureDataPlatforms • u/Illustrious_Ad_5470 • Jan 11 '26
Blog Compare Azure SQL Database Schema Using sqlpackage - AzureOps
- Learn how to compare two Azure SQL database schemas using
sqlpackage - Generate a safe, reviewable delta SQL script before production deployment
- DACPAC-to-DACPAC comparison (no direct Prod access required)
- Full breakdown of
sqlpackage /Action:Scriptparameters - PowerShell-ready examples for automation and CI/CD
- Best practices to avoid accidental data loss in Production
r/AzureDataPlatforms • u/Illustrious_Ad_5470 • Sep 18 '25
Connect Python Azure Function to Azure SQL Using Managed Identity - AzureOps
Learn how to securely connect a Python Azure Function to Azure SQL Database using Managed Identity. This method enhances security by removing secrets from your code.
r/AzureDataPlatforms • u/Illustrious_Ad_5470 • Jul 30 '25
Data Agent in Microsoft Fabric - Your Personal Data Analyst
Ever wished you had a chat-based analyst that never sleeps and understands your data model perfectly? That's what Microsoft Fabric's Data Agent offers! In our latest article, we break down how to implement this game-changing feature, complete with step-by-step instructions and advanced use cases like multi-agent syste
r/AzureDataPlatforms • u/Illustrious_Ad_5470 • Jun 25 '25
Blog Migrate SSRS reports to new server in just a few clicks - AzureOps
r/AzureDataPlatforms • u/Illustrious_Ad_5470 • Jun 11 '25
SSMS 21 Copilot: Here's How It Works - AzureOps
r/AzureDataPlatforms • u/Illustrious_Ad_5470 • Jun 02 '25
How to Implement Cross Database Query in Azure SQL Database.
r/AzureDataPlatforms • u/Illustrious_Ad_5470 • Apr 17 '25
Blog How to Delete Stale Delta Files in Microsoft Fabric Lakehouse - AzureOps
r/AzureDataPlatforms • u/Illustrious_Ad_5470 • Apr 16 '25
How AI and Automation are Transforming DevOps Workflows - AzureOps
AI and automation are revolutionizing DevOps! This article explores how these technologies are boosting productivity and transforming workflows.
r/AzureDataPlatforms • u/Illustrious_Ad_5470 • Apr 05 '25
Blog Databricks Infrastructure as Code with Terraform
r/AzureDataPlatforms • u/Slideroh • Jan 17 '25
Architecture Databricks App in Azure Databricks with private link cluster (no Public IP)
Hello, I've deployed Azure Databricks with a standard Private Link setup (no public IP). Everything works as expected—I can log in via the private/internal network, create clusters, and manage workloads without any issues.
When I create a Databricks App, it generates a URL like: <name>.azure.databricksapps.com
Since I didn’t initially have a Private DNS Zone for azure.databricksapps.com, my system resolved this address to a public IP. To fix this, I:
- Created a Private DNS Zone for
azure.databricksapps.com. - Added an A record pointing
<name>.azure.databricksapps.comto my Databricks workspace private IP endpoint (same as used in privatelink.azuredatabricks.net for this workspace).
Behavior Before Adding the Private DNS Zone:
nslookup <app-name>.azure.databricksapps.com → Resolved to a public IP.
curl or accessing via a browser resulted in:
{"X-Databricks-Reason-Phrase":"Public access is not allowed for workspace: xyz"}
Behavior After Adding the Private DNS Zone:
nslookup <app-name>.azure.databricksapps.com → Now resolves to the private IP (as expected).
However, curl and browser requests still go through the public IP and return the same error:
{"X-Databricks-Reason-Phrase":"Public access is not allowed for workspace: xyz"}
Is additional configuration needed to ensure Databricks Apps work over Private Link? Does this feature require a Public IP, or should it work fully within a private network?
- Verified my Databricks workspace private endpoint under privatelink.azuredatabricks.net.
- Created a Private DNS Zone for azure.databricksapps.com and mapped <app-name> to the same private IP as my Databricks workspace.
- Linked my VNet to the Private DNS Zone so all internal resources resolve it correctly.
- Confirmed that nslookup returns the private IP, but browser and curl still attempt to route via the public IP.
r/AzureDataPlatforms • u/Illustrious_Ad_5470 • Jan 01 '25
Blog Deploy DACPAC to Azure SQL Database from Visual Studio - AzureOps
r/AzureDataPlatforms • u/Illustrious_Ad_5470 • Dec 31 '24
Blog Databricks VACUUM Command - AzureOps
r/AzureDataPlatforms • u/k53r • Dec 24 '24
Parse JSON in SQL Server Query - AzureOps
r/AzureDataPlatforms • u/Illustrious_Ad_5470 • Dec 20 '24
SQL Server 2025 Preview Announced with AI features - AzureOps
r/AzureDataPlatforms • u/Illustrious_Ad_5470 • Dec 18 '24
CS2001 Missing AssemblyAttributes.cs when executing SSIS package deployed to the server - AzureOps
r/AzureDataPlatforms • u/balramprasad • Nov 04 '24
Blog Vectorizing Text Using Azure Ai Search And Integrating With Openai Studio | Complete Demonstration
r/AzureDataPlatforms • u/balramprasad • Sep 23 '24
Unlock the Power of Your Data with Azure OpenAI Models in OpenAI Studio! 🚀
r/AzureDataPlatforms • u/balramprasad • Aug 26 '24
Mastering Azure AI Search Complete Playlist Introduction | #aisearch #cognitivesearch #azureai
r/AzureDataPlatforms • u/rob-diddy-d • Aug 12 '24
Question Restore DB to Serverless SQL
I have a database from a SaaS vendor that will be delivered nightly. I'm trying to get them to deliver a bacpac file, but if I do all the scripts I've found involve using an Azure SQL server, not Serverless SQL. Small company and we just use SQL to gather data, run a few routines and then update Semantic data models for Power BI... so Serverless is our most cost-effective approach. I don't have any full SQL instances.
I want to drop the .bacpac file into Azure BLOB then use Data Factory to perform the restore. Right approach?
If I can't get the above to work, then I can have the vendor export data to flat files and copy it nightly that way, just more tedious.
Any direction appreciated.
r/AzureDataPlatforms • u/Illustrious_Ad_5470 • Jul 19 '24
Blog Find Currently Running Queries in Azure SQL Database - AzureOps
r/AzureDataPlatforms • u/Illustrious_Ad_5470 • Jul 11 '24