MySQL Cookbook

Along with MySQL's popularity has come a flood of questions about solving specific problems, and that's where this Cookbook is essential. Designed as a handy resource when you need quick solutions or techniques, the book offers dozens of short, focused pieces of code and hundreds of worked-out examples for programmers of all levels who don't have the time (or expertise) to solve MySQL problems from scratch.

The new edition covers MySQL 5.0 and its powerful new features, as well as the older but still widespread MySQL 4.1. One major emphasis of this book is how to use SQL to formulate queries for particular kinds of questions, using the mysql client program included in MySQL distributions. The other major emphasis is how to write programs that interact with the MySQL server through an API. You'll find plenty of examples using several language APIs in multiple scenarios and situations, including the use of Ruby to retrieve and format data. There are also many new examples for using Perl, PHP, Python, and Java as well.



Download

Read More...

Microsoft SQL Server 2005 The Complete Reference

Book Description:
SQL Server 2005 is Microsoft's next-generation data management and analysis software designed to deliver increased scalability, availability, and security to enterprise data and analytical applications while making them easier to create, deploy, and manage. Filled with practical solutions and real-world examples, this resource includes full details on:

* Enterprise data management capabilities, including security and clustering
* Powerful developer tools -- T-SQL, .NET CLR, XML, ADO.NET 2.0
* Business Intelligence features, such as Integration Services, data warehousing, and reports


Download

Read More...

Introduction To Oracle9i - PL-SQL - Student Guide

# Paperback: 664 pages
# Publisher: McGraw-Hill Osborne Media; 2 edition (November 28, 2001)
# Language: English
# ISBN-10: 0072191473
# ISBN-13: 978-0072191479

Book Description
From the authorized Oracle Press comes a complete guide to developing robust PL/SQL applications. The book contains new information on development tools, datatypes, SQL commands and functions, and much more. The CD-ROM contains sample code plus a sampling of development environments covered in the book.

Book Info
A complete guide to developing robust PL/SQL applications. Contains new information on development tools, datatypes, SQL commands and functions, and much more. Softcover. CD-ROM included.

Download

Volume 1                                                             Volume 2

Read More...

Professional Oracle Programming (Programmer to Programmer)

# Publisher: Wrox (June 17, 2005)
# Language: English
# ISBN-10: 0764574825
# ISBN-13: 978-0764574825


Review
“…a good book for an introduction to Oracle, but especially good if you are interested in the areas of Business Intelligence, HTML-DB, XML DB and Regular Expressions…” (OracleHome, 3 August 2005)
Product Description

    * One of the only Oracle books to focus exclusively on database programming rather than administration
    * Oracle owns sixty percent of the commercial database market
    * Provides full coverage of the latest Oracle version, 10g-including new features such as regular expressions and the MODEL SQL clause-as well as versions 8, 8i, and 9i
    * The authors are well-known as Oracle gurus-Greenwald is the author of Oracle in a Nutshell and the coauthor, with Stackowiak, of Oracle 9 Essentials
    * Shows how to use Oracle data and data structures to build robust, scalable database applications using Java, SQL, and PL/SQL

Download

Click to download

Read More...

Oracle Databases on the Web: Learn to Create Web Pages That Interface with Database Engines

# Paperback: 592 pages
# Publisher: Coriolis Group Books (February 20, 1997)
# Language: English
# ISBN-10: 1576100995
# ISBN-13: 978-1576100998


Product Description
Covers how to set up database systems to drive commercial Web and intranet sites. Provides the insight of two experienced Oracle database administrators. Presents need-to-know information in an easy-to-read format with clear examples and illustrations. Provides an understanding of the World Wide Web and details on Web security. Details database design, including performance and tuning.

About the Author
Donald Burleson (Raleigh, NC) has been a database administrator for over 15 years and has designed numerous data warehouse systems with Oracle. He is the author of several books about Oracle, including High Performance Oracle Database Applications and Oracle Databases on the Web, and over 30 articles in magazines such as DBMS, Oracle Magazine, and Computerworld.

Robert Papaj (Rochester, NY) has 18 years of information systems experience in database administration across numerous DBMSs. Robert is an Oracle Master in database administration, technical support, application development, and application center consulting. Donald K. Burleson (Raleigh, NC) specializes in database technology and distributed database systems. He is an Adjunct Professor of Information Systems, the author of two other books on databases, and a writer for several national publications such as Computerworld, Database Programming & Design, and Oracle Technical Journal.

Download:

Download

Click to download

Read More...

Dissecting SQL Server Execution Plans

