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

Unique Records In Oracle

Database Journal News - Thu, 02/11/2016 - 09:01

There are several ways to ensure unique records in an Oracle table, but are some better than others?  Read on to see how each method compares.

Categories: Database

2016-02-11 Security Update Release

PostgreSQL News - Thu, 02/11/2016 - 01:00

The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.5.1, 9.4.6, 9.3.11, 9.2.15, and 9.1.20. This release fixes two security issues, as well as several bugs found over the last four months. Users vulnerable to the security issues should update their installations immediately; other users should update at the next scheduled downtime.

Security Fixes for Regular Expressions, PL/Java

This release closes security hole CVE-2016-0773, an issue with regular expression (regex) parsing. Prior code allowed users to pass in expressions which included out-of-range Unicode characters, triggering a backend crash. This issue is critical for PostgreSQL systems with untrusted users or which generate regexes based on user input.

The update also fixes CVE-2016-0766, a privilege escalation issue for users of PL/Java. Certain custom configuration settings (GUCS) for PL/Java will now be modifiable only by the database superuser.

Other Fixes and Improvements

In addition to the above, many other issues were patched in this release based on bugs reported by our users over the last few months. This includes multiple fixes for new features introduced in version 9.5.0, as well as refactoring of pg_dump to eliminate a number of chronic issues with backing up EXTENSIONs. Among them are:

  • Fix many issues in pg_dump with specific object types
  • Prevent over-eager pushdown of HAVING clauses for GROUPING SETS
  • Fix deparsing error with ON CONFLICT ... WHERE clauses
  • Fix tableoid errors for postgres_fdw
  • Prevent floating-point exceptions in pgbench
  • Make \det search Foreign Table names consistently
  • Fix quoting of domain constraint names in pg_dump
  • Prevent putting expanded objects into Const nodes
  • Allow compile of PL/Java on Windows
  • Fix "unresolved symbol" errors in PL/Python execution
  • Allow Python2 and Python3 to be used in the same database
  • Add support for Python 3.5 in PL/Python
  • Fix issue with subdirectory creation during initdb
  • Make pg_ctl report status correctly on Windows
  • Suppress confusing error when using pg_receivexlog with older servers
  • Multiple documentation corrections and additions
  • Fix erroneous hash calculations in gin_extract_jsonb_path()

This update also contains tzdata release 2016a, with updates for Cayman Islands, Metlakatla, Trans-Baikal Territory (Zabaykalsky Krai), and Pakistan.

Updating

Users of version 9.4 will need to reindex any jsonb_path_ops indexes they have created, in order to fix a persistent issue with missing index entries. Users of other versions who have skipped multiple update releases may need to perform additional post-update steps; see the Release Notes for details.

All PostgreSQL update releases are cumulative. 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.

Links:

Categories: Database, Open Source

Oracle Empowers MKB Bank to Offer Customers More Personalized Banking Services at a Reduced Time to Market

Oracle Database News - Wed, 02/10/2016 - 22:04
Press Release Oracle Empowers MKB Bank to Offer Customers More Personalized Banking Services at a Reduced Time to Market Leading Hungarian bank to replace existing core banking platform with Oracle FLEXCUBE to deliver integrated workflows and streamline processes

Redwood Shores, Calif., and Budapest, Hungary—Feb 10, 2016

MKB Bank, one of Hungary’s leading banks is migrating its core banking system to Oracle FLEXCUBE to improve its go-to-market time for new products, reduce operational costs and drive growth. MKB chose Oracle FLEXCUBE to achieve faster processing times in key areas such as loan origination, account opening and account processing, as well as due to the flexibility of responding to customers new product needs.

“The ability to align with customer needs and requirements seamlessly is the future of banking and a part of our core vision at MKB,” said Mark Hetenyi, chief financial officer and chief operations officer for MKB Bank. “Oracle FLEXCUBE has the flexibility and process orientation allowing us to respond to customer needs in a dynamic and more efficient manner, while we reduce cost, time and effort through the entire process chain. Shortening processing times of traditional activities, such as the time it takes for a business to get a loan or a customer to open a new account, leaves us with precious resources to concentrate on value added activities and to develop sector specific product offerings.”

MKB Bank is one of Hungary’s largest banks, with a strong presence in the corporate and SME market. As part of its growth strategy, the bank is targeting further penetration in the SME and affluent private customer market through improved customer experience and service. To do this effectively MKB needed to either upgrade its current core banking platform or move to a new core banking system to ensure that it could reduce its go-to-market time without worrying about availability, security or scalability.

“The Oracle team worked closely with the bank to identify the best solution package that would enable us to reach new markets and new customers in the shortest time at an effective price, while they migrate the existing operations to Oracle FLEXCUBE” Hetenyi went on to say. 

By deploying Oracle FLEXCUBE on Oracle Technology and Oracle Exadata Servers, the bank can deliver enhanced, personalized services to its customers, and to manage data from multiple sources at a more effective cost and also reduce the risk to its ongoing operations.

“Banks today are looking at technology as a key enabler in achieving competitive differentiation and streamlining operations,” said Chet Kamat, Senior Vice President, Oracle Financial Services.

“Over the course of more than 600 core banking transformations we have developed the right methodologies, tools and skill sets to meet the transformational goals of all tiers of banks. Our proposition of best in class applications, technology and hardware backed by risk mitigated transformation services helps banks make aggressive moves in the market and deliver highest degree of customer satisfaction.”

Contact Info Valerie Beaudett
Oracle
+1.650.400.7833
valerie.beaudett@oracle.com Oracle Press Office
CMG Team
+44 (0) 844 875 1455
OracleFinancial@cmgrp.com About MKB Bank

Being one of the longest standing credit institutions on the Hungarian market, MKB offer best of class financial services for both corporate and retail clients. For more information about MKB Bank, visit mkb.hu.

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.

For additional information on Oracle and its banking solutions, visit Oracle FLEXCUBE, Oracle Managed Cloud Services, Oracle Financial Services Managed Cloud Solution Brief, Oracle Financial Services

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

Valerie Beaudett

  • +1.650.400.7833

