Home > Store > Operating Systems, Server > Microsoft Servers

SQL Server 2005 Distilled

Register your product to gain access to bonus material or receive a coupon.

SQL Server 2005 Distilled

eBook (Watermarked)

  • Your Price: $25.59
  • List Price: $31.99
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

Description

  • Copyright 2006
  • Pages: 336
  • Edition: 1st
  • eBook (Watermarked)
  • ISBN-10: 0-13-280080-2
  • ISBN-13: 978-0-13-280080-8

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

Sample Content

Table of Contents

Preface  xiii

Acknowledgments  xv

About the Author  xvii

Chapter 1: Introduction to SQL Server 2005  1

Chapter 2: What Everyone Should Know About Security  41

Chapter 3: Enterprise Data Management  83

Chapter 4: Features for Database Development  145

Chapter 5: Overview of Business Intelligence  197

Chapter 6: The Code Chapter  245

Appendix A: SQL Server 2005 System Information  285

Appendix B: System Tables and View in SQL Server 2005  291

Appendix C: SQL Server Built-In Functions  295

Index  297

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership