Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Defensive Database Programming with SQL Server

Buy

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment. Too often as developers, we stop work as soon as our code passes a few basic tests to confirm that it produces the 'right result' in a given use case. We do not stop to consider what other possible ways in which the code might be used in the future, or how our code will respond to common changes to the database environment, such as a change in the database language setting, or a change to the nullability of a table column, and so on. In the short-term, this approach is attractive; we get things done faster. However, if our code is designed to be used for more than just a few months, then it is very likely that such changes can and will occur, and the inevitable result is broken code or, even worse, code that silently starts to behave differently, or produce different results. When this happens, the integrity of our data is threatened, as is the validity of the reports on which critical business decisions are often based. At this point, months or years later, and long after the original developer has left, begins the painstaking process of troubleshooting and fixing the problem. Would it not be easier to prevent all this troubleshooting from happening? Would it not be better to spend a little more time and effort during original development, to save considerably more time on troubleshooting, bug fixing, retesting, and redeploying? This is what defensive programming is all about: we learn what can go wrong with our code, and we proactively apply this knowledge during development. This book is filled with practical, realistic examples of the sorts of problems that beset database programs, including:

- Changes in database objects, such as tables, constraints, columns, and stored procedures.

- Changes to concurrency and isolation levels.

- Upgrades to new versions of SQL Server.

- Changes in requirements.

- Code reuse.

- Problems causing loss of data integrity.

- Problems with error handling in T-SQL.

In each case, it demonstrates approaches that will help you understand and enforce (or eliminate) the assumptions on which your solution is based, and to improve its robustness. Ultimately, the book teaches you how to think and develop defensively, and how to proactively identify and eliminate potential vulnerabilities in T-SQL code.

(HTML tags aren't allowed.)

Artificial Intelligence in Theory and Practice: IFIP 19th World Computer Congress, TC 12: IFIP AI 2006 Stream, August 21-24, 2006, Santiago, Chile
Artificial Intelligence in Theory and Practice: IFIP 19th World Computer Congress, TC 12: IFIP AI 2006 Stream, August 21-24, 2006, Santiago, Chile
This volume presents proceedings from the 19th IFIP World Computer Congress in Santiago, Chile. The proceedings of the World Computer Congress are a product of the gathering of 2,000 delegates from more than 70 countries to discuss a myriad of topics in the ICT domain. Of particular note, this marks the first time that a World Computer Congress has...
A Guide to the Wireless Engineering Body of Knowledge (WEBOK)
A Guide to the Wireless Engineering Body of Knowledge (WEBOK)
The ultimate reference book for professionals in the wireless industry

The information presented in this book reflects the evolution of wireless technologies, their impact on the profession, and the industry's commonly accepted best practices. Organized into seven main areas of expertise, A Guide to the Wireless...

IP in Wireless Networks
IP in Wireless Networks

The complete network professional's guide to delivering wireless IP.

  • Wireless IP: the professional's guide to understanding data in wireless networks
  • Covers IP in 802.11, Bluetooth(tm), GSM/GPRS, W-CDMA, cdma2000, i-mode, and more
  • Includes expert insights into architecture, mobility models, and...

Fuzzy Reasoning in Information, Decision and Control Systems (Intelligent Systems, Control and Automation: Science and Engineering)
Fuzzy Reasoning in Information, Decision and Control Systems (Intelligent Systems, Control and Automation: Science and Engineering)
This book is devoted to the study of fuzzy reasoning as applied to decision making and control processes. It contains a collection of important contributions covering a wide well-selected range of topics within the field.
The book contains twenty-one papers, written by thirty-four distinguished contributors and is divided into five
...
Pro Visual Studio Team System with Team Edition for Database Professionals, Second Edition
Pro Visual Studio Team System with Team Edition for Database Professionals, Second Edition
It is clear that Visual Studio Team System is the future of development from Microsoft’s perspective. Development is no longer a personal pursuit by one developer in a darkened room; it is a collective effort by a team of peers. VSTS supports this broader vision by providing a complete collaboration platform for the entire project team. VSTS...
Human Impact on the Natural Environment
Human Impact on the Natural Environment

A brand new edition of the definitive textbook on humankind’s impact on the Earth’s environment—now in full color

This classic text explores the multitude of impacts that humans have had over time upon vegetation, animals, soils, water, landforms, and the atmosphere. It considers the ways in which climate...

©2019 LearnIT (support@pdfchm.net) - Privacy Policy