Oracle Press Office

  • +44 (0) 844 875 1455

Follow Oracle Corporate

Categories: Database, Vendor

Oracle Enables Leading Global Transfer Agency to Launch New Retirement & Life Products to Meet Strategic Customer Demands in South Africa

Oracle Database News - Wed, 02/10/2016 - 22:04
Press Release Oracle Enables Leading Global Transfer Agency to Launch New Retirement & Life Products to Meet Strategic Customer Demands in South Africa Maitland retail administration services now live on Oracle FLEXCUBE Investor Servicing

Redwood Shores, Calif., and Cape Town, South Africa —Feb 10, 2016

Maitland, a global independent third-party fund administrator has launched its new investor servicing Retirement and Life products to the South African market with the help of Oracle FLEXCUBE Investor Servicing.

“This is the first critical delivery of the revitalization program for of our Transfer Agency business and it is wonderful that we can now service Retirement and Life products, a complement to our long-standing capabilities for unit trusts,” said Jim Clark, Head of Transfer Agency Services at Maitland. “Maitland is now able to provide investor record-keeping services for South Africa pension funds, annuities, endowment and certain types of discretionary portfolios. This is the first step on the journey to offer our clients a multi-product, multi-currency, multi-domicile platform to support their distribution and investor servicing.”

Maitland Group has completed a demanding project on time and on specification, providing its key customers with a greatly enhanced administration solution. This showcases Maitland’s track record of efficiently migrating large IT projects to support its business goals.

Oracle FLEXCUBE Investor Servicing was successfully deployed at Maitland as part of the revitalisation program of their Global Transfer Agency business, enabling the launch of a new product line to provide investor servicing to Retirement & Life Products. Oracle FLEXCUBE Investor Servicing will enable Maitland to deliver true cross-border transfer agency capabilities for a broad range of investment products, covering collective investment schemes, tax wrappers, retirement products and alternatives. The application also enables Maitland to support multi-currencies, multi-domiciles and multi-lingual servicing across its entire services portfolio.

“Today’s consumers are demanding better and more sophisticated investment options, and FLEXCUBE Investor Servicing is designed to bring agility and scalability to the asset management and transfer agency businesses by providing them a best in class, easy to configure and manage platform,” said Chet Kamat, Senior Vice President, Oracle Financial Services. “We have been active in this market segment for over a decade with a number of top tier customers across the globe and it is of great importance that we were able to onboard Maitland to our platform in record time.”

Contact Info Valerie Beaudett
Oracle
+1.650.400.7833
valerie.beaudett@oracle.com Oracle Press Office
CMG Team
+44 (0) 844 875 1455
OracleFinancial@cmgrp.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

Valerie Beaudett

  • +1.650.400.7833

Oracle Press Office

  • +44 (0) 844 875 1455

Follow Oracle Corporate

Categories: Database, Vendor

Oracle Health Sciences to Provide Clinical E-Monitoring Solution to Bayer HealthCare

Oracle Database News - Wed, 02/10/2016 - 17:00
Press Release Oracle Health Sciences to Provide Clinical E-Monitoring Solution to Bayer HealthCare

Redwood Shores, Calif.—Feb 10, 2016

Boosting clinical development productivity and efficiency is a top priority for life sciences organizations. To that end, Oracle  today announced that two of its core Health Sciences offerings—Oracle Siebel Clinical Trial Management System and Oracle Health Sciences Clinical Development Analytics—have been selected by Bayer HealthCare, to oversee and manage the company’s clinical monitoring processes. Bayer HealthCare, a subgroup of Bayer AG researches, develops, manufactures, and markets pharmaceutical and medical products.

Oracle’s life sciences-specific solutions, combined with its broader product and service offering, are used by thousands of pharma, biopharma, and academic research centers worldwide to redesign clinical R&D processes, advance drug therapies, and optimize care delivery to improve the health, well-being, and lives of people globally.

“Oracle Health Sciences is committed to helping organizations, such as Bayer HealthCare, advance its vision of innovation to drive faster, safer, and more cost-effective therapies and treatments to improve lives around the globe,” said Steve Rosenberg, senior vice president and general manager, Oracle Health Sciences. “Our proven solutions are helping industry leaders, as well as emerging organizations, power innovation across the clinical development lifecycle.”

Oracle Siebel Clinical Trial Management System manages and monitors clinical testing sites for any issues as they arise. Oracle Health Sciences Clinical Development Analytics provides an effective platform that optimizes actionable, clinical analytics, addresses compliance issues, and monitors resources. Together, these solutions give clinical research associates greater visibility into site performance, with the ability to track open issues to resolution and manage risk.

Oracle Health Sciences’ advanced clinical trial solutions for data collection, management, and analysis help optimize research, mitigate risk, monitor/report adverse events, and drive medical insight for precision medicine

Contact Info Samantha Thai
Oracle
+1.510.917.5564
samantha.thai@oracle.com Mary Tobin
O’Keeffe & Company
+1.503.658.7396
mtobin@okco.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

Samantha Thai

  • +1.510.917.5564

Mary Tobin

  • +1.503.658.7396

Follow

Follow Oracle Corporate

Categories: Database, Vendor

Using the InfoSphere MDM Application Toolkit to build MDM services in IBM Business Process Manager, Part 3: Additions and extensions

IBM - DB2 and Informix Articles - Wed, 02/10/2016 - 06:00
Learn how to use IBM® InfoSphere® Master Data Management (MDM) Application Toolkit services to implement InfoSphere MDM additions and extensions. This tutorial is the third part of a series that describes how to integrate IBM Business Process Manager (BPM) and master data.
Categories: Database

Swisscom Delivers Higher Service Quality to Customers on New All-IP Network with Oracle Solutions

Oracle Database News - Tue, 02/09/2016 - 14:00
Press Release Swisscom Delivers Higher Service Quality to Customers on New All-IP Network with Oracle Solutions The operator is transitioning its residential customers to VoIP while maintaining service quality using Oracle Communications Operations Monitor

Redwood Shores, Calif.—Feb 9, 2016

