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 »
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 »
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 »
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 »
In this article, we will learn how to perform Process Mining with Power BI.Read more »
This article will mention five helpful Azure Data Studio extensions that may help to improve the SQL developers’ productivity.Read more »
This article will explore the importance of disk caching in Azure storage for SQL Server workloads.Read more »
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 »
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 »
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 »
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 »
This article talks about a golden rule called PRIDESTES DEPLOY to sort out any SQL BI (business intelligence) related issue and it is particularly useful for resolving database, data warehouse or even reporting related issues where the database is built through modern tools like Azure Data Studio.Read more »
In this article, we will learn various methods of how to get an SQL execution plan of a query.Read more »
In this article, we will use Power BI Desktop to analyze key influencers in a dataset and learn how to use the corresponding visualization as well.Read more »
In this article, we will learn how to use smart narratives in Power BI to generate textual narratives that summarize the key highlights of the data presented in the report.Read more »
In this article, we are going to learn about the OPENQUERY function. It is used to run an ad-hoc distributed query on the remote data source using the linked server. There are various ways to query the remote data source. You can read this article, Querying remote data sources in SQL Server, to learn more about querying the remote data source. It is also used to execute pass-through queries to run INSERT, UPDATE and DELETE statements on the tables of the database configured in the linked server.Read more »
This article explains the xp_cmdshell and sp_xp_cmdshell_proxy_account system stored procedures in SQL Server and how developers can use them to execute Windows commands.Read more »
In this article, we are going to learn how we can install PostgreSQL on CentOS. Just like Ubuntu and Redgate, CentOS is a Linux distribution and is used by many organizations. I have written an article, How to install PostgreSQL on Windows that covers the step-by-step installation process of the PostgreSQL on windows 10.Read more »
The purpose of this article is to provide insights into how parameter sniffing occurs for an ad-hoc query and how it affects their performance.Read more »
We 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?
In this article, we will explore some internal working principles of SQL Server statistics.Read more »
The goal of this article is to throw light on the less-known points about SQL Server statistics.Read more »
This article will talk about the SQL WHERE statement.Read more »
This article will show Partitions in SQL Server and how they work.Read more »
In this article, we are going to learn how we can manage the FILSTREAM filegroup of SQL Database. I am going to cover the following topics.Read more »