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.
Chapter 1: Being Objective: Re–Examining Objects in SQL Server.
Chapter 2: Tool Time.
Chapter 3: Asking a Better Question: Advanced Queries.
Chapter 4: XML Integration.
Chapter 5: Daring to Design.
Chapter 6: Core Storage and Index Structure.
Chapter 7: More Advanced Index Structures.
Chapter 8: Views.
Chapter 9: Scripts and Batches.
Chapter 10: Advanced Programmability.
Chapter 11: Transactions and Locks.
Chapter 12: Triggers.
Chapter 13: SQL Cursors.
Chapter 14: Reporting Services.
Chapter 15: Buying in Bulk: The Bulk Copy Program (BCP) and Other BasicBulkOperations.
Chapter 16: Getting Integrated.
Chapter 17: Replication.
Chapter 18: Looking at Things in Full: Full–Text Search.
Chapter 19: Feeling Security.
Chapter 20: A Grand Performance: Designing a Database That Performs Well.
Chapter 21: What Comes After: Forensic Performance Tuning.
Chapter 22: Administration.
Chapter 23: SMO: SQLManagement Objects.
Chapter 24: Data Warehousing.
Chapter 25: BeingWell Connected.
Appendix A: System Functions.
Appendix B: Going Meta: Getting Data About Your Data.
Appendix C: The Basics.