As the largest telecommunications operator in Switzerland, more than 2 million consumers count on Swisscom to deliver communications services. So when it decided to transition them from fixed line telephony to Voice over IP (VoIP)-based services, Swisscom needed a better view into its network performance—both so that it could maintain service quality through the transition, and so that it could understand the limits of its network and position it for growth. Swisscom has deployed the Oracle Communications Operations Monitor to get this complete, real-time view of the network, enabling it to be proactive in how it uses its network and identify potential issues before services are affected.

“Swisscom is in the middle of a big transition—we are migrating 2 million fixed line telephone users from traditional telephone services to VoIP by 2017. Oracle Communications Operations Monitor is a key component of this initiative. It’s what allows us to see the exact network quality results and trends that are relevant, which is what informs our decisions about how we use our network. And, we are able to more effectively manage issues—with the Oracle product, we have end-to-end network visibility so we can collect and analyze network data more quickly, which has helped us to resolve incidents 30 percent faster,” said Stephan Bieri, System Engineer‎, Swisscom.

Oracle Communications Operations Monitor is part of the Oracle Communications Session Monitor product family, which enables enterprises and service providers to quickly and securely deploy IP communications networks, reduce operational costs, generate additional revenue, prevent voice fraud, and minimize churn. Specifically, the Oracle Communications Operations Monitor captures and analyzes all signaling messages and media from the network, providing full, end to end correlation and quality metrics of all calls in real time. It also enables easy to use, drill down troubleshooting for root cause analysis of any reported problem related to a user, user group, trunk, network device, or Internet Protocol (IP) address.

By deploying Oracle Communications Operations Monitor for network monitoring, Swisscom has been able to:

  • Proactively monitor network resources, supporting Swisscom’s go to market plans. With prebuilt dashboards, Swisscom can determine network capacity usage trends and make informed decisions on new and existing offers.
  • Easily prove that it is fulfilling its obligation for providing basic quality telecommunications services in Switzerland. Armed with the quality results, Swisscom can more transparently communicate with the Swiss federal authority for telecommunications.
  • React quickly to network incidents—Swisscom has reduced its incident resolution time by 30 percent. Oracle Communications Operations Monitor provides Swisscom with end-to-end network visibility and individual monitoring of users’ activities in real time, including drill down capabilities to pinpoint issues.
  • Reduce the operating expenses of managing the network. Because the Oracle Communications Operations Monitor is used on standard server hardware, it is cost-effectively installed, integrated with other products, and maintained.

“Proper service monitoring is all about being proactive. That’s why we designed Oracle Communications Operations Monitor the way we did—with a broad and deep view of what’s happening in the network, all in real-time. So, now, CSPs can do more than just react when things go wrong—they can leverage the network to find the right opportunities and the right time to launch or modify offers. Swisscom is a testament of a CSP using network monitoring in this way for a strategic advantage,” said Douglas Suriano, senior vice president and general manager, Oracle Communications.

Contact Info Greg Lunsford
Oracle
+1 650-506-6523
greg.lunsford@oracle.com Nitesh Khetani
CMG
+44 (0) 207 067 0836
nkhetani@cmgrp.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

Greg Lunsford

  • +1 650-506-6523

Nitesh Khetani

  • +44 (0) 207 067 0836

Follow Oracle Corporate

Categories: Database, Vendor

Oracle Empowers Utilities to Identify and Implement New Asset Maintenance Strategies with Asset Management Solution

Oracle Database News - Tue, 02/09/2016 - 14:00
Press Release Oracle Empowers Utilities to Identify and Implement New Asset Maintenance Strategies with Asset Management Solution Oracle Utilities Work and Asset Management 2.1.1 enables utilities to automate situational maintenance schedules, reducing operating costs and increasing reliability

DistribuTECH, Orlando, Fla.—Feb 9, 2016

As utilities continue to juggle changing customer expectations and tighter budgets, they are increasingly reliant on maximizing the investment they have made in their existing assets. Oracle Utilities announced a management software solution to help electric, gas, and water utilities better manage asset performance. This new release provides utilities with the capacity to identify and implement effective asset maintenance strategies which enable utilities to achieve mission-critical business objectives—reducing operating costs, increasing reliability, and minimizing risk.

With the release of Oracle Utilities Work and Asset Management 2.1.1, Oracle provides a unique springboard for the implementation, automation, and execution of more effective maintenance. It does so by combining the use of multiple schedules with asset data to enable utilities to trigger the right maintenance tasks at the right time.

For example, if an asset has an unexpected change in duty cycle, such as a spare substation transformer being used to replace a failing one, the maintenance schedule can be dynamically adjusted to account for the change.

“Utilities can now replace one-size-fits-all maintenance plans with multiple strategies that they can associate with one or more assets,” said Rodger Smith, senior vice president and general manager, Oracle Utilities. “With Oracle Utilities Work and Asset Management 2.1.1, utilities can define multiple maintenance schedules based on a wider range of asset characteristics and operating situations, such as warranty specifications and expiration, usage, and changes in operating environment. This capability helps utilities activate more targeted and effective proactive maintenance.”

The updated Oracle Utilities solution also drives enormous cost savings and significantly reduces risk by automating situational-based maintenance schedules. Unlike other work and asset management systems, Oracle Utilities Work and Asset Management 2.1.1 can dynamically switch an asset to a new, optimal maintenance strategy based on operational changes—accounting for conditions such as increased use or out-of-service status. This unique automation helps ensure utilities can easily account for different use cycles by similar assets operating under different conditions.

In addition to embedded failure analytics, the new release offers out-of-the-box asset performance analytics to improve insight into asset failure and risk mitigation. Utilities can associate maintenance triggers to asset failures to determine the effectiveness of maintenance programs. In doing so, utilities can quickly gain insight into the causes of asset failures, such as incorrect maintenance frequency or gaps in training and procedures.

To drive down ownership cost, speed time to value, and reduce management complexity, Oracle Utilities Work and Asset Management has been added as a core application to the common technology framework of Oracle’s utility-specific software solutions. As a result, it is highly configurable, making it easy to enhance without adding customization or compromising upgradability.

