|
Professional Microsoft SQL Server 2008 Programming
and over one million other books are available for Amazon Kindle .
Learn more
| ||||||||||||||||||||
 Trade In this Item for up to £5.10
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in Professional Microsoft SQL Server 2008 Programming (Wrox Programmer to Programmer) for an Amazon.co.uk gift card of up to £5.10, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Frequently Bought Together
Product details
|
More About the Author
Product Description
Product Description
Master the increasingly complex feature set of the latest release of Microsoft SQL Server with the information in Professional Microsoft SQL Server 2008 Programming. Review the new features of SQL Server that will be of interest to you as an experienced developer and move on to more detailed, practical code examples. Learn how to write complex queries, build different types of data structures, improve application speed and performance, manage advanced scripting and errors, and design advanced databases the latest edition of this valuable programming guide.
From the Back Cover
By incorporating significant improvements to the core components of the database engine, Microsoft SQL Server 2008 will change the way you build database applications. Written by one of the leading authorities on SQL Server, Professional Microsoft SQL Server 2008 Programming will help you master this increasingly complex feature set so that you can manage data more efficiently.
Robert Vieira discusses the new features of SQL Server 2008 and progresses to more detailed, practical code examples. He then shows you how to write complex queries, build different data structures, and improve application performance. Plus, you′ll discover how to manage advanced scripting and databases, as well as how to identify and correct scripting errors.
This book provides you with the information you need to quickly create and deploy data–driven solutions to meet your business needs. It covers everything from the new data types and indexing structures to the manageability features and advanced time zone handling so that you can get the most out of your database.
What you will learn from this book
- Techniques for taking data design beyond normalization
Ways to ensure that your application is running at optimum speed
All about stored procedures and user defined functions
Advanced methods for handling stored procedures
How to utilize Reporting Services and Integration Services
Tips for making your database more secure
How to take advantage of XML and XQuery support
Steps for modifying specific data values to perform speculative analysis
Who this book is for
This book is for experienced SQL Server developers who want to learn how to take advantage of all the new features in the latest release.
Wrox Professional guides are planned and written by working programmers to meet the real–world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.
Inside This Book
(Learn More)
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
4 of 4 people found the following review helpful
Format:Paperback
I really like this book. It contains some material on pretty much all parts of SQL Server, aimed at the programmer rather than the DBA. It doesn't contain much introductory material (if you want to know what a join is a when you might use one, this isn't the book for you) but, that said, I'm a SQL Server newbie and I got along fine with it and didn't find much of it beyond my grasp.
My sole gripe is that its name is slightly misleading. If you want to know how to write C#/VB programs to access SQL Server via ADO.Net or Linq, this isn't the book for you: there's very little (none?) on that subject in here.
So, a firm recommendation, but make sure that it's the right book for you before buying.
My sole gripe is that its name is slightly misleading. If you want to know how to write C#/VB programs to access SQL Server via ADO.Net or Linq, this isn't the book for you: there's very little (none?) on that subject in here.
So, a firm recommendation, but make sure that it's the right book for you before buying.
3 of 3 people found the following review helpful
Format:Paperback
I'm a professional software engineer and have been working with MS SQL Server for 12 years now and other DBMS for 15 years. I bought this book to catch up with the 2008 version of the product and for reference.
My overall impression of this book is good. It covers all relevant aspects of MS SQL Server at a depth suitable for programmers and part-time DBAs, for example. The writing style does also reflect practical experience on projects with the product, which results in a balanced consideration of pros and cons of features from a practitioner's point of view blended with sufficient theory to help understanding and evaluation of design alternatives.
I have few criticisms of this book and they relate to specialist subjects mainly. The chapters on full-text search and replication, for example, do in my view not reflect practical experience (at least it isn't reported or obvious, and in particular there is no comparison with alternative concepts or other products). This is not serious, however, as these are very special subjects with whole books devoted to them in their own right. However, I have quite a bit of professional experience in both areas and when I read these two chapters I thought that they didn't highlight the really important practical problems, but rather regurgitate Microsoft's documentation in an abstract way. But clearly this is not a problem, unless a reader focuses on these two very special subject areas.
My overall impression of this book is good. It covers all relevant aspects of MS SQL Server at a depth suitable for programmers and part-time DBAs, for example. The writing style does also reflect practical experience on projects with the product, which results in a balanced consideration of pros and cons of features from a practitioner's point of view blended with sufficient theory to help understanding and evaluation of design alternatives.
I have few criticisms of this book and they relate to specialist subjects mainly. The chapters on full-text search and replication, for example, do in my view not reflect practical experience (at least it isn't reported or obvious, and in particular there is no comparison with alternative concepts or other products). This is not serious, however, as these are very special subjects with whole books devoted to them in their own right. However, I have quite a bit of professional experience in both areas and when I read these two chapters I thought that they didn't highlight the really important practical problems, but rather regurgitate Microsoft's documentation in an abstract way. But clearly this is not a problem, unless a reader focuses on these two very special subject areas.
2 of 3 people found the following review helpful
Format:Paperback
I have been using Professional SQL books by Robert Vieira since 2000. He always delivery the goods in an easy to follow format with good real world examples. This publication covers all the relevant topics and introduces a few extra.
Great book
Great book
Would you like to see more reviews about this item?
Were these reviews helpful?
Let us know
Listmania!
|
|
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
