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 »
SQL (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 »
This article will cover testing or verification aspects of Type 2 Slowly Changing Dimensions in a Data Warehouse.Read more »
In this article, we will learn how to connect the pSQL tool with Azure Database for PostgreSQL.Read more »
This 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 »
In this article, we will talk about what SQL Server developers do and which main skills are required to get a job as a SQL developer.Read more »
This article intends to give some beneficial suggestions that help to write a more readable T-SQL query.Read more »
For a recent Tsql development project involving text document records, the customer wanted a product that would show the latest and most recent earlier version of specific document text stored in a SQL Server 2014 database. One result set row had to hold all relevant information for each document: both document versions as described above, and relevant metadata. This essentially required fine-grained row pivots. This article will describe the engineering behind the solution, and compare that solution with the SQL Server PIVOT operator.Read more »
I 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 »
The SQL MIN function is an aggregate function that is used to find the minimum values in columns or rows in a table.Read more »
In this article, we will learn how to use Python to source data in Power BI using the python programming language.Read more »
In 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 »