Pro SQL Server 2005

( 1 )

Overview

SQL Server 2005 is a dramatically expanded and enhanced version of SQL Server 2000 that not only makes SQL Server a true enterprise-level RDBMS, but also changes how SQL Server professionals design databases and develop database applications.

Pro SQL Server 2005 provides in-depth coverage of new SQL Server features and enhancements. It focuses on what experienced SQL Server database administrators, developers, and business intelligence practitioners need to know to get up to ...

See more details below
Paperback
$29.35
BN.com price
(Save 41%)$49.99 List Price
Other sellers (Paperback)
  • All (30) from $1.99   
  • New (7) from $9.41   
  • Used (23) from $1.99   
Sending request ...

Overview

SQL Server 2005 is a dramatically expanded and enhanced version of SQL Server 2000 that not only makes SQL Server a true enterprise-level RDBMS, but also changes how SQL Server professionals design databases and develop database applications.

Pro SQL Server 2005 provides in-depth coverage of new SQL Server features and enhancements. It focuses on what experienced SQL Server database administrators, developers, and business intelligence practitioners need to know to get up to speed with SQL Server 2005 as quickly as possible. It carefully presents each new feature and precisely illustrates the feature with examples that show you how to use it effectively.

The authors provide practical, in-depth coverage of the core topics that they specialize inall supported by realistic examples, so you’ll be able to design and implement your own SQL Server 2005 solutions quickly and painlessly. This book is a roadmap for exploring and exploiting SQL Server 2005. So fasten your seatbelts, start your computers, and race to mastery of SQL Server 2005!

Read More Show Less

Editorial Reviews

From Barnes & Noble
The Barnes & Noble Review
If you’ve built or managed SQL Server applications before, here’s your fastest route to SQL Server 2005 mastery. Apress’s team of SQL Server experts cover every significant enhancement that’s relevant to application developers, designers, and administrators, from its improved management tools to its built-in .NET common language runtime.

DBAs will especially appreciate the authors’ coverage of new T-SQL commands that’ll simplify their lives: notably DDL triggers for auditing database object changes, as well as new metadata views (goodbye system tables, and good riddance). Meanwhile, developers will simply devour the authors’ coverage of .NET integration, programming with assemblies, and XML support.

That’s not all: This book contains thorough introductions to SQL Server 2005’s souped-up reporting, analysis, and integration services; new ways to streamline and automate monitoring; and a full chapter on security, from permissions to encryption. Bill Camarda, from the December 2005 Read Only

Read More Show Less

Product Details

  • ISBN-13: 9781590594773
  • Publisher: Apress
  • Publication date: 11/7/2005
  • Series: Pro Series
  • Edition number: 1
  • Pages: 704
  • Product dimensions: 9.25 (w) x 7.50 (h) x 1.47 (d)

Meet the Author

Robin Dewson has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He has been working with SQL Server since version 6.5 and Visual Basic since version 5. Robin is a consultant mainly in the city of London, where he has been for nearly eight years. He also has been developing a rugby-related website as well as maintaining his own site at Fat-Belly.com.

Adam Machanic is an independent database software consultant, writer, and speaker based in Boston. He has implemented SQL Server solutions for a variety of high-availability online transaction processing and large-scale data warehouse applications, and also specializes in .NET data access layer performance optimization. Adam has written for SQL Server Professional and TechNet magazines, serves as the SQL Server 2005 Expert for SearchSQLServer.com, and has contributed to several books on SQL Server, including Pro SQL Server 2005 (Apress, 2005). He regularly speaks at user groups, community events, and conferences on a variety of SQL Server and .NET-related topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server and a Microsoft Certified IT Professional (MCITP).

When not sitting at the keyboard pounding out code or code-related prose, Adam tries to spend a bit of time with his wife, Kate, and daughter, Aura, both of whom seem to believe that there is more to life than SQL.

Adam blogs at http://www.sqlblog.com, and can be contacted directly at amachanic@datamanipulation.net.

Jan D. Narkiewicz is chief technical officer of Software Pronto, Inc. His areas of expertise include Microsoft technologies, Oracle, and DB2. Jan also writes books for Apress and serves as academic coordinator for the University of California, Berkeley Extension's .NET/Windows program. His clients include E*TRADE, Visa, eBay, and Oracle.

