Внимание!!! AdBlock блокирует показ некоторых скриншотов. Пожалуйста, все вопросы к разработчкикам
Автор
Сообщение
Galfimbul
SQL Server 2005 Distilled
Год: 2006 Автор: Brown E. L. Жанр: Учебное пособие Издательство: Addison Wesley Professional ISBN: 0-321-34979-2, 978-0-321-34979-8 Язык: Английский Формат: CHM Качество: Изначально компьютерное (eBook) Количество страниц: 336
Описание: 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
Copyright Microsoft Windows Server System Series Preface How to Use This Book Who Should Read This Book How This Book Is Organized Acknowledgments About the Author Chapter 1. Introduction to SQL Server 2005 SQL Server 2005 Editions Database Scalability Revisited The Database As an Application Server Improving the Availability of SQL Server Systems High Availability in SQL Server 2005 General Data Availability Very Large Database Maintenance Overview of SQL Server 2005 Business Intelligence The Most Sublime Features of SQL Server 2005 Summary Chapter 2. What Everyone Should Know About Security Essential SQL Server Engine Security Features The Concept of End-Point Security Managed Code Security Analysis Services Security SQL Server Integration Services Security Features Securing the Server Summary Chapter 3. Enterprise Data Management SQL Server Management Studio SQL Server 2005 Infrastructure Management Operations Management Tools SQL Server 2005 Remote Management Features SQL Server Monitoring Managing Very Large Databases SQL Server Replication Enhancements High Availability for the Masses General Data Availability Indexed View Common Language Runtime and Database Administrator Business Intelligence and the Database Administrator Summary Chapter 4. Features for Database Development Visual Studio Integration .NET Framework Integration SQL Server Managed Provider XML Functionality SQL Server As an Application Server Platform SQL Server Mobile Edition International Features Added in SQL Server 2005 Full-Text Search SQL Server Express Summary Chapter 5. Overview of Business Intelligence Analysis Services Overview SQL Server Integration Services Summary Chapter 6. The Code Chapter Transaction Exception Handling Large Object Programming Model New Analytic Functions Table Sample Clause New APPLY Operator PIVOT and UNPIVOT Operators Recursive Queries TOP Enhancements DDL Triggers DML Output Extensions for Queuing Support Indexed Views Persisted Computed Columns Synonyms Security-Related Transact-SQL Working with Assemblies Working with XML Dynamic Management Views Database Features to Turn Off Table Partitioning Summary Appendix A. SQL Server 2005 System Information Appendix B. System Tables and View in SQL Server 2005 Appendix C. SQL Server Built-In Functions Index
Опубликовано группой
Внимание! AdBlock блокирует показ скриншотов, все вопросы к разработчикам )))
