Defensive Database Programming with SQL Server (Alex Kuznetsov)

0.0 (0)
Defensive Database Programming with SQL Server (Alex Kuznetsov)

The intention of protecting Programming is to supply resilient code that responds gracefully to the surprising.

To the sq. Server programmer, this means T-sq. code that behaves continuously and predictably in instances of sudden usage, would not wreck underneath concurrent loads and survives predictable adjustments to database schemas and settings.

Inside this e-book, you will find dozens of practical, shielding programming strategies a good way to improve the fine of your T-sq. code and boom its resilience and robustness.

Ebook Details

About the Authors
Alex Kuznetsov has been working with object-oriented languages and databases for extra than a decade. He has labored with Sybase, sq. Server, Oracle, and DB2. He often blogs on, more often than not about database unit testing, protective programming, and query optimization.
Published Date / Year
(May 31, 2010)
301 pages
eBook Format
3.16 MB

Similar Programming & Computer Books

The Official New Features Guide to Sybase ASE (Brian Taylor, et al)
Sybase Adaptive Server Enterprise is a mission-critical, high-performance database management system created to satisfy the growing demands of huge databases and high transaction volumes while offering a cost-efficient database...
Sybase IQ (Rocket99)
The Adaptive Server product family, which also includes Adaptive Server Enterprise and SQL Anywhere, incorporates Sybase IQ. Direct access to relational and nonrelational databases on mainframe, UNIX, or Windows...
Sybase SQL Server Administration's Guide
In addition to providing thorough explanations of how to install, configure, and maintain SQL Server 10 and SQL Server 11, this book also addresses system changes that may affect...
MonoGame Succinctly (Jim Perry)
The market for video games is enormous, but in order to reach consumers, several platforms must be supported.  
MonoGame Role-Playing Game Development Succinctly (Jim Perry, et al.)
This ebook is a crucial resource for MonoGame developers who want to create their own role-playing games (RPG). To help you create a playable game, authors Jim Perry and...
Sams Teach Yourself C# in 24 Hours (James Foxall, Wet al.)
Sams Teach Yourself C# in 24 Hours offers students 24 modules that are well-structured and give a quick yet complete introduction to C#. ...
The C# Station Tutorial (Joe Mayo)
A versatile computer programming language that may be used for a wide range of development needs is called C# (pronounced "See Sharp"). ...
Dissecting a C# Application – Inside SharpDevelop (Christian Holm, et al)
Get a behind-the-scenes peek at an entire application while learning advanced.NET development techniques! A full-featured Integrated Development Environment created in C# is called SharpDevelop. ...
The Biostar Handbook (Dr. Istvan Albert)
The scientific field of bioinformatics, which combines biology, computer science, and statistical data analytics, is explained to readers in this useful book. Bioinformatics is concerned with the digital processing...
Sams Teach Yourself Visual Basic in 24 Hours (Greg Perry)
This free programming book's unique selling point is that, in addition to concentrating on the subject at hand, it also offers a variety of tools and skills that will...

Others Programming Books by Alex Kuznetsov

SQL Server Team-based Development (Phil Factor, et al.)
This book demonstrates how to successfully develop database applications in a team setting using a combination of in-house scripts, native SQL Server tools, and tools from the Red Gate...

Others Programming Books by Red Gate Books

45 Database Performance Tips for Developers (Phil Factor, et al)
This eBook is a compilation of advice on SQL Server performance from some of the most knowledgeable individuals in the Simple Talk community, including SQL Server MVPs. ...
Fundamentals of SQL Server Replication (Sebastian Meine)
Making data from one server accessible on another is a typical requirement. You could want to offer a local copy of the data to speed up cross-server searches. ...
SQL Server Concurrency: Locking, Blocking and Row Versioning (Kalen Delaney)
Anyone who works with SQL Server, whether as a programmer, an administrator or even a user and wants to understand how the database engine handles multiple sessions and what...
SQL Server Execution Plans, 3rd Edition (Grant Fritchey)
The query's execution plan will inform you not just what data set is returning, but also what SQL Server did and in what sequence to obtain that data if...
Performance Tuning with SQL Server Dynamic Management Views (Louis Davidson, et al)
Dynamic Management Views (DMVs), which reveal previously hidden information on the background activities of your database sessions and transactions, are a substantial and valuable addition to the DBA's troubleshooting...
The Art of SQL Server FILESTREAM (Jacob Sebastian, et al)
Although storing massive object data in the database has many advantages, it also presents performance issues. On the other hand, storing large objects on the file system has significant...
SQL Server Backup and Restore (Shawn McGehee)
This book demonstrates how to create a solid, tried-and-true SQL Server backup and restore strategy. Learn how to recover your data with the least amount of downtime. Find out...
Inside the SQL Server Query Optimizer (Benjamin Nevarez)
Many people believe the SQL Server Query Optimizer to be a mysterious black box that instantly converts SQL queries into high-performance execution plans through an unknown mechanism. ...
Under the Hood of .NET Memory Management (Chris Farrell)
The analysis and optimization of.NET code performance is covered in this book in both theory and practice.
Practical Performance Profiling: Improving the Efficiency of .NET Code (Jean-Philippe Gouigoux)
This book gives readers the theoretical knowledge and practical skills they need to evaluate and enhance the performance of.NET code. It walks the reader through using a profiler and...
Exchange 2010 SP1 - A Practical Approach (Jaap Wesselius)
The most recent version of Microsoft's Messaging and Collaboration platform, Exchange Server 2010 Service Pack 1, contains several exciting new features.
SQL Server Hardware Choices Made Easy (Glenn Berry)
This book is intended to give you the core information and tools you need to choose the best configuration and installation options for the SQL Server hardware, operating system,...
SQL Server Statistics (Holger Schmeling)
A sampling representation of the data distribution in a table is a Distribution Statistics object. These statistics assist the SQL Server Database Engine's Query Optimizer in converting the 'logical'...
SQL Server Team-based Development (Phil Factor, et al.)
This book demonstrates how to successfully develop database applications in a team setting using a combination of in-house scripts, native SQL Server tools, and tools from the Red Gate...
The SysAdmin Handbook -The Best of Simple Talk SysAdmin (Jaap Wesselius, et al)
This book covers everything about the Microsoft trade Servers management intensive.
let Brad McGehee take you on a complete excursion of the sq. Server preservation Plan Wizard and clothier. find out how the renovation Plan equipment allows you to configure...
How do you rate your software program? Is it art, science, or magic? How a lot of attention should you pay to your competition? This quick guide will provide...
41Q1eGxEDqL-SX331-BO1204203200--80-1655680361 brings you an expansion of articles on all components of sq. Server from management to XML and the whole lot in among.

User reviews

There are no user reviews for this listing.
Rate this Book