SQL Antipatterns: Avoiding the Pitfalls of Database Programming By Bill Karwin
Publisher: Pragmatic Bookshelf 2010 | 300 Pages | ISBN: 1934356557 | PDF | 1 MB
Each chapter in this book helps you identify, explain, and correct a unique and dangerous antipattern. The four parts of the book group the antipatterns in terms of logical database design, physical database design, queries, and application development.
The chances are good that your application’s database layer already contains problems such as Index Shotgun, Keyless Entry, Fear of the Unknown, and Spaghetti Query. This book will help you and your team find them. Even better, it will also show you how to fix them, and how to avoid these and other problems in the future. Read more…
Free eBooks: Pro SQL Server 2008 Analysis Services

- Author: Philo Janus, Guy Fouche
- Edition: 1
- Publisher: Apress
- Pages: 480
- Publication Date: 2010-06-18
- ISBN: 1430219955
Read more…
Free eBooks: Mastering SQLServer 2000

- Author: Mike Gunderloy, Joseph L. Jorden, Joe Jorden
- Edition: 1st
- Publisher: Sybex
- Pages: 1201
- Publication Date: 2000-09
- ISBN: 0782126278
Read more…

This Database Optimization course provides viewers with important techniques and checklists to configure, monitor, and manage their databases. You will learn how to develop a tuning strategy, explore the tuning and diagnostic tools, understand the relational database model and implications on performance, evaluate the application for efficient design, structure, and other factors affecting performance and evaluate hardware for effects on performance. Join us as we review best practices in designing, optimizing, and maintaining your database. You will benefit from this course whether you have some experience with optimizing databases or are just starting out. Read more…
Free eBooks: The Data Access Handbook: Achieving Optimal Database Application Performance and Scalability

- Author: John Goodson, Robert A. Steward
- Edition: 1
- Publisher: Prentice Hall
- Pages: 360
- Publication Date: 2009-03-26
- ISBN: 0137143931
Description:
The Data Access Handbook
Achieving Optimal Database Application Performance and Scalability
John Goodson • Robert A. Steward Read more…
Free eBooks: SQL Server MVP Deep Dives

- Author: Paul Nielsen, Kalen Delaney, Adam Machanic, Kimberly Tripp, Paul Randal, Greg Low
- Edition: 1
- Publisher: Manning Publications
- Pages: 848
- Publication Date: 2009-11-03
- ISBN: 1935182048
Read more…
Arvind Maheshwari, Debu Panda, “Middleware Management with Oracle Enterprise Manager Grid Control 10g R5″
Packt Publishing | 2010
ISBN: 1847198341 | 350 pages | PDF | 13,1 MB
Monitor, diagnose, and maximize the system performance of Oracle Fusion Middleware solutions
Manage your Oracle Fusion Middleware and non-Oracle middleware applications effectively and efficiently using Oracle Enterprise Manager Grid Conrol
Implement proactive monitoring to maximize application performance
Best practices and troubleshooting tips to manage your middleware and SOA applications for optimal service levels and reduced down time from Oracle Product Managers
A Hands-on tutorial detailing Oracle Enterprise Manager Grid Control’s management of Middleware Read more…

- Free eBooks Download: PHP and MySQL by Example
- Author: Ellie Quigley, Marko Gargenta
- Publisher: Prentice Hall
- Pages: 912
- Publication Date: 2006-12-02
- ISBN: 0131875086
Description:
Quickly master dynamic, database-driven Web development—no experience necessary!
Even if you’re completely new to PHP, MySQL, and Web database development, this book will guide you through every step of building powerful, database-driven, dynamic Web sites. Direct from the world’s top scripting instructor, Ellie Quigley, PHP and MySQL by Example illuminates every concept with tested code examples, screen shots showing program output, and clear, line-by-line explanations.
Read more…
Free eBooks Download: Beginning PHP and Oracle: From Novice to Professional (Expert’s Voice)

- Author: W.J. Gilmore, Bob Bryla
- Edition: 1
- Publisher: Apress
- Pages: 763
- Publication Date: 2007-08-24
- ISBN: 1590597702
Description:
Beginning PHP and Oracle: From Novice to Professional offers comprehensive information on using the PHP scripting language in conjunction with Oracles database platform. PHP is one of the most prominent open source technologies in the area of web development, while Oracle is one of the most widely deployed and used database products.
Read more…
Free eBooks Download : Expert PHP and MySQL (Wrox Programmer to Programmer)

- Author: Andrew Curioso, Ronald Bradford, Patrick Galbraith
- Publisher: Wrox
- Pages: 624
- Publication Date: 2010-03-29
- ISBN: 0470563125
Description:
Best practices and expert techniques for today’s most demanding apps
As the world’s most popular, general purpose, open source scripting language, PHP is frequently used with MySQL to create high-traffic, mission-critical applications. This indispensable book shares proven, author-tested best practices and expert techniques that can be applied to even the most demanding MySQL-driven PHP apps. You’ll explore ways to extend MySQL with user-defined functions, write PHP extensions, and solve problems when PHP and MySQL alone are not enough and other techniques or third-party tools are necessary.
Read more…