How to Move Datafiles in SQL Server – Part 1
Introduction There are a number of situations which would warrant the movement of database files or...
Basics of sys.dm_exec_requests
Performance monitoring and troubleshooting in SQL Server is a vast topic. In SQL Server 2005, dynamic management views, also known as...
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...
Fixing Data Loss Using Log Shipping with Delayed Recovery
Introduction Transaction Log Shipping is a very well-known technology used in SQL Server to...
Export data from SQL Server to Excel and Text file via using SSIS package
While using the SSIS data flow, we can perform ETL task that can be used for data migration, data offloading, design and implementation of...
Structured Query Language – Importance of learning SQL
Computer programming language is a set of detailed instructions for computers or machines for performing specific actions. Through a...
Consolidating SQL Server Instance by Clustering and Stacking
NOTES: Windows Failover Clustering comprising two nodes. Two SQL Server Failover Cluster Instances....
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 but it requires some complex PowerShell...
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,...
