Professional Microsoft SQL Server 2008 Programming - Couverture souple

Vieira, Robert

Couverture souple

ISBN 10 : 0470257024 ISBN 13 : 9780470257029

Editeur : Wrox Press, 2009

Synopsis

Rare Book

A propos du livre

Quatrième de couverture

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.

Présentation de l'éditeur

This book is written for SQL Server 2008. However, it does maintain roots going back a few versions and looks out for backward compatibility issues with SQL Server 2005 and SQL Server 2000. These versions are old enough that there is little to no time spent on them except in passing.

The book is oriented around developing on SQL server. Most of the concepts are agnostic to what client language you use although the examples that leverage a client language general do so in C#. For those who are migrating from early versions of SQL Server, some gotchas that exist any time a product has versions are discussed to the extent that they seem to be a genuinely relevant issue.

This book assumes that you have some experience with SQL Server and are at an intermediate to advanced level. The orientation of the book is highly developer focused. While there is a quick reference–oriented appendix, there is very little coverage given to beginner level topics. It is assumed that you already have experience with data manipulation language (DML) statements and know the basics of the mainstream SQL Server objects (views, stored procedures, user defined functions, etc.). If you would like to brush up on your knowledge before diving into this book, the author recommends reading Beginning SQL Server 2008 Programming first. There is very little overlap between the Beginning and Professional books and they are designed to work as a pair.

Détails de l'édition

• Éditeur: Wrox Press
• Date d'édition: 2009
• ISBN 10: 0470257024
• ISBN 13: 9780470257029
• Reliure: Broché
• Langue: anglais
• Nombre de pages: 936