rssHome » Database

Microsoft SQL Server 2008 Management and Administration

Microsoft SQL Server 2008 Management and Administration

Book Description

If you need to deploy, manage, or secure Server 2008, this is the complete, fast-paced, task-based reference you’ve been searching for. Authored by a world-class expert on Server in the enterprise, this book goes far beyond the basics, taking on the complex tasks that DBAs need to make the most of ’s flagship database platform. Server , Ross Mistry presents proven techniques for Server 2008 installation, upgrades, backup/restore, data transfer, indexing, high availability, security, and much more. He draws on extensive testing in high-profile production environments to offer step-by-step solutions and powerful tips you won’t find anywhere else. Every chapter begins with a section identifying Server 2008’s most significant new improvements, and concludes with a convenient summary of best practices. Each chapter also outlines the benefits of leveraging Windows Server 2008.

Understand how to:

  • Master DBA tips, tricks, and best practices proven in actual enterprise environments
  • Install, upgrade or transition to 2008.
  • Harden and Secure an implementation.
  • Encrypt from an end-to-end perspective.
  • Implement high availability–and leverage SQL Server 2008’s major improvements to failover clustering and database mirroring Download Now »

Oracle Application Express 4.0 with Ext JS

Oracle Application Express 4.0 with Ext JS

Book Description

Modern web-based applications are moving rapidly away from simple HTML pages, with users expecting desktop styled rich internet applications. Application Express includes multiple built-in interfaces especially designed for adding libraries and components. is a polished, high performance set of customizable UI widgets with a well designed and extensible Component model. Combining components with the well engineered server side processing provided by APEX is a recipe for success.

Written by Oracle ACE, Mark Lancaster, this book is a complete practical guide to building robust desktop-styled web applications using Oracle Application Express and the powerful library

This book starts off by setting up a productive environment for and Ext JS, preparing you to get ready to code, and then gradually introducing you to the Ext JS API. You then create a theme based on Ext JS into APEX from scratch, starting with integrating the Ext JS library into the page template, then covering all the template types.

You further enrich your interface by integrating Ext JS form components and Ext JS layout elements. You are shown how to integrate components including tab panels, toolbars and menus. Existing components are also enhanced, transforming select lists into auto-completing combo boxes and text-areas auto-sizing as you type.

Using exciting new Plug-ins feature, you will learn how to develop custom APEX components that can be used declaritively. This book extends native APEX functionality by integrating Ext JS widgets and components with integrated server-side JavaScript generation, AJAX processing and validation. Download Now »

SQL All-in-One For Dummies, 2nd Edition

SQL All in One For Dummies, 2nd Edition

Book Description

The soup-to-nuts guide on all things !

, or structured query language, is the international standard language for creating and maintaining relational databases. It is the basis of all major databases in use today and is essential for the storage and retrieval of database information. This fun and friendly guide takes SQL and all its related topics and breaks it down into easily digestible pieces for you to understand. You’ll get the goods on relational database design, , and maintenance, enabling you to start working with SQL right away!

  • Provides an overview of the SQL language and examines how it is integral for the storage and retrieval of database information
  • Includes updates to SQL standards as well as any new features
  • Explores SQL concepts, relational database , SQL queries, data security, database tuning, and more
  • Addresses the relationship between SQL and as well as SQL and

If you’re looking for an up-to-date sequel to the bestelling first edition of SQL All-in-One , then this is the book for you!

Download Now »

Scaling CouchDB

Scaling CouchDB

Book Description

A practical guide to web developers who need to scale their database instances. The basic concepts behind ’s scalability (i.e. its distributed shared nothing architecture) will be covered as well as:

  • Replicating using both Futon and ’s RESTful API
  • Continuous replication
  • Conflict resolution
  • Load balancing
  • Clustering with CouchDB Lounge

About the Author
Bradley Holt is a web developer and entrepreneur. He has ten years of experience with PHP and MySQL and started using CouchDB soon before version 1.0 was released. He is the co-founder of Found Line, a creative services firm located in Burlington, Vermont. He has been the primary organizer of his local PHP users group since its inception in 2007.

He is a Board Member at Vermont Community Access Media (VCAM), a non-profit community media and technology center. He is a minor contributor of source code and bug reports to Zend Framework and an active member of the PHP community. He blogs at http://bradley-holt.com/ and can be found on Twitter as @BradleyHolt [http://twitter.com/BradleyHolt. Download Now »

Beginning Oracle Application Express 4

Beginning Oracle Application Express 4

Book Description

Beginning Application Express 4 introduces one of the most talked about platforms to come out of Corporation in years. Application Express, called APEX for short, enables rapid and easy of web-based applications that make full use of Database. The release of APEX 4 brings a huge leap forward in terms of functionality and usability for both the developer and the end user. Power users and programmers alike can quickly put together robust and scalable applications for use by one person, by a department, by an entire company.

Whether you’re new to Oracle or an old hand who’s yet to test the waters of APEX, Beginning Oracle Application Express 4 introduces the processes and best practices you’ll need to become proficient with APEX. The book shows off the environment, the utilities and tools available, and then continues by walking through the process of building a working system from the ground up. While the book assumes a foundational knowledge of and PL/, all code used is documented and explained so that those new to the languages will not be lost.

  • Covers brand-new functionality in APEX 4
  • Provides fully documented and explained example code
  • Guides you through creating a working and fully deployable application

What you’ll learn

Oracle PL/SQL Best Practices

Oracle PL/SQL Best Practices

Book Description

In this compact book, Steven Feuerstein, widely recognized as one of the world’s leading experts on the PL/ language, distills his many years of , teaching, and writing about PL/ into a set of best practices-recommendations for developing successful applications. Covering the latest release, Database 11gR2, Feuerstein has rewritten this new edition in the style of his bestselling Oracle PL/ . The text is organized in a problem/solution format, and chronicles the programming exploits of developers at a mythical company called My Flimsy Excuse, Inc., as they write code, make mistakes, and learn from those mistakes-and each other.

This book offers practical answers to some of the hardest questions faced by developers, including:

  • What is the best way to write the SQL logic in my application code?
  • How should I write my packages so they can be leveraged by my entire team of developers?
  • How can I make sure that all my team’s programs handle and record errors consistently?

Oracle Best Practices summarizes PL/SQL best practices in nine major categories: overall PL/SQL application ; programming standards; program testing, tracing, and debugging; variables and data structures; control logic; error handling; the use of SQL in PL/SQL; building procedures, functions, packages, and triggers; and overall program performance. Download Now »

Copyright © 2012 Wow! eBook · All rights reserved · Powered by WordPress