Skip to content

Software Development News: .NET, Java, PHP, Ruby, Agile, Databases, SOA, JavaScript, Open Source

Methods & Tools

Subscribe to Methods & Tools
if you are not afraid to read more than one page to be a smarter software developer, software tester or project manager!


Oracle Customers Plug into the Cloud with Oracle Database 12c

Oracle Database News - Wed, 07/30/2014 - 13:00
Oracle Customers Plug into the Cloud with Oracle Database 12cLatest version of world’s #1 database is available now, and includes new Oracle Database In-Memory technology to power the real-time enterprise Redwood Shores, Calif. – July 30, 2014 News Summary

In today's fast-paced, technology-driven business environment, organizations face an ever-growing volume of enterprise data to manage and analyze. To effectively deliver enhanced customer experiences, analytical insights, and efficient operations, companies around the world are adopting Oracle Database 12c, including key options such as Oracle Multitenant and Oracle Database In-Memory. Oracle Multitenant is helping customers to more easily consolidate and manage multiple databases as one, resulting in improved efficiency and simplified management with maximum availability. Additionally, the newly available Oracle Database In-Memory option transparently extends the power of Oracle Database 12c to enable organizations to discover business insights in real-time while simultaneously increasing transactional performance.

News Facts Customers and partners worldwide are using Oracle Database 12c to manage their critical and complex data workloads. The latest release, Oracle Database 12c Release, is generally available and includes Oracle Database In-Memory, an option designed to power the real-time enterprise, enabling better and faster business decisions by accelerating the performance of Oracle Database applications. By leveraging the Oracle Multitenant architecture that simplifies database consolidation in the cloud, organizations around the world have deployed database as a service (DBaaS), allowing them to manage multiple databases on a shared, scalable, and agile database platform. With DBaaS facilitated through Oracle Database 12c, customers have improved server utilization and streamlined database management, all while retaining database isolation and with no application changes. Many Oracle PartnerNetwork partners have deployed their applications on Oracle Database 12c to gain a competitive advantage for themselves and their end users, making it one of the most rapidly adopted technologies in the Oracle partner ecosystem. By hosting clients’ databases in the cloud with Oracle Multitenant, partners are passing along cost savings to their customers through streamlined management, shared resources, and trusted security. This latest release of Oracle Database 12c also enables customers and partners to: Easily develop applications with new types of data. With JSON support in Oracle Database 12c Release, organizations can store JSON document data in their Oracle Database and query it through traditional SQL and RESTful interfaces. Accelerate database and data warehousing performance. Attribute clustering is designed to ensure that related columns in a database are physically stored together for faster access. Simplify delivery of mission-critical DBaaS environments. A new Rapid Home Provisioning feature in Oracle Database 12c simplifies provisioning, upgrade, patching, and maintenance of multitenant database cloud environments.Supporting Quotes “As the cloud, mobile devices, and the web send larger volumes of data into the enterprise, organizations are challenged to manage this data efficiently and cost-effectively,” said Andrew Mendelsohn, executive vice president, Oracle Database Server Technologies. “Customers around the world are harnessing Oracle Database 12c along with options including Oracle Multitenant to consolidate their databases and deliver database as a service on premises and in the cloud. With the added firepower of Oracle Database In-Memory now available, customers can instantly gain the competitive advantage of the real-time enterprise with the flip of a switch.” “The Oracle Taleo Business Edition Cloud Service platform leverages Oracle Database 12c with Oracle Multitenant to provide a proven, scalable, multitenant platform to further grow our customer base,” said Obaidur Rashid, senior director, development, Oracle Taleo. “By migrating Oracle Taleo Business Edition to a SaaS platform using Oracle Multitenant, we now have a fast, reliable, and scalable database powering our applications to better meet customers’ service-level expectations and help grow our business.” “Deploying Oracle Database 12c with Oracle Multitenant on Oracle Exadata has saved us $1.7 million in capital expense alone, had we decided to maintain our current AIX P-Series environment,” said Brian Pawlik, information services manager, Pulte Group Inc. “The value of Oracle Multitenant ‘manage many-as-one’ for patching and database management has allowed us to save in increasing database staff, and the database clone capability, we project, will save us approximately four man-months in our first year. This was an exceptionally smooth migration for us from Oracle Database 11g to Oracle Database 12c and Oracle Multitenant on Oracle Exadata.” “With Oracle Database In-Memory, we saw our query performance go from minutes and hours to seconds, while dropping indexes reduced our database size by 80 percent,” said Francois Bermond, Data & Analytics, Schneider Electric. Supporting Resources Oracle Database 12c Oracle Database In-Memory Oracle Multitenant Connect with Oracle Database via the Oracle BlogFacebook, and TwitterAbout Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center.  For more information about Oracle (NYSE:ORCL), visit

TrademarksOracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.Contact Info

Letty Ledbetter

Teri Whitaker

Categories: Database, Vendor

Oracle Customers Plug into the Cloud with Oracle Database 12c

Oracle Database News - Wed, 07/30/2014 - 13:00
Oracle Customers Plug into the Cloud with Oracle Database 12c -- Latest version of world’s #1 database is available now, and includes new Oracle Database In-Memory technology to power the real-time /us/corporate/press/2252680 en
Categories: Database, Vendor

Expiration Date of Tender Offer for MICROS Systems, Inc. Shares Extended to August 15, 2014

