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!

Database

Glens Falls Hospital, University of Pittsburgh Medical Center (UPMC) and a New York Medical Center Move to Oracle Cloud

Oracle Database News - Mon, 07/25/2016 - 13:00
Press Release Glens Falls Hospital, University of Pittsburgh Medical Center (UPMC) and a New York Medical Center Move to Oracle Cloud Oracle’s modern, integrated cloud solutions help medical centers cost-effectively drive flexible, scalable innovation

Redwood Shores, Calif.—Jul 25, 2016

Oracle announced today that Glens Falls Hospital, University of Pittsburgh Medical Center (UPMC) and NYU Langone Medical Center have turned to Oracle Cloud to modernize their healthcare insight and administrative resources for staff and patients. These organizations join many other hospitals, healthcare providers and research centers that have moved the management of their people and business processes to the Oracle Cloud.

Today, the healthcare industry faces pressure from all sides—healthcare reform mandates, changing market conditions, increasing regulatory requirements and the constant need for new revenue streams. Therefore, it is essential for healthcare organizations to be sensitive to securing information. An added complexity is that the workforce is diverse, ranging from hourly to highly skilled workers. Mobile technology has also changed the way information is received and used. Healthcare providers are being asked to do more for less, all while juggling challenges on how to acquire and retain talent, move toward a more digital environment, cut costs and consolidate HR processes. They are turning to cloud technology to adapt to these complex needs.

With Oracle Human Capital Management (HCM) Cloud, healthcare institutions have a single, unified platform to grow with confidence and focus less on process and more on quality patient care. Oracle’s Cloud solutions provide universal reporting and analytics that allow organizations easy access to a complete perspective of its HR functions.

“As the healthcare industry transforms, healthcare institutions need to transform their HCM systems to keep pace with competition, as well as source, employ and retain the best talent. Many suffer from disparate systems that don’t work across functions,” said Chris Leone, senior vice president, Applications Development, Oracle. “Oracle HCM Cloud technology not only provides an easy experience for end users to access and navigate through a variety of platforms—including mobile—but also one that is cost-effective and integrated across all business functions, turning information into meaningful action to help improve employee experience.”

As business models change, providers need systems that can keep up with them. A few key areas in which Oracle’s HCM Cloud systems are helping include:

  • Sourcing and retaining talent with mobile applications: When improving and saving lives, the people who touch patients become incredibly important. Oracle’s Cloud technology provides tools that are modern, easy to use and personalized for each individual employee. With most hospital staff constantly on the go, mobile apps put information in employees’ hands for quick and easy information access. Mobile apps also help employees better connect with the business to take control of their jobs, their development and their careers. This leads to higher levels of productivity and engagement.
  • Cost reduction: Standardizing and automating business processes that eliminate multiple systems and duplicate tasks help reduce IT costs. This offers providers increased efficiency and new market opportunities to grow their businesses.
  • Data insight: Oracle’s Cloud solutions provide real-time business insights into data trends and analytics that directly impact the workforce and profitability. Oracle’s Cloud technology can predict potential staffing and skill gaps, as well as assess profits and losses to manage costs.

“We needed an integrated system that would allow us to provide excellent healthcare service to our patients, while still serving our employees with more convenient HR systems that include global payroll functionalities,” said Kyle Brock, vice president of Human Resources, Glens Falls Hospital. “By going with the entire Oracle HCM Cloud suite, we were able to realize significant cost savings through contract consolidation to increase team productivity and improve overall department efficiency. We were also able to shift our entire HR operations to the Cloud, while not impacting other hospital priorities.”

UPMC, the largest non-governmental employer in Pennsylvania, integrates more than 60,000 employees, 20 hospitals, 500 doctors’ offices and outpatient sites, a 2.9-million-member health insurance division, and international and commercial operations. “Healthcare is faced with increased and far more diverse requirements than even a few years ago,” said John Galley, senior vice president & chief HR officer, UPMC. “As UPMC leads the way in creating patient-centered, value-based healthcare, it is crucial that we have a modern platform in place to help us address new challenges, keep costs low, and deliver flexibility. Oracle’s Cloud-based platform and vision for healthcare made it the right choice for UPMC.”

