Difference Between Inline and Out-of-Line Constraints
Constraints on tables and columns allow you to enforce the data quality. In SQL, there are two...
Getting Started with Mssql-cli Command-Line Query Tool
A recent announcement on the release of several SQL Server tools has raised expectations across various groups. Product requirements...
SQL Server TempDB Monitoring by Using Dynamic Management Views (DMV)
What is TempDB in MS SQL Server? TempDB is a system database in Microsoft SQL Server used as a store of internal objects, row versions,...
How to Handle Errors in SQL Server Nested Transactions
In this article, we will explore SQL Server Nested Transactions, a transaction block with one or...
Read-only Routing for an Always On
As DBAs, we generally come across our clients complaining that the current Production Server is not able to hold the load on the server and...
Art of Isolating Dependencies and Data in Database Unit Testing
All the database developers more or less write database unit tests that not only help in detecting bugs early but also save a lot of time...
Azure SQL Geo-Replication and Failover Groups
Azure SQL offers different types of business continuity solutions. One of these solutions is...
Identifying and Fixing Forwarded Records Performance Issue
Before going through the Forwarded Records performance issue and resolving it, we need to review the structure of the SQL Server tables....
Unleash the Power of SQL Pivot and Unpivot: A Complete Guide to Data Transposing Techniques
Data manipulation is an essential skill for anyone working with SQL databases. It allows you to transform and analyze data, making it more...
Implementing Failover in MS SQL Server 2017 Standard
Introduction Often, we need to ensure fault tolerance of MS SQL Server DBMS, especially, when there...
