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!


Using Spark Streaming for keyword detection

IBM - DB2 and Informix Articles - Thu, 11/26/2015 - 06:00
As new kinds of devices connect to the internet, they generate petabytes of data every day. Companies analyze this valuable data to better understand and meet their customers’ needs. Streaming big data analytics gives users the ability to analyze data in real time, which is useful in time-critical applications like fraud detection. In this article, learn how to use the Spark Streaming platform for real-time keyword detection.
Categories: Database

SQL Server 2012 SP3 is now available!

Microsoft is pleased to announce the release of SQL Server 2012 Service Pack 3. The Service Pack is available for download on the Microsoft Download Center; it will be available on MSDN, MAPS/MPN, MBS/Partner Source, and VLSC in the coming weeks. As part of our continued commitment to software excellence for our customers, this upgrade is available to all customers with existing SQL Server 2012 deployments.

SQL Server 2012 Service Pack 3 provides additional updates to help workloads from a performance, scalability and monitoring perspective. Key updates include:

  • Scalability and performance improvements for the storage engine
  • Improvements in consistency check performance
  • Query hints to provide granular control while using Resource Governor
  • Additional monitoring capabilities through enhancements in DMV, Extended Events and Query Plans
  • Improved performance while opening and reading XEL files using XEvent Linq reader
  • Improved performance for spatial queries

SP3 contains Hotfix solutions provided in SQL Server 2012 cumulative updates up to and including Cumulative Update 9.

Find more information on SQL Server 2012 SP3 here. To obtain SQL Server 2012 SP3, please visit the links below:

SQL Server 2012 SP3

SQL Server 2012 SP3 Express

SQL Server 2012 SP3 Feature Packs

Categories: Database

Integrating Big Data Applications into Operational Environments

Database Journal News - Mon, 11/23/2015 - 09:01

Many IT enterprises have created big data applications to store and analyze massive amounts of historical data. Should these applications be installed in their own exclusive environment, or tightly integrated with current operational systems?

Categories: Database

5 steps for real-time data replication with IBM i remote journaling

IBM - DB2 and Informix Articles - Fri, 11/20/2015 - 06:00
Enterprises need real-time, trusted data to make decisions and stay competitive. Data loss is unacceptable, but the process to collect and synchronize data must have little to no effect on production environments. This article shows you how to use a remote journal to configure IBM InfoSphere Data Replication (IIDR) for IBM i. This trusted solution will help you effectively gather data without affecting your other business functions.
Categories: Database

Is It Time to Move from Oracle Database Standard Edition 2 or Enterprise Edition?

Database Journal News - Thu, 11/19/2015 - 09:01

New licensing for Oracle’s SE family line significantly lowers value to the enterprise.

Categories: Database

Always Encrypted in SQL Server & Azure SQL Database

This post was authored by Joseph Sirosh, Corporate Vice President of the Data Group at Microsoft.

Most data breaches involve the theft of critical data such as social security or credit card numbers. What if you could store these sensitive data elements encrypted in your database, allowing decryption only at the point of use by people or applications that need to access or process that data? For example, an admitting nurse at a doctor’s office may have a business need to access a patient’s unencrypted social security number, but that data may not need to be visible anywhere else in the system.

With the introduction of the Always Encrypted capability in SQL Server 2016 and Azure SQL Database you can now do exactly that. Your database data remains encrypted at all times during computations and query processing. This industry-first technology was developed jointly by Microsoft Research and the Data Group to offer our customers unparalleled data security.

We have enhanced the SQL Server client drivers to work in conjunction with SQL Server to decrypt and encrypt data at the point of use, requiring only minimal modifications to your applications. Encryption keys are managed outside of the database for maximum safety and separation of duties. Only authorized users with access to decryption keys can see unencrypted data while using your applications. 

As illustrated in the schematic below, the client driver encrypts the data on the client side using the keys only the client knows before sending encrypted data to the database. When the client application retrieves data from an encrypted column, the driver transparently decrypts the data before returning it to the application.

The security guarantees provided by Always Encrypted represent a shift in the industry and will help customers protect critical data in their on-premises, hosted and cloud databases.

