Professional SQL Server 2005 Programming

Robert Vieira - Collection Programmer to Programmer

884 pages, parution le 05/12/2006

Ajouter à une liste

Indisponible

Résumé

At long last, the eagerly anticipated new release of SQL Server has arrived. However, with this complex new version of Microsoft SQL Server 2005 comes a surfeit of original features and refinements, demanding that even the most experienced developers hit the books in order to learn the vastly changed features of this product.

After moving quickly through a brief review of the basic concepts of SQL Server, Robert Vieira places the focus of his attention on how to master the substantially revamped SQL Server 2005, providing extensive code examples where helpful. You'll soon get a handle on the advanced abilities of developing systems and applications that both meet your performance needs and store your data in a fashion that maintains the integrity of the data while keeping it reasonably usable.

What you will learn from this book

The various add-on services, as well as advanced programming constructs and supporting object models
Backward compatibility issues with SQL Server 2000 and 7.0
Ways to work with the completely rewritten SQL Server Integration Services (formerly known as Data Transformation Services)
The new functionality of Analysis Manager and the new Reporting Services engine
How the new Notification Services engine allows you to subscribe to customizable events on your server or to specific data activity

Who this book is for

This book is for experienced SQL Server developers who are looking for thorough coverage of the extensive changes found in Microsoft SQL Server 2005.

Sommaire

Being Objective: Re-Examining Objects in SQL Server
Tool Time
Basic T-SQL
Creating and Altering Tables
Reviewing Keys and Constraints
Asking a Better Question: Advanced Queries
Daring to Design
SQL Server - Storage and Index Structures
Views
Scripts and Batches
Getting Procedural: Stored Procedures and User-Defined Functions
Transactions and Locks
Triggers
Nothing But NET!
SQL Cursors
XML Integration
Reporting for Duty, Sir!
Buying in Bulk: the Bulk Copy Program (BCP) and Other Basic Bulk Operations
Getting Integrated
Replication
Looking at Things in Full: Full-Text Search
Security
Playing a Good Tune: Performance Tuning
Administrator
SMO: SQL Management Objects
Appendix A: System Functions
Appendix B: Connectivity
Appendix C: Getting Service
Index

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wrox Press
Auteur(s)	Robert Vieira
Collection	Programmer to Programmer
Parution	05/12/2006
Nb. de pages	884
Format	18,5 x 23,5
Couverture	Broché
Poids	1220g
Intérieur	Noir et Blanc
EAN13	9780764584343
ISBN13	978-0-7645-8434-3