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

T-SQL Programming Part 15 - Understanding How to Write a Correlated Subquery

Database Journal News - Thu, 09/03/2015 - 08:01

How do you return a set of records that are based on the results of another set of records with TSQL? One method is to write a correlated subquery. Greg Larsen explains what a correlated subquery is, and provides a number of examples.

Categories: Database

Download the new JDBC 4.2 for SQL Server Driver

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

The JDBC Driver for SQL Server is a Java Database Connectivity (JDBC) type 4 driver that implements full compliance with the JDBC specifications 4.1 and 4.2 and supports Java Development Kit (JDK) version 1.8. It supports the Transport Layer Security (TLS) 1.2 protocol for additional security over the internet. The JDBC 4.2 Driver for SQL also supports SQL Server’s AlwaysOn feature for High Availability and Disaster Recovery.

There are several additional enhancements available with the driver:

  • The updated XA Transaction feature includes new timeout options for automatic rollback of unprepared transactions.
  • New SQLServerBulkCopy class enables developers to quickly copy large amounts of data into tables or views in SQL Server and Azure SQL Database databases from other databases. For more details about what is currently supported in the bulk copy feature, please refer to What’s New in the JDBC driver.

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

SQL Server connectivity landscape

You can download the JDBC 4.2 driver here.  We invite you to explore the latest the Microsoft Data Platform has to offer via a trial of Microsoft Azure SQL Database or by trying the new SQL Server 2016 CTP. Have questions?

Join the discussion on Stack Overflow. Running into an issue or have a suggestion? Let us know.

Categories: Database

SQL Server 2016 Community Technology Preview 2.3 is available

The SQL Server engineering team is pleased to announce the immediate availability of SQL Server 2016 August monthly public preview release CTP 2.3. This release fully embraced the “Cloud First” tenet, as this release build was deployed to SQL Azure Database service first, running in production prior to the release build.

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. Have questions? Join the discussion of the new SQL Server 2016 capabilities at Stack Overflow. 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!


This preview release is packed with new features and improvements....

Row Level Security is now supported with In-memory OLTP tables. Users can now apply row-level security policies to memory-optimized tables. In addition to SCHEMABINDING, predicate functions and inline TVFs should include the compilation hint WITH NATIVE_COMPILATION. UDFs created with this hint can be used in both native modules and interop queries, and as security predicates on both memory-optimized and disk-based tables. UDFs created without this hint can only be used in interop queries, and as predicates on disk-based tables. The following built-in security functions are supported by In-memory OLTP, intended for use in RLS predicates:

  • IS_MEMBER({‘group’ | ‘role’})
  • IS_ROLEMEMBER (‘role’ [, ‘database_principal’])
  • IS_SRVROLEMEMBER (‘role’ [, ‘login’])
  • ORIGINAL_LOGIN()
  • SESSION_USER
  • CURRENT_USER
  • SUSER_ID([‘login’])
  • SUSER_SID([‘login’] [, Param2])
  • SUSER_SNAME([server_user_sid])
  • SYSTEM_USER
  • SUSER_NAME
  • USER
  • USER_ID([‘user’])
  • USER_NAME([id])
  • CONTEXT_INFO()


An exciting Core Engine Scalability improvement is made available in this release - dynamically partition thread safe memory objects by NUMA node or by CPU. This improvement will enable higher scalability of high concurrency workloads running on NUMA hardware. Thread safe memory objects (of type CmemThread) will be dynamically promoted to be partitioned by NUMA node or by CPU based on workload characteristics and contention factor. In SQL 2012 and SQL 2014, TF8048 is needed to promote memory objects that are partitioned by node to be partitioned by CPU. This improvement not only eliminated the need for the trace flag, and also dynamically determine partition based on contention.

CTP2.3 includes In-memory data warehouse (columnStore) performance optimizations, NCCI can now be created on tables with triggers, enabled with CDC/Change Tracking. For better insight of Column Store, three new fields to the sys.dm_db_column_store_row_group_physical_stats dynamic management view:

transition_to_compressed_state

tinyint

Operation that caused transition to compressed state

0 => UNKNOWN_UPGRADED_FROM_PREVIOUS _VERSION

1 => NOT_APPLICABLE

2 => INDEX_BUILD

3 => TUPLE_MOVER

4 => REORG_NORMAL

5 => REORG_FORCED

6 => BULKLOAD

7 => MERGE

transition_to_compressed_state_desc

nvarchar(60)

NOT_APPLICABLE -> It is not applicable for delta store or this compressed rowgroup existed before database upgrade

INDEX_BUILD -> The rowgroup was compressed as part of index create/rebuild

TUPLE_MOVER => The rowgroup was compressed as part of background Tuple Mover

REORG_NORMAL => The closed delta rowgroup was compressed as part of invocation of closed delta rowgroups. One implication is that TM is falling behind

REORG_FORCED => The open rowgroup was compressed

BULKLOAD -> The rowgroup was compressed as part of bulkload operation

MERGE -> The rowgroup was compressed as part of MERGE operation that compressed one or more compressed rowgroups.

 

has_vertipaq_optimization

Bit