Its integration within the framework also enables customers with multiple Oracle Utilities products to more readily share information across applications, use the same skill set to manage multiple Oracle systems, and take advantage of prebuilt, cross system integrations, reducing business processes cost and resources. The other solutions on the unified framework include Oracle Utilities Customer Care and Billing, Oracle Utilities Mobile Workforce Management and Oracle Utilities Meter Data Management.

Contact Info Samantha Thai
Oracle
+1.510.917.5564
samantha.thai@oracle.com Lacy Cooper
O’Keeffe & Company
+1.540.364.5913
lcooper@okco.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

Samantha Thai

  • +1.510.917.5564

Lacy Cooper

  • +1.540.364.5913

Follow Oracle Corporate

Categories: Database, Vendor

New Network Management Solution Enables Water Utilities to Improve Customer Satisfaction with Effective Network Analysis

Oracle Database News - Tue, 02/09/2016 - 14:00
Press Release New Network Management Solution Enables Water Utilities to Improve Customer Satisfaction with Effective Network Analysis Oracle Utilities Smart Water Network Management helps minimize lag time between problem detection and response, isolate leaks and breaks, and reduce water loss

DistribuTECH, Orlando, Fla.—Feb 9, 2016

Globally, water utilities are facing rising water demands and energy costs, shrinking resources, and deteriorating infrastructure. And, water loss and leakage are still rampant across water distribution networks even as large parts of the world are coping with severe drought. Tasked with addressing this array of challenges on shrinking or flat budgets, water utilities must implement smarter processes and control systems across their water distribution networks. To meet this need, Oracle introduced a new solution designed to help water utilities increase their speed and accuracy of response, reduce water loss and its impact on customers, and improve customer satisfaction with effective network analysis.

Oracle’s utilities-specific solutions, combined with its broader product and service offering, help utilities of all types and sizes achieve competitive advantage, business performance excellence and a lower total cost of technology ownership.

Oracle Utilities Smart Water Network Management—Oracle’s network management system for the water utility industry—enables water utilities to rapidly generate valve isolation plans for water main breaks, eliminating lag time between problem detection and response, which in turn minimizes customer impact and maximizes crew efficiency. This improved valve isolation planning can serve as a key tool for utilities to address distribution performance and conservation challenges.

“By triggering valve operation plans within Oracle Utilities Smart Water Network Management, utilities can better isolate leaks and breaks, reducing their impact on customers,” said Rodger Smith, senior vice president and general manager, Oracle Utilities. “Starting from a real-time view, utilities can simulate water valving scenarios, exploring the potential impact of each operation before executing it in the field. Utilities can then use the analysis to better prioritize infrastructure improvements, develop preventive maintenance strategies, and assess contingency and land-use plans to account for breaks and emergency services.”

Oracle Utilities Smart Water Network Management can also help water utilities in planning maintenance shutdowns as they can proactively notify affected customers and critical services, such as fire departments, of any expected service disruption (i.e. alerting area fire departments of impacted fire hydrants). By delivering an accurate, real-time view of the water network, Oracle Utilities Smart Water Network Management allows utilities to weigh the ideal network management scenarios to determine the best activities that balance regulatory, customer, and business objectives.

Contact Info Samantha Thai
Oracle
+1.510.917.5564
samantha.thai@oracle.com Lacy Cooper
O’Keeffe & Company
+1.540.364.5913
lcooper@okco.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

Samantha Thai

  • +1.510.917.5564

Lacy Cooper

  • +1.540.364.5913

Follow Oracle Corporate

Categories: Database, Vendor

Oracle Utilities Leverages the Cloud to Deliver Advanced Metering Capabilities and Enables Utilities to Reduce IT Cost and Risk, Meet Evolving Business and Technology Goals

Oracle Database News - Tue, 02/09/2016 - 14:00
Press Release Oracle Utilities Leverages the Cloud to Deliver Advanced Metering Capabilities and Enables Utilities to Reduce IT Cost and Risk, Meet Evolving Business and Technology Goals

DistribuTECH, Orlando, Fla.—Feb 9, 2016

As advanced metering and device technology continues to transform the industry, utilities need meter solutions that prepare them to take advantage of the additional benefits of this technology and optimize investments in it. To assist in this effort, Oracle Utilities announced a new utilities solution delivered through Oracle Cloud to empower utilities with advanced metering capabilities. This new cloud service enables utilities to meet evolving business and technology trends faster and with less risk, while reducing IT cost and workload. With the new solution, utilities can support grid and customer service optimization with robust metering capabilities that scale and flex as needs change.

With the release of this new utilities solution, robust metering capabilities are available for cloud deployment.

According to its analysis and buyer perception, IDC Energy Insights positioned Oracle as a Leader in its 2015 Meter Data Management MarketScape, stating “Oracle Utilities’ MDM is recognized by end users as a solid industry metering solution offering a good combination of performance, agility, scalability, and flexibility, along with ease of configuration and integration…The company has global marketing firepower, solid thought leadership, and a strong customer engagement model leveraging user groups, executive networking, and advisory councils.”1

“This new metering solution delivers market-leading technology across the utility industry, including to aggregators, retailers, and meter operators, and empowers utilities of all sizes, and at any smart grid maturity level, with advanced metering capabilities,” said Rodger Smith, senior vice president and general manager, Oracle Utilities. “These enhanced capabilities offer a more clearly defined picture of meter and grid device operations through comprehensive data capture, reducing IT costs, and supporting business goals.”

The new utilities solution includes preconfigured, solution implementation accelerators for water, gas, and electric utilities. These accelerators deliver out-of-the-box integration with major head-end systems; pre-configured validation, estimation, and editing rules; and pre-built workflow and analytical processes. The accelerators can significantly reduce the implementation project time and cost, saving utilities valuable resources.

The solution captures and manages data from multiple sources, leveraging pre-built integration with existing metering technology. This device-agnostic approach, paired with the scalability and flexibility of the cloud, prepares utilities and players throughout the utility industry to leverage data from across the grid, even as data sources and volumes expand rapidly with the evolution of grid edge and Internet of Things technologies.

