Azure Archives - {coding}Sight https://codingsight.com/category/cloud/azure/ Blog for SQL Server DBAs and Developers Wed, 13 Mar 2024 12:10:30 +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/category/cloud/azure/ 32 32 Identifying Cost-Saving Opportunities in Azure DevOps https://codingsight.com/identifying-cost-saving-opportunities-in-azure-devops/ Wed, 13 Sep 2023 16:23:53 +0000 https://codingsight.com/?p=25526 This article explores various methods that can be used to reduce costs while using Azure DevOps. When you deploy an application on the cloud, resource utilization and monitoring become key factors. The performance of a database or an application relies on how the application is configured and hosted, and the cost of maintaining and running …

The post Identifying Cost-Saving Opportunities in Azure DevOps appeared first on {coding}Sight.

]]> How to Build a Simple Data Warehouse in Azure Part 3 https://codingsight.com/how-to-build-a-simple-data-warehouse-in-azure-part-3/ Thu, 03 Nov 2022 08:54:00 +0000 http://codingsight.com/?p=20013 This is the final 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 refer to Part 1 and Part 2 to get more information. This part is mainly focused on the overall functionality of …

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

]]> 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.

]]> How to Build a Simple Data Warehouse in Azure – Part 1 https://codingsight.com/how-to-build-a-simple-data-warehouse-in-azure-part-1/ Thu, 15 Sep 2022 03:23:00 +0000 http://codingsight.com/?p=16640 The current article is the first part of the series about designing a simple data warehouse business intelligence solution in Azure from scratch. Here we are going to get the basic knowledge and prerequisites along with the initial setup of the data warehouse.   Table of contents What Is Azure Data Warehouse? Data warehousing is …

The post How to Build a Simple Data Warehouse in Azure – Part 1 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.

]]> Restoring SQL Server Data Warehouse Sample Database AdventureWorksDW2019 Using Azure Data Studio https://codingsight.com/restoring-sql-server-data-warehouse-sample-database-adventureworks-dw2019-using-azure-data-studio/ Tue, 19 Oct 2021 08:01:28 +0000 http://codingsight.com/?p=19204 I explained a step-by-step process to restore the data warehouse sample database AdventureWorks DW in my last article. AdventureWorks DW database was restored using GUI and T-SQL in SQL Server Management Studio. I would suggest you read that article to understand the complete process to install a sample database using SQL Server Management Studio. The …

The post Restoring SQL Server Data Warehouse Sample Database AdventureWorksDW2019 Using Azure Data Studio appeared first on {coding}Sight.

]]> Azure SQL Elastic Pool – Understanding and Creating https://codingsight.com/azure-sql-elastic-pool-understanding-and-creating/ Fri, 03 Sep 2021 06:17:48 +0000 http://codingsight.com/?p=16726 Microsoft Azure offers many PAAS services for addressing the database requirements based on the nature of data and transaction workload. Azure SQL Database is one of the popular PAAS services for RDBMS, always based on the latest stable version of the SQL Server database engine release. Databases from this service are highly available, fully managed, …

The post Azure SQL Elastic Pool – Understanding and Creating appeared first on {coding}Sight.

]]> How to Connect to Azure SQL Database Securely https://codingsight.com/how-to-connect-to-azure-sql-database-securely/ Tue, 11 May 2021 11:15:25 +0000 http://codingsight.com/?p=13476 As a database administrator, I started my journey in deploying managed SQL databases on the cloud, and I highly recommend deploying Azure SQL. Azure SQL belongs to the family of managed resources on the Azure cloud platform that runs the very familiar SQL Server engine. For most of these database resources, the Microsoft Azure platform …

The post How to Connect to Azure SQL Database Securely 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.

]]>