# Format: Kindle Edition
# File Size: 3207 KB
# Print Length: 252 pages
# Publisher: Simple Talk Publishing (April 28, 2008)
# Sold by: Amazon Digital Services
# Language: English
# ASIN: B0018PCIFG


Product Description
Execution plans show you what's going on behind the scenes in SQL Server. They can provide you with a wealth of information on how your queries are being executed by SQL Server, including which indexes are getting used and where no indexes are being used at all; how the data is being retrieved, and joined, from the tables defined in your query; how aggregations in GROUP BY queries are put together and the anticipated load, and the estimated cost, that all these operations place upon the system. All this information makes the execution plan a vitally important tool in the tool belt of database administrator, database developers, report writers, developers, and pretty much anyone who writes TSQL to access data in a SQL Server database. The goal with this book was to gather as much useful information on execution plans as possible into a single location, and to organize it in such as way that it provided a clear route through the subject, right from the basics of capturing plans, through their interpretation, and then onto how to use them to understand how you might optimize your SQL queries, improve your indexing strategy, spot some common performance issues, and more.

Download:

Download

Click to download

Read More...

MySQL Administrator's Bible (Bible (Wiley))

# Paperback: 888 pages
# Publisher: Wiley (May 11, 2009)
# Language: English
# ISBN-10: 0470416912
# ISBN-13: 978-0470416914



Product Description
With special focus on the next major release of MySQL, this resource provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of MySQL database management—including MySQL’s unique approach to basic database features and functions—as well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index tuning, database and performance monitoring, security, and more.
From the Back Cover

Whether you're a novice or experienced DBA, this book has all you need to learn MySQL

MySQL Administrator's Bible is designed to provide a solid framework for a beginning MySQL DBA or an experienced DBA transitioning from another database platform. The book starts with the fundamentals of MySQL database management, including MySQL's unique approach to SQL queries, data and index types, stored procedures and functions, triggers and views, and transactions. The authors continue with comprehensive coverage of major MySQL Server components and processes for which DBAs are responsible—these include:

    *      MySQL Server tuning
    *      Query optimization and index tuning
    *      Managing storage engines
    *      Caching
    *      Authentication and managing users
    *      Partitioning; Replication; Logging
    *      Database and performance monitoring
    *      Security; Backup and Recovery
    *      Managing availability and scaling
    *      Fully covers MySQL 5.1

Companion Web Site

The book's Companion Web Site includes a tutorial on foundational SQL programming that all MySQL DBAs need to understand, plus code examples, scripts, and data schemas used in the book. You'll also learn about the latest changes in MySQL and find helpful links. Visit the site at www.wiley.com/go/mysqladminbible.

Download

Click to download

Read More...

Oracle Self-Service Applications

# Paperback: 320 pages
# Publisher: McGraw-Hill Osborne Media; 1 edition (March 25, 2010)
# Language: English
# ISBN-10: 0071713301
# ISBN-13: 978-0071713306

Product Description
Maximize the Capabilities of Oracle Self-Service Applications

Get complete coverage of Oracle E-Business Suite's self-service modules, including Oracle iProcurement, Oracle Internet Expenses, Oracle iSupplier Portal, and Oracle iReceivables, inside this Oracle Press guide. Oracle Self-Service Applications discusses the features of each module and how they benefit organizational workflow, and reviews common implementation considerations that apply to all the applications. The book also provides detailed configuration instructions explaining each screen and field. Learn how to set up and use:

    * Oracle iProcurement for automating both the requesting and approval of requisitions
    * Oracle Internet Expenses for streamlining the entry, approval, and auditing of expense reports, including credit card processing
    * Oracle iSupplier Portal to allow secure supplier collaboration
    * Oracle iReceivables to enable customers and employees to review account information online
    * The order management portal for granting inquiry-only viewing and tracking of orders and delivery status
    * Oracle Bill Presentment Architecture for customizing invoices
    * Oracle Approvals Management to accommodate complex rules for approving transactions
    * Oracle Application Framework to customize both the options and usability of the self-service applications

Download

Click to download

Read More...

Oracle Application Server Portal Handbook (Osborne ORACLE Press Series)

# Paperback: 597 pages
# Publisher: McGraw-Hill Osborne Media; 1 edition (July 23, 2007)
# Language: English
# ISBN-10: 0072264608
# ISBN-13: 978-0072264609


Product Description

The Ultimate Oracle Application Server Portal Resource