Vertipaq optimization is used when rowgroups are compressed into columnar storage to improve compression achieved by rearranging the order of the rows in the row group. This optimization is automatically applied when building column store index or when directly bulk loading data into columnar format or when data transitions from delta store to columnar storage format. However, this optimization is skipped for delta rowgroups when there are one or more NCIs on the column store index to minimize changes needed to maintain mapping index

1 => Yes

        0    => No


SQL Server Analysis Service (SSAS) ships several exciting performance improvements in this release:

  • DAX query performance improvement, optimizations to the Tabular engine. These optimizations are mostly focused around reducing the “chattiness” between client tools that use DAX and the server (and eventually the storage engine for both VertiPaq and DirectQuery storage modes). In addition to query optimizations, measure executions have been streamlined as well.
  • DirectQuery enhancements. It now generates simpler queries that will provide better performance.
  • Now includes support for variables in DAX. Variables can now store the result of an expression as a named variable, which can then be passed as an argument to other measure expressions. Once resultant values have been calculated for a variable expression, those values do not change, even if the variable is referenced in another expression.

You can read the new SSAS post to learn more about these improvements.

SQL Server Reporting Services (SSRS) includes a couple of enhancements:

  • An updated version of Report Builder with a modern theme.
  • Report rendering for modern browsers built on HTML5 standards.

You can read the Reporting Services post to learn more about these improvements.

SQL Server Integration Service (SSIS) released oData v4 protocol support, SSIS Error Column support, and advanced logging levels in CTP 2.3. Previous SSIS catalog only provides four kinds of logging level None, Basic, Performance and Verbose. The new advanced logging level remove the inflexibility of previous logging levels:

  • New mechanism to collect the event context when events are fired
  • New ssis_logreader role with permission to access all the view related to SSISDB operation logs
  • New logging level customization to define logs and events collection
  • Allow the collection of event context such as variable value, task properties and connection string
  • New RuntimeLineage logging level to collect data for dynamic lineage. This function is provided through lineage library. There is a known issue that this feature doesn’t work upgrading from earlier preview build of SQL2016, the fix is work-in-progress.


Continue the momentum, Master Data Service added three improvements in this release:

  • Many to many derived hierarchy
  • Excel Addin Business rule management
  • Merge conflicts


Query Execution with improved diagnostics for memory grant usage in this release. The following new XEvents added to facilitate better diagnostics of memory grant usage and issues. Showplan xml is extended to include memory grant usage per thread and iterator (additions in “RunTimeCountersPerThread” element).

  1. query_memory_grant_blocking
  2. query_memory_grant_resource_semaphores
  3. query_memory_grant_usage (details on ideal vs granted vs used memory)


DBCC CHECKDB Improvements in this release include: 1) Persisted computed columns and filtered indexes validation. Persisted computed columns are frequently used. DBCC CHECKDB can take long time to complete with persisted columns. This improvement provides an option to do persisted column validation under EXTENDED_LOGICAL_CHECKS; 2) Performance improvement when validating a table with thousands of partitions.

Categories: Database

Introducing: SQL Server 2016 Community Technology Preview 2.3

The SQL Server 2016 Community Technology Preview (CTP) 2.3 is now available for download! This release fully embraced the “Cloud First” tenet, as this release build was deployed to SQL Azure Database service first, running in production prior to the release build.

In SQL Server 2016 CTP 2.3, part of our new rapid preview model, we made enhancements to several features. You can try them now in your SQL Server 2016 development and test environments.

As part of our new rapid release model, you don’t have to wait several months for responses to feedback or to test new capabilities. This means you can accelerate testing and time to production. The frequent updates are also engineered to be of the same quality as major CTPs, so you don’t have to be concerned about build quality. You also have the flexibility to choose which CTPs you will deploy for development and test environments and won’t be forced to upgrade to the most recent preview release.

In SQL Server 2016 CTP 2.3, available for download today, you will see enhancements in several key areas:

  • Row Level Security support for in-memory OLTP tables
  • A core engine scalability improvement, dynamically partitioning thread safe memory objects by NUMA or CPU, which enables higher scalability
  • In-memory data warehouse (column tore) performance optimizations
  • Many-to-many derived hierarchies in Master Data Services
  • Several performance improvements to SQL Server Analysis Services, including DAX query performance
  • Enhancements to Reporting Services, including an updated Report Builder with a modern theme and report rendering for modern browsers


CTP 2.3 also has improvements to the SQL Server Integration Service, Query Execution, and DBCC CHECKDB.

For additional details, please visit the detailed SQL Server 2016 CTP 2.3 Engineering post, SQL Server 2016 CTP 2.3 SQL Server Analysis Services post, and SQL Server 2016 CTP 2.3 Reporting Services post.

Download SQL Server 2016 CTP 2.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.

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

Categories: Database

Oracle Canadian Data Center Now Available to Support Localized Data Residency

Oracle Database News - Wed, 09/02/2015 - 13:00
Press Release Oracle Canadian Data Center Now Available to Support Localized Data Residency

Redwood Shores, Calif.—Sep 2, 2015

