Professional Microsoft SQL Server 2008 Programming
- 16h 49m
- Rob Vieira
- John Wiley & Sons (US)
- 2009
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.
About the Author
Experiencing his first infection with computing fever in 1978, Rob Vieira knew right away that this was something "really cool." In 1980 he began immersing himself into the computing world more fully — splitting time between building and repairing computer kits, and programming in BASIC as well as Z80 and 6502 assembly. In 1983, he began studies for a degree in Computer Information Systems, but found the professional mainframe environment too rigid for his tastes and dropped out in 1985 to pursue other interests. Later that year, he caught the "PC bug" and began the long road of programming in database languages from dBase to SQL Server. Rob completed a degree in business administration in 1990 and since has typically worked in roles that allow him to combine his unique knowledge of business and computing. Beyond his bachelor's degree, he has been certified as a Certified Management Accountant (CMA); Microsoft Certified as a Solutions Developer (MCSD), Trainer (MCT), and Database Administrator (MCDBA); and even had a brief stint certified as an Emergency Medical Technician (EMT).
Rob is currently the Database Team Lead for Stockamp, a Huron Consulting Group practice. He has published six books on SQL Server development.
In this Book
-
Being Objective: Re-Examining Objects in SQL Server
-
Tool Time
-
Asking a Better Question: Advanced Queries
-
XML Integration
-
Daring to Design
-
Core Storage and Index Structure
-
More Advanced Index Structures
-
Views
-
Scripts and Batches
-
Advanced Programmability
-
Transactions and Locks
-
Triggers
-
SQL Cursors
-
Reporting Services
-
Buying in Bulk: The Bulk Copy Program (BCP) and Other Basic Bulk Operations
-
Getting Integrated
-
Replication
-
Looking at Things in Full: Full-Text Search
-
Feeling Secure
-
A Grand Performance: Designing a Database That Performs Well
-
What Comes After: Forensic Performance Tuning
-
Administration
-
SMO: SQL Management Objects
-
Data Warehousing
-
Being Well Connected
