Consolidating SQL Server Instance by Clustering and Stacking
NOTES: Windows Failover Clustering comprising two nodes. Two SQL Server Failover Cluster Instances....
Understanding Data Sharing in SQL Server Docker Containers
In the previous articles, “Introduction to Docker and Docker Toolbox” and “Docker and SQL Server on Linux“, we...
Understanding GROUPING and GROUPING_ID Functions in SQL Server
The ROLLUP and CUBE operators are used to return results aggregated by the columns in the GROUP BY clause. The GROUPING and GROUPING_ID...
Different Ways to Compare SQL Server Tables Schema and Data
SQL Server provides us with different solutions to replicate or archive a database table or tables...
Registered Server, a Hidden Gem of SQL Server Management Studio
Managing numerous database servers in an organization can be performed using the PowerShell scripts but it requires some complex PowerShell...
SQL Server Management Studio (SSMS) Registered Server
Managing numerous database servers in an organization is difficult. Either we must maintain a list or maintain an Excel file that has a...
Main concept of SQL Server locking
In this post, we will discuss the SQL Server lock mechanism and how to monitor SQL Server locking...
Migrating SQL Server Database to Azure SQL (PaaS)
In this article, we will highlight SQL Server Data migration to Azure SQL (PaaS). You can find different approaches for this...
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...