Contact Info Jennifer Yamamoto
Oracle
+1.916.761.9555
jennifer.yamamoto@oracle.com About Oracle

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

Trademarks

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. 

Talk to a Press Contact

Jennifer Yamamoto

  • +1.916.761.9555

Follow Oracle Corporate

Categories: Database, Vendor

Is Your Oracle Invisible Index REALLY Invisible?

Database Journal News - Mon, 07/25/2016 - 08:01

If you’re using invisible indexes, they may not be entirely ‘invisible’ to the optimizer. Read on to see why.

Categories: Database

Is Your Oracle Invisible Index REALLY Iinvisible?

Database Journal News - Mon, 07/25/2016 - 08:01

If you’re using invisible indexes, they may not be entirely ‘invisible’ to the optimizer. Read on to see why.

Categories: Database

Manage spatial data with IBM DB2 Spatial Extender, Part 1: Acquiring spatial data and developing applications

IBM - DB2 and Informix Articles - Sun, 07/24/2016 - 05:00
This tutorial series describes common tasks to manage spatial data with IBM DB2 Spatial Extender, including importing and creating spatial data, constructing and executing spatial queries, working with IBM, third-party, and open source spatial tools, tuning performance, and considering special circumstances in a data warehouse environment. In this first article in the series, learn how to acquire spatial data and build applications. Learn how to use shapefiles, spatial data tables, and spatial indices.
Categories: Database

Compare the Informix Version 12 editions

IBM - DB2 and Informix Articles - Fri, 07/22/2016 - 05:00
Get an introduction to the various editions of IBM Informix, and compare features, benefits, and licensing considerations in a side-by-side table. Regardless of which edition you choose, Informix brings you legendary ease of use, reliability, stability, and access to extensibility features.
Categories: Database

Getting started with Query Store feature in SQL Server 2016 – Part 3

Database Journal News - Thu, 07/21/2016 - 08:01

Arshad Ali demonstrates how you can analyze the data collected by Query Store either with T-SQL scripting or with the graphical user interface in SSMS.

Categories: Database

PostgreSQL 9.6 Beta 3 Released

PostgreSQL News - Thu, 07/21/2016 - 01:00

The PostgreSQL Global Development Group announces today that the third beta release of PostgreSQL 9.6 is available for download. This release contains previews of all of the features which will be available in the final release of version 9.6, including fixes to many of the issues found in the first and second betas. Users are encouraged to continue testing their applications against 9.6 beta 3.

Changes Since Beta 2

Our users and contributors tested the first two betas, and found and reported many bugs and usability issues. This beta release fixes many of those issues. If you reported an issue, please test this beta to ensure that it's completely fixed.

This included many more fixes to parallel query:

  • adding support for TABLESAMPLE
  • correcting cost data in Gather nodes
  • check parallel-safety of all appended relations
  • fix planner issues with initPlans
  • fix several issues with client_encoding
  • clean up EXPLAIN output for parallel queries
  • multiple changes to parallel aggregation internals

Among the other issues addressed were:

  • add conninfo field to pg_stat_wal_receiver
  • clear all-frozen visibilitymap status when locking tuples
  • correctly dump database and tablespace ACLs
  • avoid invalidating all foreign-join cached plans when user mappings change
  • fix nested NOT operation cleanup in tsquery
  • allow IMPORT FOREIGN SCHEMA within pl/pgsql
  • print a given subplan only once in EXPLAIN
  • change the GetForeignUpperPaths API
  • fix several issues in postgres_fdw
  • added many additional regression tests
  • many documentation updates and clarifications
  • multiple translation updates for the docs

Due to changes in system catalogs, a pg_upgrade or dump and restore will be required for users migrating databases from earlier betas. This includes a version update to the pg_control tool, making it incompatible with PostgreSQL 9.4 and earlier. This beta also includes patches to many issues shared with earlier versions, which will be updated in an upcoming minor release.

Note that some known issues remain unfixed. Before reporting a bug in the beta, please check the Open Items page.

Beta Schedule

This is the third beta release of version 9.6. The PostgreSQL Project will release additional betas as required for testing, followed by one or more release candidates, until the final release in late 2016. For further information please see the Beta Testing page.