Oracle Database News - Tue, 07/29/2014 - 12:32
Expiration Date of Tender Offer for MICROS Systems, Inc. Shares Extended to August 15, 2014REDWOOD SHORES, Calif. – July 29, 2014

Oracle Corporation (NYSE: ORCL) announced today that, in accordance with the terms of its merger agreement with MICROS Systems, Inc. (Nasdaq: MCRS), Rocket Acquisition Corporation, a subsidiary of OC Acquisition LLC, a subsidiary of Oracle Corporation, has extended its all-cash tender offer for $68.00 per share for all of the issued and outstanding shares of common stock, par value of $0.025 per share (the “Shares”), of MICROS Systems, Inc. to 12:00 Midnight, New York City time, at the end of August 15, 2014, unless further extended. The tender offer was previously set to expire at 12:00 Midnight, New York City time, at the end of July 31, 2014.

American Stock Transfer & Trust Company LLC, the depositary for the tender offer, has indicated that as of 12:00 Midnight, New York City time, at the end of July 28, 2014, approximately 74,902,285 Shares were issued and outstanding, and 1,896,113 Shares have been tendered into and not properly withdrawn from the tender offer.

About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE: ORCL), visit


Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

This document is for informational purposes only and may not be incorporated into a contract or agreement.

Contact Info

Ken Bond
Oracle Investor Relations

Deborah Hellinger
Oracle Corporate Communications

Additional Information

This communication does not constitute an offer to buy or solicitation of an offer to sell any securities. This communication is for informational purposes only. The tender offer is not being made to, nor will tenders be accepted from, or on behalf of, holders of shares in any jurisdiction in which the making of the tender offer or the acceptance thereof would not comply with the laws of that jurisdiction. The tender offer is being made pursuant to a tender offer statement on Schedule TO (including the Offer to Purchase, a related Letter of Transmittal and other offer materials) filed by Rocket Acquisition Corporation with the U.S. Securities and Exchange Commission (“SEC”) on July 3, 2014, as amended from time to time. In addition, on July 3, 2014, MICROS Systems, Inc. filed a Solicitation/Recommendation statement on Schedule 14D-9 with the SEC related to the tender offer. Stockholders of MICROS Systems, Inc. are urged to read these documents, all amendments thereto and other documents filed with the SEC carefully in their entirety because they contain important information about the tender offer. The tender offer statement and certain other offer documents, along with the Solicitation/Recommendation statement, will be made available to all stockholders of MICROS Systems, Inc. at no expense to them. These documents are available at no charge through the web site maintained by the SEC at The Offer to Purchase, related Letter of Transmittal, the Solicitation/Recommendation statement and other offering documents may also be obtained for free by contacting the Information Agent for the tender offer, Innisfree, M&A Incorporated, toll-free at 888-750-5834.

Cautionary Statement Regarding Forward-Looking Statements

This document contains certain forward-looking statements about Oracle and MICROS Systems, Inc., including statements that involve risks and uncertainties concerning Oracle's proposed acquisition of MICROS Systems, Inc., anticipated customer benefits and general business outlook. When used in this document, the words "anticipates", “can", “will”, "look forward to", "expected" and similar expressions and any other statements that are not historical facts are intended to identify those assertions as forward-looking statements. Any such statement may be influenced by a variety of factors, many of which are beyond the control of Oracle or MICROS Systems, Inc., that could cause actual outcomes and results to be materially different from those projected, described, expressed or implied in this document due to a number of risks and uncertainties. Potential risks and uncertainties include, among others, the possibility that the transaction will not close or that the closing may be delayed, the anticipated synergies of the combined companies may not be achieved after closing, the combined operations may not be successfully integrated in a timely manner, if at all, general economic conditions in regions in which either company does business, and the possibility that Oracle or MICROS Systems, Inc. may be adversely affected by other economic, business, and/or competitive factors. Accordingly, no assurances can be given that any of the events anticipated by the forward-looking statements will transpire or occur, or if any of them do so, what impact they will have on the results of operations or financial condition of Oracle or MICROS Systems, Inc. You are cautioned to not place undue reliance on forward-looking statements, which speak only as of the date of this document. Neither Oracle nor MICROS Systems, Inc. is under any duty to update any of the information in this document.

In addition, please refer to the documents that Oracle and MICROS Systems, Inc., respectively, file with the U.S. Securities and Exchange Commission (the “SEC”) on Forms 10-K, 10-Q and 8-K. These filings identify and address other important factors that could cause Oracle's and MICROS Systems, Inc’s respective operational and other results to differ materially from those contained in the forward-looking statements set forth in this document. You are cautioned to not place undue reliance on forward-looking statements, which speak only as of the date of this document. Neither Oracle nor MICROS Systems, Inc. is under any duty to update any of the information in this document.

Categories: Database, Vendor

Processing and content analysis of various document types using MapReduce and InfoSphere BigInsights

IBM - DB2 and Informix Articles - Tue, 07/29/2014 - 05:00
Businesses often need to analyze large numbers of documents of various file types. Apache Tika is a free open source library that extracts text contents from a variety of document formats, such as Microsoft Word, RTF, and PDF. Learn how to run Tika in a MapReduce job within InfoSphere BigInsights to analyze a large set of binary documents in parallel. Explore how to optimize MapReduce for the analysis of a large number of smaller files. Learn to create a Jaql module that makes MapReduce technology available to non-Java programmers to run scalable MapReduce jobs to process, analyze, and convert data within Hadoop.
Categories: Database

New Oracle E-Business Suite Extensions for Oracle Endeca Help Companies Make Faster, More Informed Decisions

Oracle Database News - Mon, 07/28/2014 - 13:00
New Oracle E-Business Suite Extensions for Oracle Endeca Help Companies Make Faster, More Informed Decisions Capabilities include a complete data view, key performance metrics, advanced visualizations and instant searchRedwood Shores, Calif. – July 28, 2014News Summary

Oracle has released four new Oracle E-Business Suite Extensions for Oracle Endeca to help organizations make better operational decisions, improve process efficiency, and drive better cost and revenue decisions. Leveraging Oracle Endeca Information Discovery technology, these new extensions offer customers a complete data view, key performance metrics, advanced visualizations and virtually instant search results that allow them to discover and act on their most important business challenges.

News Facts Oracle has released four new Oracle E-Business Suite Extensions for Oracle Endeca to help organizations explore operational data in real-time. The four new Oracle E-Business Suite Extensions for Oracle Endeca are: Oracle Quality Extensions for Oracle Endeca: Allows quality analysts, shop floor managers and production control personnel to quickly explore and analyze product and process quality data within Oracle E-Business Suite to identify nonconformance sources, investigate root causes and take immediate corrective action Oracle TeleService Extensions for Oracle Endeca: Enables users to proactively monitor service requests, facilitate timely resolution of customer issues and improve resource planning with an integrated, in-memory service operations dashboard. Oracle Service Contracts Extensions for Oracle Endeca: Maximizes customer satisfaction by letting users effectively manage contract renewals and proactively monitor performance metrics and the customer service experience. Oracle Human Resources Extensions for Oracle Endeca: Provides actionable information in real-time, improves productivity and leverages existing investments in the Oracle Human Capital Management product suite. The new extensions help organizations to drive revenue and efficiency and focus on transactions that require immediate attention and have a measurable impact on business results. Oracle E-Business Suite Extensions for Oracle Endeca offer customers a complete data view, key performance metrics, advanced visualizations and instant search results across organizations and flex fields that might not be found using a conventional ERP query interface. Leveraging Oracle Endeca Information Discovery technology, which provides a virtually seamless layer on the Oracle E-Business Suite, the new extensions help ensure that operational information is pre-classified, pre-summarized and pre-filtered to enable search, discovery and analysis via a rich, configurable interface. With a simple, all-in-one installer, customers can quickly deploy Oracle E-Business Suite Extensions for Oracle Endeca, achieve out-of-the-box security and get more value by integrating new capabilities with existing Oracle E-Business Suite applications. Oracle E-Business Suite Extensions for Oracle Endeca are also available on mobile devices, helping to increase productivity by empowering the mobile workforce with the convenience, speed and flexibility of anywhere, anytime data access.Supporting Quote “To succeed in today’s increasingly competitive and fast-paced business environment, speed is everything,” said Cliff Godwin, senior vice president, Applications Development, Oracle. “The Oracle E-Business Suite Extensions for Oracle Endeca allow organizations to leverage the full power of operational data to quickly discover and act on transactions that require immediate attention. By offering real-time access in an easy-to-digest display, these new extensions enable users to make faster, better informed decisions that drive revenue and reduce costs.” Supporting Resources Oracle E-Business Suite Release 12.1 Demo: Oracle E-Business Suite Endeca Applications Oracle Endeca Information Discovery Oracle E-Business Suite on YouTube Oracle Quality Extensions for Oracle Endeca Oracle TeleService Extensions for Oracle Endeca Oracle Service Contracts Extensions for Oracle Endeca Oracle Human Resources Extensions for Oracle Endeca

About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit


Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.


Karen Hartquist

Simon Jones
Blanc & Otus

Categories: Database, Vendor

Oracle Introduces Oracle Project Procurement for Better Alignment of Project Management and Procurement

Oracle Database News - Mon, 07/28/2014 - 13:00
Oracle Introduces Oracle Project Procurement for Better Alignment of Project Management and ProcurementNew Oracle E-Business Suite Solution Helps Improve Project Performance Redwood Shores, Calif. – July 28, 2014News Summary

In order for project-centric businesses with high procurement spend or significant reliance on subcontracts to successfully deliver the expected value to their customers without wasting limited resources, they must ensure that project and procurement teams are closely aligned. To address this challenge, Oracle today announced Oracle Project Procurement, the latest addition to the Oracle E-Business Suite Project Portfolio Management and Procurement applications. Oracle Project Procurement helps project teams eliminate silos around project management and procurement by establishing and measuring strategic objectives, hence driving accountability for value to the customer, optimizing procurement planning and execution throughout the lifecycle of a project. This new application provides project teams and stakeholders the ability to share information on project requirements and schedule, product specifications, budget and quality standards to provide the necessary information to meet their organization’s objectives and deliverables.

