Главная    Ex Libris    Книги    Журналы    Статьи    Серии    Каталог    Wanted    Загрузка    ХудЛит    Справка    Поиск по индексам    Поиск    Форум   
blank
Авторизация

       
blank
Поиск по указателям

blank
blank
blank
Красота
blank
Brown E.L. — SQL Server 2005 Distilled
Brown E.L. — SQL Server 2005 Distilled



Обсудите книгу на научном форуме



Нашли опечатку?
Выделите ее мышкой и нажмите Ctrl+Enter


Название: SQL Server 2005 Distilled

Автор: Brown E.L.

Аннотация:

Need to get your arms around Microsoft SQL Server 2005 fast, without getting buried in the details? Need to make fundamental decisions about deploying, using, or administering Microsoft’s latest enterprise database?



Need to understand what’s new in SQL Server 2005, and how it fits with your existing IT and business infrastructure? SQL Server 2005 Distilled delivers the answers you need–quickly, clearly, and objectively.



Former SQL Server team member Eric L. Brown offers realistic insight into every significant aspect of SQL Server 2005: its new features, architecture, administrative tools, security model, data management capabilities, development environment, and much more. Brown draws on his extensive experience consulting with enterprise users, outlining realistic usage scenarios that leverage SQL Server 2005’s strengths and minimize its limitations. Coverage includes

* Architectural overview: how SQL Server 2005’s features work together and what it means to you
* Security management, policies, and permissions: gaining tighter control over your data
* SQL Server Management Studio: Microsoft’s new, unified tool suite for authoring, management, and operations
* Availability enhancements: online restoration, improved replication, shorter maintenance/recovery windows, and more
* Scalability improvements, including a practical explanation of SQL Server 2005’s complex table partitioning feature
* Data access enhancements, from ADO.NET 2.0 to XML
* SQL Server 2005’s built-in .NET CLR: how to use it, when to use it, and when to stay with T-SQL
* Business Intelligence Development Studio: leveraging major improvements in reporting and analytics
* Visual Studio integration: improving efficiency throughout the coding and debugging process
* Simple code examples demonstrating SQL Server 2005’s most significant new features


Язык: en

Рубрика: Технология/

Статус предметного указателя: Готов указатель с номерами страниц

ed2k: ed2k stats

Год издания: 2006

Количество страниц: 336

Добавлена в каталог: 21.06.2007

