Creating and Deploying Multiple Versions of Database through Schema Snapshots
Overview This article talks about using database schema snapshots to maintain different versions of...
How to create Snapshot Replication
The concept of snapshot replication is simple. It generates and distributes the snapshot of schema and data of articles, appeared at a...
How to create Transactional Replication
In this article, I am going to demonstrate how to create transactional replication. Transactional replication generated a snapshot of...
Simplifying Unit Testing Main Stored Procedure Which Also Calls a Utility Procedure
This article provides a walkthrough of database unit testing a stored procedure which contains a...
Configuring Database Mail in SQL Server
SQL Server Database Mail has been introduced in SQL Server 2005. Database Mail is a component that can send emails using SQL Server Engine....
Main Usage of sys.dm_os_wait_stats
As you know, the main responsibility of the database administrator lies in the monitoring of the SQL Server performance and intervening in...
Compare Execution Plans in SQL Server
Database Administrator always makes an effort to tune SQL Server query performance. The first step...
SQL Server IntelliSense and Autocomplete
Starting from SQL Server 2008, Microsoft introduced a new feature in the SQL Server Management Studio that helps the database developers...
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...