Further, the new cloud service provides users with immediate access to a smooth upgrade path for on-premise Oracle Utilities Meter Solution releases—ensuring utilities remain at the forefront of innovation. Additionally, the solution’s pre-built analytics dashboards and processes provide users with complete visibility into growing amounts of data and actionable insight in tune with the needs of the industry. This announcement furthers Oracle’s goal to deliver comprehensive, innovative cloud solutions that align with industry growth.

[1] IDC MarketScape: “Meter Data Management Software for EMEA Utilities 2015 Vendor Assessment,” #EMEA40706815e, December 2015

Contact Info Samantha Thai
Oracle
+1.510.917.5564
samantha.thai@oracle.com Lacy Cooper
O’Keeffe & Company
+1.540.364.5913
lcooper@okco.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

Samantha Thai

  • +1.510.917.5564

Lacy Cooper

  • +1.540.364.5913

Follow Oracle Corporate

Categories: Database, Vendor

New Advanced Analytics Solution Enables Utilities to Use the Oracle Cloud to Securely and Efficiently Transform Big Data into Compelling, Quantifiable

Oracle Database News - Tue, 02/09/2016 - 14:00
Press Release New Advanced Analytics Solution Enables Utilities to Use the Oracle Cloud to Securely and Efficiently Transform Big Data into Compelling, Quantifiable Oracle DataRaker 3.8 enables utilities to quickly and seamlessly integrate and analyze data by integrating disparate data sources

DistribuTECH, Orlando, Fla.—Feb 9, 2016

Today’s electric, gas, and water utilities recognize the value of optimizing data—transforming information into actionable insight. Yet, while many utilities have the know-how to perform basic data analysis, many lack a system to productize analytic approaches that require ongoing data processing and analytic computational automation. To help meet this demand, Oracle today announced the latest release of its software as a service (SaaS) platform designed to enable utilities to unlock new data sources and transform them into compelling, quantifiable, and actionable information.

Oracle’s utilities-specific solutions, combined with its broader product and service offering, help utilities of all types and sizes achieve competitive advantage, business performance excellence and a lower total cost of technology ownership.

“Utilities require a system that enables them to reliably perform analytics with their data on an ongoing basis, and then integrate the results back into their downstream transactional systems and processes. Oracle DataRaker 3.8 is that powerful platform. Oracle DataRaker 3.8 is the unifying data platform that allows utilities to use analytics to increase customer satisfaction while lowering operating costs,” said Rodger Smith, senior vice president and general manager, Oracle Utilities.

Oracle DataRaker 3.8 continues to provide comprehensive insight into areas such as distribution operations and planning, advanced metering infrastructure deployment, meter to bill operations, and safety with even higher levels of performance, integration, and security. The latest version Oracle DataRaker is built on Oracle’s leading cloud infrastructure, ensuring higher performance for data management and analytics processing. The release also includes a redesigned, intuitive user interface and new business intelligence dashboards for utility operations.

The cloud service contains a powerful combination of high-frequency data ingestion, big data management, ad-hoc analysis, and data visualization capabilities designed for utilities’ needs. The purpose-built applications embedded with the platform lower project risk and accelerate time to value by making use of proven algorithms, data models, and workflows. Additionally, Oracle DataRaker 3.8 helps optimize utilities’ existing business processes by leveraging actionable analytic insights to drive closed-loop workflows. Oracle not only offers ways to easily tie in to non-Oracle systems, but now offers productized integrations for Oracle Utilities Customer Care and Billing, Oracle Utilities Meter Data Management, and Oracle Utilities Network Management System.

Oracle DataRaker 3.8 ensures both technical and business benefits by operating in the Oracle Cloud, which allows utilities to innovate more quickly, simplify IT management, and increase flexibility. Finally, Oracle Cloud also provides continuous industry-leading compliance, maintenance, and data privacy services.

Contact Info Samantha Thai
Oracle
+1.510.917.5564
samantha.thai@oracle.com Lacy Cooper
O’Keeffe & Company
+1.540.364.5913
lcooper@okco.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

Samantha Thai

  • +1.510.917.5564

Lacy Cooper

  • +1.540.364.5913

Follow Oracle Corporate

Categories: Database, Vendor

Utilities are Embracing Cloud, Almost All Currently Use or Plan to Use Cloud Technologies

Oracle Database News - Tue, 02/09/2016 - 14:00
Press Release Utilities are Embracing Cloud, Almost All Currently Use or Plan to Use Cloud Technologies Oracle Utilities’ study highlights utilities’ transition to the cloud, including the next-generation hot spots and key legacy systems utilities are moving to the cloud

DistribuTECH, Orlando, Fla.—Feb 9, 2016

People talk about the cloud in terms of the distant future and many think utilities are slow to get on board—but new research shows 45 percent of utilities currently use the cloud, and 52 percent plan to use the cloud. What’s more, 69 percent of utilities already use or plan to use cloud technologies for their customer information systems in the next three years.

According to the new Oracle Utilities “On Cloud Now: Cloud Technologies are Here for Utilities” study, larger utilities appear to be the earliest adopters (72 percent), with small and mid-sized utilities following suit (50 and 23 percent, respectively). Survey respondents indicated that they are considering both software-as-a-service and private cloud/hosting solutions as they transition to the cloud.

“The survey results signify a milestone for the industry—a fundamental change in how utilities are approaching their technology investments. Technology that used to be characterized by large homegrown systems managed by internal utility staff is transforming into more nimble partnerships with external providers,” said Rodger Smith, senior vice president and general manager, Oracle Utilities.

With the rise of distributed energy resources, a smarter grid, and the need for more advanced analytics, technologies for utilities continue to become increasingly sophisticated and complex. Data is growing exponentially, and technologies that previously lasted for decades are now becoming obsolete. Nearly 50 percent of survey respondents listed keeping pace with technology changes and improving their flexibility as key drivers for their cloud investments. The cloud enables them to reallocate funds once required to upgrade and replace their legacy systems.

