SQL Server 2005 T-SQL Recipes

A Problem-solution Approach

Joseph Sack - Collection The Expert's Voice in SQL Server

750 pages, parution le 16/12/2005

Ajouter à une liste

Indisponible

Résumé

SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach

Need to brush up on specific SQL Server tasks, procedures, or Transact-SQL commands? Not finding what you need from SQL Server books online? Or perhaps you just want to familiarize yourself with the practical application of new T-SQL-related features. SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach is an ideal book, whatever your level as a DBA or developer.

This "no-fluff" desk reference offers direct access to the information you need to get the job done. It covers basic T-SQL data manipulation, the use of stored procedures, triggers and UDFs, and advanced T-SQL techniques for database security and maintenance. It also provides hundreds of practical recipes that describe the utilities of features and functions, with a minimim of background theory.

Additionally, this book provides "how-to" answers to common SQL Server T-SQL questions, conceptual overviews, and highlights of new features introduced in SQL Server 2005. It also features concise T-SQL syntax examples, and you can use the book to prepare for a SQL Server-related job interview or certification test.

L'auteur - Joseph Sack

is a database administration and developer consultant based in Minneapolis, Minnesota. Since 1997, he has been developing and supporting SQL Server environments for clients in financial services, IT consulting, manufacturing, and the real estate industry. He is a Microsoft Certified Database Administrator (MCDBA). Sack received his bachelors degree in Psychology from the University of Minnesota. He is the author of SQL Server 2000 Fast Answers for DBAs and Developers.

Sommaire

SELECT
INSERT, UPDATE, DELETE
Transactions, Locking, Blocking, and Deadlocking
Tables
Indexes
Full-Text Search
Views
SQL Server Functions
Conditional Processing, Control-Of-Flow, and Cursors
Stored Procedures
User-Defined Functions and Types
Triggers
CLR Integration
XML
Web Services
Error Handling
Principals
Securables and Permissions
Encryption
Service Broker
Configuring and Viewing SQL Server Options
Creating and Configuring Databases
Database Integrity and Optimization
Maintaining Database Objects and Object Dependencies
Database Mirroring
Database Snapshots
Linked Servers and Distributed Queries
Performance Tuning
Backup and Recovery

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Apress
Auteur(s)	Joseph Sack
Collection	The Expert's Voice in SQL Server
Parution	16/12/2005
Nb. de pages	750
Format	18 x 23,5
Couverture	Broché
Poids	1190g
Intérieur	Noir et Blanc
EAN13	9781590595701
ISBN13	978-1-59059-570-1