Product Description

Use this comprehensive tutorial and reference to increase productivity and write stored procedures using the language with which you′re most familiar. The revised content covers new features such as XML integration, Web services, the .NET Common Language Runtime (CLR), and security updates, making this book a must for any developer or database administrator transitioning to the new version of SQL Server. You′ll learn to develop SQL Server database and data connections, administer SQL Server, and keep databases performing at their peak. In addition, you′ll find dozens of specific examples in both a graphical format and as SQL code as well as numerous best practices describing the most effective way to accomplish a given task. A companion Web site provides all of the code examples found in the book.

Product Details

• Amazon Sales Rank: #168080 in Books
• Published on: 2006-11-03
• Original language: English
• Number of items: 1
• Binding: Paperback
• 1344 pages

From the Back Cover
Develop and manage a SQL Server 2005 database like a pro

Seasoned database developers think inside the box, because that′s where the cool code is. This comprehensive reference takes you inside the latest, coolest, and most powerful box, Microsoft′s SQL Server 2005. Each of the book′s seven sections focuses on key elements in a logical sequence, so you can easily find what you need—including all the basics, best practices, dozens of targeted examples, and sample code. If you develop, manage, or maintain SQL Server 2005 databases, this in–depth book is what you need to succeed!

• Master the fundamentals of SQL Server technology
• Write better logic queries for greater success
• Manage and secure a production database 24/7/365
• Integrate with .NET CLR and XML
• Understand SOA and emerging technologies
• Meet business intelligence goals with new tools
• Measure performance, lock transactions, and scale very large databases

About the Author
Paul Nielsen, Microsoft SQL Server MVP, is an author, hands–on database developer, and trainer specializing in data architecture and Microsoft SQL Server tech?nologies. Besides holding several certifications, he is the Subject Matter Expert (SME) for the Microsoft Official Course, 2784: Tuning and Optimizing Queries using Microsoft SQL Server 2005. Visit www.sqlserverbible.com, where he hosts screencasts that walk readers through many tasks in the SQL Server 2005 Bible. The site also includes sample databases, sample code, hot SQL Server links, and additional articles and white papers.

Customer Reviews

Great SQL 2005 Book
This book is very help to understand what is the inside of Microsoft SQL Server 2005. This book is for anyone, novice or experienced who wants to learn about query tuning. It has enough beginning discussion to be useful to the novice, and it has enough detail to be useful to experienced DBAs and developers.

A comprehensive reference
As an experienced web developer and database programmer, but who hasn't used SQL Server very much, I was looking to grow my understanding of the capabilities of SQL Server as much as for a detailed reference. This book didn't really achieve the former, but has turned out to be the most useful paper reference we've got.

It seems to have an overview of all the functionality available in the SQL Server suite, though I don't understand all the terminology used. Although the logic behind the organisation of such a large book is difficult for me to understand, there's an extensive index which enabled me to find the things I've been looking for over the past six months.