How SQL Server 2016 Took Azure SQL Data Warehouse to Next Level
Azure SQL DW (SQL Data Warehouse) is a massively parallel, petabyte-scale, cloud solution for data...
Consolidating SQL Server Instance by Clustering and Stacking
NOTES: Windows Failover Clustering comprising two nodes. Two SQL Server Failover Cluster Instances. This configuration optimizes the...
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...
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 to another database, or the same...
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...
Registered Server, a Hidden Gem of SQL Server Management Studio
Managing numerous database servers in an organization can be performed using the PowerShell scripts...
Introduction to Docker and Docker Toolbox
The article gives some knowledge about getting started and utilizing Docker containers. The focus is all about understanding Docker and...
Main concept of SQL Server locking
In this post, we will discuss the SQL Server lock mechanism and how to monitor SQL Server locking with SQL Server standard dynamic...
Migrating SQL Server Database to Azure SQL (PaaS)
In this article, we will highlight SQL Server Data migration to Azure SQL (PaaS). You can...
