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 »
Manvendra Singh
Azure Storage Account

Understanding Azure BLOB storage and its uses in SQL Server

April 26, 2022 by

This article will describe Azure blob storage, its features along with its uses in SQL Server. I have explored the basics of Azure storage in my last article, “Getting started with Azure Storage”, I would recommend you read this article to learn various storage options available in Microsoft Azure. The blob storage is one of the storage options offered under Azure storage discussed in this article.

Read more »
Manvendra Singh
Validate when access tier was changed for a blob

Change Access Tiers of a blob and Azure storage account

April 20, 2022 by

This article will explain the Access Tier property of Azure storage. I will also explain how to change access tiers of an Azure storage account and for a specific blob object in this article. We have explored the basics of Azure storage in my last articles below which I would suggest you read to understand Azure blob storage.

Read more »
Manvendra Singh
Overview page of storage account after upgrade

Upgrade an Azure blob storage account type from BlobStorage or GPv1 to GPv2

April 15, 2022 by

This article will explain the steps of upgrading the Azure blob storage account type from legacy storage account type BlobStorage or GPv1 to GPv2. Microsoft Azure keeps on adding and upgrading their services. They also persuade customers to upgrade their services which were initially provisioned on older or legacy versions. This article will discuss steps about upgrading the Azure blob storage account that is running on standard performance tier GPv1 or BlobStorage to its latest version standard performance tier GPv2.

Read more »
Manvendra Singh
Launch storage explorer

Getting started with Azure storage explorer

April 8, 2022 by

This article will explain Azure storage explorer, its installations, and details of how to start working with this application to access Azure storage services. Azure storage provides a flexible solution to store various types of data at a massive scale in the cloud environment. If you have many storage accounts in Azure storage, then it will be difficult to manage them. Microsoft has recognized this problem and developed a desktop application Azure storage explorer to manage Azure storage accounts easily. It can be installed on Windows, Linux, and macOS operating systems.

Read more »
Manvendra Singh
Storage account created

Getting started with Azure Storage

April 1, 2022 by

This article will help you understand the Azure storage options available in the Microsoft Azure cloud. Microsoft Azure provides various services to store data depending on their type, nature, shape, and size. Data could be anything like an image, a video, a text file, a database file to store customer’s data, or data that comes from a digital medium like online retail websites or YouTube, etc. There are various types of data available, and one storage solution cannot fit all distinct types of data storage requirements.

Read more »