News Facts To help organizations further improve project performance and profitability, Oracle today announced Oracle Project Procurement. Part of the Oracle E-Business Suite Project Portfolio Management family of applications, Oracle Project Procurement enables project teams to align and measure project and organizational objectives around procurement planning, decision making and execution throughout the lifecycle of a project. With an in-memory visualization layer that leverages Oracle Endeca Information Discovery, Oracle Project Procurement enables faster and better decision making by breaking down functional silos and helping to eliminate the communication gaps that exist between project management and procurement. By enabling increased collaboration across project teams, Oracle Project Procurement helps ensure projects are delivered according to plan, eliminate sources of waste, reduce project risk and provide visibility into supplier performance metrics. Oracle Project Procurement seamlessly integrates with Oracle E-Business Suite Project Portfolio Management and Oracle E-Business Suite Advanced Procurement to give businesses access to the data needed to manage the entire project procurement process. Optimizing Project Procurement Planning, Decision Making and Execution The Oracle E-Business Suite Supply Chain Management family of applications integrates and automates key supply chain processes, from design, planning and procurement to manufacturing and fulfillment, enabling organizations to power information-driven value chains. With the release of Oracle Project Procurement, organizations can make better procurement decisions faster, reduce process latency, reduce waste by aligning delivery to key objectives and enable best-in-class project procurement processes. Oracle Project Procurement lets organizations: Enhance procurement planning for projects that depend heavily on procured materials and services Drive alignment and accountability of all stakeholders around the project’s acquisition strategy Achieve faster project planning by enabling collaboration between project and procurement team members Effectively execute supply chain processes and plan and track supplier performance Act on procurement plans by initiating requisitions or negotiations Leverage the power of Oracle Endeca to discover project risks before they happen Supporting Quote “Functional silos and communication gaps between project management and procurement can increase project risk, create inefficiencies and make a significant impact on the bottom-line of projects,” said Cliff Godwin, senior vice president, Applications Development, Oracle. “Oracle Project Procurement addresses this challenge by enabling project management and procurement to closely collaborate throughout the lifecycle of the project. This not only helps project teams to establish and measure strategic project objectives, but importantly helps improve project procurement planning, decision making and execution.”Supporting Resources Oracle Project Procurement Oracle Endeca Information Discovery Oracle E-Business Suite Project Portfolio Management Oracle E-Business Suite Advanced Procurement

About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit


Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.


Karen Hartquist

Simon Jones
Blanc & Otus

Categories: Database, Vendor

Understanding Hugepages in Oracle Database

Database Journal News - Mon, 07/28/2014 - 08:01

Large Oracle instances running on Linux can benefit from using hugepages.  Read on to see what hugepages are and how they help Oracle run better.

Categories: Database

For proven in-memory technology without costly add-ons, migrate your Oracle databases to SQL Server 2014

Today, we are making available a new version of SQL Server Migration Assistant (SSMA), a free tool to help customers migrate their existing Oracle databases to SQL Server 2014. Microsoft released SQL Server 2014 earlier this year, after months of customer testing, with features such as In-Memory OLTP to speed up transaction performance, In-Memory Columnstore to speed up query performance, and other great hybrid cloud features such as backup to cloud directly from SQL Server Management Studio and the ability to utilize Azure as a disaster recovery site using SQL Server 2014 AlwaysOn.

Available now, the SQL Server Migration Assistant version 6.0 for Oracle databases, greatly simplifies the database migration process from Oracle databases to SQL Server. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion, data migration as well as migration testing to reduce cost and reduce risk of database migration projects. Moreover, SSMA version 6.0 for Oracle databases brings additional features such as automatically moving Oracle tables into SQL Server 2014 in-memory tables, the ability to process 10,000 Oracle objects in a single migration, and increased performance in database migration and report generation.

Many customers have realized the benefits of migrating their database to SQL Server using previous versions of SSMA. For example:

SSMA for Oracle is designed to support migration from Oracle 9i or later version to all editions of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012 and SQL Server 2014. The SSMA product team is also available to answer your questions and provide technical support at

To download SSMA for Oracle, go here. To evaluate SQL Server 2014, go here.  

Categories: Database

Oracle Expands Footprint in Seattle with New Cloud Engineering Center

Oracle Database News - Thu, 07/24/2014 - 18:00
Oracle Expands Footprint in Seattle with New Cloud Engineering Center HackerX Recruitment Event to Kick Off Seattle Office Opening REDWOOD SHORES, Calif. – July 24, 2014


News Summary

To take advantage of Seattle’s highly skilled workforce and experienced cloud engineering community, Oracle has unveiled a new cloud development facility in the city’s tech corridor. The company plans to hire more than 100 engineers in Seattle to bolster and build its growing portfolio of public cloud computing services. The new center will be unveiled during HackerX, an open house and recruitment event aimed at giving cloud developers a chance to explore employment opportunities at Oracle.

News Facts Today, Oracle unveiled its new cloud engineering center in downtown Seattle, Washington, where developers will focus on building new cloud computing services as part of Oracle’s comprehensive cloud offerings. Oracle expanded its presence in Seattle to take advantage of the deep expertise in cloud computing available in Seattle’s rapidly growing technical community. The company plans to hire more than 100 top-tier engineers in this new location. The state-of-the-art facility was designed to support a startup-focused, entrepreneurial culture and offers an exciting working environment with numerous amenities. Local cloud engineering veterans, including Oracle’s Craig Kelly and Don Johnson, will lead the Oracle cloud engineering center. A HackerX open house and recruitment event will take place at Oracle’s new Seattle facility on Tuesday, July 29, from 6 p.m. to 9 p.m. Supporting Quotes “Oracle is committed to providing organizations with the industry’s broadest and most advanced cloud portfolio,” said Prashant Ketkar, vice president, product management, Oracle. “By opening this state-of-art facility, we are equipped to aggressively build out new cloud services. Seattle has a deep pool of talented engineers with its rich history of innovation and is the perfect location for us to harness that talent in order to accelerate our cloud investments.” “We are building a team of rock star engineers who want to shape the next-generation, cutting-edge public cloud,” said Don Johnson, senior director, product development. “Equally important, this is a unique opportunity to build the culture from the ground up—like a startup, but with the resources of a company and customer base that can influence the market.”

