Cloud Archives - {coding}Sight https://codingsight.com/category/cloud/ 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 Cloud Archives - {coding}Sight https://codingsight.com/category/cloud/ 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.

]]> Configure SQL Server Failover Cluster on AWS using Amazon FSx for Windows File Server – Part 1 https://codingsight.com/configure-sql-server-failover-cluster-on-aws-using-amazon-fsx-for-windows-file-server-part-1/ Tue, 01 Nov 2022 09:04:30 +0000 http://codingsight.com/?p=20330 The current article series will focus on configuring the SQL Server Always-on failover cluster on AWS with the Amazon FSx Windows File Server. AWS offers Elastic Block Storage (EBS) volumes that can be attached to the Amazon Elastic Compute Cloud (EC2) instances. These volumes are local to the EC2 instance they were attached to. As …

The post Configure SQL Server Failover Cluster on AWS using Amazon FSx for Windows File Server – Part 1 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.

]]> What is AWS IAM: Tutorial Guide and Features Overview https://codingsight.com/deep-dive-into-aws-iam/ Tue, 20 Sep 2022 09:22:00 +0000 http://codingsight.com/?p=19073 In this article, we are going to explore the Identity and Access Management concepts available in Amazon Web Services. Abbreviated as IAM, it enables AWS admins and users to control how services are available to other users within the account. In cloud computing, setting up the correct access for users is very important in order …

The post What is AWS IAM: Tutorial Guide and Features Overview appeared first on {coding}Sight.

]]> How to Use AWS Secrets Manager: Tutorial & Examples https://codingsight.com/the-aws-secrets-manager/ https://codingsight.com/the-aws-secrets-manager/#comments Sun, 18 Sep 2022 10:59:00 +0000 http://codingsight.com/?p=16164 Keeping credentials and other sensitive data out of application code can be a challenge. AWS Secrets Manager is meant to help abstract these data points all wrapped in a single easy-to-use service. You pay a small amount per secret ($0.40) and an additional ($0.05) fee for every 1,000 requests to get those secrets. The entire …

The post How to Use AWS Secrets Manager: Tutorial & Examples appeared first on {coding}Sight.

]]> https://codingsight.com/the-aws-secrets-manager/feed/ 2 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.

]]> What is Amazon VPC: Tutorial Guide https://codingsight.com/the-essence-and-configuration-of-aws-virtual-private-cloud/ Fri, 09 Sep 2022 08:01:00 +0000 http://codingsight.com/?p=16872 Amazon Web Service environment is a fully digital experience of a typical brick-and-mortar data center. All components, such as firewalls or load balancers, are fully digitalized. Likewise, all of the services that AWS offers, such as Elastic Compute servers, databases, or Lambda functions live within that ecosystem. When running any type of service within Amazon …

The post What is Amazon VPC: Tutorial Guide appeared first on {coding}Sight.

]]> What is AWS Athena? https://codingsight.com/amazon-athena-overview/ Tue, 02 Aug 2022 11:58:00 +0000 http://codingsight.com/?p=15893 AWS Athena is a fully managed, popular cloud service provided by Amazon to query structured data in S3. It allows users to write custom SQL queries to retrieve data from CSV or other file formats in S3. This is helpful if you want to query your static data at rest. Being a pioneer in the …

The post What is AWS Athena? appeared first on {coding}Sight.

]]> Upload Files to AWS S3 with the AWS CLI https://codingsight.com/upload-files-to-aws-s3-with-the-aws-cli/ Wed, 20 Jul 2022 07:39:00 +0000 http://codingsight.com/?p=15565 Introduction Amazon Web Service, aka AWS, is a leading cloud infrastructure provider for storing your servers, applications, databases, networking, domain controllers, and active directories in a widespread cloud architecture. AWS provides a Simple Storage Service (S3) for storing your objects or data with (119’s) of data durability. AWS S3 is compliant with PCI-DSS, HIPAA/HITECH, FedRAMP, …

The post Upload Files to AWS S3 with the AWS CLI appeared first on {coding}Sight.

]]>