Apr 04, 2012 |
4,932 views |
Book Description
Introducing Microsoft® SQL Server® 2012 explores the exciting enhancements and new capabilities engineered into SQL Server, ranging from improvements in operation to those in reporting and management. This book is for anyone who has an interest in SQL Server 2012 and wants to understand its capabilities, including database administrators, application developers, and technical decision makers.
Table of Contents
Part I: Database Administration
Chapter 1. SQL Server 2012 Editions and Engine Enhancements
Chapter 2. High-Availability and Disaster-Recovery Enhancements
Chapter 3. Performance and Scalability
Chapter 4. Security Enhancements
Chapter 5. Programmability and Beyond-Relational Enhancements
Part II: Business Intelligence Development
Chapter 6. Integration Services
Chapter 7. Data Quality Services
Chapter 8. Master Data Services
Chapter 9. Analysis Services and PowerPivot
Chapter 10. Reporting Services Download Now »
Mar 29, 2012 |
7,378 views |
Book Description
How can you bring out MySQL’s full power? With High Performance MySQL, you’ll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover.
Updated to reflect recent advances in MySQL and InnoDB performance, features, and tools, this third edition not only offers specific examples of how MySQL works, it also teaches you why this system works as it does, with illustrative stories and case studies that demonstrate MySQL’s principles in action. With this book, you’ll learn how to think in MySQL.
- Learn the effects of new features in MySQL 5.5, including stored procedures, partitioned databases, triggers, and views
- Implement improvements in replication, high availability, and clustering
- Achieve high performance when running MySQL in the cloud
- Optimize advanced querying features, such as full-text searches
- Take advantage of modern multi-core CPUs and solid-state disks
- Explore backup and recovery strategies—including new tools for hot online backups
Table of Contents
Chapter 1. MySQL Architecture and History Download Now »
Mar 08, 2012 |
4,983 views |
Book Description
Imagine a public storage system that has a place online for structured data about everything that exists—or that could exist. This book introduces Fluidinfo, a system that enables you to store information about anything, real or imaginary, in any digital form. You’ll learn how to organize and search for data, and decide who can use, modify, and extend what you’ve contributed.
This guide demonstrates Fluidinfo’s potential to create social data, with facilities that encourage users and applications to share, remix, and reuse data in ways they may not have anticipated. You’ll learn how to use tools for reading and writing data, and how to use Fluidinfo in your own applications by working with its writable API and simple query language.
- Read and write Fluidinfo data from web applications—and reuse and build upon each other’s data
- Discover Fluidinfo’s permissions system for tags and namespaces
- Learn how to use Fish, the command-line tool for interacting with Fluidinfo data
- Delve into Fluidinfo’s RESTful API, and learn how to make HTTP requests
- Use Fluidinfo client libraries to build a simple Python utility or a JavaScript web application
Table of Contents
Chapter 1. What Is Fluidinfo?
Chapter 2. Fluidinfo from the Command Line
Chapter 3. Social Data
Chapter 4. Programming with Fluidinfo Download Now »
Mar 08, 2012 |
6,577 views |
Book Description
Portable and precise, this pocket-sized guide delivers ready answers for the day-to-day administration of SQL Server. Zero in on core support and maintenance tasks using quick-reference tables, instructions, and lists. You’ll get the focused information you need to save time and get the job done—whether at your desk or in the field!
Get fast facts to:
Table of Contents
Part I: Microsoft SQL Server 2012 Essentials
Chapter 1. Managing Your SQL Servers
Chapter 2. Managing SQL Server Services and Clients
Part II: Microsoft SQL Server 2012 Management and Security
Chapter 3. Implementing Policy-Based Management
Chapter 4. Configuring and Tuning Your SQL Servers Download Now »
Mar 07, 2012 |
6,534 views |
Book Description
Stuck with bugs, performance problems, crashes, data corruption, and puzzling output? If you’re a database programmer or DBA, they’re part of your life. The trick is knowing how to quickly recover from them. This unique, example-packed book shows you how to handle an array of vexing problems when working with MySQL.
Written by a principal technical support engineer at Oracle, MySQL Troubleshooting provides the background, tools, and expert steps for solving problems from simple to complex—whether data you thought you inserted doesn’t turn up in a query, or the entire database is corrupt because of a server failure. With this book in hand, you’ll work with more confidence.
- Understand the source of a problem, even when the solution is simple
- Handle problems that occur when applications run in multiple threads
- Debug and fix problems caused by configuration options
- Discover how operating system tuning can affect your server
- Use troubleshooting techniques specific to replication issues
- Get a reference to additional troubleshooting techniques and tools, including third-party solutions
- Learn best practices for safe and effective troubleshooting—and for preventing problems
Table of Contents
Chapter 1. Basics Download Now »
Mar 02, 2012 |
2,642 views |
Book Description
PeopleSoft for the Oracle DBA, Second Edition stands on the boundary between the PeopleSoft application and the Oracle database. This new edition of David Kurtz’s book is freshly revised, showing how to tame the beast and manage Oracle successfully in a PeopleSoft environment.
You’ll learn about PeopleSoft’s Internet architecture and its use of Oracle’s Tuxedo Application Server. You’ll find full coverage of key database issues such as indexing, connectivity, and tablespace usage as they apply to PeopleSoft. Kurtz also provides some of the best advice and information to be found anywhere on managing and troubleshooting performance issues in a PeopleSoft environment. The solid coverage of performance troubleshooting is enough by itself to make PeopleSoft for the Oracle DBA a must-have book for any Oracle Database administrator working in support of a PeopleSoft environment.
What you’ll learn
- Understand PeopleSoft’s technical architecture and the structure of a PeopleSoft database
- Measure performance of the various tiers in the application
- Pinpoint and resolve performance problems within the code Download Now »