Build dynamic, feature-rich enterprise portals using Oracle Application Server Portal and the expert information in this exclusive Oracle Press guide. You'll learn how to maximize the capabilities of Oracle Application Server Portal, customize your portals, integrate Oracle Forms and Oracle Reports, and add Java functionality. Oracle Application Server Portal Handbook covers all of the design, management, and security features available in Oracle Application Server Portal 10.1.4 alongside real-world solutions.

    *
      Take full advantage of the built-in tools and wizards
    *
      Create rich end-user experiences quickly and easily
    * Customize pages and maintain site-wide consistency using HTML templates
    *
      Incorporate data from disparate formats using Oracle Application Server Portal's content management features
    *
      Build pages using OmniPortlet and the Web clipping studio
    *
      Write portlets with Java and Oracle JDeveloper
    *
      Implement SOA-based applications to connect business processes
    *
      Administer, tune, and secure Oracle Application Server Portal
    *
      Integrate Oracle Forms, Oracle Reports, and Oracle Discoverer workbooks

Download:
- Hotfile:

Download

Click to download

- Filesonic:

Download

Click to download

Read More...

SQL Server Tacklebox Essential tools and scripts for the day-to-day DBA

# Paperback: 250 pages
# Publisher: Red gate books (August 3, 2009)
# Language: English
# ISBN-10: 1906434255
# ISBN-13: 978-1906434250


Product Description

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 periods, you, the DBA, are the centre of attention. Suddenly, three or four people crowd your desk, laser beam focused on your every action, fully expecting you to solve the problem quickly.

The success of your career as a DBA depends largely on how well-prepared you are to deal with such situations. Without verified backups, sound server documentation, and a ready supply of tried-and tested troubleshooting tools, there is no safe place to hide when the monster rears up. All you can do is buy some time, patch things up as best you can and then duck away into your cubicle, which, if you lost any data in the process, may soon be empty.

However, with the tools and techniques provided in the SQL Server Tacklebox, you will be fully-equipped to fight back. Inside, you'll find scripts that will allow you to automate and standardize SQL Server installation, document and report on your servers, migrate data and manage data growth, troubleshoot performance issues, receive notifications of impending danger, secure access to your servers and fight off data corruption.

In short, you'll be able to respond quickly and professionally to the many issues that blight the waking, and often sleeping, hours of the DBA. Then, one day, who knows? That cubicle may turn into an executive office with wall-to-wall tinted windows revealing a flowing brook outside, where no monsters live.

Download

Click to download

Read More...

Access 2010 Programmer's Reference (Wrox Programmer to Programmer)

Paperback: 1272 pages
Publisher: Wrox (August 9, 2010)
Language: English
ISBN-10: 0470591668
ISBN-13: 978-0470591666

Product Description
A comprehensive guide to programming for Access 2010 and 2007
Millions of people use the Access database applications, and hundreds of thousands of developers work with Access daily. Access 2010 brings better integration with SQL Server and enhanced XML support; this Wrox guide shows developers how to take advantage of these and other improvements.

With in-depth coverage of VBA, macros, and other programming methods for building Access applications, this book also provides real-world code examples to demonstrate each topic.

Access 2010 Programmer's Referenceis a comprehensive guide to the best-of-breed techniques for programming Access applications.

Coverage Includes:

Introduction to Microsoft Access 2010
New Features
Upgrading and Converting to Access 2010
Macros in Access 2010
Using the VBA Editor
VBA Basics
Using VBA in Access
Creating Classes in VBA
Extending VBA with APIs
Working with the Windows Registry
Using DAO to Access Data
Using ADO to Access Data
Using SQL with VBA
Using VBA to Enhance Forms
Enhancing Reports with VBA
Customizing the Ribbon
Customizing the Office Backstage
Working with Office 2010
Working with SharePoint
Working with .NET
Building Client-Server Applications with Access
The Access 2010 Templates
Access Runtime Deployment
Database Security
Access 2010 Security Features

Download

Click to download

Read More...

Microsoft SQL Server 2008 R2 Unleashed

# Paperback: 1704 pages
# Publisher: Sams; Pap/Cdr/Ps edition (September 26, 2010)
# Language: English
# ISBN-10: 0672330563
# ISBN-13: 978-0672330568


Product Description

Microsoft® SQL Server 2008 R2 Unleashed



Ray Rankins

Paul Bertucci

Chris Gallelli

Alex T. Silverstein



Includes full coverage of SQL Server 2008 in addition to R2 coverage



This is the industry’s most comprehensive and useful guide to SQL Server 2008 and 2008 R2. It presents start-to-finish coverage of SQL Server’s core database server and management capabilities, plus complete introductions to Integration, Reporting, and Analysis Services, application development, and much more.



