This article explains Azure SQL Database Geo Restore using geo-replicated backups for disaster recovery.Read more »
Deploy a SQL Server container using Azure Kubernetes Services (AKS)August 31, 2022
This article deploys a SQL Server container using Azure Kubernetes Services (AKS).Read more »
Template Gallery in Azure Synapse Lake DatabaseAugust 29, 2022
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 »
Configuring tables and relationships in Azure Synapse Lake DatabaseAugust 26, 2022
In this article, we will learn how to configure properties and relationships in Azure Synapse Lake Database.Read more »
Manage SQL Databases in CentOS: Install SQL Server on CentOSAugust 24, 2022
In this article, we will understand how we can manage a SQL Database in CentOS 8.0. This article is the first article on the topic Manage SQL Server on CentOS.Read more »
Deploy Azure SQL Elastic Pools for Azure SQL DatabaseAugust 23, 2022
This article gives an overview and deployment steps for SQL Elastic Pool for Azure SQL database.Read more »
Getting started with Azure Synapse Lake Database and Lake tablesAugust 19, 2022
This article will get you started with Azure Synapse Lake Database and Lake tables.Read more »
Managing memory-optimized file groups of SQL DatabaseAugust 17, 2022
This article explains how to manage a memory-optimized filegroup of SQL Database. The memory-optimized filegroup contains the memory-optimized tables and table variables. I have written two articles that explain how we can migrate the disk-based tables to memory-optimized tables. Now, we will learn how to add memory-optimized filegroups in a SQL database. I will cover the following topics in the article.Read more »
Rebuild system databases for SQL Server on Linux and WindowsAugust 15, 2022
This article explores the process for rebuilding system databases – Master, MSDB, and Model for SQL Server on Linux and Windows.Read more »
Getting started with PostgreSQL on DockerAugust 12, 2022
In this article, we will learn how to get started using PostgreSQL on Docker. PostgreSQL is one of the most popular open-source databases that is being used by a lot of developers. It is highly stable and has a large community that maintains and supports the database development lifecycle. PostgreSQL can be installed on any operating system like Windows, macOS, and Linux. With the rise in containerization technologies, PostgreSQL can now also be installed using Docker.Read more »
Configure cross-platform SQL Server Always On Availability GroupsAugust 10, 2022
This article for the Always On Availability Groups series will show how to configure SQL Server Always On Availability Groups between Windows and Linux SQL instances.Read more »
Managing file groups of SQL DatabasesAugust 8, 2022
IN this article, we are going to learn how we can manage the filegroup of SQL Database in SQL Server. The SQL Server has four filegroups.Read more »
SSMS 2016 – A FAQ manualAugust 5, 2022
In this article, we will answer the most common questions related to SSMS 2016 like these ones:
- What is SSMS 2016?
- How to install SSMS 2016?
- What SSMS versions exist?
- Is SSMS 2016 compatible with any SQL Server version?
- What changes were made in SSMS 2016?
- How to uninstall SSMS 2016?
SQL Server Data Tools for Visual Studio 2015August 3, 2022
The SQL Server Data Tools for Visual Studio 2015 are tools used for different purposes like:
- Working in relational database projects.
- Creating multidimensional or tabular databases in Analysis Services.
- Using Integration Service projects to import and export data.
- Building Reports in reporting services.
SQLPackage utility to export Azure SQL DatabasesAugust 1, 2022
Azure SQL Database does not support native database backups. Therefore, you cannot use it to move from the Azure cloud to on-premises SQL Server. You can use the data-tier application BACPAC file format for exporting database schema and data from the Azure database. This BACPAC file is helpful to deploy on an Azure SQL Database, Managed Instance, and on-premises SQL Server.Read more »
Managing Cosmos DB using Azure storage explorerJuly 29, 2022
This 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 »
Import data using R in Power BIJuly 27, 2022
In this article, we will learn how to configure Power BI to work with R and source the required datasets from it for reporting in Power BI Reports.Read more »
Enable Azure Storage diagnostics – Storage Metrics and Storage loggingJuly 25, 2022
Azure 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 »
How to perform Process Mining using Power BIJuly 20, 2022
In this article, we will learn how to perform Process Mining with Power BI.Read more »
Five beneficial Azure Data Studio Extensions for SQL developersJuly 19, 2022
This article will mention five helpful Azure Data Studio extensions that may help to improve the SQL developers’ productivity.Read more »
Importance of Disk Caching in Azure storage disks for SQL Server workloadsJuly 15, 2022
This article will explore the importance of disk caching in Azure storage for SQL Server workloads.Read more »
Analyzing spatial data with Azure Maps in Power BIJuly 14, 2022
In this article, we will learn how to represent spatial data on Azure Maps visualization and explore the features to effectively format the data to make it intuitive for the end-user.Read more »
Azure SQL Interview Questions and AnswersJuly 13, 2022
Interested 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 »
How to build custom widgets on Azure Data StudioJuly 7, 2022
In this article, we will learn how to build a customized widget in Azure Data Studio that helps to monitor the performance metrics.Read more »
Choosing optimal Azure disk storage for SQL Server running on Azure VMsJuly 6, 2022
This 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 »