azure Archives - {coding}Sight https://codingsight.com/tag/azure/ Blog for SQL Server DBAs and Developers Tue, 27 Jun 2023 04:24:22 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png azure Archives - {coding}Sight https://codingsight.com/tag/azure/ 32 32 How to Build a Simple Data Warehouse in Azure – Part 2 https://codingsight.com/how-to-build-a-simple-data-warehouse-in-azure-part-2/ Sun, 25 Sep 2022 17:32:00 +0000 http://codingsight.com/?p=19389 This is the second part of the three-part article which aims to help both beginners and professionals in designing a simple but fully functional data warehouse business intelligence solution in Azure from scratch. Please get acquainted with the first part before reading this one. This part is mainly focused on adding database objects such as …

The post How to Build a Simple Data Warehouse in Azure – Part 2 appeared first on {coding}Sight.

]]> Deploying Azure Synapse Analytics workspaces – How it works https://codingsight.com/deploying-azure-synapse-analytics-workspaces/ Tue, 15 Feb 2022 12:14:07 +0000 http://codingsight.com/?p=18487 In the article, An Overview of the Azure Synapse Analytics, we explored the Azure Synapse workspace and its features as an analytics service combining Big data analytics and enterprise data warehousing. This article is a practical demonstration of deploying Azure Synapse Analytics workspace using the Azure portal. Table of contents How to Deploy Synapse Analytics …

The post Deploying Azure Synapse Analytics workspaces – How it works appeared first on {coding}Sight.

]]> What is Azure Synapse Analytics? Complete Overview https://codingsight.com/an-overview-of-the-azure-synapse-analytics/ Tue, 15 Feb 2022 10:11:12 +0000 http://codingsight.com/?p=16923 This post provides an overview of the Azure Synapse Analytics. It explains what it is and how it can be used. Table of contents What is Azure Synapse Analytics? When to use Azure Synapse Analytics? Main features of Azure Synapse Analytics Unified Analytics Platform Enterprise Data Warehousing Code-Free Hybrid Data Integration Serverless and Dedicated Options …

The post What is Azure Synapse Analytics? Complete Overview appeared first on {coding}Sight.

]]> How to Create and Configure Microsoft Azure DevOps CI/CD Pipeline Agent https://codingsight.com/self-hosted-agent/ Wed, 21 Apr 2021 11:26:35 +0000 http://codingsight.com/?p=12939 What is CI / CD Pipeline in Azure DevOps? In the process of learning Azure DevOps, you’ll face numerous challenges, but the most sophisticated of them is setting up the CI Pipeline to work appropriately. The pivotal point is the Azure Pipelines Agent that establishes and monitors connection with the machine running the DevOps CI …

The post How to Create and Configure Microsoft Azure DevOps CI/CD Pipeline Agent appeared first on {coding}Sight.

]]> How to Create and Deploy Azure Database for MySQL Server using Azure Portal and Workbench https://codingsight.com/understanding-azure-database-deployment-on-mysql/ Wed, 17 Feb 2021 14:26:37 +0000 http://codingsight.com/?p=12050 This article describes the step-by-step deployment process of the Azure Database for MySQL Server. Open the Azure portal and log in using the appropriate credentials. Note: For demonstration purposes, I got a pay-as-you-go subscription to Microsoft Azure. For more information about the Azure MySQL pricing model and various Azure subscriptions, refer to Subscriptions, licenses, accounts, …

The post How to Create and Deploy Azure Database for MySQL Server using Azure Portal and Workbench appeared first on {coding}Sight.

]]> How to install SQL Server vNext and Azure data studio on Ubuntu 18.04 https://codingsight.com/how-to-install-sql-server-vnext-and-azure-data-studio-on-ubuntu-18-04/ Fri, 13 Dec 2019 01:04:21 +0000 https://codingsight.com/?p=8067 Azure data studio is a cross-platform database management tool. This tool is used to connect, configure, and administrate SQL Server instances installed locally or in the cloud. This tool can be installed on the following operating systems: Microsoft Windows Linux Redgate Debian Ubuntu macOS Initially, Microsoft introduced this tool as the “SQL Server operations studio.” …

The post How to install SQL Server vNext and Azure data studio on Ubuntu 18.04 appeared first on {coding}Sight.

]]> Applying SQL Transformations and Handling Missing Values in Azure ML https://codingsight.com/applying-sql-transformations-and-handling-missing-values-in-azure-ml/ Wed, 16 Oct 2019 21:45:03 +0000 https://codingsight.com/?p=7964 In this article, we will introduce SQL transformations in action. We will also see how to handle missing values in our dataset. Consider a scenario of a movie rating dataset containing records of different movies along with the average user ratings associated with each movie. The ratings are in numeric form ranging from 1 to …

The post Applying SQL Transformations and Handling Missing Values in Azure ML appeared first on {coding}Sight.

]]> Microsoft Graph or Azure Active Directory Graph API: Which is better? https://codingsight.com/microsoft-graph-or-azure-active-directory-graph-api-which-is-better/ Fri, 14 Jun 2019 01:30:54 +0000 https://codingsight.com/?p=7203 Are you a .NET developer who is stuck in great confusion when it comes to choosing Azure Active Directory or Microsoft Graph? We all have look at those multiple posts on which you can choose for better web development. In this article, we will be providing some guidance along with a bit of roadmap to …

The post Microsoft Graph or Azure Active Directory Graph API: Which is better? appeared first on {coding}Sight.

]]> How to Test Azure Web Application Performance through Microsoft Azure and Visual Studio https://codingsight.com/how-to-test-azure-web-application-performance-through-microsoft-azure-and-visual-studio/ Tue, 23 Oct 2018 14:39:32 +0000 https://codingsight.com/?p=5390 Before deploying your application into production, doing a performance load test is imperative for measuring future performance and ensure that your application is production-ready. Testing is essential for every application to make sure that any application works and performs according to the desired requirements. During the application testing process, we can attempt and find out …

The post How to Test Azure Web Application Performance through Microsoft Azure and Visual Studio appeared first on {coding}Sight.

]]> Azure Cosmos DB Analysis https://codingsight.com/azure-cosmos-db-analysis/ Wed, 13 Jun 2018 14:07:39 +0000 http://codingsight.com/?p=4395 Azure Cosmos DB is the first globally distributed, multi-model database service for building world-scale applications. Over the years, it has been providing momentum for Microsoft’s Internet-scale services, which are now available to all Azure developers. The service is designed to allow customers to flexibly and horizontally scale throughput and storage across any number of geographic …

The post Azure Cosmos DB Analysis appeared first on {coding}Sight.

]]>