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 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 »How to perform Process Mining using Power BI
July 20, 2022In this article, we will learn how to perform Process Mining with Power BI.
Read more »Five beneficial Azure Data Studio Extensions for SQL developers
July 19, 2022This 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 workloads
July 15, 2022This 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 BI
July 14, 2022In 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 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 »How to build custom widgets on Azure Data Studio
July 7, 2022In 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 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 »Problem solving database or data warehouse production issues with PRIDESTES DEPLOY Principle
July 5, 2022This 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 »How to obtain SQL Execution Plans using different methods
June 30, 2022In this article, we will learn various methods of how to get an SQL execution plan of a query.
Read more »Analyzing key influencers in data with Power BI
June 29, 2022In 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 »Generating smart narratives in Power BI
June 28, 2022In 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 »Understanding the OPENQUERY function in SQL Server
June 24, 2022In 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 »xp_cmdshell and sp_xp_cmdshell_proxy_account stored procedures in SQL Server
June 22, 2022This 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 »Learn PostgreSQL: Install PostgreSQL on CentOS Linux
June 21, 2022In 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 »How to overcome parameter sniffing problems in ad-hoc queries
June 17, 2022The 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 »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?
Unrevealed tips of SQL Server Statistics
June 13, 2022In this article, we will explore some internal working principles of SQL Server statistics.
Read more »SQL Server statistics from a different perspective
June 10, 2022The goal of this article is to throw light on the less-known points about SQL Server statistics.
Read more »Exploring the SQL WHERE statement
June 9, 2022This article will talk about the SQL WHERE statement.
Read more »Partitions in SQL Server
June 8, 2022This article will show Partitions in SQL Server and how they work.
Read more »Manage FILESTREAM filegroups of SQL Databases
June 3, 2022In 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 »7 Common T-SQL Query mistakes
June 1, 2022SQL (Structured Query Language) is an ANSI/ISO standard programming language that is designed to program relational databases and T-SQL (Transact-SQL) is an extended implementation of the SQL for Microsoft SQL Server databases. T-SQL is highly used by database persons when they want to program or manage the SQL Server databases. However, the beginners may do some mistakes without realizing when they write queries with SQL. In the next section of this article, we will glance at the common mistakes that may be made by newbies.
Read more »Testing Type 2 Slowly Changing Dimensions in a Data Warehouse
May 30, 2022This article will cover testing or verification aspects of Type 2 Slowly Changing Dimensions in a Data Warehouse.
Read more »