Canadian organizations are increasingly looking to improve efficiency, flexibility, operational agility, and integrity of systems, while wrestling with the need to reduce IT costs and comply with localization and security concerns. To address the increasing demand for data sovereignty, Oracle has opened a fully functional data center that supports the deployment of cloud services for customers whose cloud applications and cloud-based solutions are deployed in Canada.

To help customers achieve the benefits of cloud, the Canadian data center will support Oracle Human Capital Management Cloud (Oracle HCM Cloud), Oracle Enterprise Resource Planning Cloud (Oracle ERP Cloud), and Oracle Customer Experience (CX) Cloud applications. The best-of-breed software as a service applications in Oracle Cloud are integrated with social, mobile, and analytic capabilities to help deliver the experiences customers expect, the talent to succeed, and the performance the marketplace demands.

With Oracle HCM Cloud applications now available through Oracle Cloud, customers can securely deploy a modern human resources (HR) system in the cloud with a talent-centric and collaborative strategy that aligns HR with their recruitment, skills development, and business objectives, enabling them to find and retain talent and improve operational efficiency.

Oracle ERP Cloud helps customers streamline business processes using tools supporting financials, procurement, project costing, and project portfolio management. With the solution in place, organizations will be able to confidently implement secure enterprise applications designed to increase productivity, lower costs, and improve controls.

Oracle CX Cloud provides customers with modern sales tools that are user friendly and quick to deploy, and help improve customer engagement through enhanced social and mobile capabilities, and leverage learned insights to improve constituent experience from actionable data, all with the speed and agility of the cloud. Customers will be able to deliver great customer experience throughout the customer journey and across all interaction channels.

“Canadian organizations are evaluating and pursuing the benefits of cloud as both a business and deployment model to achieve these aspirations,” said Mario Meroni, area vice president, Oracle Canada Public Sector. “Our customers are now able to leverage the value of our world-class ERP, HCM, and CX cloud offerings while knowing their data resides in Canada.”

  Contact Info Katie Barron
Oracle
+1.202.904.1138
katie.barron@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

Katie Barron

  • +1.202.904.1138

Lacy Cooper

  • +1.540.364.5913

Follow Oracle Corporate

Categories: Database, Vendor

Oracle Service Cloud Granted U.S. Department of Defense Authority to Operate

Oracle Database News - Tue, 09/01/2015 - 13:00
Press Release Oracle Service Cloud Granted U.S. Department of Defense Authority to Operate

Redwood Shores, Calif.—Sep 1, 2015

Oracle Service Cloud—a software-as-a-service (SaaS) solution—has received an Authority to Operate (ATO) from the U.S Department of Defense (DoD) under the DoD Cloud Security Model at security impact Level 4. The Oracle Service Cloud is Oracle’s premier SaaS solution providing the industry’s best-in-class customer service platform for enterprise customers.

Oracle Service Cloud is the first cloud offering in Oracle’s U.S. DoD Cloud to receive an ATO. Oracle’s U.S. DoD Cloud is a community cloud available for all DoD agencies, and additional cloud services such as Human Capital Management Cloud are in process for accreditation. 

The rigorous review of Oracle’s environment was completed by an accredited third-party organization at the Level 4 security impact for a SaaS offering using a community deployment model. Level 4 security impact refers to Controlled Unclassified Information (CUI) or other critical mission data that requires protection from unauthorized disclosure.

“Oracle will be able to support U.S. government agencies by providing a secure platform in the cloud to better serve military men and women,” said David Vap, group vice president, Oracle Service Cloud. “The Department of Defense can now procure commercial cloud services in order to meet dynamic user needs, improve efficiency and drive greater productivity while at the same time, have assurances that Oracle Service Cloud delivers against process and security control requirements.”

By deploying Oracle Service Cloud on top of Oracle’s FedRAMP authorized Infrastructure as a Service (IaaS), Oracle provides the DoD with benefits such as:

  • Supporting the DoD Cloud First Policy
  • Providing a secure Cloud environment to support DoD needs
  • Offering a low cost option to the DoD
  • Allowing faster implementations and better service to DoD customers

More information on this certification is available at www.FedRAMP.gov.

Contact Info Katie Barron
Oracle
+1.202.904.1138
katie.barron@oracle.com Lacy Cooper
O'Keeffe and 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

Katie Barron

  • +1.202.904.1138

Lacy Cooper

  • +1.540.364.5913

Follow Oracle Corporate

Categories: Database, Vendor

New SQL Server 2014 Logo Certification Program

We are proud to announce the SQL Server Logo Certification Program, part of the Enterprise Cloud Application Logo Certification Programs announced in April. The program is designed to help application providers and ISV partners drive growth through recognition that their applications work with Microsoft SQL Server 2014 and global exposure in the Microsoft Pinpoint partner listing.


This program builds on the success of the Microsoft Azure Certified for Virtual Machines program and the Windows Server Logo certification program that helped connect thousands of partners with customers worldwide by delivering their certified applications globally. The logo certification programs are designed to deliver value to not just application providers and ISVs, but also IT pros and customers through:

  • A great partner experience - Our new Partner Center portal makes it even easier for partners to register, certify and generate market visibility of their applications.
  • Certified quality and reliability - Partners can now run validation tests and certify their applications ensuring quality, compatibility, reliability and security.
  • Global reach and exposure - With the new and improved Pinpoint, partners can now reach a global market, generating leads to grow their business
  • Credit toward Microsoft Partner Network competencies - The new certification option also qualifies application provider partners toward the application test requirements of the Microsoft Partner Network Competency program.

