Kuznetsov A. - Defensive Database Programming with SQL Server [2010, PDF, ENG]

Reply to topic
DL-List and Torrent activity
Size:  4 MB   |    Registered:  3 years 2 months   |    Completed:  2 times
Seeders:  427  [  0 KB/s  ]   Leechers:  29  [  0 KB/s  ]   Show peers in full details
Author Message

Microsoft SQL Server ®


Longevity: 6 years 6 months

Posts: 515

Post 26-Jul-2018 03:45


Defensive Database Programming with SQL Server
Год издания: 2010
Автор: Kuznetsov A.
Издательство: Simple Talk Publishing
ISBN: 978-1-906434-44-1
Язык: Английский
Формат: PDF
Качество: Издательский макет или текст (eBook)
Интерактивное оглавление: Да
Количество страниц: 302
Описание: 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

Примеры страниц

Torrent: Registered   [ 2018-07-26 03:45 ]

2 KB

Status: checked
Completed: 2 times
Size: 4 MB
(Vote: 0)
Have thanked: 0  Thanks
Kuznetsov A. - Defensive Database Programming with SQL Server [2010, PDF, ENG] скачать торрент бесплатно и без регистрации
[Profile] [PM]
Forum Topic Author Size
СУБД Factor Ph., Fritchey G., Kuznetsov A., Prajdic M. - The Red Gate Guide to SQL Server Team-based Development [2010, PDF, ENG] Microsoft SQL Server 9 MB
Display posts from previous:    
Reply to topic

The time now is: Today 20:13

All times are GMT + 4 Hours

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum