Configuring Azure SQL Long-term Backup Retention
Backup is the most important case for database administration because it provides business...
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 ways of creating constraints on a...
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...
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 several transactions. The image describes...
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...
Azure SQL Geo-Replication and Failover Groups
Azure SQL offers different types of business continuity solutions. One of these solutions is Geo-Replication that provides an asynchronous...
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...
