Written by the technical director for SQL Server Magazine, this expert guide shows you how to implement clustering and database mirroring in SQL Server 2008. Learn proven techniques for ensuring zero database loss, avoiding system downtime, and providing...

If you?re an IT professional tasked with launching and administering SharePoint to your organization, Inside SharePoint 2007 Administration is the only book you?ll need. You?ll find all of the information necessary to administer SharePoint -- everything from detailed real-world installation instructions and proper backup procedures to...

MySQL, an open source relational database management system (RDBMS), can be made highly available to protect from corruption, hardware failure, software crashes, and user error. Running a MySQL setup is quite...

Candidates for the Oracle Certified Associate in Oracle Database 11g need to pass Exams 1Z0-051 and 1Z0-052 to achieve their certification—this guide prepares you for taking both those exams. This two-in-one study guide covers the Oracle Certified Associate certification for Oracle database 11g and reviews exam topics such as...

SharePoint 2010 boasts a variety of incredible new features that will challenge even the most experienced administrator who is upgrading from SharePoint 2007. Written by a team of SharePoint experts, this book places a takes aim at showing you how to make these...

Protect your databases from hardware, software, and operator failures using the detailed information in this Oracle Press guide. Oracle RMAN 11g Backup and Recovery explains how to configure databases, generate accurate archives, and carry out system restores. Work from the command line or...

• Get more done faster, and become a true Linux guru by mastering the command line!
• ...

Millions of SQL Server instances run in the offices of small and medium-sized organizations and there are many "accidental" DBAs out there whose job it is to maintain them. Often, they find that they don't have the knowledge, experience, or critically the time, to perform the correct level of maintenance on their SQL Server...

PostgreSQL is a powerful, open source object-relational database system. An enterprise database, PostgreSQL includes features such as Multi-Version Concurrency Control (MVCC), point-in-time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and...

For the day-to-day DBA, there are dangers around every corner; monsters waiting to strike down the unsuspecting database with a resource-hungry query, an inefficient data load, or even outright data corruption. When the worst happens, and SQL Server is down, or performance is suffering, customers are quick to complain.. During such difficult...

Social Networking has quickly become a very popular activity on the Internet, particularly with the emergence of sites like Facebook and MySpace. PHP is a flexible web development language used on a wide variety of sites, including Facebook and Yahoo! But building a social networking site from scratch using PHP involves some complex logic,...