In addition, application and ISV partners can now take advantage of the features of SQL Server 2014 for Mission Critical performance:

  • Up to 30X faster transactional performance with in-memory OLTP
  • Up to 100X faster queries with the in-memory ColumnStore for analytics processing
  • Better availability with AlwaysOn Availability Groups, now with up to 8 readable secondaries
  • The ability to scale across compute, networking and storage when used with Windows Server 2012 R2
  • Data tools like Master Data Services and Data Quality Services to scale, enrich and secure your BI models
  • New hybrid cloud scenarios including easy migration to Microsoft Azure and Azure DR using an asynchronous AlwaysOn replica in the cloud


Some partners who are already taking advantage of the SQL Server 2014 Logo Certification Program are Seradex, which has certified the Seradex OrderStream application, and Synerion Inc., which has certified one of its Workforce Management applications for use with SQL Server 2014. Not only do Microsoft SQL Server customers know they will have a great experience with these applications, but the partners now have exposure from their partner listings and the ability to use the SQL Server 2014 Certified logo. “Synerion is delighted to advance its long standing partnership with Microsoft bringing cutting edge technologies to the Workforce Management software industry,” said Lee Lipes, VP of Product Management of Synerion.

To get started, a partner just needs to create an application profile in the Partner Center. From there, partners can self-test the application using our App Certification Test Tools. Then, showcase the certified application on the Pinpoint Marketplace. Learn more here.


Categories: Database

Is My Oracle Index Being Used?

Database Journal News - Mon, 08/31/2015 - 08:01

Finding 'unused' indexes in Oracle isn't an easy task for a number of reasons.  Read on to see why an index you might think isn't used probably is and discover the long path to dealing with such indexes.

Categories: Database

Analytics Platform System Update 4 Generally Available

Matt Usher, Senior Program Manager, DS SQL Engineering

We are pleased to announce the general availability of Appliance Update 4 for the Microsoft Analytics Platform System. The Microsoft Analytics Platform System is a turnkey big data analytics appliance, combining Microsoft’s massively parallel processing (MPP) data warehouse technology with HDInsight, Microsoft’s 100% Apache Hadoop distribution, and delivering it as a turnkey appliance. APS’s big data capability is powered by PolyBase, an integrated technology allowing customers to utilize the skillset they've developed in TSQL for querying and managing data in Hadoop platforms.

This update delivers several new capabilities and features, including:

PolyBase/Hadoop enhancements
  • Support for Cloudera 5.1 and Hortonworks Data Platform 2.1 and 2.2
  • Extended partial aggregate pushdowns into Hadoop
  • Grow HDInsight region on an appliance with an existing region
T-SQL compatibility improvements to reduce migration friction from SQL SMP
  • Scalar User Defined Functions – CREATE/DROP FUNCTION statements
  • PIVOT/UNPIVOT relational operators
  • Round Robin as a third table type for hybrid performance
  • Query plan improvements to favor hash joins over nested loop joins in DW scenarios for better query performance
  • Addition of a new DBCC command - DBCC DROPCLEANBUFFERS
  • SQL Server SMP to APS Migration Utility
Performance
  • 1.5x data return rate improvement for SELECT queries to improve external analysis integration
OEM Hardware on AU4
  • Dell, Quanta, and HP (Gen9) next generation server support
    • Intel Haswell Processors, 256 GB (16x16Gb) 2133MHz memory
  • Updated HP 5900 series switches including High Availability improvements
  • Mixed hardware version support allows extended appliance lifetime and expandability

Together with SQL Data Warehouse, Microsoft offers a choice of MPP data warehouse on-premises, in the cloud or both.

To learn more, please see the Microsoft Analytics Platform portal.

Related Link:
Microsoft Analytics Platform System Appliance Update 4 Documentation and Client Tools

Categories: Database

Oracle Launches New All Flash FS1 Storage System

Oracle Database News - Fri, 08/28/2015 - 00:35
Press Release Oracle Launches New All Flash FS1 Storage System With Superior Flash Performance, Scalability and Unique Co-engineering, Oracle All Flash FS1 Tops EMC XtremIO Across Multiple Concurrent Mixed Workloads

Redwood Shores, Calif.—Aug 27, 2015