Take the example of Financial Fabric, an ISV that offers the ‘DataHub’ aggregation and analytics service to hedge funds. They are an early adopter and beneficiary, relying on Always Encrypted to help protect sensitive data about their investors and their holdings, including investors’ names, addresses and their assets. Subhra Bose, the CEO of Financial Fabric, has referred to Always Encrypted as nothing less than a “game changer for the financial industry.”

To simplify the adoption of Always Encrypted, SQL Server Management Studio now includes the new Column Encryption Wizard. With just a few clicks this wizard will:

  1. Create the necessary encryption keys and store them in a secure location of the user’s choice,
  2. Generate the encryption metadata based on the choice of columns to be encrypted, and, if applicable,
  3. Encrypt any existing data without the user ever having to call a single encryption function or worry about new encryption syntax.

For more information on Always Encrypted including how to get started today, be sure to check out these additional resources:

At Microsoft we are working hard to keep our customers’ data safe, both on premises and in the cloud. Always Encrypted in SQL Server and Azure SQL DB represents an important step in that journey. We hope many of you give it a spin and share your thoughts and experiences with us.

- Joseph
Follow me on Twitter

Categories: Database

Marketers Optimize the Customer Experience with New Oracle Marketing Cloud Enhancements

Oracle Database News - Wed, 11/18/2015 - 09:00
Press Release Marketers Optimize the Customer Experience with New Oracle Marketing Cloud Enhancements New innovations enhance sales enablement, improve cross-channel orchestration and demonstrate marketing’s impact on business results

London, UK - Modern Marketing Experience—Nov 18, 2015

To help marketers deliver a more consistent customer experience across paid, owned and earned media, Oracle has introduced a series of new innovations within the Oracle Marketing Cloud. The new innovations enable marketers to orchestrate relevant mobile interactions for consumers and salespeople, clearly attribute revenue to marketing activities and optimize the experience for individual customers.

Marketers must adopt and embrace digital technologies in order to meet the skyrocketing expectations of digitally-savvy customers. For many marketers, this will require rethinking existing processes, as according to Forrester Research, more than three-quarters of marketing leaders believe that the majority of their digital customer engagements are not optimized today1.To optimize digital marketing activities and successfully meet the demands of today’s customer-first business environment, marketers need to be able to quickly and easily embrace data, technology and content.

By introducing new mobile, data, content and reporting capabilities, the latest additions to the Oracle Marketing Cloud enable modern marketers to successfully use digital technologies to deliver meaningful customer experiences and demonstrate marketing’s impact on business results. The new innovations help marketers to:

  • Enhance Sales Enablement: The new release includes enhancements to Engage and Profiler, Oracle Marketing Cloud’s sales tools, which help salespeople better understand the profile of their individual contacts and engage them with relevant content. The new release of Engage improves productivity and accelerates sales cycles by making pre-loaded campaigns and content accessible on mobile devices, while Profiler now enables salespeople to get a more holistic view of the customer through a new Google Chrome Extension.  

  • Improve Cross-Channel Orchestration: Expanded out-of-the-box in-app messaging empowers marketers to deliver a relevant message to consumers within the context of a mobile application. Rather than silo those messages within the app itself, it can now be orchestrated alongside email, social, push, SMS, MMS and other channels orchestrated inside the Oracle Marketing Cloud.

  • Extend Reach Into Paid Media Ecosystem: A new self-service tool for audience data integration helps marketing teams or their media vendors build integrations that send audience data from the Oracle Data Management Platform (DMP) into key digital advertising and media platforms, such as demand side platforms, ad networks and website optimization tools. The new integration tools enable marketers, publishers and advertisers to quickly and efficiently maximize existing investments and expand data-driven marketing initiatives.

  • Optimize the Consumer Experience: With new multivariate testing, marketers can now move beyond traditional A/B testing, which can oversimplify the complexities inherent in today’s consumer interactions, and can optimize the consumer experience by testing the performance of up to eight versions of the same message by analyzing variables including subject lines, content and the sender of the message.

  • Attribute Revenue to Marketing Activities: A new visually powerful, but simple, set of dashboards help marketers analyze what content and cross-channel interactions drive conversions. For power users, marketers can build customized reports based on specific engagement and conversion metrics that matter most to their business.

