—Karen Watterson,Editor,Pinnacle Publishing's SQL Server Professional
"Finally! This book dedicated to T-SQL Stored Procedure development is long overdue. . . a must have for the developer who is serious about creating powerful and scalable SQL Server 2000 architectures. "
—Ed Musters,Chief Technology Officer,Sage Information Consultants,Inc.
Design,deploy,and manage stored procedures in enterprise data applications SQL Server 2000 Stored Procedure Programming shows you how to use Transact-SQL to design,debug,and manage custom stored procedures,functions,and triggers. You'll learn to manage SQL Server resources using new features of Enterprise Manager,Query analyzer,Visual Basic,and Visual Studio,implement robust error handling,and establish the professional habits you need to become an expert SQL Server developer. This guide contains simple explanations for developers who are just starting to work with stored procedures and advanced recommendations and techniques for experienced DBAs. SQL Server stored procedures and advanced recommendations and techniques for experienced DBAs. SQL Server experts provide concise explanations,design recommendations,many examples,and a real-world case study.
Microsoft SQL Server is the relational database management system (RDBMS) of choice for a growing number of business organizations and professional database and application developers. The reasons for this growing popularity are quite simple: Integration No other RDBMS integrates as fully and cleanly with applications and integrated development environments (IDES) designed to run on the ubiquitous Microsoft Windows platform.
Power SQL Server makes large amounts of data available to large numbers of concurrent users while maintaining the security and integrity of the data. At the time of this writing, SQL Server holds the record in TPC-C benchmark tests for performance and price/ performance (see www.tpc.org).
When we began working with SQL Server, reference materials relating to the development and deployment of stored procedures were rare and not particularly helpful. These materials described basic concepts, but the examples presented were often trivial and not complex enough to be applied to real-world situations in which aspects such as error handling, debugging, naming conventions, and interfaces to other applications are critical. As the legions of application developers and development DBAs migrate from Microsoft Access to SQL Server, and as SQL Server becomes the RDBMS of choice for mission-critical application development, the need for more advanced work on SQL Server stored procedures becomes even more critical.
This book has been written to fill this gap, and thus it has been written with a wide audience in mind. Ideally, it will be neither the first nor the last book you read on SQL Server, but it may be the one you refer to and recommend the most. Above all, this book has been written to help professional developers get the most out of SQL Server stored procedures and produce quality work for their clients. If you are an experienced SQL Server developer, you will find this book to be an essential reference text full of tips and techniques to help you address the development issues you encounter in the course of your day-to-day development activities.
If you have some experience with SQL Server development, but substantially more in other programming environments such as Visual Basic, you will find this book useful as a tool to orient yourself with the SQL Server environment and become proficient more quickly with SQL Server stored procedure concepts and methods. If you are a novice SQL Server developer, the concepts, tips, and techniques you will learn in reading this book and working through the exercises will help you attain the knowledge, skills, and good habits that will make you an accomplished professional.
We hope that this book remains close to your workstation for a long time. Indeed, in the course of this book's useful life, you may in turn be all three of the users just described.
All chapters in this book (aside from the one you are reading, which is introductory in nature) provide conceptual grounding in a specific area of the SQL Server development landscape...
Anonymous
Posted Thu Jul 11 00:00:00 EDT 2002
This book offers more real-life examples than many database books. I've found it to be very helpful.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.Anonymous
Posted Thu Oct 26 00:00:00 EDT 2000
I used to work a lot in Microsoft Access, but since Microsoft released MSDE as part of Access 2000, I am doing a lot more SQL Server projects. I recommend this book to you if you need to learn about TSQL and stored procedure development. However, this book is probably not the best place to start if you need to learn about basic database concepts like tables, indexes and select, update and insert statements. It's definitely for the intermediate to senior database developer. You should definitely get this book if you want to improve your ability to build complex stored procedures systematically.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.Anonymous
Posted Sun Oct 22 00:00:00 EDT 2000
Finally good book on the market for stored procedures. This book 'shoots' directly at the hart of problem. Developers need tips and advanced technics, and you have it here. I recommend this book for every professional who want to be the best in DB programming. Try it, you'll find for long time searched solutions, I suppose. Regards Nikola
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.Anonymous
Posted Sun Oct 22 00:00:00 EDT 2000
This is a very readable book for those who need to learn to write stored procedures for Microsoft SQL Server 2000 (and 7.0). Descriptions are concise, examples are extensive, and new features (such as user-defined functions and XML) are covered well. There were some minor annoyances. For example, in talking about optimistic locking the authors made two 'mistakes'. First, they were too broad in calling out when not to use pessimistic locking. They essentially end up saying never, while they seem to want to say that you should never hold a lock while waiting for user input. Then they describe optimistic locking by talking about the undocumented TSEQUAL function. Usually if Microsoft doesn't document a function it means they may remove it in the future. So the authors may be leading readers down a bad path. But otherwise, their advice is sound.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Overview
—Karen Watterson,Editor,Pinnacle Publishing's SQL Server Professional
"Finally! This book dedicated to T-SQL Stored Procedure development is long overdue. . . a must have for the developer who is serious about creating powerful and scalable SQL Server 2000 architectures. "
—Ed Musters,Chief Technology Officer,Sage Information Consultants,Inc.