How to combine the Id-ParentId and HierarchyId approaches to keep and fetch the data in hierarchical and alphabetical order.

This article explains how to take the script from database in SQL server in a different mode. Normally we take back up our entire database as “.bak, .mdf, .ldf” file but sometimes we need to alter,...

Create SSRS drill down report, add link enable/disable based on specific condition, adding download links in reports.

When there is any automatic failure we need another server that will monitor the principal server.

This article helps you in creating and using SQL Server and SQL database.

This article explains how to monitor our database when accessing from outside or any other applications in an easy way.

With the release of Microsoft SQL Server on Linux, it is a huge step towards gaining markets in Database Technologies giving competition to other RDBMS software. Microsoft SQL Server is not only on...

This article explains Wild Card Operators in SQL. Wildcard characters can be used in LIKE expressions; the percent sign (%) matches zero or more characters and underscore (_) a single character.

This article explains the Rank function. Ranking functions provide a very good feature of assigning numbering to the records in the result set in SQL. Row_Number is one of these functions available...

This article explains how to shrink database log daily using jobs in SQL server by step by step. We can shrink database logs automatically using jobs in SQL Server that we no need to run SQL Script...

In this article I described Role in SQL Server. Roles are a collection of permissions or access rights for providing permissions or privileges easily in a large database system with multiple users.

TO Get All File Details From Local File Into SQL Server.

Concept Of Change Data Capture (CDC) In SQL Server.

Concept Of Change Data Capture (CDC) In SQL Server.

Top Ten Things You Should Know About Optimizing SQL Server Performance.

Top 10 Things You Should Know About Optimizing SQL Server Performance.

Time and Date query code and analysis.

Transparent Data Encryption in SQL Server.

How to create a Solution and what its uses are.

Fix: Unable to open the physical file. Operating system error (Access is denied.). In this article, we'll learn the best practice of moving database to another physical location on the Server.