Supporting Resources

Register for HackerX Apply for Oracle Careers in Seattle Read 5 Reasons Why CEOs Should Love the Cloud, by Mark Hurd Sign up for Oracle Cloud Learn more about Oracle Cloud Join the Oracle Cloud online communities: TwitterFacebook and blogsAbout Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit


Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

# # #


Chery Isen
Isen & Co.

Categories: Database, Vendor

Get started backing up to the cloud with SQL Server Backup to Microsoft Azure Tool

If you’re considering backing up your SQL Server database to the cloud, there are many compelling reasons. Not only will you have an offsite copy of your data for business continuity and disaster recovery purposes, but you can save on CAPEX by using Microsoft Azure for cost-effective storage.  And now, you can choose to backup to Microsoft Azure even for databases that aren’t running the latest version of SQL Server – creating a consistent backup strategy across your database environment. 

SQL Server has these tools and features to help you back up to the cloud:

  • In SQL Server 2014, Managed Backup to Microsoft Azure manages your backup to Microsoft Azure, setting backup frequency based on data activity.  It is available inside the SQL Server Management Studio in SQL Server 2014.
  • In SQL Server 2012 and 2014, Backup to URL provides backup to Microsoft Azure using T-SQL and PowerShell scripting.
  • For prior versions, SQL Server Backup to Microsoft Azure Tool enables you to back up to the cloud all supported versions of SQL Server, including older ones.  It can also be used to provide encryption and compression for your backups – even for versions of SQL Server that don’t support these functions natively.

To show you how easy it is to get started with SQL Server Backup to Microsoft Azure Tool, we’ve outlined the four simple steps you need to follow:

Prerequisites: Microsoft Azure subscription and a Microsoft Azure Storage Account.  You can log in to the Microsoft Azure Management Portal using your Microsoft account.  In addition, you will need to create a Microsoft Azure Blob Storage Container:  SQL Server uses the Microsoft Azure Blob storage service and stores the backups as blobs. 

Step 1: Download the SQL Server Backup to Microsoft Azure Tool, which is available on the Microsoft Download Center.

Step 2: Install the tool. From the download page, download the MSI (x86/x64) to your local machine that has the SQL Server Instances installed, or to a local share with access to the Internet. Use the MSI to install the tool on your production machines. Double click to start the installation. 

Step 3: Create your rules.  Start the Microsoft SQL Server Backup to Microsoft Azure Tool Service by running SQLBackup2Azure.exe.  Going through the wizard to setup the rules allows the program to process the backup files that should be encrypted, compressed or uploaded to Azure storage. The Tool does not do job scheduling or error tracking, so you should continue to use SQL Server Management Studio for this functionality.

On the Rules page, click Add to create a new rule.    This will launch a three screen rule entry wizard.

The rule will tell the Tool what local folder to watch for backup file creation. You must also specify the file name pattern that this rule should apply to.

To store the backup in Microsoft Azure Storage, you must specify the name of the account, the storage access key, and the name of the container.  You can retrieve the name of the storage account and the access key information by logging into the Microsoft Azure management portal.

At this time, you can also specify whether or not you wish to have the backup files encrypted or compressed.

Once you have created one or more rules, you will see the existing rules and the option to Modify or Delete the rule.

Step 4: Restore a Database from a Backup Taken with SQL Server Backup to Microsoft Azure Tool in place. The SQL Server Backup to Microsoft Azure Tool creates a ‘stub’ file with some metadata to use during restore.  Use this file like your regular backup file when you wish to restore a database.  SQL Server uses the metadata from this file and the backup on Microsoft Azure storage to complete the restore. 

If the stub file is ever deleted, you can recover a copy of it from the Microsoft Azure storage container in which the backups are stored.  Place the stub file into a folder on the local machine where the Tool is configured to detect and upload backup files.

That’s all it takes!  Now you’re up and running with Backup to and Restore from Microsoft Azure.

To learn more about why to back up to the cloud, join Forrester Research analyst Noel Yuhanna in a webinar on Database Cloud Backup and Disaster Recovery.  You’ll find out why enterprises should make database cloud backup and DR part of their enterprise database strategy. 

The webinar takes place on Tuesday, 7/29 at 9 AM Pacific time; register now.

Categories: Database

Getting Started with Hashing in SQL Server

Database Journal News - Thu, 07/24/2014 - 08:01

Encryption brings data into a state which cannot be interpreted by anyone who does not have access to the decryption key, password, or certificates. Hashing brings a string of characters of arbitrary size into a usually shorter fixed-length value or key. Read on to learn about hashing in SQL Server and how it is different from encryption.

Categories: Database

Use the DB2 with BLU Acceleration Pattern to easily deploy a database

IBM - DB2 and Informix Articles - Thu, 07/24/2014 - 05:00
The database as a service (DBaaS) component of the IBM PureApplication System introduced many new features. This article describes some of them, including deployment of DB2 with BLU, increasing the database resources, and backup. You also will learn how the DB2 with BLU Acceleration Pattern can make it easier and faster to create and deploy BLU-enabled datasets in DBaaS
Categories: Database

DB2 monitoring enhancements for BLU Acceleration

