Happy New Year 2026

 


Comments

Post a Comment

Popular posts from this blog

What is Azure DevOps and how to configure your first project using Azure DevOps services

Image
Azure DevOps is integrated and independent tools supporting your DevOps practices with any language, any platform and any cloud. Azure DevOps is the platform for developers, testers and integrators. Come up with two major flavors - DevOps Service , and DevOps Server . Main services are Boards , Repos , Pipeline , Test Plans , and Artifacts . Below are details about Services and Server. Let us compare Services and Server options here. Azure DevOps Services Provided as a cloud service Microsoft hosted and managed New capabilities and fixes released every three weeks Simplified server management A transition from capital expenditures (servers and the like) to operational expenditures (subscriptions) Connect over the public internet (for example, https://contoso.visualstudio.com) authenticate with Microsoft account credentials or with Azure AD credentials Azure DevOps Server Installed in your datacenter or your cloud Managed, patched and controlled by you Provides...
Read more

How to bring on-premise SQL Server data into Azure Fabric Lakehouse

Image
On-premise data gateway - one of the important feature/service Azure Fabric platform is using to bring your on-premise data into Azure cloud. The data movement is secure and encrypted. You can review my my earlier post  https://splaha.blogspot.com/2025/03/use-on-premise-gateway-in-fabric-and.html   where I explain how to configure On-premise data gateway using Step 1 and Step 2. In this exaple, I'm going to use the same data conenction to pull my on-premise SQL tables using custom join SQL into Lakehouse. The entire post is self explanatory with step-by-step snapshot. I hope this will help you to understand each and individual steps as well as to execute the same at your end. Let's start with my on-premise SQL server details. As you can see the below picture, it talks about the database Employee where there are two tables EMP and DEPT. I'm going to use the same SQL into Fabric to pull the data. I assume you already created the on-premise data gateway using my earlier post...
Read more

Use On-Premise-Gateway In Fabric and copy data from On-prem to Azure Fabric

Image
On-Premise data gateway is an application which is required to be installed in your laptop/computer/server which connect to cloud and uses cloud services to send data back-and-forth from on-prem to cloud. This is secure data connection and data encryption is in place. Here is more about on-premise data gateway - https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem?toc=%2Ffabric%2Fdata-factory%2Ftoc.json https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem?toc=%2Ffabric%2Fdata-factory%2Ftoc.json Architecture of it - https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem-indepth?toc=%2Ffabric%2Fdata-factory%2Ftoc.json https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem-indepth?toc=%2Ffabric%2Fdata-factory%2Ftoc.json Step 1 First thing first - You need to install on-premise data gateway in your lcoal. Second thing is to open the on-premise data gateway and ensure th...
Read more