Articles for MCSE, MCSD, MCAD, CIW, CompTIA, Oracle, SCJP Certifications
All articles for MCITP Database Administrator certification
Tips and How Tos for MCITP Database Administrator certification
MCITP 70-444 Short Notes: Exam passing Tips
in MCITP Database Administrator
Optimizing the performance of database servers and databases
Memory: Pages/sec counter is used to detect whether or not the memory bottleneck is caused by I/O overhead.
Disk I/O bottleneck can be monitored by Physical Disk: % Disk Time and Physical Disk: Avg Disk Queue Length counters....
continue reading "MCITP 70-444 Short Notes: Exam passing Tips" »
Study Tips for 70-444
in MCITP Database Administrator
The objective of Microsoft test 70-444 is to test the skills of a user to optimize, manage, and administer the databases of SQL Server 2005. A candidate should be able to resolve the issues related to system and user databases, SQL Server services, and SQL Server tools. A user should be able to...
continue reading "Study Tips for 70-444" »
Things to Practice for 70-444
in MCITP Database Administrator
The Microsoft test 70-444 measures your ability to optimize, manage, and administer SQL Server databases. The test is designed to check your ability to use the SQL Server services and objects. It requires you to have a good knowledge of the SQL Server objects and troubleshooting issues related to...
continue reading "Things to Practice for 70-444" »
Monitoring Physical Server Performance
in MCITP Database Administrator
SQL Server 2005 can be installed on a Windows 2000 or Windows 2003 server computer. A database administrator is always concerned about the performance of the SQL Server database engine and the server computer. Database Administrators monitor the performance of the server using various tools to...
continue reading "Monitoring Physical Server Performance" »
Replication
in MCITP Database Administrator
Replication is a type of configuration used to copy data and database objects from one database instance to another. A database administrator has to configure a server for replication, and monitor it in order to detect and resolve issues regarding replication.
Requirements for replication:...
continue reading "Replication" »
SQL Server Profiler
in MCITP Database Administrator
SQL Server Profiler is a tool used to determine which transact SQL statements are submitted to the instance of a server. SQL Server Profiler is run from a Monitoring server to test a Production server. A SQL Server Profiler template is used to capture events and store the results in a file with...
continue reading "SQL Server Profiler" »
How to create a backup device?
in MCITP Database Administrator
Take the following steps to create a backup device:
Run SQL Server Management Studio from Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio.
Right-click the Server Objects folder and go to New > Backup Device.
In the Backup Device...
continue reading "How to create a backup device?" »
How to create a database diagram?
in MCITP Database Administrator
Take the following steps to create a database diagram:
Run SQL Server Management Studio from Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio.
In the Connect To Server window, select the Server name and click the Connect button.
In the...
continue reading "How to create a database diagram?" »
How to create a database?
in MCITP Database Administrator
Take the following steps to create a database:
Run SQL Server Management Studio from Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio.
In the Connect to Server dialog box, select the Server type as Database Engine, specify the Server Name and...
continue reading "How to create a database?" »
How to create a Maintenance Plan using Maintenance Plan wizard?
in MCITP Database Administrator
Take the following steps to create a Maintenance Plan:
Run SQL Server Management Studio from Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio.
In the Connect To Server window, select the Server name, and click the Connect button.
In...
continue reading "How to create a Maintenance Plan using Maintenance Plan wizard?" »
