Category: Database

How to parse JSON in SQL Server

In this article, we will learn how to parse and query JSON in SQL Server with the help of the OPENJSON function. Firstly, we will briefly look at the data structure of the JSON and then we will learn details of the parsing and querying JSON data using the OPENJSON function. What is JSON? JSON …


SQL SERVER – What is Latch?

Earlier I wrote about SQL SERVER – SQLOS Scheduler and the Process States, lots of people liked the blog post and asked me another question – What is Latch? You can find lots of information about the latch online. Even I have previously written about this subject. Today, I am going to do my best …


Manticore search: a continuation of the Sphinx search engine

In this article, we will be talking about Manticore Search, which is an open-source search engine first released in 2017 as a fork of the Sphinx search engine. We will try to describe this search engine briefly, mention some of its differences from the Sphinx search engine, and we will provide a step-by-step guide on …


SQL SERVER – SQLOS Scheduler and the Process States

Today’s subject is a very interesting subject and I got lots of people asking me about this after watching my Sleeping vs Suspended Process – SQL in Sixty Seconds #122. If you have not watched my previous SQL in the Sixty Seconds video on this topic, I strongly suggest that you first watch it before …


Where are SQL Jobs Stored? – Interview Question of the Week #293

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours. Once you learn my business secrets, you will fix the majority of problems in the …


Deploy MSDTC for distributed transactions in SQL Server Always On Availability Groups

In this 19th article for SQL Server Always On Availability Groups, we configure MSDTC for distributed transactions in an availability group. Introduction In the article, Explore Cross-database MSDTC for distributed transactions in SQL Server Always On Availability Groups, we understood the following concepts: What is Microsoft distributed transaction coordinator and purpose of it in distributed …


Exploring AG dashboards for monitoring SQL Server Always On Availability Groups

In this 21st article on SQL Server Always On Availability Group series, we will explore the AG dashboard and its various options for monitoring purposes. Introduction Monitoring is an essential and critical aspect of database professionals. You can identify potential issues, rectify them proactively. As you configure SQL Server Always On Availability Group for the …


CONCAT and NULL – SQL in Sixty Seconds #123

Just another day, I posted a blog post over here SQL SERVER – NULL Values and CONCAT Function. Lots of people read the blog post and I got quite a few emails on this blog post as well as some interesting conversation on twitter. Based on the suggestions, I have decided to convert the blog …


Exporting SSRS reports to multiple worksheets in Excel

Introduction SQL Server Reporting Services (SSRS) has multiple options of exporting data into a variety of formats and we will be discussing the options of exporting SSRS Reports to multiple sheets of excel. In SSRS, there are multiple formats available to export reports depending on the user’s needs. Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Tiff …


SQL SERVER – NULL Values and CONCAT Function

I have been posting a lot of SQL in the Sixty Seconds video recently, however, today, we will be looking at a very interesting T-SQL CONCAT function and how it works with the NULL Values. One of my clients who has worked with me previously Comprehensive Database Performance Health Check, recently sent me an email …