Titlebook: Beginning SQL Server 2000 DBA; From Novice to Profe Tony Bain,Baya Pavliashvili,Brian Freeman Book 2004 Baya Pavliashvili and Michael Benko

outer-ear

Security,ty management lies in finding a satisfactory balance between preventing anyone from doing anything and allowing everyone to do everything. If you’re too restrictive in the assignment of permissions then your users aren’t going to be able to use the database effectively. If you’re too loose in assign

類(lèi)似思想

Tidious

Replication, participating databases can exist on the same or different servers. Depending on the type of replication that you select, data can be modified on the copy of the database, and then resynchronized with the source database.

命令變成大炮

transient-pain

Data Warehousing and Analysis,uses. Microsoft changed this by introducing OLAP Services with SQL Server version 7.0 (in SQL Server 2000, OLAP Services are referred to as Analysis Services). What this means to you, as a DBA (database administrator), is that you and your colleagues are now more likely to develop and maintain a dat

jet-lag

FAZE

Connectivity,ata is only of use if the end users can access it—they could be, but aren’t limited to applications, services, reports, and data-entry screens. As a database administrator (DBA), you’ll be called on to help architect, configure, and troubleshoot a variety of issues related to the connectivity and availability to your database.

debase

支形吊燈

Development with Transact-SQL,ibility to ensure that database routines do what they’re supposed to do, and that these routines are as efficient as possible. Knowledge of T-SQL will provide you with the ability to determine which code is acceptable for your database. It will also allow you to set coding standards for your organization’s developers.

涂掉

Data Warehousing and Analysis,uses. Microsoft changed this by introducing OLAP Services with SQL Server version 7.0 (in SQL Server 2000, OLAP Services are referred to as Analysis Services). What this means to you, as a DBA (database administrator), is that you and your colleagues are now more likely to develop and maintain a data warehouse than ever before.