Oracle expanded its flash storage portfolio today with the announcement of an all-flash model of its Oracle FS1 Flash Storage System. Available now, the new Oracle All Flash FS1 Storage System delivers superior flash performance, capacity scaling, and flash provisioning and is designed to handle concurrent mixed workloads, such as OLTP and high-speed data backup, in enterprise SAN environments as well as in private or public clouds. It delivers up to 64 all-flash domains for highly-secure data isolation in multitenant cloud environments, I/O prioritization based on business value, scales to nearly 1 PB of raw flash capacity, and goes from pallet to power-on in less than 30 minutes.   All Flash FS1 demonstrates superior I/O performance and low latency with minimal falloff. Tests performed for customers show sub-one millisecond latency when running simultaneous workloads across small to large block sizes with up to 8x faster IOPS and 9.7x faster write throughput than EMC XtremIO(1). As a result, All Flash FS1 can reduce Oracle Database I/O wait times and effectively give customers back time for projects that can help drive a company’s top-line growth and bottom-line savings.   Oracle All Flash FS1 is the only all-flash storage system co-engineered with Oracle Database and Applications and delivers net incremental business benefits to customers when deployed with Oracle software, from industry-leading data compression to one-click application provisioning. All Flash FS1 is uniquely able to take advantage of Oracle Hybrid Columnar Compression, available only to Oracle Storage, the most advanced data reduction technology in the industry. Hybrid Columnar Compression typically delivers a 10:1 compression ratio, nearly twice the data reduction usually obtained with deduplication techniques, reducing storage capacity requirements and accelerating Oracle Database queries. While encrypted Oracle Database data can’t be deduplicated, it can be compressed with Hybrid Columnar Compression, providing significantly higher levels of security to customers and maintaining Oracle Database best practices.   All Flash FS1 also features Flash Profiles, which provide pre-tuned and optimized provisioning profiles for Oracle Database and enterprise applications to simplify and accelerate flash storage provisioning and application deployment. As the industry’s best all-flash scale up two-node system, Oracle All Flash FS1 can support hundreds of Oracle databases—all in flash.   “High latency has impacted customers on shared storage platforms for years, slowing down OLTP response times and preventing mixed workloads from running at full speed. Customers are looking to flash to address these issues,” said Mike Workman, senior vice president, Flash Storage Systems, Oracle. “Oracle All Flash FS1 dramatically reduces I/O wait times typically seen in today’s highly virtualized, transaction-driven enterprises where low latency is critical to response time. This superior performance combined with unique features, such as Flash Domains and Flash Profiles, make the All Flash FS1 the platform for customers who want to significantly accelerate their applications in SAN and secure cloud environments.”   “Oracle practitioners in our community expect the highest levels of data integrity and security coupled with predictable performance,” said David Vellante, chief research officer, Wikibon. “Products such as the All Flash FS1 are riding the flash price/performance curve and promise to deliver dramatically lower latency and consistent response times at an affordable price. This can significantly reduce the effort required to deliver what are often among the most stringent service level requirements in IT.”   “With their introduction of the Oracle All Flash FS1, which was engineered from the ground up to maximize Oracle Database performance and scale, Oracle enters the ranks of what IDC defines as the ‘true All Flash Array (AFA) vendors’,” said Eric Burgener, research director, Storage, IDC.  “AFAs feature unique designs that are specifically optimized for flash media, delivering more consistent performance across their entire throughput range than Hybrid Flash Arrays, and making them the storage platform of choice for application environments that demand the highest levels of performance.”   Additional Information Join Oracle on LinkedIn and follow @Oracle on Twitter.  To learn more about Oracle’s flash storage, please follow @OracleHardware.   Contact Info Michelle Jenkins
Oracle
+1.425.945.8306
michelle.jenkins@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.

Footnote
  1. (1) Oracle FS1-2 delivers 8x higher IOPS for 50% Read/50% Write IOs of 32KB, 215,000 for FS1-2 and 26,863 for XtremIO X-Brick, and 9.7x higher write throughput 5.4GB/s for FS1-2 and 554MB/s for XtremIO X-Brick. XtremIO data from pages 10-13 of “EMC XTREMIO PERFORMANCE REPORT: Test Methodology and Performance Results of EMC XtremIO Version 2.4 SP1,” published September 2014.

 

Talk to a Press Contact

Michelle Jenkins

  • +1.425.945.8306

Follow Oracle Corporate

Categories: Database, Vendor

New Azure SQL Database offerings add capabilities to scale data up and out

Tiffany Wissner, Senior Director of Data Platform Marketing

At Microsoft we’re committed to meeting the needs of our customers by offering choices as they build cloud applications for scale and performance. Today we’re continuing to deliver on this commitment with two announcements:

As more customers build more powerful applications in Azure using Azure SQL Database, we've seen strong demand for more options to scale performance. We’re dedicated to offering a portfolio of data services for cloud applications that effectively scales up to support data growth from more users, and scales out to support growth from more customers and fluctuating resource demands.

To meet this scale up demand, we are announcing the release of new Azure SQL Database Premium performance levels, P4 and P11. With the introduction of both P4 and P11, we’ve expanded the range of throughput performance developers can leverage to scale their applications. Developers can quickly start with our basic or standard performance tiers and easily scale database performance up to 350 times greater with our premium tier as their data needs grow – all without code or application changes.  This enables developers to match application needs with the right database performance.



On the scale out front, we have seen an increasing demand for Elastic Database pools since we announced its public preview.  We’ve seen SaaS developers adopt and embrace elastic databases because it makes it easier to manage their growing number of customers.  With Elastic Database pools SaaS developers can manage hundreds of databases for each of their customers, optimize the performance of each database, and manage the cost of these databases to support their explosive growth. This means their customers still get a great experience, even during peak usage periods, and there’s no need to over-provision resources during lulls.