IBM - DB2 and Informix Articles - Thu, 07/24/2014 - 05:00
BLU Acceleration is a collection of technologies for analytic queries that was introduced in IBM DB2 for Linux, UNIX and Windows (LUW) Version 10.5. BLU Acceleration can provide significant benefits in many areas including performance, storage savings, and overall time to value. This article provides an overview of the monitoring capabilities that support BLU Acceleration. These capabilities provide insight into the behavior of the database server and assist with tuning and problem determination activities. Extensive example queries help you start monitoring workloads that take advantage of BLU Acceleration.
Categories: Database

PostgreSQL updates 9.3.5, 9.2.9, 9.1.14, 9.0.18, and 8.4.22 released

PostgreSQL News - Thu, 07/24/2014 - 01:00

The PostgreSQL Global Development Group has released an update to all supported version of the database system, including versions 9.3.5, 9.2.9, 9.1.14, 9.0.18, and 8.4.22. This minor release fixes a number of issues discovered and reported by users over the last four months, including some data corruption issues, and is the last update of version 8.4. Users of version 9.3 will want to update at the earliest opportunity; users of version 8.4 will want to schedule an upgrade to a supported PostgreSQL version.

Among the notable issues fixed in this release are:

PostgreSQL 9.3 and pg_upgrade: Users who upgraded to version 9.3 using pg_upgrade may have an issue with transaction information which causes VACUUM to eventually fail. These users should run the script provided in the release notes to determine if their installation is affected, and then take the remedy steps outlined there.

PostgreSQL 9.3 crash recovery: Three issues which could compromise data integrity during crash recovery on master or standby servers in PostgreSQL 9.3 have been fixed.

GIN and GiST indexes: Three issues with GIN and GiST indexes, used for PostGIS and full text indexing, can cause corruption or incorrect query responses. Any indexes on bit or bit varying columns should be rebuilt following the instructions in the release notes.

Security during make check: The insecure socket permissions during "make check", reported in a previous security announcement, have now been fixed.

With this release, version 8.4 is now End-of-Life (EOL), per our Versioning Policy. This means that no additional updates will be released for version 8.4, and users should plan to upgrade to a later version very soon.

In addition the above, this update release includes the following fixes which affect multiple PostgreSQL versions:

  • Fix race condition with concurrent tuple updating
  • Prevent "could not find pathkey item to sort" planner error
  • Properly optimize subqueries with set-returning functions
  • Repair planner regression in optimizing AND/OR NULL
  • Fix planner handling of VARIADIC functions
  • Make json_populate_recordset handle nested JSON properly
  • Prevent corruption of TOAST values when creating complex types
  • Prevent "record type has not been registered" query error
  • Fix a possible crash condition with functions and rewinding cursors
  • Patch three memory leaks
  • Fix row checks for rows deleted by subtransactions
  • Change how pg_stat_activity displays sessions during PREPARE TRANSACTION
  • Prevent multixact ID corruption during VACUUM FULL
  • Fix indentation when displaying complex view definitions
  • Fix client hostname lookup in pg_hba.conf
  • Fix libpython linking on OSX
  • Avoid buffer bloat in libpq
  • Fix an issue with dumping materialized views
  • Fix pg_upgrade's handling of multixact IDs
  • Make sure that pgcrypto clears sensitive information from memory
  • Time zone updates for Crimea, Egypt, and Morocco

Four Windows-specific fixes are included in this release:

  • Prevent tablespace creation recovery errors
  • Fix detection of socket failures
  • Allow users to change parameters after startup
  • Properly quote executable names so they don't fail

A few of the issues above require post-update steps to be carried out by affected users. Please see the release notes for details.

As with other minor releases, users are not required to dump and reload their database or use pg_upgrade in order to apply this update release; you may simply shut down PostgreSQL and update its binaries. Users who have skipped multiple update releases may need to perform additional post-update steps; see the Release Notes for details.


Categories: Database, Open Source

PostgreSQL 9.4 Beta 2 Released

PostgreSQL News - Thu, 07/24/2014 - 01:00

The PostgreSQL Global Development Group has made available the second beta release of PostgreSQL 9.4. This beta contains previews of all of the features which will be available in version 9.4, plus corrections for many of the issues discovered by users who tested 9.4 Beta 1. Please download, test, and report what you find.

Among the changes made since 9.4 Beta 1 are:

  • Fix handling of two-phase commit and prepared statements for logical decoding
  • Multiple fixes for bugs in pg_recvlogical
  • Change slot handling logic for replication slots
  • Add support for BSD and e2fsprogs UUID libraries.
  • Multiple jsonb bug fixes
  • Remove use_json_as_text options from json functions
  • Make json_build_* functions STABLE instead of IMMUTABLE
  • Prevent ALTER SYSTEM from changing the data directory
  • Prevent autovacuum-related crash
  • Many documentation improvements and changes

Beta 2 includes changes to pg_control and to the system catalogs. As such, users who have been testing Beta 1 will need to upgrade in order to test Beta 2. We suggest using pg_upgrade for this upgrade in order to test that as well.

For a full listing of the features in version 9.4 Beta, please see the release notes. Additional descriptions and notes on the new features are available on the 9.4 Features Wiki Page.

We depend on our community to help test the next version in order to guarantee that it is high-performance and bug-free. Please download PostgreSQL 9.4 Beta 2 and try it with your workloads and applications as soon as you can, and give feedback to the PostgreSQL developers. Features and APIs in Beta 2 will not change substantially before final release, so it is now safe to start building applications against the new features. More information on how to test and report issues

Get the PostgreSQL 9.4 Beta 2, including binaries and installers for Windows, Linux and Mac from our download page.

Full documentation of the new version is available online, and also installs with PostgreSQL.