Операции: Положить на полку | Скопировать ссылку для форума | Скопировать ID
blank
Предметный указатель
.NET Framework      
.NET Framework, integrating      
.NET, managed code      
64-bit Enterprise Edition      
64-bit support, SQL Server Express      
accessing      
accessing managed provider      
accumulate()      
ACID (Atomicity, Consistency, Isolation, Durability)      
activation, SQL Service Broker      
actual value      
ADF (Application Definition File)      
ADO.NET      
advancements in      
advancements in SQL Server 2005      
Aggregate functions      
ALTER LOGIN      
AMD      
Analysis Services      2nd 3rd
Analysis Services components      
Analysis Services Scripting Language (ASSL)      
Analytic functions      
and XML column comparisons      
ANONYMOUS, end points      
API (Application Programming Interface)      
AppDomain      2nd
Application Definition File (ADF)      
Application Programming Interface (API)      
application servers      
application services, Notification Services      
applications and database encryption      
apply      
APPLY operator      
Architecture      
as a datasource, transformations      
as application servers      
Assemblies      
ASSL (Analysis Services Scripting Language)      
asymmetric keys      2nd
atomicity      
Authentication      
authentication, principle of least privileges      
Authorization      
automatic client-side redirect      
automatic MOLAP      
Availability      2nd
BAB (Binary Adjacent Broker)      
backup and restore enhancements      
Backup Database Wizard      
backward compatibility      
backward compatibility, SSIS      
bcp (Bulk Copy Program)      
benefits of SQL Server 2005      
BI (business intelligence)      2nd 3rd
BI and      2nd
bidirectionality (bidi) of text      
Binary Adjacent Broker (BAB)      
blocks, TRY/CATCH blocks      
Books Online Internet search      
Bulk Copy Program (bcp)      
Business Intelligence Development Studio      2nd
Business Intelligence Wizard      
Business Intelligence Wizard, Analysis Services      
business intelligence/datawarehousing      
CA (certificate authority)      
Caching      
calculated measures, UDM      
catalog views      
cell-level security      
Certificate authority (CA)      
certificates      
certificates and SSL      
Change management      
characters, surrogate characters      
CHECK constraints      
Checksum      2nd
checksum integrity checks      
choice of XML technology      
choosing between Transact SQL and managed code      
choosing between Transact-SQL and managed code      
Classes      
client initiated      
CLOSE ALL KEYS      
CLR      
CLR (Common Language Runtime)      2nd
CLR and      
CLR integration, .NET Framework      
CLR stored procedures      
columns, persisted computed columns (Transact-SQL)      
combining characters      
Commands      
Common Language Runtime      [See CLR (Common Language Runtime). ]
Common Table Expressions (CTE)      2nd
comparing      
comparing components      
comparing solutions      
comparing Standard Edition and Enterprise Edition for HA solutions      
compatibility, backward compatibility (SSIS)      
complex script enabling      
component dependencies      
components, comparing (Analysis Services components)      
Configuration Manager      
configuring SQL Server Express      
Connection dialog      
Consistency      
Consistency Checker      
constrained XML data types      
CONTAINSTABLE query      
contextual shaping      
control flow      
control flow, SSIS      
conversation groups, SQL Service Broker      
create      
CREATE certificate      
Create Database dialog      
Create Database dialog, SQL Server Management Studio      
creating in SQL Server Management Studio      
Creating tables      
CREDENTIAL      
CROSS APPLY      
CTE (Common Table Expressions)      
Cube Wizard      
Cube Wizard, Analysis Services      
cube-level security      
Current Activity window      
custom delivery protocol      
custom event providers      
custom event providers, EventLoaderClass      
customizable installation path      
Customizing      
customizing SQL Server Management Studio      
DAC (Dedicated Administrator Connection)      
data access interfaces      
data availability      
Data Definition Language (DDL)      2nd
data destination adapters      
data flow      2nd
Data Flow Engine      
Data Flow Pipeline (DFP)      
data flow, SSIS      2nd
data guardians      
Data manipulation language (DML)      2nd
Data Manipulation Language (DML) trigger      
Data Mining      2nd
data mining dimension      
data partition tuning      
data source adapters      
data source view      [See DSV (data source view). ]
Data Source View Wizard      
Data Transformation Services (DTS)      2nd 3rd
data warehousing, relational features      2nd
Database administrator      [See DBA (database administrator). ]
database administrators      
database alerts      
database catalog views      
database data encryption      
database encryption and applications      
database engine enhancements      
database features to turn off      
Database Mail      
Database Mail Configuration Wizard      
database master key      
database mirroring      
database objects (DBOs)      
database roles, Analysis Services      
database scalability      [See scalability. ]
Database Snapshot      
database states      
database system availability      
Database Tuning Advisor      
Database Tuning Advisor (DTA)      
database-level roles in SSIS      
databases      
databases as      
datawarehousing, SQL Server Replication      
DBA (database administrator)      2nd
DBA and      
DBAs and      
DBCS (double-byte character system)      
DBO (database object)      
DCOM (Distributed Component Object Model)      
DDL (Data Definition Language)      2nd
DDL triggers      
deadlock traces      
Dedicated Administrator Connection (DAC)      
default trace      
DENSE_RANK      
deploying in SSIS      
deploying packages      
deploying packages, SSIS      
Deployment      
deployment scenarios      
deployment, Reporting Services      
designing reports      
designing reports, Reporting Services      
Destinations      
DFP (Data Flow Pipeline)      
dialog security      
dialogs, SQL Service Broker      
dimension-level security      
dimensions      
dimensions, UDM      
disk I/O errors      
Distributed Component Object Model (DCOM)      
Distributed Partition Views (DPVs)      2nd
Distributed Transaction Coordinator (DTC)      
DML      
DML (data manipulation language)      2nd
DML (Data Manipulation Language) triggers      
DML triggers      
DML with results      
DMVs      
DMVs (Dynamic Management Views)      2nd 3rd
DontSaveSensitive      
double-byte character system (DBCS)      
DPVs (Distributed Partition Views)      2nd
Dr. Watson integration      
DSV      
DSV (data source view)      2nd 3rd
DTA (Database Tuning Advisor)      
DTC (Distributed Transaction Coordinator)      
DTS (Data Transformation Services)      2nd 3rd
durability      
Dynamic Management Views (DMVs)      2nd 3rd
e-commerce applications      
EE (Enterprise Edition)      
EFS (Encrypted File System)      
EncryptAllWithPassword      
EncryptAllWithUserKey      
encrypting SSIS packages      
Encryption      2nd
EncryptSensitiveWithPassword      
EncryptSensitiveWithUserKey      
end points, HTTP      
end-point security      
Enterprise Edition (EE)      
error capturing and manipulation      
Error handling      
error handling, SSIS      
errors, disk I/O errors      
ETL      
ETL (extraction, transformation, and loading)      
ETL tools      
event and scheduled notification generation      
event notifications      
event notifications and reactive monitoring      
event notifications and triggers      
event providers      
event submission SQL Server stored procedures      
event submission, Notification Services      
Event subscriptions      
EventLoaderClass      
events, Notification Services      
execute as caller      
execute as owner      
execute as principal      
execute as self      
execution context      2nd 3rd
explicit impersonation      
exportable showplans and deadlock traces      
exposed state      
extending HA to all database applications      
extending to all database applications      
Extensible Markup Language      [See XML (eXtensible Markup Language). ]
Extensible Stylesheets Language Transformation (XSLT)      
extensions for queuing support      
extensions for queuing support (Transact-SQL)      
External_Access      
extraction, transformation, and loading (ETL)      
fact dimension      
failover clustering      
failure reporting      
fall behind recovery handling      
fast recovery      
features of      
File delivery protocol      
File Extensions delivery protocol      
FILE path      
filegroups, creating      
FileSystemWatcherProvider      
for SQL Server Mobile Edition      
FOR XML      
full-text catalog inclusion      
Full-Text Search      2nd
Functions      
fuzzy lookup and grouping      
GB18030      
general data availability      [See general data availability. ]
GLBA (Gramm-Leach-Bliley Act)      
goal value      
GRANT EXECUTE      
granular permission control      
greater parallelization of data flow      
groups, partition groups      
HA (high-availability)      2nd 3rd 4th
HA (high-availabilty)      
HA solutions      
help      
help, SQL Server Management Studio      
heterogeneous data targeting after transformation      
1 2 3
blank
Реклама
blank
blank
HR
@Mail.ru
       © Электронная библиотека попечительского совета мехмата МГУ, 2004-2020
Электронная библиотека мехмата МГУ | Valid HTML 4.01! | Valid CSS! О проекте