Nisarg Upadhyay
Data from Remote PostgreSQL server

Understanding the OPENQUERY function in SQL Server

June 24, 2022 by

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 »
Rajendra Gupta
View charts

Notebook Views for SQL Notebooks in Azure Data Studio

June 15, 2022 by

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?
Read more »
Esat Erkec
Implicit conversion warning in an execution plan

7 Common T-SQL Query mistakes

June 1, 2022 by

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 »
Frank Solomon
The solution result set.

Lever the TSQL MAX/MIN/IIF functions for Pinpoint Row Pivots

May 16, 2022 by

Introduction

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 »
Manvendra Singh
Manage Access Policies

Manage Azure Blob Storage using Azure Storage Explorer

May 13, 2022 by

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 »