Categories: Database, Open Source

Oracle Linux 7 Now Available

Oracle Database News - Wed, 07/23/2014 - 13:00
Oracle Linux 7 Now Available New Release Continues the Tradition of Delivering an Operating Platform to Support Business-Critical Applications Across the Data Center and into the CloudREDWOOD SHORES, Calif. – July 23, 2014News Summary

Oracle today introduced Oracle Linux 7, an open source operating platform that gives customers and partners the capabilities, tools, and features they need to innovate, collaborate, and create solutions across traditional, cloud-based, and virtual environments. As with previous releases, Oracle Linux 7 is easy to download, free to distribute, and the only major enterprise Linux distribution that publishes all bug fixes and security errata publicly, providing more flexibility and choice than other commercial Linux distributions. With extensive testing for demanding workloads such as Oracle Database, a flexible free-to-use and paid support model, and strong uptake, Oracle Linux is the best general-purpose open source operating platform for the modern data center.

News Facts Oracle Linux 7 is generally available today. This release builds on Oracle’s approach to providing support for emerging technologies, such as OpenStack, while delivering the latest Linux innovations, tools, and features customers and partners need to deliver enterprise-grade solutions for the modern data center. Oracle Linux 7 features include XFS, Btrfs, Linux Containers (LXC), DTrace, Ksplice, Xen enhancements, and the Unbreakable Enterprise Kernel Release 3. Available for download from Oracle Software Delivery Cloud, Oracle Linux 7 is free to download and distribute. All bug fixes and security errata are published to Oracle’s public yum servers, allowing customers to install the same code across all their deployments, with or without a subscription, and creating a simple migration path from free to paid. No reinstalls are required. Oracle Linux is a general-purpose operating system designed to run any Linux application and provides an ideal platform for third-party solutions, giving partners and customers the freedom to choose the solution they need to meet their business objectives. Oracle Linux provides the performance and reliability to support business-critical workloads such as Oracle Database 12c and is used by all the x86-based Oracle engineered systems. More than 12,000 customers have selected Oracle Linux Support, which offers low-cost enterprise-class support with 24/7 access in 145 countries worldwide, premier backports, additional management tools, cluster software, indemnification, and more. Oracle Linux is the only Linux distribution that provides production support for zero-downtime updates with Ksplice. Ksplice allows customers to keep their systems secure by providing updates without the need to reboot and has been providing updates for production systems for more than seven years, delivering more than 1 million patches. It is also used to provide diagnostics on production servers, with debug kernels that can be applied and removed without restart. Ksplice is included with all Oracle Linux Premier Support subscriptions. Oracle Linux 7 provides a 10-year production lifecycle; those with Oracle Linux Support subscriptions receive lifetime support as well. Customers using the Unbreakable Enterprise Kernel Release 3 also have access to features such as Btrfs, DTrace, and Linux Containers (LXC) across multiple major releases (Oracle Linux 6.4 and later), allowing them time to plan their upgrade. Supporting Quotes “Oracle Linux continues to provide the most flexible options for customers and partners, allowing them to easily innovate, collaborate, and create enterprise-grade solutions,” said Wim Coekaerts, senior vice president of Linux and Virtualization Engineering, Oracle. “With Oracle Linux 7, users have more freedom to choose the technologies and solutions that best meet their business objectives. Oracle Linux allows users to benefit from an open approach for emerging technologies, like OpenStack, and allows them to meet the performance and reliability requirements of the modern data center.” “With the growing Oracle install base, we’ve been working closely with Oracle to strengthen collaboration between Lenovo solutions and Oracle Linux and Oracle VM,” said Darrel Ward, vice president and general manager, Enterprise Product Group, Lenovo. “Our customers benefit from the flexibility and performance Oracle Linux provides, allowing us to achieve the best low-cost infrastructure solution for SMB and midsize enterprises.” “Many customers today are standardizing their server deployments, using consistent hardware and operating system layers. A more consistent and optimized foundation streamlines support and manageability for a wide variety of business workloads, ranging from database and commercial applications to infrastructure and web-serving tasks,” said Al Gillen, Program VP, Servers and System Software, IDC. “Oracle starts with the mainline Linux code base, like all other Linux distribution providers. But the company then integrates value-added technologies such as Ksplice and DTrace with the Linux kernel to give customers a product optimized for commercial deployments that demand performance and reliability. This gives Oracle both a competitive story and a measurable differentiation." “OpenStack offers customers a reliable software platform for mission-critical, scalable clouds without the lock-in,” said Boris Renski, Co-Founder and CMO, Mirantis. “Oracle Linux 7 is an ideal operating system for OpenStack not only for its technical capabilities but because of its support for any OpenStack distribution, allowing organizations to build private or public clouds using the technology of their choosing.” “Microsoft congratulates Oracle on its release of Oracle Linux 7. Since June 2013, Microsoft and Oracle have collaborated to help customers embrace cloud computing by providing greater choice and flexibility in how to deploy Oracle software,” said Jason Zander, corporate vice president, Microsoft Azure. “We recently added Oracle Linux to the list of Hyper-V guest OS’s for Windows Server and Microsoft Azure and we look forward to offering this latest release in Microsoft Azure.” Supporting Resources Oracle Linux Download Oracle Linux 7 here. Individual packages are available on the public yum server. Terms, conditions, and restrictions apply. Data sheet: Oracle Linux Podcast: Q&A with Wim Coekaerts Oracle Linux Customers The Value of Oracle Linux Support IDC white paper: Oracle Linux: Engineered into a Business-Class Solution Wim Coekaerts Blog Connect with Oracle Linux via Blog, Facebook, Twitter, and YouTubeAbout Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center.  For more information about Oracle (NYSE:ORCL), visit

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Contact Info