“As we look ahead to 2016, marketing’s ability to modernize existing processes and embrace data, technology and content will increasingly define the success of organizations across all industries,” said Kevin Akeroyd, SVP and GM, Oracle Marketing Cloud. “For many marketers, this will require a significant transformation and that is why we are so focused on making marketing technology more integrated, more holistic and, frankly, easier to use. With the latest enhancements to the Oracle Marketing Cloud, we continue to deliver on that vision with an exciting set of new innovations that improve sales enablement, allow better cross-channel orchestration and help marketers directly attribute revenue to marketing activities.”

1.Forrester Consulting Report on behalf of Qubit, Optimizing the Digital Customer Experience, March 2015 Download the full report here

  Contact Info Erik Kingham
+1.650.506.8298 About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. 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.

Safe Harbor

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

For More Information See the Oracle Marketing Cloud WebsiteVisit the Oracle Marketing Cloud Blog Talk to a Press Contact

Erik Kingham

  • +1.650.506.8298

Follow Oracle Corporate

Categories: Database, Vendor

The CMO Club and Oracle Deliver New Solution Guide to Help CMOs Transform Their Marketing Organization

Oracle Database News - Tue, 11/17/2015 - 09:00
Press Release The CMO Club and Oracle Deliver New Solution Guide to Help CMOs Transform Their Marketing Organization New CMO Solution Guide provides best practices to help marketers maximize business impact of data, technology and content

Redwood Shores, California—Nov 17, 2015

To help CMOs meet skyrocketing customer and boardroom expectations, The CMO Club, along with Oracle, today released “The CMO Solution Guide for Building a Modern Marketing Organization.” The guide, which is based on interviews with CMOs and digital marketing leaders from major brands including Dow Chemical, JetBlue Airways, MasterCard, PayPal, Quiznos, The Hershey Company and Viking River Cruises, includes insights and best practices that CMOs can apply to build customer-first marketing teams that drive measureable results.

Marketing leaders are faced with a perfect storm of business, consumer and technological change that is exponentially increasing the complexity of every single marketing activity. In this new business environment, marketers need to rethink existing processes and embrace data, technology and content to deliver more meaningful customer experiences and demonstrate marketing’s impact on business results. To help marketers successfully manage this transformation, the new CMO Solution Guide provides practical advice from 20 in-depth interviews with CMOs and digital marketing leaders from organizations of various sizes and different industries.

“While the number of tools and amount of data available to marketers continues to multiply, the age old challenge of capturing and leveraging the right data to create engaging customer experience across all channels still exists,” said Pete Krainik, CEO, The CMO Club. “The first step they must take is to establish the appropriate organizational alignment to successfully create this type of customer experience. While no organization is exactly the same, this guide helps provide easy-to-implement changes that any marketer can use to drive transformation.”

CMO Priorities: Acumen, Alignment, Agility and Accountability

While there is no organizational model that fits every company universally, four key themes emerged during the course of the interviews that informed the organizational decisions that CMOs make: Acumen, Alignment, Agility and Accountability.

“During the course of our interviews, we heard repeatedly how marketers could address key issues around acumen, alignment, agility and accountability and how these forces shape the CMO,” said John Ellett, report author and CEO of nFusion. “The leaders we spoke with all emphasized how thoughtful organizational changes can help better position today’s marketer to keep pace with rapidly changing consumer dynamics.”

Acumen: To become more effective modern marketers, respondents reported that enhancing the skills within their department has become a top priority. From developing valuable customer insights through data mining to investing in content creation and the need for greater evaluative analytics, leading marketers are investing heavily in helping their teams learn new skills.

“We set up an analytics center of excellence to centralize and analyze information across platforms,” said Karen Quintos, CMO, Dell. “This equips our marketers with the real-time insights and agility they need to develop customer-centric programs that advance our business.”