One example is StudioPlus, which offers solutions for professional photographers. CEO Matthew Hunt says, “We are expanding our legacy on-premises solution with a SaaS solution. Azure SQL Database is a fundamental part of this journey because it allows us to leverage an existing code base and gives us a platform for unlimited customer growth. From a DevOps perspective, it’s simple to set up and manage Azure SQL Database Elastic Database pools to support the unlimited scale-out of a one-database-per-customer pattern.”



To support the increasing demand of Elastic Database Pools, we are now introducing a public preview of two additional service tiers for Elastic Databases, Basic and Premium.  These new tiers give organizations and developers with SaaS applications greater options and flexibility for getting started with Elastic Databases and scaling out to meet new customer demands.




We are thrilled that we can support StudioPlus and a growing number of developers on their SaaS journey with Azure SQL Database.

Our announcements today add scale and performance options, and these releases are just part of our end-to-end data platform. We continue to make it easier for customers to maximize their data dividends with our data platform and services. It’s never been easier to capture, transform, mash-up, analyze and visualize any data, of any size, at any scale, in its native format using familiar tools, languages and frameworks in a trusted environment on-premises and in the cloud.

Find out more and try Azure SQL Database and Azure SQL Database Elastic Databases today.

Categories: Database

New Oracle Research Reveals that Businesses are Unaware of Competitive Advantages of Cloud Agility

Oracle Database News - Thu, 08/27/2015 - 13:00
Press Release New Oracle Research Reveals that Businesses are Unaware of Competitive Advantages of Cloud Agility

Redwood Shores, Calif.—Aug 27, 2015

Today, Oracle announced the results of its “Oracle Cloud Agility” study and revealed that businesses worldwide overestimate their agility. While a majority of businesses believe they are agile, Oracle’s research highlights that many organizations cannot flexibly manage workloads or rapidly develop, test, and launch new applications, leaving them poorly prepared to deal with competitive threats. The study also found a lack of awareness among businesses around how technology, like Platform-as-a-Service (PaaS), can be used to help address these challenges.

The Oracle Cloud Agility study surveyed 2,263 employees working for large global enterprises to understand business agility in the age of cloud. The results show that 64 percent consider their organization to be agile (i.e., able to adjust quickly to new business opportunities or to iterate new products and services quickly). When looking at the United States, businesses are even more positive, with 66 percent believing their business to be agile.

Respondents are clear about the benefits of agility, with 81 percent stating that the ability to rapidly develop, test, and launch new business applications is either critically important or important to the success of their business, falling to 76 percent in the United States. In particular, nearly one-third of respondents (29 percent) believe the effective mobilization of applications and services is the most important factor in business success today when it comes to IT infrastructure.

The study also reveals that the impact of agility on competitiveness is critically important to businesses. In fact, the ability of competitors to launch innovative customer services more rapidly was identified as the top threat by businesses (27 percent). Fifty two percent of global respondents indicated that their business does not have an IT infrastructure capable of meeting competitive threats. Those surveyed in the United States aligned exactly with their global counterparts, as 52 percent noted that their IT infrastructure was insufficient to meet competitive threats.

Significantly, the survey reveals that the agility benefits delivered by PaaS are not being leveraged. In fact, nearly half of businesses (49 percent) surveyed either cannot, or do not know if they can shift workloads between public, private, and hybrid clouds, and migrate on-premises applications to the cloud. Additionally, only 50 percent of businesses can develop, test, and deploy new business applications for use on mobile devices within six months, with this figure falling to just 30 percent within a one month timeframe.

“Businesses clearly know agility holds the key to their success, but there is an awareness gap around exactly how this agility can be realized through the right technology investments,” said Robert Shimp, group vice president, Oracle. “Today, PaaS can enable businesses to build new applications quickly – in as little as two weeks – allowing them to launch new internal and customer-facing applications rapidly. This capability allows organizations to respond almost immediately to market conditions and get their products and services to customers ahead of the competition.”

The survey results bear out the assessment that businesses are not fully aware of how PaaS can increase operational agility. Only 32 percent of respondents state that they fully understand what PaaS is, rising to 37 percent in the United States, while 29 percent admit that they do not understand it at all. For those that say they do understand PaaS, only 31 percent cite reduced timeframes for application development as a main benefit, far behind less strategic benefits such as savings on the cost of internal IT infrastructure (47 percent).

”PaaS offerings, such as the Oracle Cloud Platform, have the ability to deliver unprecedented levels of business agility. The key now is to demonstrate to businesses just how easy it is to integrate this critical cloud platform into their IT architectures. Yes, the cost savings delivered by PaaS are important, but of greater importance is its ability to help businesses reduce application development timeframes and more easily tailor and integrate third-party Software as a Service apps into their business, allowing them to more effectively address customer demand,” said Shimp.

Contact Info Nicole Maloney
Oracle
+1.650.506.0806
nicole.maloney@oracle.com Teri Whitaker
Oracle
+1.650.506.9914
teri.whitaker@oracle.com Additional Information

For this research Oracle partnered with Opinium Research to survey 2,263 individuals from large enterprises based around the globe, with respondents coming from countries including Australia, Brazil, China, France, Germany, South Korea, Poland, UK, and the USA.

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

