Авторизация
Поиск по указателям
Beauchemin B., Sullivan D. — A Developer's Guide to SQL Server 2005
Обсудите книгу на научном форуме
Нашли опечатку? Выделите ее мышкой и нажмите Ctrl+Enter
Название: A Developer's Guide to SQL Server 2005
Авторы: Beauchemin B., Sullivan D.
Аннотация: Few technologies have been as eagerly anticipated as Microsoft SQL Server 2005. Now, two SQL Server insiders deliver the definitive hands-on guide—accurate, comprehensive, and packed with examples. ADeveloper's Guide to SQL Server 2005 starts where Microsoft's documentation, white papers, and Web articles leave off, showing developers how to take full advantage of SQL Server 2005's key innovations. It draws on exceptional cooperation from Microsoft's SQL Server developers and the authors' extensive access to SQL Server 2005 since its earliest alpha releases.
You'll find practical explanations of the new SQL Server 2005 data model, built-in .NET hosting, improved programmability, SQL: 1999 compliance, and much more. Virtually every key concept is illuminated via sample code that has been fully updated for and tested with the shipping version of the product.
Key coverage includes
• Using SQL Server 2005 as a .NET runtime host: extending the server while enhancing security, reliability, and performance
• Writing procedures, functions, triggers, and types in .NET languages
• Exploiting enhancements to T-SQL for robust error-handling, efficient queries, and improved syntax
• Effectively using the XML data type and XML queries
• Implementing native SQL Server 2005 Web Services
• Writing efficient, robust clients for SQL Server 2005 using ADO.NET, classic ADO, and other APIs
• Taking full advantage of user-defined types (UDTs), query notifications, promotable transactions, and multiple active result sets (MARS)
• Using SQL Management Objects (SMO), SQL Service Broker, and SQL Server Notification Services to build integrated applications
Язык:
Рубрика: Руководства по программному обеспечению /
Статус предметного указателя: Готов указатель с номерами страниц
ed2k: ed2k stats
Год издания: 2006
Количество страниц: 1088
Добавлена в каталог: 23.10.2006
Операции: Положить на полку |
Скопировать ссылку для форума | Скопировать ID
Предметный указатель
Query Notification support, SqlDependency for
Query Notification support, SqlNotificationRequest for
Query Notification support, usage
Query plans
Query predicates
Query window
QueryMemoryResourceNotification API
Queues
Queues for messages 2nd 3rd
Queues for Query Notifications
Queues in service programs
QUEUE_ACTIVATION events
QuoteIdentifier property
RAISERROR statement 2nd 3rd 4th
Random samples
Range class 2nd
Range errors
RangeFunctions class
RANK function 2nd
Ranking functions
RAW mode for XML
RDS (remote data services) architecture
READ COMMITTED isolation level 2nd 3rd
Read method
Read method in IBinarySerialize
Read method in LDim 2nd
Read method in SqlDataReader 2nd 3rd
Read method in XmlReader
READ UNCOMMITTED isolation level
Read-mostly lookup tables
Read-only lookup tables
Read-only mode
ReadCommitted method
Reader-makeright approach
Readers in SAX
Reading trace output
ReadLine method
READTEXT method
ReadXml method
ReadXml method in IXmlSerializable
ReadXml method in LDim
READ_COMMITTED_SNAPSHOT option 2nd 3rd
RECEIVE statement
RECEIVE statement for conversation groups 2nd
RECEIVE statement for Event Notifications
RECEIVE statement for processing loops 2nd
RECEIVE statement for queues 2nd
Recompilation, statement-level
Recordsets
Recursive queries
REF data type
ref modifier
Reference types 2nd
ReferenceEquals method
References folder
REFERENCES permission
REFERENCES permission for assemblies
REFERENCES permission for schema collections
REFERENCES permission for tables
Reflection for assemblies
Regex class
Register command
Registry
Registry for data tracing 2nd
Registry for provider factories
Registry for SMO
Regular expressions
Relational data access APIs
Relational databases
Remote data services (RDS) architecture
Remote procedure calls (RPCs)
REMOVE PRIVATE KEY statement
RENAME LOGIN statement
RepairWSDL function
REPEATABLE clause
REPEATABLE READ isolation level 2nd
replace value of statement
REPLICATE function
Reporting Services feature 2nd
ReportingServices namespace
Reservations for URLs
ReservedWords metadata category
Reset Lockout Counter After setting
Resource management for hosting
Responses for Web Services
Restore object module
RestrictionNumbers
Restrictions collection
Restrictions, URN retrieval
Result method
Results window
Resultsets
Retention for queues
Retrieved property
RetrieveStatistics method
Retry stored procedure
Retrying transactions
return expressions
return expressions in FLWOR
return expressions in XQuery 2nd
Return values
Return values for in-process data access
Return values for stored procedures
Return values in CLR
ReturnProviderSpecificTypes property
Reverse method
REVERT statement
Roles
Roles assigning
Roles schemas for
ROLLBACK TRAN statement
Rollup accounts
Rollup query
Root elements in XML
Root nodes in XQuery 2nd
Routes and routing tables
Rows
ROWS clause
Rows in SNAPSHOT isolation
Rows inserting
Rowsets
Rowsets from XML documents
Rowsets, creating and sending
Rowsets, watching
ROWSETS_ONLY option
ROW_NUMBER function
RPCs (remote procedure calls)
Rules
Rules creating
Rules for Notification Services
Rules.dll file
Runas utility
Runas utility for ImpersonateConnect program
Runas utility for SMO connections
Runtime hosts [See Hosting.]
SAFE security level 2nd
SAFE security level for assemblies 2nd 3rd
SAFE security level for hosting
SafeHandle class
Safety levels
Sagas 2nd
Sample applications for Notification
Samples, random
SAXXMLReader40 class
Scalars
Scalars, dimensions for
Scalars, points for
Scalars, user-defined functions
Scalars, user-defined types
ScaleBy method 2nd
ScheduledRules section
Schema node
Schema-bound links
SchemaFile argument
SchemaGen option
Schemas and schema collections
Schemas and schema collections for assemblies
Schemas and schema collections for HTTP
Schemas and schema collections for message types
Schemas and schema collections for Notification Services 2nd
Schemas and schema collections in ADO.NET
Schemas and schema collections in XML 2nd 3rd 4th
Schemas and schema collections in XQuery
Schemas and schema collections inline XSD format
Schemas and schema collections managing
Schemas and schema collections mapping
Schemas and schema collections metadata in
Schemas and schema collections, availability of
Schemas and schema collections, customizing and extending
Schemas and schema collections, purpose of
Schemas and schema collections, security for
Schemas and schema collections, user customization in
Schemas and schema collections, user separation from
SCOPE_IDENTITY function 2nd
Script method
Script Stored Procedure As command
ScriptDrops property 2nd
Scripter objects
ScriptingOptions object
Scripts
Scripts for SMO
Scripts, Object Explorer for
Sealing the data process
SecondsDelay data type
Securables
Secure Sockets Layer (SSL)
Secure Sockets Layer (SSL), encryption in
Secure Sockets Layer (SSL), for Web Services
SecureString class
Security
Security Configuration Manager screen
Security, authentication and authorization in
Security, best practices
Security, code signing
Security, configuring
Security, encryption for
Security, execution contexts
Security, execution contexts and ownership chaining
Security, execution contexts for procedural code
Security, for assemblies
Security, for metadata 2nd
Security, for schema collections
Security, for SQLCLR objects
Security, for synonyms
Security, in .NET Framework
Security, in hosting
Security, new features
Security, optional features in
Security, password policies and credentials in
Security, safety levels for
Security, separation of users and schemas for
SELECT permission 2nd
SELECT statement
SELECT statement, CTEs with
SELECT statement, encryption in 2nd
SELECT statement, for queues
SELECT statement, FOR XML clause in [See FOR XML clause.]
SELECT statement, in SNAPSHOT isolation
SELECT statement, return data from
SELECT statement, TABLESAMPLE clause in
SELECT statement, TOP clause in
SELECT statement, vs. XQuery
SelectCommand command
select_and_count stored procedure
Self axes in XQuery
Self-signed certificates
Semicolons (;)
Semicolons (;) for CTEs
Semicolons (;) for SSB
Send a message and go on about your business technique
Send method
SEND ON CONVERSATION statement
SEND statement 2nd
Send type in business transactions
SendResultsEnd method
SendResultsRow method
SendResultsStart method
SENT BY ANY clause
SENT BY clause
SEP (SQL Server event provider) 2nd
Separation of users and schemas 2nd
Sequences in XQuery 2nd
SequentialAccess method 2nd 3rd
Serializable attribute 2nd
SERIALIZABLE isolation level
Serialization
Serialization class
Serialization for UDTs
Serialization IBinarySerialize for
Serialization in XML 2nd
Serialization namespace
Serialization of DataSets
Serialization of transactions
Server class
Server class for SMO
Server class, properties in 2nd 3rd
Server Explorer
Server Management Objects (SMO)
Server Management Objects (SMO), best practices
Server Management Objects (SMO), configuration management for
Server Management Objects (SMO), connections in
Server Management Objects (SMO), connections in automatic
Server Management Objects (SMO), connections in default Windows credentials
Server Management Objects (SMO), connections in managing
Server Management Objects (SMO), connections in Runas utility
Server Management Objects (SMO), connections in SQL Server login
Server Management Objects (SMO), connections in Windows identity impersonation
Server Management Objects (SMO), object model for 2nd
Server Management Objects (SMO), objects in
Server Management Objects (SMO), objects in GetSmoObject for
Server Management Objects (SMO), objects in identity of
Server Management Objects (SMO), objects in methods of
Server Management Objects (SMO), objects in parent navigation
Server Management Objects (SMO), objects in properties for
Server Management Objects (SMO), objects in state of
Server Management Objects (SMO), objects in URN retrieval object model
Server Management Objects (SMO), objects in URN retrieval restrictions
Server Management Objects (SMO), projects
Server Management Objects (SMO), purpose of
Server Management Objects (SMO), scripts for
Server Management Objects (SMO), Server class for
Server Management Objects (SMO), vs. ADO
Server rules
Server Service Broker (SSB) service
Server Service Broker (SSB) service, best practices
Server Service Broker (SSB) service, business transactions in [See Business transactions.]
Server Service Broker (SSB) service, for events
Server Service Broker (SSB) service, for messaging applications
Server Service Broker (SSB) service, in Query Notification
Server Service Broker (SSB) service, message processing in
Server-side cursors
ServerConnect object
ServerConnection class
ServerConnection class for credentials
ServerConnection class for passwords
ServerConnection class for SMO 2nd
ServerConnection class, properties of
Service Broker [See Server Service Broker (SSB) service.]
Service master keys
Service programs
Реклама