845viewsSQL Server Data Migration Assistant (DMA) is a free tool developed by Microsoft to help you migrate your databases to a newer version of SQL Server or even migrate them to the cloud, specifically...
Articles / Database Administration / SQL Server / SQL Tools / Tutorials
by Manzoor Siddiqui · Published July 31, 2015 · Last modified September 24, 2015
514viewsSQL Server maintenance plan wizard is inbuilt feature which helps in creating automated maintenance jobs for database integrity checks, rebuild and reorganize indexes, update statistics, backup databases and performs maintenance cleanup tasks etc. These...
Articles / Database Administration / Performance Tuning / SQL Server / SQL Tips and Tricks / SQL Tools / Tutorials
by Manzoor Siddiqui · Published July 13, 2015 · Last modified September 24, 2015
640viewsPerformance monitor is a free tool provided by Microsoft windows and is very useful to analyse real time and historical performance information of your database servers and windows servers. So if you don’t have...
Articles / Database Administration / Performance Tuning / SQL Server / SQL Tips and Tricks / SQL Tools / Tutorials
by Manzoor Siddiqui · Published June 28, 2015 · Last modified September 24, 2015
372viewsActivity Monitor is an inbuilt monitoring tool which comes with SQL Server Management Studio. This monitoring tool provides real-time information about processes, resource waits, data file I/O and recent expensive queries etc. If you...
Articles / Database Administration / SQL Server / SQL Tips and Tricks / SQL Tools / Tutorials
by Manzoor Siddiqui · Published June 25, 2015 · Last modified September 24, 2015
701viewsSQL Server replication is a process and technique where data is frequently copied from one database server to another database server. The output or work is distributed across database where relevant data is accessed...
Articles / SQL Server / SQL Tips and Tricks / SQL Tools / Tutorials
by Manzoor Siddiqui · Published June 11, 2015 · Last modified September 24, 2015
Bulk Copy Program (BCP) is a powerful command line utility to import and export data in SQL Server database. If you do not have much knowledge about database commands then also you can use it...