Nicole Maloney

  • +1.650.506.0806

Teri Whitaker

  • +1.650.506.9914

Follow Oracle Corporate

Categories: Database, Vendor

A Roundup of Popular MySQL Mobile Apps for Android

Database Journal News - Mon, 08/24/2015 - 08:01

Not so long ago, Rob Gravelle compiled a list of the most popular MySQL mobile apps for iOS. There are some excellent MySQL mobile apps available for Android as well. Rob Gravelle presents a selection of the popular choices.

Categories: Database

dbMigration .NET 1.0 released

PostgreSQL News - Sun, 08/23/2015 - 01:00

dbMigration .NET is a simple, easy and intuitive multiple database migration tool, With it you can easily migrate schema and data between different databases without complicated procedure. Supported databases: PostgreSQL, SQL Server, SQL Azure, LocalDB, MySQL, Oracle, IBM DB2, Informix, HP Vertica, NuoDB, Teradata, Sybase ASE, Firebird, SQLite, SQLCe, Access, dBase, FoxPro...etc.

Major features:

  • Automatic column matching
  • SQL preview
  • Filter source data
  • Show target results
  • Integrated with Database .NET
  • BLOB type support
  • Command-Line support

For more information please visit http://fishcodelib.com/DBMigration.htm

Categories: Database, Open Source

Oracle Buys Maxymiser

Oracle Database News - Thu, 08/20/2015 - 20:05
Press Release Oracle Buys Maxymiser Extends Oracle Marketing Cloud’s Leadership with the Industry’s Most Powerful Solution for Optimizing Web and Mobile Customer Experiences

Redwood Shores, Calif.—Aug 20, 2015

Oracle today announced that it has signed an agreement to acquire Maxymiser, a leading provider of cloud-based software that enables marketers to test, target and personalize what a customer sees on a Web page or mobile app, substantially increasing engagement and revenue. Maxymiser optimizes over 20 billion customer experiences per month for brands such as Allianz, HSBC, Lufthansa, Tommy Hilfiger and Wyndham.

Oracle Marketing Cloud is already the fastest growing software platform for modern marketers in the world. The addition of Maxymiser to Oracle Marketing Cloud will strengthen the most comprehensive solution to manage marketing programs across all digital channels and across the customer lifecycle.

“Companies are increasingly seeking innovative ways to differentiate their brands while increasing both ROI and loyalty based on optimized customer experiences,” said Thomas Kurian, President, Product Development, Oracle. “Together with Maxymiser, Oracle Marketing Cloud enables enterprises to stop guessing and start delivering what customers want across all digital channels and devices.”

“Our mission is to empower enterprises to use data science to systematically test, discover, and predict what customers want and deliver uniquely tailored experiences,” said Tim Brown, Chief Executive Officer, Maxymiser. “We are excited to join Oracle and bring these capabilities to help extend Oracle Marketing Cloud.”

Contact Info Deborah Hellinger
Oracle Corporate Communications
+1.212.508.7935
deborah.hellinger@oracle.com Ken Bond
Oracle Investor Relations
+1.650.607.0349
ken.bond@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.

Oracle is currently reviewing the existing Maxymiser product roadmap and will be providing guidance to customers in accordance with Oracle’s standard product communication policies. Any resulting features and timing of release of such features as determined by Oracle’s review of Maxymiser’s product roadmap are at the sole discretion of Oracle. All product roadmap information, whether communicated by Maxymiser or by Oracle, does not represent a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. It is intended for information purposes only, and may not be incorporated into any contract.

Cautionary Statement Regarding Forward-Looking Statements

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

Talk to a Press Contact

Deborah Hellinger

  • +1.212.508.7935

Ken Bond

  • +1.650.607.0349

Follow Oracle Corporate

Categories: Database, Vendor

Creating Dashboards for Mobile Devices with Datazen – Part 3

Database Journal News - Thu, 08/20/2015 - 08:01

Learn how to create a data source and data view and then how to create dashboards with Datazen Publisher using those data sources and data views.

Categories: Database

SQL Relay 0.62 release announcement

PostgreSQL News - Thu, 08/20/2015 - 01:00

SQL Relay 0.62 is now generally available.

SQL Relay is a connection pool, load balancer, query router, and database proxy. It supports many databases, including PostgreSQL and provides API's for most popular programming languages and database abstraction layers.

Categories: Database, Open Source

2UDA Alpha 2 Release Available

PostgreSQL News - Wed, 08/19/2015 - 01:00

Enhanced alpha release of new data analytics application available.

2ndQuadrant is pleased to announce further enhancements to 2UDA (pronounced 'Tudor'), our new data analytics application suite currently under development, and available to try now.

This second alpha release brings a number of enhancements and product updates, based on user feedback and the continuous development of the core applications 2UDA unifies:

  • PostgreSQL server daemon is now an OS service (named "org.2ndQ.2UDA.postgres-9.5") on OS X
  • PostgreSQL server daemon is now an OS service (named "2uda-postgresql-9.5") on Linux (tested on Ubuntu 14.04, CentOS 7, openSUSE 13.2, & Fedora 22)
  • Windows installer is now certified from Microsoft and signed digitally
  • Latest PostgreSQL 9.5 after its Alpha 2 release has been included. Details of changes are listed
  • Latest Orange 3 has been included. This version uses the new tablesample patch in PostgreSQL rather than relying on blocksample extension.
  • Latest LibreOffice 5 has been included.
  • The installer now checks for server readiness before loading sample database. This prevents a bug where sample data got loaded while the server was still consolidating its connections.
  • Other small bugs and tweaks.

