Главная    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-2025
Электронная библиотека мехмата МГУ | Valid HTML 4.01! | Valid CSS! О проекте