Professional Microsoft Sql Server 2008 Programming

Informationen zum Autor 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 EmergencyMedical 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 Klappentext 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. Zusammenfassung 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. Inhaltsverzeichnis Introduction.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.Index. ...

List of contents

Introduction.

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.

Index.

Product details

• Authors: Robert Vieira
• Publisher: Wiley, John and Sons Ltd
• Languages: English
• Product format: Paperback / Softback
• Released: 10.04.2009
• EAN: 9780470257029
• ISBN: 978-0-470-25702-9
• No. of pages: 936
• Series: Wrox Programmer to Programmer; Wrox Programmer to Programmer
• Subject: Natural sciences, medicine, IT, technology > IT, data processing > Application software