Links
Categories: Database, Open Source

Microsoft drivers 4.0 for PHP for SQL Server with PHP 7.0 support released

Dear PHP Community,

We wanted to extend a massive ‘thank you’ for providing feedback for our preview releases over the last few weeks. We’ve been working hard to incorporate the feedback you have provided us. You will find that we’ve fixed many issues you reported, and we are proud to be able to release the final build of our 4.0 drivers. We will continue to fix bugs and ship regular updates to the GitHub repository. The new driver enables access to SQL Server 2008+, Azure SQL Database and Azure SQL DW from any PHP 7 application.

The major highlights of this release include: support for SQL Server 2016, PHP7, bug fixes, and better test coverage.

Improvements from our previous release:
  • Fixed a heap corruption when binding parameters in a prepare statement with error
  • Fixed leaks in SQLSRV streams and output parameters handling
  • Fixed leaks in SQLSRV fetch object
  • Fixed leaks in SQLSRV binding object parameters
  • Fixed leaks in SQLSRV buffered result set
  • Fixed leaks in SQLSRV getting datetime and stream fields
  • Fixed leaks in PDO_SQLSRV field cache
  • Fixed leaks in PDO_SQLSRV construct when connecting with error
  • Fixed leaks in PDO_SQLSRV exception handling

We will continue to make bug fixes and adding new features on your feedback on GitHub.

Future plans

Going forward we plan on improving the current Linux port, expand SQL 16 Feature Support (example: Always Encrypted), build verification/fundamental tests, and bug fixes reported on GitHub.

Getting the product ready for release

You can find the latest bits on our Github repository, at our existing address. We provide support for any bugs reported on our Github Issues page. As always, we welcome contributions of any kind, be they Pull Requests, or Feature Enhancements. Additionally, you can also get the pre-packaged exe. from the Download Center.

I’d like to thank everyone on behalf of the team for supporting us in our endeavors to provide you with a high-quality driver. Happy downloading!

Meet Bhagdev (meetb@microsoft.com)

MSFTlovesPHP

Categories: Database

Crunchy Delivers First Commercially Available 100% Open Source RDBMS To Receive Common Criteria Certification

PostgreSQL News - Wed, 07/20/2016 - 01:00
Crunchy Certified PostgreSQL Receives Level 2 + Certification, Meeting Common Criteria’s Rigid Standards and Organizations’ Security Needs

Charleston, SC — July 19, 2016 — Crunchy Data, a leading provider of trusted open source PostgreSQL and PostgreSQL technology, support and training, today announced that Crunchy Certified PostgreSQL, the company’s commercially available distribution of PostgreSQL 9.5, has been awarded Common Criteria Evaluation Assurance Level (EAL) 2+ certification, an international standard for computer security certification. It is the first commercially available 100% open source relational database management system to receive Common Criteria certification.

For more information please see the full press release here.

Categories: Database, Open Source

Crunchy Delivers First Commercially Available 100% Open Source RDBMS To Receive Common Criteria Certification

PostgreSQL News - Wed, 07/20/2016 - 01:00
Crunchy Certified PostgreSQL Receives Level 2 + Certification, Meeting Common Criteria’s Rigid Standards and Organizations’ Security Needs

Charleston, SC — July 19, 2016 — Crunchy Data, a leading provider of trusted open source PostgreSQL and PostgreSQL technology, support and training, today announced that Crunchy Certified PostgreSQL, the company’s commercially available distribution of PostgreSQL 9.5, has been awarded Common Criteria Evaluation Assurance Level (EAL) 2+ certification, an international standard for computer security certification. It is the first commercially available 100% open source relational database management system to receive Common Criteria certification.

For more information please see the full press release here.

Categories: Database, Open Source

SQL Server 2016 posts world record TPC-H 10 TB benchmark

SQL Server 2016 delivers unparalleled performance and security built-in for your most mission critical transactional systems and data warehouses, along with an integrated business intelligence and advanced analytics solution for building intelligent applications.  Blazing-fast performance is key to ensuring you can deliver a flawless transactional experience while at the same time support demanding real-time operational analytics over the data as fast as the data is coming in.

