Master your Minecraft
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    Best Books of the Year | December 8, 2014

    Tracey T.: IMG Best Cookbooks of 2014



    As the cookbook buyer for Powell's Books, I am the lucky one who gets to choose every new cookbook that comes into our stores. This means I have a... Continue »

    spacer
Qualifying orders ship free.
$5.98
List price: $36.25
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Local Warehouse COMP- DATA SQL

More copies of this ISBN

SQL Server 2005 Distilled

by

SQL Server 2005 Distilled Cover

 

Synopses & Reviews

Publisher Comments:

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

Book News Annotation:

Writing at the high-end level, Brown works to provide decision-makers with clear and objective data about Microsoft's latest enterprise database. He introduces the basics behind the software, including general data availability and very large database maintenance, what everyone should know about security, including managed code, end-point security and securing the server, enterprise data management, including replication enhancements and operations management tools, features for database development, business intelligence, including the software's reporting capabilities, and a full chapter on code. He also provides data on the system and the server's built-in functions along with a variety of samples and exercises.
Annotation 2006 Book News, Inc., Portland, OR (booknews.com)

Book News Annotation:

Writing at the high-end level, Brown works to provide decision-makers with clear and objective data about Microsoft's latest enterprise database. He introduces the basics behind the software, including general data availability and very large database maintenance, what everyone should know about security, including managed code, end-point security and securing the server, enterprise data management, including replication enhancements and operations management tools, features for database development, business intelligence, including the software's reporting capabilities, and a full chapter on code. He also provides data on the system and the server's built-in functions along with a variety of samples and exercises. Annotation ©2006 Book News, Inc., Portland, OR (booknews.com)

About the Author

Eric Brown's professional computing work began in earnest in 1996 when he began work at Multiple Zones International as a product manager. While there, he realized the next big wave was the Internet, and raced to get a job at a dot-com. He worked for three dot-coms before ending up on the SQL Server Product Team at Microsoft. At one point in his early DB years, they cut the edge of SQL Server capabilities by owning a 500GB data warehouse running SQL Server 7 and 2000. In the three years he was on the team, he ran “Yukon” readiness. Brown has written a column for SQL Server Magazine, and has written extensively about SQL Server for MSDN Magazine and MSDN online library. Since leaving Microsoft officially, he has worked on this book and started an e-commerce hosting company. He is now working for Quilogy as a senior consultant on the Business Intelligence National Practice.

 

 

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

 

 

Product Details

ISBN:
9780321349798
Author:
Brown, Eric
Publisher:
Addison-Wesley Professional
Author:
Brown, Eric L.
Subject:
Database management
Subject:
Client-server computing
Subject:
Database Management - SQL Server
Subject:
Database Management - General
Subject:
Database-SQL
Subject:
Database design
Copyright:
Edition Description:
Trade paper
Series:
Microsoft Windows Server System Series
Publication Date:
March 2006
Binding:
TRADE PAPER
Grade Level:
Professional and scholarly
Language:
English
Illustrations:
Y
Pages:
314
Dimensions:
9.18x7.42x.61 in. 1.05 lbs.

Other books you might like

  1. Microsoft SQL Server 2005 Stored... Used Trade Paper $30.00
  2. SQL Server 2005 T-SQL Recipes: A... New Trade Paper $59.99
  3. Cryptography in the Database: The... New Trade Paper $54.99
  4. Sql Server Security Distilled 2ND... New Trade Paper $49.99

Related Subjects

Computers and Internet » Database » Applications
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Software Management
Science and Mathematics » Mathematics » General

SQL Server 2005 Distilled Used Trade Paper
0 stars - 0 reviews
$5.98 In Stock
Product details 314 pages Addison-Wesley Professional - English 9780321349798 Reviews:
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.