Migrating SQL Server Database to Azure SQL (PaaS)
In this article, we will highlight SQL Server Data migration to Azure SQL (PaaS). You can...
Configuring Heterogeneous Database Replication – SQL Server to Oracle
Introduction SQL Server Replication is an SQL Server feature that allows us to transfer data from one instance to another for such purposes...
Logon Triggers in SQL Server
A logon trigger, as the name suggests, is a trigger that fires in response to a LOGON event in SQL Server. In simple terms, a logon trigger...
How to Copy SQL Server Databases from One Instance to Another
Copying or moving databases is one of the most common tasks for data professionals who regularly...
Planning of Disk Space for Databases
Do you think about something when you create a new database? I guess that most of you would say no, since we all use default parameters,...
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...
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...
