Book Description

A hands-on resource for SQL Server 2008 troubleshooting methods and tools

SQL Server administrators need to ensure that SQL Server remains running 24/7. Authored by leading SQL Server experts and MVPs, this book provides in-depth coverage of best practices based on a deep understanding of the internals of both SQL Server and the Windows operating system.

You’ll get a thorough look at the SQL Server database architecture and internals as well as Windows OS internals so that you can approach troubleshooting with a solid grasp of the total processing environment. Armed with this comprehensive understanding, readers will then learn how to use a suite of tools for troubleshooting performance problems whether they originate on the database server or operating system side.

Topics Covered:

• SQL Server Architecture
• Understanding Memory
• SQL Server Waits and Extended Events
• Working with Storage
• CPU and Query Processing
• Locking and Latches
• Knowing Tempdb
• Defining Your Approach To Troubleshooting Download Now »

Book Description

Since the 1990s Grid Computing has emerged as a paradigm for accessing and managing distributed, heterogeneous and geographically spread resources, promising that we will be able to access computer power as easily as we can access the electric power grid. Later on, Cloud Computing brought the promise of providing easy and inexpensive access to remote hardware and storage resources. Exploiting pay-per-use models and virtualization for resource provisioning, cloud computing has been rapidly accepted and used by researchers, scientists and industries.

In this volume, contributions from internationally recognized experts describe the latest findings on challenging topics related to grid and cloud database management. By exploring current and future developments, they provide a thorough understanding of the principles and techniques involved in these fields. The presented topics are well balanced and complementary, and they range from well-known research projects and real case studies to standards and specifications, and non-functional aspects such as security, performance and scalability. Following an initial introduction by the editors, the contributions are organized into four sections: Open Standards and Specifications, Research Efforts in Grid Database Management, Cloud Data Management, and Scientific Case Studies.

With this presentation, the book serves mostly researchers and graduate students, both as an introduction to and as a technical reference for grid and cloud database management. The detailed descriptions of research prototypes dealing with spatiotemporal or genomic data will also be useful for application engineers in these fields. Download Now »

Book Description

“This book takes the somewhat daunting process of database design and breaks it into completely manageable and understandable components. Mike’s approach whilst simple is completely professional, and I can recommend this book to any novice database designer.”
–Sandra Barker, Lecturer, University of South Australia, Australia

“Databases are a critical infrastructure technology for information systems and today’s business. Mike Hernandez has written a literate explanation of database technology–a topic that is intricate and often obscure. If you design databases yourself, this book will educate you about pitfalls and show you what to do. If you purchase products that use a database, the book explains the technology so that you can understand what the vendor is doing and assess their products better.”
–Michael Blaha, consultant and trainer, author of A Manager’s Guide to Database Technology

“If you told me that Mike Hernandez could improve on the first edition of Database Design for Mere Mortals I wouldn’t have believed you, but he did! The second edition is packed with more real-world examples, detailed explanations, and even includes database-design tools on the CD-ROM! This is a must-read for anyone who is even remotely interested in relational database design, from the individual who is called upon occasionally to create a useful tool at work, to the seasoned professional who wants to brush up on the fundamentals.
–Matt Greer, Process Control Development, The Dow Chemical Company Download Now »

Book Description

There are many reasons for serving up dynamic content from a web site: to offer an online shopping site, create customized information pages for users, or just manage a large volume of content through a database. Anyone with a modest knowledge of HTML and web site management can learn to create dynamic content through the PHP programming language and the MySQL database. This book gives you the background and tools to do the job safely and reliably.

Web Database Applications with PHP and MySQL, Second Edition thoroughly reflects the needs of real-world applications. It goes into detail on such practical issues as validating input (do you know what a proper credit card number looks like?), logging in users, and using templates to give your dynamic web pages a standard look.

But this book goes even further. It shows how JavaScript and PHP can be used in tandem to make a user’s experience faster and more pleasant. It shows the correct way to handle errors in user input so that a site looks professional. It introduces the vast collection of powerful tools available in the PEAR repository and shows how to use some of the most popular tools.

Even while it serves as an introduction to new programmers, the book does not omit critical tasks that web sites require.

Through a sophisticated sample application–Hugh and Dave’s Wine Store–all the important techniques of dynamic content are introduced. Good design is emphasized, such as dividing logic from presentation. Download Now »

Book Description

Pro Oracle Application Express 4 is your key to mastering one of the most innovative products to come out of Oracle in years. Application Express, termed “APEX” for short, is fast becoming one of the easiest and most widely-used of tools for creating enterprise-level applications that run against an Oracle database. APEX is easy enough for power users to create ad-hoc applications atop something more reliable than a spreadsheet. Yet APEX is powerful and extensible enough to enable fully-scalable, enterprise-level applications that are accessed by thousands of users.

Authors Tim Fox, John Scott, and Scott Spendolini take you to the professional level in developing for Application Express. They show how to handle user authentication in enterprise environments and how to extend APEX by writing components based upon Oracle’s new plug-in architecture. You’ll learn to deal with localization issues such as time zones and translations, and to customize the look and feel of an APEX website to blend in with your corporate branding strategy. The authors also cover web service development, performance and scalability, and the production issues that you encounter in enterprise-level deployments. Many years of experience in solving the “hard problems” are coalesced in this book to help you, the reader, take advantage of all that APEX has to offer.

• Focuses on high-end, enterprise-level development
• Covers new features such as plug-ins and Websheets
• Introduces the new interface released with APEX 4.0

Download Now »

Book Description

Oracle Application Express 4 Recipes provides an example-based approach to learning Application Express—the ground-breaking, rapid application development platform included with every Oracle Database license. The recipes format is ideal for the quick-study who just wants a good example or two to kick start their thinking and get pointed in the right direction.

The recipes cover the gamut of Application Express development. Author and Application Express expert Edmund Zehoo shows how to create data entry screens, visualize data in the form of reports and charts, implement validation and back-end logic, and much more. Solutions are presented in an easy problem/solution format, which you can copy and adapt for your own use. Detailed discussion for each solution deepens your understanding and aids in customizing the solutions to fit your particular development challenges.

• Teaches Application Express via an example-based format
• Takes you from beginner to intermediate level
• Shows how to build a fully-functional web store in just one hour

What you’ll learn

• Create web application forms and tables
• Customize application look and feel
• Visualize data via reports, calendars, maps, and charts
• Globalize applications in support of language and regional differences Download Now »