Four expert SQL Server administrators, developers, and consultants have packed this book with real-world information, tips, guidelines, and samples drawn from their own extensive experience creating and managing complex database solutions. Writing for intermediate-to-advanced-level SQL Server professionals, they focus on the product’s most complex and powerful capabilities, and its newest tools and features. For example, you’ll find invaluable information on administering SQL Server more efficiently, analyzing and optimizing queries, implementing data warehouses, ensuring high availability, and tuning performance.



The accompanying CD-ROM contains an extraordinary library of practical tools and information including sample databases and all code examples. Whether you’re responsible for SQL Server 2008 analysis, design, implementation, support, administration, or troubleshooting, no other book offers you this much value.



    * Understand the Microsoft SQL Server 2008 environment, R2’s newest features, and each edition’s capabilities
    * Manage SQL Server 2008 more effectively with SQL Server Management Studio, the SQLCMD command-line query tool, and Powershell
    * Efficiently manage security, users, backup/restore, replication, Database Mail, and database objects–from tables and indexes to stored procedures and triggers
    * Increase availability with clustering, database mirroring, and other features
    * Use new Policy-Based Management to centrally configure and operate SQL Server throughout the organization
    * Use SQL Server Profiler to capture queries and identify bottlenecks
    * Improve performance by optimizing queries, design more effective databases, and manage workloads with the new Resource Governor
    * Develop applications using SQL Server 2008’s enhancements to T-SQL and SQLCLR, .NET integration, LINQ to SQL, XML, and XQuery
    * Make the most of Analysis Services, Integration Services, and Reporting Services–especially Microsoft’s new R2 reporting improvements
    * Improve data security using Column-level and Transparent Data Encryption



Ray Rankins, president of Gotham Consulting Services, has worked with Sybase and Microsoft SQL Server for more than 23 years and is coauthor of Sybase SQL Server Unleashed, Microsoft SQL Server 2000 Unleashed, and Microsoft SQL Server 2005 Unleashed. Paul Bertucci, founder of Database Architechs, has more than 30 years of experience in database design, architecture, replication, tuning, integration, and high availability. Chris Gallelli, president of CGAL Consulting Services, specializes in database administration, tuning, and programming. Alex T. Silverstein is managing principal and chief architect of Unified Digital Group, LLC, a developer of custom SQL Server and Microsoft .NET solutions.



CD-ROM includes:

    * 15 additional chapters
    * Code samples, scripts, and databases utilized within the book
    * Free version of SQL Shot (performance & tuning software)



Category: Database / Microsoft SQL Server

Covers: Microsoft® SQL Server 2008 R2

User Level: Intermediate—Advanced

Download

Click to download

or

Download

Click to download

Read More...

Professional SQL Server 2008 Internals and Troubleshooting

# Paperback: 624 pages
# Publisher: Wrox (January 7, 2010)
# Language: English
# ISBN-10: 9780470484289
# ISBN-13: 978-0470484289


Product 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
    * Viewing Server Performance with PerfMon and the PAL Tool
    * Tracing SQL Server with SQL Trace and Profiler
    * Consolidating Data Collection with SQLDiag and the PerfStats Script
    * Introducing RML Utilities for Stress Testing and Trace File Analysis
    * Bringing It All Together with SQL Nexus
    * Using Management Studio Reports and the Performance Dashboard
    * Using SQL Server Management Data Warehouse
    * Shortcuts to Efficient Data Collection and Quick Analysis

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
From the Back Cover
An in-depth look at SQL Server and best practices for troubleshooting

When faced with a variety of SQL Server issues, you need to be able to troubleshoot SQL Server as well as its underlying operating system. To that end, this author group of SQL Server experts presents you with invaluable advice that brings together—and simplifies—practical internal information concerning SQL Server along with troubleshooting techniques and methodologies. Packed with real-world examples of ways to effectively use troubleshooting tools, this book shows you how to efficiently and accurately determine the root of your SQL Server problem so you can successfully resolve it.

    *

      Escorts you through the lifecycle of a query to establish an understanding of the fundamental concepts and architectures
    *

      Examines the use of memory including the physical components, Windows memory management, and SQL Server's own memory architecture
    *

      Reviews SQL Server wait types and how to monitor them with Extended Events
    *

      Equips you with the knowledge to confidently specify and monitor your storage performance requirements
    *

      Details SQL Server's locking model, the internal use of latches, and row versioning
    *

      Shows you how to use SQLDiag, RML Utilities, SQL Nexus, the Management Data Warehouse, and how to build your own SQL Server Management Studio reports

Download

Click to download

Read More...