Recently, Lenovo announced the number one TPC-H 10TB benchmark world record1 using SQL Server 2016 and Windows Server 2016 on Lenovo System x3850 X6 using the latest the latest Intel Xeon E7 processor technology. In May 2016, Lenovo also published a new number one TPC-H 30TB world record2 using SQL Server 2016 and Windows Server 2016 on Lenovo System x3950 X6. These results, in addition to recent benchmarks by software and hardware partners, as well as key applications, show that SQL Server 2016 is the fastest in-memory database on the planet for your applications.3

SQL Server 2016 owns the top TPC-E performance benchmarks4 for transaction processing, the top TPC-H performance benchmarks for data warehousing, and the top performance benchmarks with leading business applications. PROS Holdings uses SQL Server 2016’s superior performance and built-in R Service to deliver advanced analytics more than 100x faster than before, resulting in higher profits for their customers. KPMG, a leader in audit, tax, and advisory solution, posted 2.5x faster execution time with ten times the table compression with their solution using SQL Server 2016.

Customers can also gain tremendous performance improvement by simply upgrading to SQL Server 2016 without application changes (e.g. queries will run up to 34x faster)5. In addition to leading performance benchmarks, SQL Server 2016 also delivers top price/performance for both workloads providing customers with significantly reduced total cost of ownership.

Easily experience SQL Server 2016 by creating a test environment using an Azure SQL VM. You can also experience the full features through the free developer edition (you will be prompted to sign in to Visual Studio Dev Essentials before you can download SQL Server 2016 Developer Edition). Visit SQL Server 2016 to learn more about new features and download the SQL Server 2016 e-book.

SQL Server 2016 performance

 

1Non-clustered TPC-H 10TB. https://lenovopress.com/lp0528-x3850-x6-tpch-10tb-benchmark-result-2016-07-11. http://www.tpc.org/3325.

2Non-clustered TPC-H 30 TB. https://lenovopress.com/lp0502-x3950-x6-tpch-30tb-benchmark-result-2016-05-02. http://www.tpc.org/3321.

3Learn more about how your organization can scale to handle the increasing amount of data being stored in modern data warehouses by reading the Intel whitepaper entitled “Accelerating Large-Scale Business Analytics,” which illustrates the integration of Microsoft SQL Server 2016 and Intel® Xeon® E7 platform driving advanced analytics on a large 100TB dataset.

4http://www.tpc.org/tpce/results/tpce_price_perf_results.asp?resulttype=ALL&version=1&currencyID=0

5Based on internal tests from Microsoft, customers who upgrade to SQL Server 2016 will also experience tremendous performance gain including faster real-time analytics with up to 34x performance on in-memory columnstore queries, faster synchronization and greater availability with up to seven times faster AlwaysOn throughput, 3.6x faster reporting on AlwaysOn replicas and seven to ten times faster on database maintenance (DBCC).

Categories: Database

Is Your DB2 Subsystem Healthy?

Database Journal News - Mon, 07/18/2016 - 08:01

Lockwood Lyon presents simple SQL statements that the database administrator (DBA) can execute against the DB2 catalog to determine if your DB2 subsystem suffers from common maladies, and what the DBA can do to fix or mitigate potential problems.

Categories: Database

Oracle Joins the White House’s Advanced Wireless Research Initiative

Oracle Database News - Mon, 07/18/2016 - 05:40
Press Release Oracle Joins the White House’s Advanced Wireless Research Initiative Bringing the Power of the Cloud to 5G and Beyond

Redwood Shores, Calif.—Jul 18, 2016

Oracle is proud to provide Oracle Cloud technology and engineering resources to the White House Office of Science and Technology Policy’s program Platforms Enabling Advanced Wireless Program (PAWR). The program is led by the National Science Foundation, the nonprofit organization US Ignite, and a consortium of industry and academic leaders collaborating to better understand the unique challenges and opportunities created by next generation platforms for networking.

