Microsoft SQL Server 2008 Bible /by Paul Nielsen (Author), Uttam Parui (Author), Mike White (Contributor) .Harness the power of SQL Server, Microsoft’s high-performance database and data analysis software package, by accesing everything you need to know in Microsoft SQL Server 2008 Bible. Learn the best practices, tips, and tricks from this comprehensive tutorial and reference, which includes specific examples and sample code, with nearly every task demonstrated in both a graphical and SQL code method. Understand how to develop SQL Server databases and data connections, how to administer the SQL Server and keep databases performing optimally, and how to navigate all the new features of the 2008 release.
*Master the data architecture concepts that drive database technologies
*Write elegant set-based queries that respond well to a comprehensive indexing strategy
*Code an efficient and robust data abstraction layer with stored procedures
*Learn the best way to connect to SQL Server with ADO or Microsoft Access
*Use PowerShell and Policy-based Management to better administer your servers
*Use Analysis Services, MDX, and Excel to analyze data trends
*Optimize performance with data compression, resource governor, and partitioning

Creating your MySQL Database: Practical Design Tips and Techniques: A short guide for everyone on how to structure your data and set-up your MySQL database tables efficiently and easily /by Marc DeLisle (Author) .For most of us, setting up the database for an application is often an afterthought. While you don't need to be a professional database designer to create a working application, knowing a few insider tips and techniques can make both the process easier and the end result much more effective.

This book doesn't set out to make you an expert in data analysis, but it does provide a quick and easy way to raise your game in this essential part of getting your application right.
What you will learn from this book?
* Asking users the right questions to collect relevant data for the system you are building
* Detecting bad structures
* Sound data-naming techniques, for both table and column names
* Modeling data with future growth in mind
* Implementing security policies with data privileges and views
* Tuning the structure for performanceProducing system documentation (data dictionary, relational schema)
* Testing the model with appropriate SQL queries

 

PDF | English | 3.7MB(zip)

Author: IBM Redbooks

Locking is the generic term used to refer to the database management system function that is required for managing interprocess concurrency and maintaining data integrity. However, locking is just one of the serialization mechanisms available in IBM® DB2® for z/OS®. DB2 uses different mechanisms for serialization to achieve its goal of maximizing concurrency without losing integrity with a minimum cost in CPU, I/O, and storage resources. In this IBM Redbooks® publication, we review and explore the different serialization mechanisms used in DB2, such as transaction (DML) locking, claims and drains, restrictive states, latching, and optimistic serialization. This book was written for application developers in order to help them better understand serialization mechanisms and how they influence application design decisions.

PDF | English | 1.5MB(zip)

Author: Conor O’Mahony

If you want to learn more about native XML databases and DB2 pureXML, this eBook uses the fun and easy-to-understand “for Dummies” format to do just that. It introduces these topics, while guiding you to create your first native XML database. You don’t need to purchase any software to get started creating native XML databases—you simply use the freely available version of DB2.

jQuery Recipes: A Problem-Solution Approach /by Bintu Harwani (Author) .jQuery is one of today’s most popular JavaScript web application development frameworks and libraries. jQuery Recipes can get you started with jQuery quickly and easily, and it will serve as a valuable long-term reference.
* The book begins with small initial problems that developers typically face while working with jQuery, and gradually goes deeper to explore more complex problems.
* The solutions include illustrations and clear, concise explanations of the code. Using this book and jQuery, your web sites will be more dynamic and lively.