MCTS: SQL Server 2005 certification
All articles for MCTS: SQL Server 2005 certification
Tips and How Tos for MCTS: SQL Server 2005 certification
How to change the recovery model of a database?
Take the following steps to change the recovery model of a database: Run SQL Server Management Studio from Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio. In the Connect to Server window, click the Connect button. In the SQL Server Management...
continue reading "How to change the recovery model of a database?" »
How to create a backup device?
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 computed column?
The syntaxes of creating a computed column are as follows:
CREATE TABLE table_name
(
column1 datatype,
column2 datatype,
computed_column_name AS computed_column_expression
)
ALTER TABLE table_name ADD computed_column_name AS computed_column_expression
The following example...
continue reading "How to create a computed column?" »
How to create a temporary table?
The syntax of creating a temporary table is as follows:
To create a local temporary table.
CREATE TABLE #temporary_table
(
column1 datatype,
column2 datatype
)
SELECT * INTO #temporary_table FROM original_table To create a...
continue reading "How to create a temporary table?" »
Monitoring Physical Server Performance
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" »
Note for the Publisher role
There is a difference between the Publisher role related to replication and reporting services. In replication, a server is assigned to the Publisher role. This server contains data that is to be replicated. In Reporting Services, a user is assigned to the Publisher role. This user has the...
continue reading "Note for the Publisher role" »
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" »
Replication
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" »
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." »