Many of the technologies that utilities are taking to the cloud today revolve around smart grid efforts and next-generation technologies—including meter data management, big data analytics, and distribution automation and network management. Utilities are also seeing opportunities for transformation in more traditional areas of the organization—customer information systems, mobile workforce management, and enterprise resource management.

Finally, while most utilities are already embracing the cloud, the study found that privacy, control, security, and system integration still cause them hesitation. Respondents rated their concern on a scale of one to five, where five indicated significant concern. Privacy earned a rating of 4.31, closely followed by control (3.90) and security (3.89).

“These concerns point to the need to ask technology and service providers the right questions about cloud technologies, and truly understand their approaches and plans,” said Smith. “Begin building your cloud strategy now—determining how to prepare for and leverage the cloud; align business and IT to ensure successful deployment; and talk with your cloud provider—ask questions and challenge prospective providers on their approaches to the cloud. With these steps, the cloud provides utilities a path for transformation into a more nimble, flexible organization that can better adapt to today’s changing marketplace.”

Conducted by research firm Zpryme on behalf of Oracle Utilities, the Oracle Utilities “On Cloud Now: Cloud Technologies are Here for Utilities” study surveyed 100 electric, gas, and water utility executives and directors about their cloud objectives.

Contact Info Samantha Thai
Oracle
+1.510.917.5564
samantha.thai@oracle.com Lacy Cooper
O’Keeffe & Company
+1.540.364.5913
lcooper@okco.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

Samantha Thai

  • +1.510.917.5564

Lacy Cooper

  • +1.540.364.5913

Follow Oracle Corporate

Categories: Database, Vendor

Searching on JSON Values in MySQL 7

Database Journal News - Mon, 02/08/2016 - 09:01

The MySQL 5.7.7 JSON Lab release introduced a native JSON datatype, which opened the door for handling JSON data in ways that were previously impossible. Several new functions assist in the selecting of data from a JSON document. We covered a few of them; in this article Rob Gravelle shows you some additional functions for searching on JSON values in MySQL 7.

Categories: Database

Keeping up with the data needs of the business with SQL Server 2016

Leaders are embracing the need to partner with IT to help them gain actionable insights from data. Attesting to this, The Economist recently published a study, “Big data evolution: Forging new corporate capabilities for the long term,” which found that companies “that have a well-defined data strategy are much more likely to say that they financially outperform their competitors — in fact, strategic data managers are four times as [likely] to report that they are substantially ahead of peers.” As a result, “a new kind of partnership has emerged between IT and the business … Not only is this resulting in less dead-weight friction about the goals and approach to data initiatives, but it is also allowing IT to up their game.”

Data’s contribution to business success is ever-expanding. However, unless IT can help transform more data into actionable insights, they are not providing the business with the trusted information they need to uncover new business opportunities and fuel innovation.

Modern BI platform

For IT to remain responsive and agile to the demands they face, a modern Business Intelligence (BI) and analytics platform that provides trusted datasets and metrics that can be easily accessed, consumed and shared by the right people is needed.

SQL Server continues to evolve to let you benefit from data without incurring extra cost from expensive add-ons or facing additional expenses for training IT staff. Because the enhancements to SQL Server 2016 are based on technology that IT is already familiar with, IT can build on existing skill sets to perform modern BI and analytics responsibilities that support a modern data strategy. For example, SQL Server 2016 lets IT transform data into easily understood, trusted data models with user access control to make sure only appropriate users see sensitive data. This means IT can transform complex data from multiple sources into powerful, scalable models that business analysts can easily understand and access by using familiar data analytics and discovery tools such as Excel or Power BI.

But these enhancements are just the beginning. The release of SQL Server 2016 starts the cloud-paced cadence of new capabilities in Microsoft’s comprehensive enterprise-ready BI platform. This approach enables organizations to continuously build on existing investments to create, manage, and consume business insights on-premises and in the cloud. With all this, SQL Server 2016 provides what you need to transform data into actionable insights to help advance your business, including mobile and hybrid BI. To learn more about the modern advances built into SQL Server 2016, read about what you can expect and see the Microsoft BI reporting roadmap here. Upcoming blog posts in this series will dive into the technology that makes all this functionality possible.

Mobile BI

Mobile BI iPhoneAccommodating mobile users has become a key requirement of Business Intelligence and analytics efforts. Businesses recognize that the number of other mobile workers will continue to increase as the number of smartphones and mobile devices increases. And with this growth, users expect IT to support their mobile devices as the means to access the information they need to do their jobs whenever and wherever they need to. From business executives meeting with clients, to managers visiting warehouses and individual employees traveling to the airport, all workers are looking to stay connected to their data and business insights through their own devices.

SQL Server 2016 delivers built-in mobile BI capabilities for both IT and business users. IT professionals have the tools they need to administer user access and shared data sets in one place. Business users can then access insights in an intuitive, engaging way from their desktop and mobile devices and expect the insights to be optimized for different form factors and major mobile platforms.

When you think about optimizing your data infrastructure and maximizing your IT personnel, mobile BI is an important consideration. Providing BI access to more employees can help you transform the decision-making process and make your organization agile.

Hybrid BI

Pin Report items to Power BI dashboard

As your organization transitions to the cloud to benefit from flexibility and scale, you might still have many data sources that reside on-premises. Microsoft BI tools support this trend so that you can transition to the cloud at your pace and take advantage of a hybrid BI solution that will let you continue to benefit from existing on-premises investments. For example, you can pin a Reporting Services paginated report item to a Power BI dashboard so you can view all your information in one place. Or you can access on-premises data from the Power BI service without the need to move the data to the cloud.

Trusted BI platform: Building on your foundation

SQL Server has gained a reputation as a trusted and scalable platform, and has been recognized as a leader in Gartner’s Magic Quadrant for Business Intelligence and Analytics. (Download the Gartner Magic Quadrant for Business Intelligence and Analytics Platforms). With that knowledge and the Microsoft data platform infrastructure that organizations depend on today, business and IT can strengthen their data partnership by building on the existing skills and technology and the advances built into SQL Server 2016. Grow your business bottom line by confidently relying on the Microsoft data platform, knowing that it will work with what you have—whether your data and tools reside on-premises or in the cloud—and it will scale with your business as your data and reporting needs grow over time.

