Book description
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
Table of contents
- Microsoft Windows Server System Series
- Title Page
- Copyright Page
- Dedication
- Contents
- Preface
- Acknowledgments
- About the Author
- Chapter 1. Introduction to SQL Server 2005
- Chapter 2. What Everyone Should Know About Security
- Chapter 3. Enterprise Data Management
- Chapter 4. Features for Database Development
- Chapter 5. Overview of Business Intelligence
- Chapter 6. The Code Chapter
- 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
Product information
- Title: SQL Server 2005 Distilled
- Author(s):
- Release date: March 2006
- Publisher(s): Addison-Wesley Professional
- ISBN: 9780321349798
You might also like
book
Inside SQL Server 2005 Tools
Direct from Microsoft Insiders: the Complete Hands-On Guide to SQL Server 2005’s Powerful Tools! Microsoft SQL …
book
Administrator’s Guide to SQL Server 2005
“Buck Woody’s new book will help new and experienced users alike in getting productive with SQL …
book
Microsoft® SQL Server™ 2005 Administrator's Companion
Get comprehensive information to plan, deploy, administer, and support Microsoft SQL Server 2005 in organizations of …
book
SQL Server 2005 Practical Troubleshooting: The Database Engine
Never-Before-Published Insiders’ Information for Troubleshooting SQL Server 2005. This is the definitive guide to troubleshooting the …