SQL Server 2000 Stored Procedures Handbook (Expert's Voice) [Paperback]

Tony Bain (Author), Louis Davidson (Author), Robin Dewson (Author), Chuck Hawkins (Author), Tony Bain (Author), Louise Davidson (Author), Robin Dewson (Author), Chuck Hawkins (Author)

Book Description

ISBN-10: 1590592875 | ISBN-13: 978-1590592878 | Publication Date: September 29, 2003 | Edition: 1

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.

Editorial Reviews

About the Author

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. Other books include: VB.NET & SQL Server 2000: Building an Effective Data Layer (co-author); SQL Server 2000 Stored Procedure Handbook (co-author), Beginning SQL Server 2000 Programming (contributing); Professional SQL Server 2000 Data Warehousing with Analysis Services (contributing).

Louis Davidson: Louis has been in the IT industry for ten years, as a corporate database developer and architect. Currently, he is serving as 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 experiencehas been spent with Microsoft SQL Server from version 1.0 to whatever latest version that is in Beta. Louis' primary areas of expertise are in database architecture and coding in Transact-SQL, and he has written thousands of stored procedures and triggers throughout the years. Louis is the author of Professional SQL Server 2000 Database Design.

 

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 author of the successful Beginning SQL Server 2000 Programming book and has contributed to other successful books, including Professional Access 2000 Programming, Professional SQL Server Development with Access 2000, Professional SQL Server DTS, and Professional SQL Server 2000 Programming.

Chuck Hawkins: Chuck 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 Professional Association for SQL Server conferences in Chicago, London, Denver and Seattle. He has contributed columns to several magazines and was a contributing author to Professional SQL Server 2000 Database Design.

Product Details

• Paperback: 266 pages
• Publisher: Apress; 1 edition (September 29, 2003)
• Language: English
• ISBN-10: 1590592875
• ISBN-13: 978-1590592878
• Product Dimensions: 9.2 x 7.5 x 0.8 inches
• Shipping Weight: 1 pounds (View shipping rates and policies)
• Amazon Best Sellers Rank: #1,900,112 in Books (See Top 100 in Books)

More About the Author

I grew up in Symington in Lanarkshire where my mum and dad had a local post office and grocers. I went to school in the village being the only boy in my class for a number of years. Trust me, at 7 or so, it wasnt as cracked up as you may think. I then on to Biggar for my secondary education. I hated it like mad and was so glad when I could leave. Having gained sufficient qualifications and found interest in computers through the Sinclair ZX80 it was time to move on and thanks solely to my mother and father who trawled the papers looking for jobs and colleges, I ended up at Motherwell Technical College where I gained an SOND in Computer Data Processing. This was a one year course giving the basis of working with mainframes as well as programming them.
Having studied at Motherwell Technical College as it was then named, just across the road from Fir Park football ground home of Motherwell FC, including day release at Ravesncraig Steel woorks, I then moved to two years at the Scottish College of Textiles (S.C.O.T) in Galashiels. Although a textile college this was one of the best colleges for computing due to the small class sizes and the great facilities there. Again this was teaching programming on an IBM mainframe using COBOL. This was also where I met my first real computer game, Collossus Cave! An excellent adventure that kept most of the students engrossed for months! I also met some of the best people at this college, a few who I still keep in contact with. College is a great place to move in to adult hood

From S.C.O.T. I found my first job which was with Texas Instruments in Bedford. This is was a whole new set of thinking with working in a big organisation where you compiled your code on a mainframe in Dallas from your computer in England. It was hard work and I was so wet behind the ears at that time. I wish I knew then what I know now and it would have been such a more pleasant experience.

I stayed with Texas Instruments for just over a year having been under the wing of a big Brian Nicholson. I met some great people there as well but time moved on and I ended up in Hemel Hempstead with Atlas Copco. This was a bad move for me which soon became apparent for many reasons so just over a year later I ended up with Link Associates in Chesham, Bucks. A software house by trade, gave me great exposure and a confidence boost not only in work levels but in self motivation, all given by the great guiding hand of Val Dromgoole.

After just over 2 years it was time to break out on my own as a consultant. Being a consultant gives you the freedom of choice, the freedom to change jobs at will, the freedom to move around and the freedom of office politics. Well, when I say break out on my own and look for these freedoms, my first consultancy lasted just over 8 years with Save & Propser in Romford, Essex, England. Still on mainframes I used a Computer Associates product called Ideal, which was far from the name suggested. It was restrictive but did get me away from the mundane that COBOL had become in my life.

I then moved to FoxPro and FoxBase almost at the same time, using FoxPro to write a generic Fantasy game simulation and FoxBase to look after a postal football game I inherited called Sick Parrot. What a great game that was and at this present time play an internet based version found here.

I soon learned the restrictedness of having the programming language along side the database language and so moved in to Visual Basic (v5) and SQL Server (6.5). Very soon after version 7 of SQL Server came along so I moved straight to there and avoid some of the problems with 6.5 solutions.

Moving from this point I have moved through Visual Basic 6, ASP, SQL Server 2000 to SQL Server 2005, C#, Visual Basic .Net and now learning ASP.NET and Java.