Alignment: From top to bottom and across all functions, the guide shows that it is critical for all departments to follow the same processes and company culture in order to effectively engage customers across all touchpoints.

“Alignment is very important,” said Rishi Dave, CMO, Dun & Bradstreet. “Marketing is evolving and becoming very specialized across a number of disciplines—technology, data, analytics, content, operations, creative, etc. Marketing organizations need to hire specialists who are experts in these areas and create the processes for the specialists to work together in an integrated way in service of the customers. This was less of an issue when marketing was a general discipline in the old days.”

Agility: To meet consumer demands for exceptional customer experience, the guide noted how important it is for businesses to have strong cross-functional teams and the flexibility to pilot something new to test and learn best practices.

“Pilot is my favorite word – trying something new with the intention of learning and knowing it may fail,” said Snehal Desai, Global Business Director, Dow Water & Processing Solutions, Dow Chemical. “People are more willing to support a pilot than to completely change the way they are doing things today.”

Accountability: To demonstrate marketing’s impact on the bottom line, the guide recommends establishing the right measures from the outset and instilling a culture of personal accountability around those parameters.

“I can measure everything today, and that is both a blessing and a curse” said Heidi Melin, CMO, Plex Systems. “The curse is you have to decide what the most important things are to measure to demonstrate accountability.”

“Modern marketing has undergone significant changes in the last few years,” said Andrea Ward, vice president, Marketing, Oracle Marketing Cloud. “To help marketers successfully navigate these changes and drive measurable results, we teamed with The CMO Club to produce this guide. The guide provides invaluable insights from marketing leaders at some of the world’s largest brands and reminds us all to continue to focus on key marketing tenants of acumen, alignment, agility and accountability. These themes are at the heart of the Oracle Marketing Cloud, which enables marketers to activate the right data, in the right way, in the right channels at the right time, in order to stay ahead of their competition.”

Contact Info Erik Kingham
+1.650.506.8298 Cassady Nordeen
Blast PR on behalf of The CMO Club
+1.718.644.0273 About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit

About CMO Club

The CMO Club is the world's most engaged and inspired community of Senior Marketing Executives who help each other solve their biggest challenges within a candid, trusted and sharing environment. Collaboration fueled by inspiring events and within the members-only Digital Solutions Clubhouse raises the standard for what is required to be a successful Chief Marketing Officer. With more than 850 members, The CMO Club is the go-to center for today's Senior Marketer for peer-based personal and career success support. For more details, please visit


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

Safe Harbor

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Additional Information View The CMO Club and Oracle guide hereLearn more about The CMO Club Talk to a Press Contact

Erik Kingham

  • +1.650.506.8298

Cassady Nordeen

  • +1.718.644.0273


Follow Oracle Corporate

Categories: Database, Vendor

Have you pre-registered for Microsoft Ignite 2016? Here are four reasons to do it now.

Microsoft Ignite is all about getting knowledge direct from the source—everything from industry leaders talking about what’s next, to in-person Q&As with the people who built the tools you use every day.

So what better way to introduce the 2016 conference than with insights directly from product experts—Julia White, Jeffrey Snover, and Mark Russinovich—sharing their thoughts about what to expect, what you can learn, who you’ll meet, and why you’ll definitely want to be part of it.

Why attend? Product truths—and a commanding view of what’s next.

Microsoft Ignite is the single place where you can hear about all of Microsoft’s technologies and, as Julia says, “we bring it.”

When we say “in-person access” we really mean it.

At Microsoft Ignite, you can meet the people behind the products you use every day. And with 1,000+ hours of content, you can mix and match what you learn, how you learn, and even the best time of day to do it.

Meet great people, and grow your community.

Microsoft Ignite is smart people talking tech, everywhere you look. It’s a lot of learning, and a lot of fun. Here’s a glimpse of the many ways you can meet up with Microsoft experts and your peers.

Tell your boss: This is why we need to be there.

From high-level strategy to deep product insights, Microsoft Ignite will cover what’s next in tech. It’s great for your company—and your career.

Microsoft Ignite 2016 is September 26–30 in Atlanta, GA. Pre-register now to secure your spot, join your community, and get the latest knowledge direct from the source. We hope to see you there!

