SQL Server 2000 stored procedures handbook

Tony Bain, Louis Davidson, Robin Dewson, Chuck Hawkins

274 pages, parution le 30/10/2003

Ajouter à une liste

Indisponible

Résumé

Stored procedures are compiled T-SQL statements that reside on the database, and are the cornerstone of successful data manipulation; data-handling operations of any complexity make use of them. This book is an in-depth guide to a key area of database development.

This book tackles real-world problems faced by developers when working with stored procedures, showing how to solve these problems, avoid the common pitfalls and work around them, to produce faster, more robust stored procedures. Put simply: if you want to write better stored procedures, then this is the book for you.

Introduction
Stored Procedures Overview
Optimizing and Debugging
Concurrency, Cursors and Transactions
Common Practices with Stored Procedures
System Stored Procedures
User Defined Functions
Triggers
Security
Appendix
Index

L'auteur - Tony Bain

Tony Bain - Tony Bain is the founder of Tony Bain & Associates and he has worked with SQL Server for the last 6 years. He is passionate about all database technologies especially when they relate to enterprise availability and scalability. Tony currently has Microsoft Certified System Engineer, Microsoft Certified Solution Developer, and Microsoft Certified Database Administrator certification.

L'auteur - Louis Davidson

Louis Davidson - Louis has been in the IT industry for ten years, as a corporate database developer and architect. He is currently a database administrator for Compass Technology Management, supporting the Christian Broadcasting Network and NorthStar Studios in Nashville, TN. Davidson has a bachelor's degree from the University of Tennessee at Chattanooga in computer science with a minor in mathematics The majority of his experience has been spent with Microsoft SQL Server from version 1.0 to the latest version that is in Beta. His areas of expertise are database architecture and coding in T-SQL, and he has written thousands of stored procedures and triggers through the years.

L'auteur - Robin Dewson

Robin Dewson - Robin Dewson: Robin has been hooked on programming ever since he bought his first computer in 1980, a Sinclair ZX80. His first main application of his own was a Visual FoxPro application that could be used to run a Fantasy League system. It was at this point he met up with a great help in his PC development life, Jon Silver at Step One Technologies, where in return for training, he helped Jon with some other Visual FoxPro applications. From there, realizing that the market place for Visual FoxPro was limited, he decided to learn Visual Basic and SQL Server. Starting out with SQL Server 6.5, he soon moved to SQL Server 7 and Visual Basic 5 and became involved in developing several applications for clients both in the UK and the US. From there he moved to SQL Server 2000 and Visual Basic 6. Robin currently is consulting at Lehman Brothers in London, where he has been for nearly 5 years, using Visual Basic 6 and Sybase on a trading system called Kojak. Robin is also the author of Beginning SQL Server 2000 Programming.

L'auteur - Chuck Hawkins

Chuck Hawkins - Chuck Hawkins is a senior consultant and database administrator in Virginia Beach, VA. He works for Compass Technology Management where he manages the daily ups and downs of multiple servers for several large ministries. He has extensive experience in T-SQL programming, replication, performance tuning, developer management, and routine server management. Chuck has spoken at the Professional Association for SQL Server conferences in the US and UK. He has contributed columns to several magazines and was a contributing author to Professional SQL Server 2000 Database Design.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Apress
Auteur(s)	Tony Bain, Louis Davidson, Robin Dewson, Chuck Hawkins
Parution	30/10/2003
Nb. de pages	274
Format	15 x 23
Couverture	Broché
Poids	450g
Intérieur	Noir et Blanc
EAN13	9781590592878
ISBN13	978-1-59059-287-8