Tom Rizzo is a director in the SQL Server group at Microsoft. Being an 11-year veteran at Microsoft, Tom has worked on a number of the different Microsoft server technologies such as BizTalk, SharePoint and Exchange Server before joining the SQL Server group. Tom is a published author on topics ranging from SQL Server to developing collaborative applications using Microsoft's collaboration servers.

Joseph Sack is a Principal Consultant with SQLskills. He has worked as a SQL Server professional since 1997 and has supported and developed for SQL Server environments in financial services, IT consulting, manufacturing, retail, and the real estate industry. Prior to joining SQLskills, he worked at Microsoft as a Premier Field Engineer supporting very large enterprise customer environments. He was responsible for providing deep SQL Server advisory services, training, troubleshooting, and ongoing solutions guidance. His areas of expertise include performance tuning, scalability, T-SQL development, and high-availability. In 2006 Joe earned the Microsoft Certified Master: SQL Server 2005 certification; and in 2008, he earned the Microsoft Certified Master: SQL Server 2008 certification. In 2009 he took over responsibility for the SQL Server Microsoft Certified Master program and held that post until 2011. He is the author of a few books and white papers, including most recently, SQL Server 2008 Transact-SQL Recipes (Apress, 2008). Joe's blog is at www.SQLskills.com/blogs/joe, and he can be reached at joe@SQLskills.com.

Rob Walters is a data platform technology specialist for Microsoft. His extensive experience with Microsoft SQL Server began over 10 years ago when he worked as a consultant for Microsoft Consulting Services in Denver, Colorado. Shortly after the dot-com bubble burst, Walters returned to Microsoft s headquarters and worked as a program manager in the SQL Server product unit. There, he owned various features within SQL Server including SQL Server Agent, various management features, and the security for the database engine. Walters has co-authored three patents for technologies used within SQL Server.

Walters has also co-authored Programming Microsoft SQL Server 2005 by Microsoft Press, and Pro SQL Server 2005, Accelerated SQL Server 2008, and Beginning SQL Server 2008 Database Administration by Apress. He holds a bachelor's of science degree in electrical engineering from Michigan State University and a master's degree in business administration from Seattle University. When not at work, he is very active in his community as an on-call firefighter.

Julian Skinner has been developing applications for over a decade. He has used a variety of Microsoft development technologies to create applications for both commercial and government entities on the Microsoft .NET platform. During his time as both a software developer and an IT consultant, he has been a part of all aspects of the SDLC, ranging from technical requirements gathering to deployment in large-scale environments. He has designed databases, implemented business logic components, and designed user interfaces for both Windows and web applications.

Louis Davidson has been in the IT industry for more than 15 years as a corporate database developer and architect. He has spent the majority of his career working with Microsoft SQL Server, beginning from the early days of version 1.0. He has a bachelor s degree from the University of Tennessee at Chattanooga in computer science, with a minor in mathematics. Louis is the data architect for Compass Technology (Compass.net) in Chesapeake, Virginia, leading database development on their suite of nonprofit oriented CRM products, built on the Microsoft CRM platform and SQL Server technologies.

Read More Show Less

Table of Contents

Ch. 1 SQL Server overview and installation 1
Ch. 2 SQL Server management technologies 25
Ch. 3 T-SQL enhancements for developers 53
Ch. 4 T-SQL enhancements for DBAs 103
Ch. 5 .Net integration 135
Ch. 6 Programming assemblies 161
Ch. 7 SQL Server and XML 207
Ch. 8 SQL Server 2005 XML and XQuery support 247
Ch. 9 SQL Server 2005 reporting services 287
Ch. 10 Analysis services 347
Ch. 11 Security 387
Ch. 12 Service broker 419
Ch. 13 Automation and monitoring 459
Ch. 14 Integration services 507
Ch. 15 Database mirroring 567
Ch. 16 Notification services 609
Read More Show Less

Customer Reviews

Average Rating 5
( 1 )
Rating Distribution

5 Star

(1)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted December 8, 2006

    Great Introduction to SQL Server 2005

    This is one of my favourite introduction books on SQL Server 2005, ideal if you are new or converting from a previous version. Useful to both DBAs and Programmers, it is readable from cover to cover.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)