Articles for MCSE, MCSD, MCAD, CIW, CompTIA, Oracle, SCJP Certifications
All articles for MCTS: SQL Server 2005 certification
Tips and How Tos for MCTS: SQL Server 2005 certification
Skills required for Microsoft test 70-431.
Microsoft has specified more than thirty objectives for the test 70-431, which are grouped under six topics. Following are the important areas in which an individual should have good knowledge before taking the test 70-431:
Configuring Mixed Mode authentication and Windows Authentication,...
continue reading "Skills required for Microsoft test 70-431." »
Things to practice for Microsoft test 70-431.
Microsoft test 70-431 focuses on your ability to maintain and implement SQL Server 2005 computers. To successfully pass the test 70-431, you need to practice the following:
Install and uninstall SQL Server 2005. Upgrade earlier versions of SQL Server. Configure SQL Server 2005 security....
continue reading "Things to practice for Microsoft test 70-431." »
Replication
Introduction
Replication is a process that copies and distributes data and database objects from one database to another and then synchronizes information between the databases for consistency.
SQL Server 2005 replication is a set of solutions that allow the copying, distribution, and...
continue reading "Replication" »
Service Broker
Service Broker is a new technology in SQL Server 2005 and provides a solution to message delivery issues that occur while transferring transactional data from one server to another. This technology provides a message-based communication platform and is part of the Database Engine. Database...
continue reading "Service Broker" »
