SQL Server 2000 stored procedures handbook
Tony Bain, Louis Davidson, Robin Dewson, Chuck Hawkins
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.
Contents
- 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 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