Oracle Communications will provide core network control, analytics and network orchestration technology to researchers and help them understand the impact of subscriber behavior, enhance orchestration, and bolster security. Oracle's contributions, in this groundbreaking initiative, will aid the advancement in wireless technology areas by:

  • Discovering how applied analytics can help minimize negative impacts on orchestration, and improve overall network and service performance;
  • Monitoring and measuring networks in the new environment to provide optimal performance and reliability;
  • Analyzing capacity in a virtual network, making resources available (such as hardware and licenses) when needed;
  • Identifying new formulas and metrics to engineer and secure cloud-based telecom networks;
  • Determining what impact subscriber behaviors and events have on network/service orchestration.

The research and development from Oracle will assist in the understanding of protecting from network abuse through legitimate network connections to ensure even ‘trusted’ networks cannot abuse their access. This will include analyzing the impact from other networks through misconfigurations or malformed packets. Additionally, our contributions will help set up standards, procedures and principles for the Telecommunications cloud.

“We see an opportunity to bring the power and flexibility of the cloud to telecommunications,” said Doug Suriano, senior vice president and general manager, Oracle Communications. “As a means to better understand the impact of subscriber behaviors to traffic engineering, how analytics can enhance orchestration at the network and service levels, and how to bolster security of the control plane to protect against malicious behavior.”

Oracle is proud to join as a founding board member of PAWR, an organization steering the research agenda and policy issues for US Ignite, responsible for the design, scope, and research goals for its members.

Contact Info Katie Barron
Oracle
+1 202.904.1138
katie.barron@oracle.com About Oracle

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

Trademarks

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. 

Talk to a Press Contact

Katie Barron

  • +1 202.904.1138

Follow Oracle Corporate

Categories: Database, Vendor

PostgreSQL Conference Europe Registration Open - Call for Papers is still open!

PostgreSQL News - Mon, 07/18/2016 - 01:00

PostgreSQL Conference Europe 2016 in Tallin, Estonia, on November 1-4 is now accepting registrations for conference attendance at http://2016.pgconf.eu/registration/.

The Early Bird special price will be available until September 14th, and is limited to 75 tickets which is a great reason to get your registration in early!

There are also six training sessions available for registration - two full day and four half day sessions - for the Tuesday before the main event. These are all limited space sessions, so make sure you register early if you want to attend!

And don't forget - the call for papers is still open! If you have already submitted a talk, or are planning to submit one, we suggest you wait to register until you have received a confirmation if the talk was accepted or not. The early bird rate will be available long enough for you to register after you have received this notification - and if your talk is accepted, attendance is of course free!

We are accepting proposals for talks in English. Each session will last 45 minutes, and may be on any topic related to PostgreSQL.

The submission deadline is August 7th. Selected speakers will be notified before August 24th, 2016.

Please submit your proposals by going to http://2016.pgconf.eu/callforpapers/ and following the instructions.

The proposals will be considered by committee who will produce a schedule to be published nearer the conference date.

All selected speakers will get free entry to the conference (excluding training sessions). We do not in general cover travel and accommodations for speakers, but may be able to do that in limited cases. If you require assistance with funding to be able to attend, please make a note of this in the submission notes field.

The full call for papers is available on the website

As usual, if you have any questions, don't hesitate to contact us at contact@pgconf.eu.

Categories: Database, Open Source

JDBC 1209 released

PostgreSQL News - Mon, 07/18/2016 - 01:00

Notable changes include :

  • Many improvements to insert into .. values(?,?) -> insert .. values(?,?), (?,?)... rewriter. Give it a try by using reWriteBatchedInserts=true connection property. 2-3x improvements for insert batch can be expected
  • Full test suite passes against PostgreSQL 9.6, and OpenJDK 9
  • Performance optimization for timestamps (~TimeZone.getDefault optimization)
  • Allow build-from-source on GNU/Linux without maven repositories, and add Fedora Copr test to the regression suite

The full changelog can be found here

Categories: Database, Open Source

Database .NET 18.9 released!

PostgreSQL News - Fri, 07/15/2016 - 01:00

