By incorporating significant improvements to the core components ofthe database engine, Microsoft SQL Server 2008 will change the wayyou build database applications. Written by one of the leadingauthorities on SQL Server, Professional Microsoft SQL Server 2008Programming will help you master this increasingly complex featureset so that you can manage data more efficiently.
Robert Vieira discusses the new features of SQL Server 2008 andprogresses to more detailed, practical code examples. He then showsyou how to write complex queries, build different data structures,and improve application performance. Plus, you'll discover how tomanage advanced scripting and databases, as well as how to identifyand correct scripting errors.
This book provides you with the information you need to quicklycreate and deploy data-driven solutions to meet your businessneeds. It covers everything from the new data types and indexingstructures to the manageability features and advanced time zonehandling 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 optimumspeed
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 speculativeanalysis
Who this book is for
This book is for experienced SQL Server developers who want tolearn how to take advantage of all the new features in the latestrelease.
Wrox Professional guides are planned and written byworking programmers to meet the real-world needs of programmers,developers, and IT professionals. Focused and relevant, theyaddress the issues technology professionals face every day. Theyprovide examples, practical solutions, and expert education in newtechnologies, all designed to help programmers do a better job.