Categories: Database

Getting Started with Stretch Database Functionality in SQL Server 2016 – Part 1

Database Journal News - Mon, 11/16/2015 - 09:01

Start using Stretch Database in SQL Server 2016 with this step-by step guide. Learn how to use SSMS to do it manually or use T-SQL to automate the overall process.

Categories: Database

Barman 1.5.1 released

PostgreSQL News - Mon, 11/16/2015 - 01:00

16 November 2015: 2ndQuadrant is proud to announce the release of version 1.5.1 of Barman, Backup and Recovery Manager for PostgreSQL.

This minor release introduces support for 'per-server' concurrency of maintenance operations through the 'cron' command. Internally, Barman is now able to spawn a new sub-process for WAL archive operations on a specific server. For this purpose, the 'archive-wal' command has been added to the command interface.

Minor bugs have also been fixed.

For a complete list of changes, see the "Release Notes" section below.

Links Release notes
  • Add support for the 'archive-wal' command which performs WAL maintenance operations on a given server
  • Add support for "per-server" concurrency of the 'cron' command
  • Improved management of xlog.db errors
  • Add support for mixed compression types in WAL files (
  • Bug fixes:
    • Avoid retention policy checks during the recovery
    • Avoid 'wal_level' check on PostgreSQL version < 9.0 (#3)
    • Fix backup size calculation (#5)
Download About

Barman (Backup and Recovery Manager) is an open source administration tool for disaster recovery of PostgreSQL servers written in Python. It allows your organisation to perform remote backups of multiple servers in business critical environments and help DBAs during the recovery phase. Barman's most requested features include backup catalogues, incremental backup, retention policies, remote backup and recovery, archiving and compression of WAL files and backups. Barman is distributed under GNU GPL 3.

Categories: Database, Open Source

Database .NET v17 released

PostgreSQL News - Mon, 11/16/2015 - 01:00

I am happy to announce the new major release of Database .NET v17. It is an innovative, powerful and intuitive multiple database management tool, With it you can browse objects, design tables, edit rows, export data, run queries and migrate data with a consistent interface.

Free, All-In-One, Portable, Single executable file and Multi-language.

Major New features from version 16.1 to 17.0:

  • Compatible with PostgreSQL 9.5 beta 2 or higher
  • Updated to Npgsql.dll 2.2.7
  • Auto Completion supports for JSON functions (9.2~9.5)
  • Generate Table Data (INSERTs) as a single file
  • Clear Quick Filter on the object explorer
  • Edit Rows with Filter Expression
  • Minimize Main Window on the progress window
  • Detect when file is changed outside the environment
  • Displaying Data Types on the Form Viewer and Editor
  • Filter and Reordering columns in the results pane
  • Auto Completion for the Advanced options
  • Built-in Database Migration and Data Synchronization (Pro)
  • ...and more
The new version is immediately available for download.
Categories: Database, Open Source

Oracle Business Intelligence 12c Helps Organizations Boost Their Digital Transformation Through Agile Visual Analytics

Oracle Database News - Thu, 11/12/2015 - 15:18
Press Release Oracle Business Intelligence 12c Helps Organizations Boost Their Digital Transformation Through Agile Visual Analytics Major Release Delivers Unmatched Levels of Visual Simplicity, Business Agility and Scalable Performance

Redwood Shores, Calif.—Nov 12, 2015

Oracle today announced the general availability of Oracle Business Intelligence 12c (BI 12c), designed to deliver an entirely new experience for blending and visually analyzing any data in an enterprise-scale analytics platform. The foundation of Oracle’s analytics offerings, Oracle BI 12c allows people across the organization to leverage a single integrated platform for self-service, visual data discovery and quickly find answers to pressing business questions while in the office or on the go.   Analytics offerings today force organizations to make a difficult choice between business agility and enterprise scale: Desktop solutions offer agile visual analytics but are limited to user-managed or departmental data; traditional BI solutions offer scalable performance on IT-managed data, but compromise agile self-service and time-to-value. Only Oracle BI 12c delivers both in a no-compromise, modern platform that empowers people with stunning visual analytics as well as curated dashboards and analysis across personal, departmental and enterprise data. Oracle BI 12c advances the state-of-the-art with an integrated platform delivering self-service visual analytics, a re-imagined user experience, optimized in-memory processing, built-in advanced analytics and simplified administration.   “We were impressed with what we saw in the Oracle Business Intelligence 12c Beta program,” said Arvinder Singh, BI solutions architect, Land O’Lakes.  “Data mashup is a big win for the business, allowing people to upload Excel data and combine results with existing OBI data for quick analysis and data visualization means users can quickly create meaningful, versatile dashboards without getting too technical.”    With the new enhancements in Oracle BI 12c, organizations are able to benefit from:  
  • Integration of data visualization and self-service data blending with enterprise analytics capabilities in the same offering, allowing customers to achieve the best of self-service agility and IT-managed reliability.
  • Intuitive search-driven analytics enabling people to type or speak questions and receive visualizations in response, broadening the reach and adoption of analytics across the organization.
  • Optimized in-memory processing for best use of system resources, enabling faster analysis on more data from personal, departmental, enterprise and Big Data sources.
  • Simplified administration and a streamlined upgrade process, delivering significantly lower cost of ownership.
“Our customers recognize that making informed decisions at the speed of today’s business requires a no-compromise analytics platform – one that empowers people with visual analytics, without compromising scale and reliability,” said Hari Sankar, group vice president, Business Analytics, Oracle. “Oracle BI 12c provides an enterprise-class visual analytics platform with everything customers need -- rich visual analytics and extreme performance, with simplified administration and governance.”   Oracle BI 12c offers compatibility and integration with the full breadth of Oracle’s analytics offerings, both on-premises and in the cloud. Oracle’s consistent technology approach ensures continuity of experience and portability across its entire analytics portfolio – in the cloud and on-premises– making it simpler for customers to adopt the environment of their choice and scale as their needs evolve.   Contact Info Tara Hanney
+1.832.435.7518 Michelle Jenkins
+1.425.945.8306 About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. 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. 

Talk to a Press Contact

Tara Hanney

  • +1.832.435.7518

Michelle Jenkins

  • +1.425.945.8306


Follow Oracle Corporate

Categories: Database, Vendor

Tivoli and RMAN in Oracle

Database Journal News - Thu, 11/12/2015 - 09:01

RMAN in Oracle version is sending incorrect information to the Tivoli MML process, resulting in backup files that are larger than expected, filling the storage pool and causing the backups to fail.

Categories: Database

Using the MDM Application Toolkit to build MDM services in Business Process Manager, Part 2: Creating services and error handling

IBM - DB2 and Informix Articles - Thu, 11/12/2015 - 06:00
Learn how to use the IBM InfoSphere Master Data Management (MDM) Application Toolkit to create basic services in IBM Business Process Manager (BPM) and to implement error handling.
Categories: Database

PostgreSQL 9.5 Beta 2 Released

PostgreSQL News - Thu, 11/12/2015 - 01:00

The PostgreSQL Global Development Group announces today that the second beta release of PostgreSQL 9.5 is available for download. This release should contain all features and APIs which will be in the final release with few, if any, changes. Users should begin testing their applications against 9.5 Beta 2 in preparation for the final release.

Changes Since Beta1

Many bugs and issues reported by our users and contributors have been fixed since the release of Beta1. These include:

  • Many documentation fixes and improvements
  • Rename PQsslAttributes() to PQsslAttributeNames()
  • Pass extra data to pgworkers for context
  • Fix other issues with parallel workers
  • Fix multiple issues with BRIN indexes
  • Fix problems with commit timestamps and replication
  • Put back ssl_renegotiation_limit, set to 0

If you reported an issue while testing PostgreSQL 9.5, please download Beta2 and test whether that issue has been fixed. If you have not yet tested version 9.5, now is the time for you to help out PostgreSQL development. Known issues which are still open are listed on the Open Items page.

Beta Schedule

This is second beta release of version 9.5, indicating that very few user-visible feature changes are expected before final release. The PostgreSQL Project will release additional betas as required for testing, followed by one or more release candidates, until the final release in late 2015. For more information, and suggestions on how to test the betas, see the Beta Testing page.

Full documentation and release notes of the new version is available online and also installs with PostgreSQL. Also see the What's New page for details on some features.

Categories: Database, Open Source

Oracle Introduces Oracle Knowledge Advanced Cloud to Meet Customer Demands for Modern, Multi-Channel Customer Service and Support

Oracle Database News - Wed, 11/11/2015 - 14:00
Press Release Oracle Introduces Oracle Knowledge Advanced Cloud to Meet Customer Demands for Modern, Multi-Channel Customer Service and Support Oracle’s new cloud solution enables global organizations to significantly improve customer experiences and reduce support costs

Redwood Shores, Calif.—Nov 11, 2015

Oracle today launched Oracle Knowledge Advanced, a new cloud solution within the Oracle Service Cloud that helps organizations deliver a better customer experience, while reducing overall customer support costs. Fully integrated into Oracle Service Cloud, the new cloud-based knowledge management solution enables organizations worldwide to effectively create and refine their knowledge assets to deliver a seamless cross-channel customer experience in 33 languages for both end customers and contact center agents.

In today’s digital economy, customers want effortless engagements, and will increasingly leverage web or mobile self-service as a first point of contact with an organization. This makes it essential that organizations are able to leverage knowledge management to provide exceptional, effortless customer engagements and increase customer loyalty.

In fact, according to Forrester Research’s September 2015 report Vendor Landscape: Knowledge Management for Customer Engagement, “Knowledge delivered to the customer or the customer-facing employee at the right time in the customer engagement process is critical to a successful interaction,” wrote Kate Leggett, vice president & principal analyst, Forrester Research. “When done correctly, deeper knowledge can be used to personalize an interaction, increase customer satisfaction, reduce call handle time, lead to operational efficiencies, increase customer engagement, and ultimately drive conversion and revenue.”

To help organizations around the globe meet customer demands and deliver the right answers through self-service channels, Oracle Knowledge Advanced cloud delivers rich capabilities including highly accurate cross-lingual search using natural language processing and self-learning algorithms, flexible authoring and workflow, rich analytics and customizable self-service and agent-facing knowledge applications. By taking advantage of federated search, organizations can find and display knowledge in one single interface regardless of where it is located, including the knowledgebase, other content stores and social sites.

Oracle Knowledge Advanced cloud also helps organizations drive efficiencies across the contact and engagement center by empowering agents with timely information at the point of need. The new release provides a complete web self-service solution with the integration of Knowledge Advanced and Customer Portal that enables brands to easily create and deploy pixel perfect service experiences using built-in tools and widgets. “Oracle’s internal deployment of Oracle Knowledge Advanced along with Oracle Service Cloud has been a huge success”, said Mark Sunday, CIO Oracle. “Oracle’s ‘My Help Customer Portal’ offers a single place for our employees to find out how to do something, make a request, or obtain support. In addition to modernizing the support experience for Oracle employees, it has helped IT and other internal service providers be more efficient, proactive and productive by including Knowledge directly in the support process.”

The addition of Oracle Knowledge Advanced cloud reinforces Oracle Service Cloud's commitment to helping organizations deliver successful customer experiences. Oracle Service Cloud is part of Oracle's Customer Experience Cloud, which also includes Oracle Marketing Cloud, Oracle Sales Cloud, Oracle Social Cloud, Oracle Configure, Price and Quote Cloud and Oracle Commerce Cloud.

Contact Info Asad Mushtaq
+44 207 562 7068 Diana Wong
+1.650.506.2757 About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. 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.

Safe Harbor

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Additional Information Oracle Service Cloud Knowledge Advanced Data SheetOracle Achieves Latest Knowledge-Centered Support (KCS) v5 VerificationWatch Video of Oracle KnowledgeLearn more about Oracle Service Cloud Talk to a Press Contact

Asad Mushtaq

  • +44 207 562 7068

Diana Wong

  • +1.650.506.2757

Follow Oracle Corporate

Categories: Database, Vendor

Devart Released New SSIS Components for PostgreSQL

PostgreSQL News - Wed, 11/11/2015 - 01:00

Devart released a first version of SSIS Components for PostgreSQL v1.0

It deliver performance-optimized SSIS Data Flow Source, Lookup, and Destination components for PostgreSQL.

Included Components:

Data Flow Source Component. Devart SSIS Source components come with convenient and user-friendly editor that visually displays the corresponding source objects and SSIS variables. It allows you to quickly configure your SELECT query that gets data. SQL SELECT statements are supported both for databases and cloud sources.

Data Flow Destination Component. Devart SSIS Destination components allow fast data loading and has data source specific optimizations. They offer advanced per-row error processing and allow returning generated IDs (primary key values) for records that were inserted successfully.

Data Flow Lookup Component. Devart SSIS Lookup components offer high-performance lookup transformation with advanced caching. To reduce the number of server round-trips, they use SELECT statements that check several rows at once, and cache the returned data to avoid querying the same rows again.

Categories: Database, Open Source

MySQL Pattern Matching using Regular Expressions

Database Journal News - Mon, 11/09/2015 - 09:01

In this follow-up to Beyond the LIKE Operator: Advanced Pattern Matching with MySQL, Rob Gravelle shows how to use the REGEXP operator to match alphanumeric characters, explores the role of meta-characters, and compares standard regular expression syntax to that of MySQL.

Categories: Database

Preview of the new Microsoft JDBC Driver 6.0 for SQL Server

We are pleased to announce the community technology preview release of the Microsoft JDBC Driver 6.0 for SQL Server! The updated driver provides robust data access to Microsoft SQL Server and Microsoft Azure SQL Database for Java-based applications.

The JDBC Driver for SQL Server is a Java Database Connectivity (JDBC) Type 4 driver that implements full compliance with the JDBC specifications 4.1 and 4.2 and supports Java Development Kit (JDK) versions up to 1.8. It supports the Transport Layer Security (TLS) 1.2 protocol for additional security over the internet. The Microsoft JDBC Driver 6.0 for SQL Server Preview also supports two new scenarios:

  • Always Encrypted is a new SQL Server 2016 and Azure SQL Database security feature that helps to prevent sensitive data from being seen in plaintext in a SQL Server instance. Always Encrypted works by transparently encrypting the data in the application, so that SQL Server will only handle the encrypted data and not plaintext values. Even if the SQL instance or the host machine is compromised, an attacker gets ciphertext of sensitive data. This new feature allows customers to store sensitive data outside of their trust boundary. Data remains protected from high-privileged, yet unauthorized users including DBAs and admins.
    In order to use the Always Encrypted feature, you have to use a supported driver such as ADO.NET or the JDBC 6.0 Driver for SQL Server Preview to encrypt the plain text data then store the encrypted data inside SQL Server 2016 CTP2 and above or Azure SQL Database. Similarly, you will use a capable driver like the new JDBC driver or ADO.NET to decrypt the data.
  • Internationalized Domain Names (IDNs) allow your web server to use Unicode characters for server name, enabling support for more languages. Using the new Microsoft JDBC Driver 6.0 for SQL Server Preview, you can convert a Unicode serverName to ASCII compatible encoding (Punycode) when required during a connection. This conversion is enabled by setting the property serverNameAsACE to true. Otherwise, if the DNS service is configured to allow the use of Unicode characters, use the default serverNameAsACE property value of false.

The JDBC driver is part of SQL Server and the Microsoft Data Platform’s wider interoperability program, with drivers for PHP 5.6, Node.js, JDBC, ODBC, and ADO.NET already available.

You can download the JDBC Driver 6.0 for SQL Preview here. We invite you to explore the latest the Microsoft Data Platform has to offer via a trial of Microsoft Azure SQL Database or by trying the new SQL Server 2016 CTP.

Questions? Join the discussion of the new driver capabilities at MSDN and stackoverflow. If you run into an issue or would like to make a suggestion, let us know.

Categories: Database