Tag: database administration

How to Move Datafiles in SQL Server – Part 1

Database administration, Work with data

Introduction There are a number of situations which would warrant the movement of database files or...
Read More

Basics of sys.dm_exec_requests

Database administration, Performance Tuning

Performance monitoring and troubleshooting in SQL Server is a vast topic. In SQL Server 2005, dynamic management views, also known as...
Read More

Main Usage of sys.dm_os_wait_stats

Database administration, Database development, Troubleshooting Issues, Views

As you know, the main responsibility of the database administrator lies in the monitoring of the SQL Server performance and intervening in...
Read More

Fixing Data Loss Using Log Shipping with Delayed Recovery

Database administration, Transaction Log, Troubleshooting Issues

Introduction Transaction Log Shipping is a very well-known technology used in SQL Server to...
Read More

Export data from SQL Server to Excel and Text file via using SSIS package

Business intelligence, Database administration, SSIS, Work with data

While using the SSIS data flow, we can perform ETL task that can be used for data migration, data offloading, design and implementation of...
Read More

Structured Query Language – Importance of learning SQL

Database administration, Database development, MySQL, Oracle, PostgreSQL, SQL Server • One Comment

Computer programming language is a set of detailed instructions for computers or machines for performing specific actions. Through a...
Read More

Consolidating SQL Server Instance by Clustering and Stacking

Database administration, Performance Tuning

NOTES: Windows Failover Clustering comprising two nodes. Two SQL Server Failover Cluster Instances....
Read More

SQL Server Management Studio (SSMS) Registered Server

SSMS, Tools & technologies

Managing numerous database servers in an organization is difficult. Either we must maintain a list or maintain an Excel file that has a...
Read More

Registered Server, a Hidden Gem of SQL Server Management Studio

SSMS, Tools & technologies

Managing numerous database servers in an organization can be performed using the PowerShell scripts but it requires some complex PowerShell...
Read More

Planning of Disk Space for Databases

Database administration, Memory Optimization

Do you think about something when you create a new database? I guess that most of you would say no,...
Read More
Close