Download a copy now and let us know what you think: http://bit.ly/2UDA-A2

Categories: Database, Open Source

Oracle Helps Organizations Power Customer Experiences with Latest Releases of Oracle Service Cloud and Oracle Social Cloud

Oracle Database News - Mon, 08/17/2015 - 20:20
Press Release Oracle Helps Organizations Power Customer Experiences with Latest Releases of Oracle Service Cloud and Oracle Social Cloud Enables brands to leverage social channels and self-service communities to expand customer engagements and business insights

Redwood Shores, Calif.—Aug 17, 2015

News Summary

Oracle unveiled significant new functionality within Oracle Service Cloud and Oracle Social Cloud that helps organizations deliver better customer experience and drive more informed business decisions. The new social customer service capabilities enable brands to increase social engagement and business insights via a new community self-service solution, enhanced social service and incident routing, and extended social listening and analytics capabilities to private data sources.

Today more than one in three customers prefer to contact brands through social channels rather than by phone or email (Nielsen), and the distinction between social and traditional channels is eroding. To deliver the best possible customer experience across this expanding range of traditional and digital channels, customer care organizations need to provide a positive and unified experience where and when customers want, whether they are on Twitter, Facebook, customer communities or other social networks. Through a unified and modern customer experience across channels, organizations establish a competitive advantage.

The latest release of Oracle Service Cloud includes Community Self-Service, a new approach to web self service that brings community functionality directly into the core multi-channel web experience. Oracle Service Cloud now enables organizations to deliver a seamless experience between web service and community interactions, leveraging the power of customer knowledge to improve service operations. This helps organizations streamline the customer journey and lets customers quickly find an answer, while also driving efficiencies by reducing the overall requests to the contact center.

The latest enhancements to Oracle Social Cloud and Oracle Service Cloud extend Oracle’s commitment to help organizations leverage social channels to enhance the customer experience and build on the recent introduction of Oracle’s Twitter-enriched social customer service solution.

Gartner’s research indicates that investment in Peer-to-Peer Communities drives support costs down and boosts profits. In fact, in a December 2014 research note, Nine CRM Projects to Do Right Now for Customer Service, “Gartner clients who are successful in this space are still seeing on average a 20% reduction in the creation of support tickets following the introduction of peer-to-peer communities,” wrote Michael Maoz, Vice President, Distinguished Analyst, Gartner. “Clients are seeing other business benefits as well. By enabling community-based support, clients have been able to recognize new sales opportunities and increase existing customer satisfaction, resulting in increased revenue in several of these cases.”

Oracle is also introducing new workflow and automation capabilities between Oracle Social Cloud and Oracle Service Cloud that empower organizations to leverage the power of social insights and engagements. Business users can now attach contextual attributes and notes generated from posts or incidents identified by Oracle Social Cloud directly to the Oracle Service Cloud. By providing more customer information and context, organizations can improve service quality, drive efficiencies and improve resolution time as social posts are shared with the appropriate agents quickly.

The improved connectivity between Oracle Social Cloud and Oracle Service Cloud includes extended social listening and analytics to enterprise private-data sources such as the new Community Self-Service capability, survey data, chat and call logs. Organizations can now listen and analyze unstructured data and gain insights with terms, themes, sentiment and customer metrics, and can view private and public data side by side in the Oracle Social Cloud Relationship Management dashboard.

“In today’s hyper-competitive business environment, understanding the voice of the customer is essential to providing exceptional experiences, whether on public social networks, across communities, or within high-touch contact centers,” said David Vap, group vice president, product development, Oracle. “The updates to the Oracle Service Cloud and Oracle Social Cloud help businesses listen, identify and track social conversations, enabling them to quickly and efficiently respond to customers looking for answers, which helps foster a loyal group of brand ambassadors.”

To learn more, attend Stephen Fioretti’s session Accelerating Success with Modern Service in the Cloud at 3:10 p.m. eastern in A204 on Tuesday, September 18 at CRM Evolution in New York and visit us at Booth 300.

  Contact Info Diana Wong
Oracle
+1.650.506.2757
diana.wong@oracle.com Peter Mertens
Team Oracle PR
+1.312.596.3515
peter.mertens@teamoraclepr.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

Diana Wong

  • +1.650.506.2757

Peter Mertens

  • +1.312.596.3515

Follow Oracle Corporate

Categories: Database, Vendor

Staffing Your IT Organization for Big Data

Database Journal News - Mon, 08/17/2015 - 08:01

Most large companies have one or more big data applications, which provide fast access to large stores of customer and sales data. As the IT organization grows new job categories and new tasks are added to the mix. These include big data hardware and software support, business analysts who use analytics to probe and explore the data, and managers who must supervise and prioritize job tasks.

Categories: Database