Nicole Maloney

Danielle Tarp
Blanc & Otus for Oracle

Categories: Database, Vendor

Managing Big Data DBAs

Database Journal News - Mon, 07/21/2014 - 08:01

Technical support teams usually support familiar hardware and software configurations. Specialization in particular combinations of operating systems and database management software is common, and this allows some team members to gain in-depth experience that is extremely valuable in an enterprise IT setting. How has big data changed this paradigm?

Categories: Database

IBM InfoSphere Optim Data Growth: Setting up your first Archive

IBM - DB2 and Informix Articles - Mon, 07/21/2014 - 05:00
This article introduces the IBM InfoSphere Optim product. It explains its fundamentals elements, and shows step-by-step how to set up your first archive request; thus help technical audience in achieving comfort of getting on to product quickly.
Categories: Database

Sentiment Analysis with Microsoft APS and StreamInsight

In this overview and demo, we will show you what sentiment analysis is and how to build a quick mashup that combines real-time access to multiple data sources using tools from Microsoft.

Sentiment analysis is one of the hottest topics in the Big Data space. Sentiment analysis is the process of analyzing customer comments and feedback from Facebook, Twitter, Email, and more. The purpose of the analysis is to understand the overall sentiment the customer is trying to convey. This could be a negative sentiment, when the customer is unhappy with a company or its product. Neutral sentiment, when the customer is only mentioning a company or product, in passing, without a good or a bad feeling. The last is positive sentiment, when a customer is happy or excited about a company or its product.

Traditionally sentiment analysis was complicated because it required a mixture of very complex platforms and tools. Each component required for sentiment analysis was offered from a different company and required a large amount of custom work. The difficulty is further exasperated by hard-to- achieve business requirements. When we discuss sentiment analysis there are 3 key business requirements we see repeated:

  • Real-time access
  • Full granular data set (structured & unstructured)
  • BI and SQL front-end
Real-time Access

In the case of real-time access, business users need access to fresh data. In the world of social media, customer sentiment can change rapidly. With images and videos quickly being posted with re-tweets and Facebook ‘like’ capabilities, a good or bad aspect of a company’s product can go viral in minutes. Business users need to have the ability to analyze data as it comes in, in real-time. We will show in our overview video and demo, how we can utilize Microsoft’s StreamInsight technology for real-time data analysis and complex-event processing.

Full Granular Data Set

In the case of full granular data, in practice we have seen that using a traditional database system can hinder development. This is because a lot of the data that comes in for sentiment analysis such as email, is in a semi-structured or unstructured format. This means the data is not easily modeled into a database. The data does not come in a simple row/column format. Thus we utilize our Big Data technology that is meant for this type of data:  HDInsight (Hadoop). HDInsight is essentially Hortonworks Data Platform running on Windows. In our case we utilize HDInsight to land all of the data, in its raw original format, into the distributed file system HDFS. This allows us to ingest any kind of data, regardless of structure, and store that data online for further analysis at low cost. The Hadoop software is open-source and readily available.

BI and SQL Front-End

The most important area around delivering sentiment analysis to the business is access, making sure we are able to provide the data both in real-time (and high-fidelity) within the tools that our business users know and love. Previously when our customers were doing sentiment analysis on Hadoop systems, BI and SQL access was not available. This was not because the tools could not integrate with Hadoop systems. This was because they could not scale or have the same level of functionality. Some BI users have chosen Hive ODBC in Hadoop, which many claim to be slow and ‘buggy’. Instead here we utilize one of our flagship technologies: PolyBase. With PolyBase we expose the data in Hadoop, and relational SQL Server, with one T-SQL query. What this means is users can use BI tools like Excel, SSAS, or other 3rd party tools. They can then utilize PolyBase within Analytics Platform System (APS) to query that data either in Hadoop, or Parallel Data Warehouse (SQL Server), or mash up the data from both systems!

How It Works

Now we will show you how to use all of the tools from the SQL Server data platform to achieve sentiment analysis. This will allow you to quickly deploy and meet all 3 business requirements through a set of tools and platforms that are very easy to use, fully integrated, and ‘just work’ together.

Let’s get started with the first video (~5 minutes) where we present sentiment analysis using Microsoft technologies. We show you how sentiment analysis works, and how the Microsoft products fit. We then follow up by discussing the architecture in detail surrounding StreamInsight, HDInsight, and Analytics Platform System.

Watch the overview video:


In the second video (~7 minutes), we show you sentiment analysis in action. The demo will include a full sentiment-analysis engine running in real-time against Twitter data along with a web dashboard. We then stream Twitter data to both HDInsight and Parallel Data Warehouse. Finally, we end the demo by showcasing PolyBase, our flagship technology. With Polybase we can do data mashups combining data from relational and non-relational systems. We will use Polybase to write standard T-SQL queries against this data to determine tweet analytics and how social sentiment is fairing for our marketing campaigns and products.

Watch the demo video:

Categories: Database

Exadata: When A Smart Scan Isn't

Database Journal News - Thu, 07/17/2014 - 08:01

Exadata is known far and wide for Smart Scans, but sometimes Oracle can do better without one.  Read on to see how to know when Oracle decided to not continue with a Smart Scan.

Categories: Database