Archive for the ‘MCTS SQL Server 2005’ category

Take the following steps to change the authentication mode of a database server:

1. Run SQL Server Management Studio from Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio.

   

2. In the Connect to Server window, click the Connect button.

   

Take the following steps to create a role:

1. Run SQL Server Management Studio from Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio.

   

2. In the Connect to Server window, click the Connect button.

   

3. In the SQL Server Management Studio window, double-click the Databases folder.

   

Before a role is created, the owner of the role should be added to the required database. If this is not done, an error occurs and the role is not created. The user can be added to the database through the Security page in the Database Properties dialog box.

The objective of Microsoft test 70-447 is to measure your ability to install and manage database servers and databases to test the skills of a user, and to optimize, manage, and administer the SQL Server 2005 databases. Your capability of database designing and administration are also measured. You should be able to work with different tools present in SQL Server 2005 to create and manage databases. Before taking the test, you should remember the following study tips:

1. Always remember that the System Monitor tool is used to measure the counters of database servers and databases.
2. Always remember that the counter values give you an idea of whether to upgrade or replace a hardware resource.
3. Always remember that the storage and performance of a database can be improved by using different levels of RAIDs.
4. Always remember that SQL Server Management Studio is used to create and manage a database and database objects.
5. Always remember that SQL Server 2005 have different editions.
6. Always remember that a server having SQL Server 2005 Enterprise Edition can have fifty instances of SQL Server 2005.
7. Always remember that roles and permissions should be used to secure the database server from external and internal attacks.
8. Always remember that server-level, database-level, and schema-level security can be used to protect the server and the database.
9. Always remember that tables should have a primary key and foreign key relationship to retrieve data from more than one table.
10. Always remember that the traces can be used to view the cause of locks and deadlocks.
11. Always remember that Dynamic Management Views (DMVs) are used to view and resolve the issues related to different database objects such as tables, indexes, stored procedures, views, and triggers, etc.
12. Always remember that SQL Server Profiler provides event classes that are used to trace events occurring in SQL Server.
13. Always remember that transactions fail due to locks and deadlocks.
14. Always remember that locks and deadlocks are caused due to unavailable resources.
15. Always remember that traces can be created and managed through SQL Server Profiler.
16. Always remember that Backup and Restore processes help recover damaged databases and their objects.
17. Always remember that Failover Clustering helps maintain the performance in case a server in the cluster fails.

To derive maximum value from the uCertify PrepKit, you should take a diagnostic test and find out your weak areas. Read all the study notes and remove your weaknesses. Use the uCertify PrepKit several times for the preparation of the test. Buy the PrepKit with 200+ questions and 100+ study notes. Practice all the tests several times until you get 100% in all the tests.

The Microsoft test 70-447 measures your ability to design the infrastructure of database servers and databases, and to optimize, manage, and administer SQL Server databases. It covers a range of database technologies. You must understand the ways of planning to install database servers and databases, and know about the cost of hardware and software resources to develop the infrastructure. You should also consider the security of the database servers and usage of SQL Server services and objects. It requires you to have a good knowledge of the SQL Server objects and troubleshooting issues related to SQL Server. Before taking the 70-447 test, you should practice the following:

The following query is used to know about the currently installed SQL Server Edition on a computer:

SELECT SERVERPROPERTY(’edition’)