Stay tuned to this blog series for in-depth details on SQL Server 2016 analysis, reporting and BI innovations, and click below for further reading and to try SQL Server 2016 CTP3 for yourself.

See the other posts in the SQL Server 2016 blogging series.

Try SQL Server 2016 RC

Categories: Database

PL/Java 1.5.0-BETA1 announced; security note.

PostgreSQL News - Thu, 02/04/2016 - 01:00

PL/Java brings functions, triggers, and types in Java. 1.5.0, now in beta, supports latest PostgreSQL and Java versions with a range of improvements and fixes.

Project site: http://tada.github.io/pljava/
Release notes: http://tada.github.io/pljava/releasenotes.html

Security note:

1.5.0 brings a policy change to a more secure-by-default posture, where the ability to create functions in `LANGUAGE java' is no longer automatically granted to 'public', but can be selectively granted to roles that will have that responsibility. The change reduces exposure to a known issue present in 1.5.0 and earlier versions, that will be closed in a future release; details are in the release notes.

The new policy will be applied in a new installation; permissions will not be changed in an upgrade, but any site can move to this policy, even before updating to 1.5.0, with REVOKE USAGE ON LANGUAGE java FROM public; followed by explicit GRANT commands for the users/roles expected to create Java functions. Many sites guided by the principle of least privilege may have chosen such a policy already.

MS Windows note:

1.5.0 development snapshots have been repeatedly tested on Windows building with Visual Studio (including the Express and Community editions), and the build documentation covers this combination. Beta testers should find it straightforward.

Resources have not been available to test MinGW-based builds. Beta testers using this combination are encouraged to report build issues they may encounter. (Patches, where possible, would be appreciated also. A likely place to look in case of issues would be the comments above PLJAVADLLEXPORT in Backend.c.)

Many thanks to all the individuals and organizations listed in the release notes under Credits.

Categories: Database, Open Source

Introducing: SQL Server 2016 Community Technology Preview 3.3

The SQL Server 2016 Community Technology Preview (CTP) 3.3 is now available for download! In SQL Server 2016 CTP 3.3, part of our new rapid preview model, we made enhancements to several features which you can try in your development and test environments.

In SQL Server 2016 CTP 3.3, available for download or in an Azure VM today, some of the key improvements include:

  • Continued enhancement of Stretch Database: Stretch Database allows you to stretch operational tables in a secure manner into Azure for cost-effective historic data availability. CTP 3.3 includes multiple improvements to Stretch Database, including Azure Stretch database edition preview with support for up to 60TB, Point-in-time restore and geo-failover support.
  • Enhancements to In-Memory OLTP: In-Memory OLTP, which dramatically improves transaction processing performance, has added support in CTP 3.3.
  • Enhancements to Analysis Services DirectQuery models: Analysis Services Tabular Models running in DirectQuery mode now also allows us of DAX filters when defining roles and creation of calculated columns.
  • Enhancements to the new Reporting Services web portal: An updated preview of the new web portal now enables you to add the KPIs and reports you use to your Favorites, to create and edit shared data sources for your KPIs and reports, and to perform other management tasks.

For additional detail, please visit the detailed CTP 3.3 technical overview blog post, CTP 3.3 Analysis Services blog post, CTP 3.3 Management Studio blog post, and SQL Server 2016 CTP 3.3 Reporting Services blog post.

Download SQL Server 2016 CTP 3.3 preview today!

As the foundation of our end-to-end data platform, SQL Server 2016 is the biggest leap forward in Microsoft’s data platform history with real-time operational analytics, rich visualizations on mobile devices, built-in advanced analytics, new advanced security technology, and both on-premises and in the cloud.

To learn more about the release, visit the SQL Server 2016 preview page. To experience the new, exciting features in SQL Server 2016 and the new rapid release model, download the preview or try the preview by using a virtual machine in Microsoft Azure and start evaluating the impact these new innovations can have for your business.

Questions? Join the discussion of the new SQL Server 2016 capabilities at MSDN and StackOverflow. If you run into an issue or would like to make a suggestion, you can let us know on Connect. We look forward to hearing from you!

Categories: Database

Technical Overview: SQL Server 2016 Community Technology Preview 3.3

The SQL Server engineering team is pleased to announce the immediate availability of SQL Server 2016 public preview release CTP 3.3. This release advances the “Cloud First” tenet; the build has already been deployed to SQL Azure Database worldwide.

To learn more about the release, visit the SQL Server 2016 preview page. To experience the new, exciting features in SQL Server 2016 and the new rapid release model, download the preview or try the preview by using a virtual machine in Microsoft Azure and start evaluating the impact these new innovations can have for your business.

Questions? Join the discussion of the new SQL Server 2016 capabilities at MSDN and StackOverflow. If you run into an issue or would like to make a suggestion, you can let us know using Microsoft’s Connect tool. We look forward to hearing from you.

New Stretch Database improvements in CTP 3.3 include:

  • Support to enable TDE on a remote DB if the local database has TDE enabled
  • Azure Stretch database edition preview with support for up to 60TB
  • Alter and drop index support for stretch tables
  • Add, alter and drop columns support for stretch tables
  • Point-in-time restore and geo-failover support
  • Query performance improvement

SQL Server Management Studio improvements in this release include:

  • Additional Wizard features:
    • Added new SQL db credential management functionality
    • Integrated Table validation and selection updates to prevent stretch of unsupported datatypes at selection time
    • Table search functionality for table select page
    • Table selection column reordering
    • Support for temporal tables during table select
    • Integrated Azure sign in and SQL sign in credential
    • Add support for stretching using federated accounts
    • New firewall configuration and subnet detection functionality
    • Updated summary page details with pricing information
    • Improved SSMS visualization with StretchDB icons
  • Object Explorer:
    • Fly out menu updates to support disable and un-migration functionality
    • Un-migrate support functionality at database and table level

Read the SSMS blog post to learn more.

CTP3.3 adds support with In-Memory OLTP for:

  • Automatic update of statistics on memory-optimized tables: The statistics for memory-optimized tables are now updated automatically, removing the need for running maintenance tasks that update statistics manually.
  • Sampled statistics for memory-optimized tables: Sampling of statistics for the data in memory-optimized tables is now supported, alongside the previously supported fullscan statistics. This reduces the time it takes to collect statistics for large tables.
  • Use of LOB types varchar(max), nvarchar(max), and varbinary(max) with built-in string functions (‘+’, len, ltrim, rtrim and substring) in natively compiled modules, and as return type of natively compiled scalar UDFs.
  • Memory-optimized tables with row size > 8060 bytes, using non-LOB types. CTPs 3.1 and 3.2 supported larger rows using LOB types; as of CTP3.3, memory-optimized tables support also larger rows using types varchar(n), nvarchar(n) and varbinary(n). See below for an example.
  • The OUTPUT clause can now be used with INSERT, UPDATE and DELETE statements in natively compiled stored procedures.

Autostats improvements in CTP 3.3

Previously, statistics were automatically recalculated when the change exceeded a fixed threshold. As of CTP 3.3, we have refined the algorithm such that it is no longer a fixed threshold, but in general will be more aggressive in triggering statistics scans, resulting in more accurate query plans.

Foreign Key Support enhancements in CTP 3.3

SQL Server 2014 and earlier versions have limitations on the number of FOREIGN KEY references a table can contain, as well as the maximum number on incoming foreign key REFERENCES. The documented recommended maximum is 253, and when performing DML on tables with large numbers of incoming REFERENCES, statements time out with stack overflow error messages.

This improvement increases the number of supported incoming foreign key REFERENCES to a table, while maintaining good performance for DML operations in both the referencing and the referenced table. The new maximum is 10,000. However, with the CTP 3.3 release, we have certain limitations on this feature:

  • We ONLY support Delete DML operation on foreign key references that go beyond the current recommended maximum of 253. Therefore, we will validate that no referencing rows exist before deletion.
  • Update and Merge operations are not supported with this release. Update will be available in RTM.
  • You will not see any change in behavior for cascading actions.
  • This is not available in ColumnStore, Hekaton or StretchDB.
  • This change is not applicable to a primary key table that is self-referencing (that is, if the table has a foreign key to itself). In this case, the behavior would remain the same as before.
  • This is not supported for partitioned foreign key tables for CTP 3.3. However, partitioned tables will be supported in RTM.

SQL Server Analysis Services (SSAS) includes multiple additions in this release. Read the SSAS CTP 3.3 blog post to learn more.

SQL Server Reporting Services (SSRS) includes an updated preview of its brand-new web portal with additional functionality:

  • Add the KPIs and reports that matter most to you to your Favorites and view them all in one place.
  • Manage shared data sources for your KPIs and reports and perform other management tasks.

Read the SSRS blog post to learn more.

Master Data Services (MDS) improvements in this release include:

  • Business rule changes
    • New, easier-to-use web UI administration page
    • Support for NOT conditional operator
    • Support for ELSE section that contains a set of actions to execute if the IF condition is false
    • Removed management UI from Excel add-in
  • Added support for purging (hard-deleting soft-deleted members) of an entity version
  • Added to the web explorer page a button to open the current entity view in the Excel add-in
Categories: Database

TLS 1.2 support availability for SQL Server

Microsoft is ensuring that customers can remain compliant with the current changes in guidance for using strong cryptography for implementing security control. A number of known vulnerabilities has been reported against SSL and earlier versions of TLS which has changed the security guidance to move to TLS 1.2 for support secure communication.

There has been no known vulnerability that has been reported for Microsoft's TDS implementation which is the communication protocol used between SQL Server clients and the SQL Server database engine.

As of January 29, Microsoft SQL Server supports TLS 1.2 for SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014 and major client drivers like Server Native Client, Microsoft ODBC Driver for SQL Server, Microsoft JDBC Driver for SQL Server and ADO.NET (SqlClient).

You can read more about the release here. The list of builds that support TLS 1.2 along with the client and server component download locations is available in KB3135244.

Categories: Database

It’s time! Registration is now open for Microsoft Ignite

It’s time — Register now for Microsoft Ignite and mark your calendar for September 26–30. Be there when top industry leaders talk about what’s next, get direct access to the people who built the products you use every day, and surround yourself with smart people talking tech.

Sharpen your ideas with the best in the business.

From high-level strategy to deep product insights, you’ll hear about new technologies and explore real-world solutions to today’s challenges. Customize your schedule to go deep on the topics that matter most to you and your organization including: cloud infrastructure and management, big data, analytics, productivity, communications, operating systems, mobile devices, and more.

  • 1,000+ hours of content, 700+ sessions, and a multitude of networking opportunities
  • Insights and roadmaps from industry leaders
  • Deep dives and live demos on the products you use every day
  • Direct access to Microsoft product experts
  • Hands-on learning in digital labs
Connect with techies like yourself.

After last year’s conference, an attendee wrote, “Networking at #MSIgnite is like coming home.” We make it easy to connect, with dozens of opportunities including networking lounges, mealtime mashups, and meetups. You’ll expand your contact list—and meet people who can challenge your thinking and inspire you to take your ideas further.

Join us. Register for Microsoft Ignite 2016.

Categories: Database

TLS 1.2 support availability for SQL Server

Microsoft is ensuring that customers can remain compliant with the current changes in guidance for using strong cryptography for implementing security control. A number of known vulnerabilities has been reported against SSL and earlier versions of TLS which has changed the security guidance to move to TLS 1.2 for support secure communication.

There has been no known vulnerability that has been reported for Microsoft’s TDS implementation which is the communication protocol used between SQL Server clients and the SQL Server database engine.

As of January 29, Microsoft SQL Server supports TLS 1.2 for SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014 and major client drivers like Server Native Client, Microsoft ODBC Driver for SQL Server, Microsoft JDBC Driver for SQL Server and ADO.NET (SqlClient).

You can read more about the release here. The list of builds that support TLS 1.2 along with the client and server component download locations is available in KB3135244.

Categories: Database