Articles & Tutorial for MCTS: SQL Server 2005 certification
All articles for MCTS: SQL Server 2005 certification
Tips and How Tos for MCTS: SQL Server 2005 certification
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" »
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." »
What are articles?
Articles include database objects such as tables, views, stored procedures, indexed views, user-defined functions, and other objects. Articles are stored within a publication. When tables are published as articles and are vertically or horizontally partitioned, filters are used to restrict the...
continue reading "What are articles?" »
What are collation settings?
Collation settings are fundamental to the structure and working of SQL Server 2005 databases. They include character set, sort order, and other locale-specific settings. Many server-to-server activities can fail or yield inconsistent results if collation settings are not consistent across...
continue reading "What are collation settings?" »
What are user-defined functions?
User-defined functions are subroutines that contain one or more Transact-SQL statements. Function can be created using CREATE FUNCTION statement. You can define input parameters to provide data to the function. User-defined functions can either return a single value or table. SQL Server supports...
continue reading "What are user-defined functions?" »
What is database snapshot?
Database snapshot is a read-only view of a database. It is taken from the source database and resides on the same server as the database. A snapshot uses a sparse file to store original pages from the source database. A sparse file is empty when a snapshot is taken. Whenever a page is changed in...
continue reading "What is database snapshot?" »
What is a backup job?
A backup job is created on a primary server. It performs a number of operations such as performing backups, logging the history of backups to the local server and to the monitor server, and deleting old backup files and history. By default, a backup job runs every two minutes, but users can...
continue reading "What is a backup job?" »
What is a certificate?
A certificate is a set of data that completely identifies an entity. It is a digitally signed statement that binds the value of a public key to the identity of a person. It can be issued to perform a number of functions such as Web server authentication, secure e-mail, etc. A certificate is...
continue reading "What is a certificate?" »