I am happy to announce the new major release of Database .NET 18.9. 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 18.1 to 18.9:

  • PostgreSQL 9.6 compatibility
  • Added Support for multi-dimensional arrays (PG)
  • Added Support for bigserial datatype (PG)
  • Added Support for Reporting Errors and Messages (PG)
  • Added Support for LISTEN (listen for a notification) (PG)
  • Added Support for browsing delimited text files
  • Added Automatic reconnection
  • Ability to Cancel executing command
  • Ability to Copy Selected Results to Clipboard
  • Ability to Calculate Selected Cells
  • Ability to Export Results to PSV/SSV (Pipe and Semicolon delimited) (.psv;.ssv)
  • Improved SQL History
  • Improved Query Builder
  • Improved Binding Procedure and Function parameters
  • Improved Transaction Mode
  • Improved Find In Grid
  • Improved Data Import and Export
  • Improved Data Editor and Browser
  • Improved Generating Batch Scripts
  • Improved SQL Editor
  • Improved AutoComplete and IntelliSense
  • Improved SQL File Version Control
  • Improved Database Migration and Data Synchronization (Pro)
  • ...and more
For more information please visit http://fishcodelib.com/Database.htm.
Categories: Database, Open Source

Microsoft JDBC Driver 6.0 for SQL Server is now released!

This post was authored by Andrea Lam, Program Manager, SQL Server.

We are pleased to announce the full 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.

What’s new Always Encrypted

You can now use Always Encrypted with the Microsoft JDBC Driver 6.0 for SQL Server. Always Encrypted is a new SQL Server 2016 and Azure SQL Database security feature that prevents sensitive data from being seen in plaintext in a SQL instance. You can now transparently encrypt the data in the application, so that SQL Server or Azure SQL Database will only handle the encrypted data and not plaintext values. If a SQL instance or host machine is compromised, an attacker can only access ciphertext of your sensitive data. Use the JDBC Driver 6.0 to encrypt plaintext data and store the encrypted data in SQL Server 2016 or Azure SQL Database. Likewise, use the driver to decrypt your encrypted data.

Azure Active Directory (AAD)

AAD authentication is a mechanism of connecting to Azure SQL Database v12 using identities in AAD. Use AAD authentication to centrally manage identities of database users and as an alternative to SQL Server authentication. The JDBC Driver 6.0 allows you to specify your AAD credentials in the JDBC connection string to connect to Azure SQL DB.

Table-Valued Parameters (TVPs)

TVP support allows a client application to send parameterized data to the server more efficiently by sending multiple rows to the server with a single call. You can use the JDBC Driver 6.0 to encapsulate rows of data in a client application and send the data to the server in a single parameterized command.

Parameterized queries

Extended support for retrieving parameter metadata with prepared statements for complex queries such as sub-queries and/or joins.

Internationalized Domain Names (IDNs)

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, you can convert a Unicode serverName to ASCII compatible encoding (Punycode) when required during a connection.

AlwaysOn Availability Groups (AG)

The driver now supports transparent connections to AlwaysOn Availability Groups. The driver quickly discovers the current AlwaysOn topology of your server infrastructure and connects to the current active server transparently.

Next steps

You can download the JDBC Driver 6.0 for SQL Server here.

Learn how to pick the right JDBC jar file based on your system requirements here and read up on more documentation here.

Roadmap

We are committed to bringing more feature support for connecting to SQL Server, Azure SQL Database and Azure SQL DW. 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.

Please stay tuned for upcoming releases that will have additional feature support. This applies to our wide range of client drivers including PHP 7.0, Node.js, ODBC and ADO.NET which are already available.

Categories: Database

Returning The Actual DOP When Using Oracle’s Auto Degree Of Parallelism

Database Journal News - Thu, 07/14/2016 - 08:01

Without having an execution plan it’s difficult to know the degree of parallelism Oracle has selected.  Read on to see how that can be reported.

Categories: Database

SQL Server 2014 SP2 is now available

The SQL Server team is excited to bring you SQL Server 2014 Service Pack 2 (SP2). This service pack is available on the Microsoft Download Center, MSDN, Eval Center, MBS/Partner Source and VLSC. As part of our continued commitment to software excellence for our customers, this upgrade is available to all customers with existing SQL Server 2014 deployments.

SQL Server 2014 SP2 includes a rollup of released hotfixes as well as more than twenty improvements centered around performance, scalability and diagnostics based on feedback from customers and the SQL community. These improvements enable SQL Server 2014 to perform faster and scale out of the box on modern hardware design, and showcase the SQL Server Team’s commitment to provide continued value into in-market releases.

