In this article, we will learn how we can create tables in the Azure Synapse Lake Database instance first and bind it with data later.
Read more »Azure
Configuring tables and relationships in Azure Synapse Lake Database
August 26, 2022In this article, we will learn how to configure properties and relationships in Azure Synapse Lake Database.
Read more »Getting started with Azure Synapse Lake Database and Lake tables
August 19, 2022This article will get you started with Azure Synapse Lake Database and Lake tables.
Read more »Managing Cosmos DB using Azure storage explorer
July 29, 2022This article will explain how to perform various activities for Azure cosmos DB using Azure storage explorer. The storage explorer is a very useful desktop utility that helps admins to manage Azure storage without accessing the Azure portal. We can also connect to Azure Cosmos DB accounts using this tool but this feature will be deprecated in the future. As of now, it is supported so I decided to explore it for cosmos DB activities.
Read more »Enable Azure Storage diagnostics – Storage Metrics and Storage logging
July 25, 2022Azure storage is a core cloud storage service that is used by almost all application or database deployments. We use it in SQL Server for various requirements like for backing up our databases directly to blob storage or some clients prefer to host their databases in Azure blob storage to leverage snapshot backups functionality. Today, I will explore how to monitor and troubleshoot blob storage issues in the Azure cloud by looking into storage metrics and storage logging features of Azure storage. We can configure or enable both configurations to view graphs and visualize their metrics like how storage is performing in the Azure cloud during each transaction. We will be discussing two storage diagnostics features Storage Metrics and Storage Logging which are extensively used to identify a storage problem in the Azure cloud.
Read more »Importance of Disk Caching in Azure storage disks for SQL Server workloads
July 15, 2022This article will explore the importance of disk caching in Azure storage for SQL Server workloads.
Read more »Azure SQL Interview Questions and Answers
July 13, 2022Interested in becoming an Azure SQL DBA but don’t know how to start? This article prepares you for the Azure SQL DBA interview by providing reference material links.
Read more »Choosing optimal Azure disk storage for SQL Server running on Azure VMs
July 6, 2022This article will explore various Azure disk storage available for SQL Server workload running on Azure virtual machines. Suppose you have been tasked to migrate your on-premises SQL Server workload to the Azure cloud. Your client does not want significant change in architecture so you have decided to migrate with IaaS (Infrastructure as a service) approach where SQL Server will be running on Azure virtual machines.
Read more »Notebook Views for SQL Notebooks in Azure Data Studio
June 15, 2022We are excited to share that Notebook Views are available for SQL Notebooks in the Azure Data Studio (Currently Insiders release). This article will cover the following topics:
- What are Notebook Views?
- Where can you find Notebook Views?
- How do you create a new view?
- How do you modify an existing view?
- Where can you see database objects in the view?
- Where can you see table data in the view?
- Where can you see query results in the view?
Using psql tool with Azure Database for PostgreSQL
May 27, 2022In this article, we will learn how to connect the pSQL tool with Azure Database for PostgreSQL.
Read more »Understanding and creating Azure Cosmos DB accounts
May 25, 2022This article will explore an overview of Azure Cosmos DB, we will also discuss how to create Cosmos DB along with its uses on why we need to choose Cosmos DB.
Read more »Introduction to Azure Synapse Lake Database in Azure Synapse Analytics
May 23, 2022
In this article, we will learn what is an Azure Lake Database conceptually, and the different components of this solution, followed by its practical implementation in upcoming articles.
Manage Azure Blob Storage using Azure Storage Explorer
May 13, 2022I will explore how to manage Azure blob storage using storage explorer. Azure blob storage is a storage solution to store various types of data at a massive scale in the cloud environment. If you have a large number of storage accounts in Azure storage, then it will be difficult to manage them. Microsoft has developed a desktop application to manage Azure storage accounts easily. This desktop application is known as Azure storage explorer which is used to manage Azure storage accounts. Read the attached article to learn how to download and install Azure storage explorer, “Getting started with Azure storage explorer”.
Read more »Reporting data from Azure Cosmos DB using Power BI
May 6, 2022In this article, we will learn how to report data from Azure Cosmos DB using Power BI which is one of the most popular reporting tools in the industry.
Read more »Understanding Azure BLOB storage and its uses in SQL Server
April 26, 2022This article will describe Azure blob storage, its features along with its uses in SQL Server. I have explored the basics of Azure storage in my last article, “Getting started with Azure Storage”, I would recommend you read this article to learn various storage options available in Microsoft Azure. The blob storage is one of the storage options offered under Azure storage discussed in this article.
Read more »Change Access Tiers of a blob and Azure storage account
April 20, 2022This article will explain the Access Tier property of Azure storage. I will also explain how to change access tiers of an Azure storage account and for a specific blob object in this article. We have explored the basics of Azure storage in my last articles below which I would suggest you read to understand Azure blob storage.
Read more »Upgrade an Azure blob storage account type from BlobStorage or GPv1 to GPv2
April 15, 2022This article will explain the steps of upgrading the Azure blob storage account type from legacy storage account type BlobStorage or GPv1 to GPv2. Microsoft Azure keeps on adding and upgrading their services. They also persuade customers to upgrade their services which were initially provisioned on older or legacy versions. This article will discuss steps about upgrading the Azure blob storage account that is running on standard performance tier GPv1 or BlobStorage to its latest version standard performance tier GPv2.
Read more »Database level roles in Azure SQL Database
April 12, 2022This article explores the database-level roles in the Azure SQL Database.
Read more »Getting started with Azure storage explorer
April 8, 2022This article will explain Azure storage explorer, its installations, and details of how to start working with this application to access Azure storage services. Azure storage provides a flexible solution to store various types of data at a massive scale in the cloud environment. If you have many storage accounts in Azure storage, then it will be difficult to manage them. Microsoft has recognized this problem and developed a desktop application Azure storage explorer to manage Azure storage accounts easily. It can be installed on Windows, Linux, and macOS operating systems.
Read more »Fixed Server Roles in Azure SQL Database Server
April 6, 2022This article is for discussing fixed server roles in Azure SQL Database Server.
Read more »Getting started with Azure Storage
April 1, 2022This article will help you understand the Azure storage options available in the Microsoft Azure cloud. Microsoft Azure provides various services to store data depending on their type, nature, shape, and size. Data could be anything like an image, a video, a text file, a database file to store customer’s data, or data that comes from a digital medium like online retail websites or YouTube, etc. There are various types of data available, and one storage solution cannot fit all distinct types of data storage requirements.
Read more »SQL Server Dedicated Administrator Connections for Azure SQL Database
March 29, 2022This article explains SQL Server Dedicated Administrator Connections and how you can use it for Azure SQL Database.
Read more »Azure SQL Database Connectivity architecture
March 24, 2022The article Configure IP firewall rules for Azure SQL Databases, discuss the configuring server and database IP firewall rules for Azure databases. In this article, we will explore setting applicable to Azure databases that control connectivity to the database.
Read more »Configure IP firewall rules for Azure SQL Databases
March 18, 2022The Azure SQL Database provides high performance, secure and reliable managed relational database service. Security is the prime focus area in both on-premises and cloud infrastructure while designing the database infrastructure.
Read more »Azure Functions for Azure SQL Database
March 10, 2022As a Platform as a Service (PaaS) service, Azure SQL Database enables developers to deploy SQL Database in Azure Cloud without managing the infrastructure. We use SQL Server Agent to schedule jobs to run at a specific schedule in an on-prem SQL instance. However, Azure DB does not have agent functionality.
Read more »