The simplest way to find the how many number of times the specific string repeated in paragraph.

This blog explains how to split a string using recursive CTE in SQL.

In this tutorial, we learn about how to create a database connection string for MS-SQL Server with simple steps.

This shows a faster alternative to get the same information as sp_helpdb

In this blog, you will learn how to build a SSRS (RDL) report with a bar graph and a pie chart from Microsoft Report Builder.

In this blog, you will learn about Brief Introduction to SQL Server Reporting Services.

This article describes how to build a SSRS(RDL) report from Microsoft Report Builder.

Here we try to understand the Difference between Union and Union All in Sql Server.

In this article, you will learn how to configure the setup for SQL Server Reporting Services.

n this article, we will understand Union, Intersect, and Except clause in SQL Server. Also, we will see the difference between Intersect and Union in SQL Server. Also, the difference between Join w...

This post will give a high-level overview of this setting.

In this blog, you will learn how to resolve the error “Could not find server 'server name' in sys.servers” in SQL Server.

This is a blog on my thoughts on TSQL formatting. There are quite a few suggestions that are out there. These are just the rules I have been following for a number of years and they have worked for...

In this article Sagar Jaybhay explains how to write Subqueries and Correlated Subqueries in SQL Server and what to choose for performance -- Subquery or Join?

This post will cover the differences between Max Degree of Parallelism and Cost Threshold for Parallelism. These are two server settings that have a less the ideal default value. All DBAs should ...

This post will go over how you can use the DEADLOCK_PRIORITY to prioritize your processes so that the most important ones aren't chosen as victims of a deadlock.

In this blog, I will explain to you how to apply a script or a query to multiple databases in a single execution using a database name.

This post will go very a few of the methods that can be used to capture failed logins to your SQL Servers.

This post will focus on how to find what logins are mapped to database user accounts in a SQL Server database.

This blog explains the Select statement in SQL.