SQL Server 2014 SP2 now includes:

  • All fixes and CUs for SQL 2014 released to date.
  • Performance, scale and supportability improvements.
  • New improvements based on connect feedback items filed by the SQL community.
  • Improvements originally introduced in SQL 2012 SP3, after SQL 2014 SP1 was released.

Find more information on SQL Server 2014 SP2 by reading the SQL Server Release Services Blog post and What’s New in SQL Server 2014 SP2. To obtain SQL Server 2014 SP2, the options below are available:

Categories: Database

Oracle Cloud Solves Undiscovered Stadium Revenue Growth as Sports Fans Desire Mobile Food & Beverage Ordering

Oracle Database News - Tue, 07/12/2016 - 15:02
Press Release Oracle Cloud Solves Undiscovered Stadium Revenue Growth as Sports Fans Desire Mobile Food & Beverage Ordering

Redwood Shores, Calif.—Jul 12, 2016

More than 40% of sports fans worldwide abandoned concession lines in the past 12 months—without making a purchase—because of excessive waiting, according to a just-released Oracle Hospitality Sports and Entertainment research report The Fan Experience: Changing the Game with Food and Beverage, published in partnership with Turnkey Intelligence, an industry-leading market research provider.

The global study surveyed more than 3,500 sports fans in eight countries—Australia, Brazil, China, France, Germany, Japan, United Kingdom and United States—and focused on uncovering their top priorities. Most importantly, the survey aids venue operators by identifying “pain points” and solutions designed to trigger greater attendance and spark sales.

“Aside from safety and overall venue environment, fans across the world place food and beverage above all else when ranking the elements that are most important to their fan experience,” said, Jay Upchurch, Oracle Hospitality, vice president. “Our cloud platforms provide operators with the enterprise agility they need to remain innovative and responsive to change, readily incorporating the most advanced technologies that come along to make the fan experience even more memorable.”

Counter to current trends of spending exorbitantly on video boards and pre-game entertainment to fill seats, the research indicates employing technology to enhance food and beverage may yield a greater return on investment. Indeed, survey findings reveal the underutilization of food and beverage technology and confirm significant demand for it. For example, mobile technology to improve ordering, payment and delivering loyalty programs is a promising path to greater sales. That premise is supported by results, including:

  • 68% of U.S. fans and 60% of international fans said they would “probably” or “definitely” use in-seat ordering if available at their stadium.
  • American fans, on average, said they would spend an additional $20 for food & beverage if wait times were cut in half—representing a 43% increase in typical expenditure (per party, per game).
  • 27% of U.S. fans and 14% of international fans stated they are members of a loyalty rewards program offered by a team or stadium.

“The live event experience continues to be the optimal method of consuming entertainment,” said Haynes Hendrickson, Turnkey Intelligence’s President. “We have found that technology can positively impact the event experience and the bottom line of a venue. By embarking on this research study with Turnkey Intelligence, Oracle has demonstrated its commitment to excellence in our industry.”

Oracle Hospitality pursued the research project to advance the company’s commitment of delivering foundational technology that helps solve venue operators’ biggest challenges.

About Oracle Hospitality Sports & Entertainment

Oracle Hospitality Sports & Entertainment brings 35+ years of experience providing industry-leading technology solutions to sports and entertainment venues worldwide. The company’s point-of-sale platform is the premier food and beverage solution, enabling operators to deliver an efficient and innovative fan experience throughout their venue. Key features include: inventory management, loyalty rewards, third-party integrations for in-seat ordering, and more.

About Turnkey Intelligence

Turnkey Intelligence is home to a custom research department that has conducted and analyzed more than 500 studies for sports and entertainment’s top leagues, properties, brands and events. TI is also the proud creator of the Audience Portal, the sports and entertainment industry’s online data and analytics hub. Over 220 clients utilize the Portal to sell and market smarter. For more information about Turnkey Intelligence, visit Intel.TurnkeySE.com.

Contact Info Katie Barron
Oracle
202-904-1138
katie.barron@oracle.com About Oracle

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

Trademarks

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. 

Talk to a Press Contact

Katie Barron

  • 202-904-1138

Follow Oracle Corporate

Categories: Database, Vendor