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

SAAS AND PAAS CLOUD REVENUE UP 32%, SOFTWARE AND CLOUD REVENUE UP 6% TO $6.6 BILLION

Oracle Database News - Thu, 09/18/2014 - 21:35
SAAS AND PAAS CLOUD REVENUE UP 32%, SOFTWARE AND CLOUD REVENUE UP 6% TO $6.6 BILLIONRecord Quarterly Operating Cash Flow Up 7% to $6.7 BillionREDWOOD SHORES, Calif. – September 18, 2014

Oracle Corporation (NYSE: ORCL) today announced that fiscal 2015 Q1 total revenues were up 3% to $8.6 billion. Total Software plus Cloud revenue was up 6% to $6.6 billion. Software-as-a-service (SaaS) and Platform-as-a-service (PaaS) cloud revenue was up 32% to $337 million. Infrastructure-as-a-service (IaaS) cloud revenue was up 26% to $138 million. Hardware systems revenue was down 8% to $1.2 billion. GAAP operating income was up 3% to $3.0 billion, and the GAAP operating margin was 34%. Non-GAAP operating income was up 2% to $3.8 billion, and the non-GAAP operating margin was 44%. GAAP net income was unchanged at $2.2 billion while non-GAAP net income was up 2% at $2.8 billion. GAAP earnings per share were $0.48, up 2% compared to last year while non-GAAP earnings per share were $0.62, up 4%. GAAP operating cash flow on a trailing twelve-month basis was $15.4 billion.

“We are increasing our cloud services growth rate while simultaneously delivering record levels of cash flow,” said Oracle CEO, Safra Catz. “In Q1, our overall cloud services business grew more than 30% to $475 million in revenue. At the same time, we delivered an all-time record operating cash flow up 7% to $6.7 billion. We are laser focused on two goals: growing our cloud business and growing our cash flow. We’re off to a good start in FY15.”

“Our internally developed Fusion cloud applications business grew at a rate of nearly 200% in the quarter,” said Oracle CEO, Mark Hurd. “As our hyper-growth Fusion applications become a larger and larger portion of our total SaaS sales, that will drive up our overall cloud services growth rate. Our cloud business is already three times the size of Workday, but we won’t be satisfied until we’re number one in the cloud.”

“Next week at Oracle Open World, we will be rolling out our database cloud service,” said Oracle Executive Chairman and Chief Technology Officer, Larry Ellison. “Database is our largest software business, and database will be our largest cloud service. With our new multitenant Database as a Service offering, our customers and ISV’s can move any of their existing Oracle databases and applications to the Oracle Cloud with the push of a button.”

The Board of Directors also declared a quarterly cash dividend of $0.12 per share of outstanding common stock. This dividend will be paid to stockholders of record as of the close of business on October 8, 2014, with a payment date of October 29, 2014.

Oracle also announced that its Board of Directors authorized the repurchase of up to an additional $13.0 billion of common stock under its existing share repurchase program in future quarters.

Q1 Fiscal 2015 Earnings Conference Call and Webcast

Oracle will hold a conference call and webcast today to discuss these results at 2:00 p.m. Pacific. You may listen to the call by dialing (816) 287-5563, Passcode: 425392. To access the live webcast of this event, please visit the Oracle Investor Relations website at http://www.oracle.com/investor. In addition, Oracle’s Q1 results and Fiscal 2015 financial tables are available on the Oracle Investor Relations website.

A replay of the conference call will also be available by dialing (855) 859-2056 or (404) 537-3406, Passcode: 99926438.

About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit www.oracle.com or contact Investor Relations at investor_us@oracle.com or (650) 506-4073.

# # #

Trademark

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

"Safe Harbor" Statement: Statements in this press release relating to Oracle's future plans, expectations, beliefs, intentions and prospects, including statements regarding our cloud services growth rate, growing our cash flow, our plans to be number one in the cloud, our Database as a Service offering and that database will be our largest cloud service, are "forward-looking statements" and are subject to material risks and uncertainties. Many factors could affect our current expectations and our actual results, and could cause actual results to differ materially. We presently consider the following to be among the important factors that could cause actual results to differ materially from expectations: (1) Economic, geopolitical and market conditions, including the continued slow economic recovery in the U.S. and other parts of the world, can adversely affect our business, results of operations and financial condition, including our revenue growth and profitability, which in turn could adversely affect our stock price. (2) We may fail to achieve our financial forecasts due to such factors as delays or size reductions in transactions, fewer large transactions in a particular quarter, unanticipated fluctuations in currency exchange rates, delays in delivery of new products or releases or a decline in our renewal rates for support contracts. (3) Our cloud computing strategy, including our Oracle Cloud Software-as-a-Service, Platform-as-a-Service, Infrastructure-as-a-Service and our new Database as a Service offerings, may not be successful. (4) If we are unable to develop new or sufficiently differentiated products and services, or to enhance and improve our products and support services in a timely manner or to position and/or price our products and services to meet market demand, customers may not buy new software licenses, cloud software subscriptions or hardware systems products or purchase or renew support contracts. (5) Our international sales and operations subject us to additional risks that can adversely affect our operating results, including risks relating to foreign currency gains and losses. (6) If the security measures for our software, hardware, services or Oracle Cloud offerings are compromised or if such offerings contain significant coding, manufacturing or configuration errors, we may experience reputational harm, legal claims and financial exposure. (7) We have an active acquisition program and our acquisitions may not be successful, may involve unanticipated costs or other integration issues or may disrupt our existing operations. A detailed discussion of these factors and other risks that affect our business is contained in our SEC filings, including our most recent reports on Form 10-K and Form 10-Q, particularly under the heading "Risk Factors." Copies of these filings are available online from the SEC or by contacting Oracle Corporation's Investor Relations Department at (650) 506-4073 or by clicking on SEC Filings on Oracle’s Investor Relations website at http://www.oracle.com/investor. All information set forth in this press release is current as of September 18, 2014. Oracle undertakes no duty to update any statement in light of new information or future events.

Contact Info

Ken Bond
Oracle Investor Relations
+1.650.607.0349
ken.bond@oracle.com

Deborah Hellinger
Oracle Corporate Communications
+1.212.508.7935
deborah.hellinger@oracle.com

Categories: Database, Vendor

Oracle Board Appoints Larry Ellison Executive Chairman and CTO

Oracle Database News - Thu, 09/18/2014 - 21:22
Oracle Board Appoints Larry Ellison Executive Chairman and CTOSafra Catz and Mark Hurd Appointed CEOREDWOOD SHORES, Calif. – September 18, 2014

Oracle Board of Directors today announced that it has elected Larry Ellison to the position of Executive Chairman of Oracle's Board and appointed him the company's Chief Technology Officer. Jeff Henley, who has served as Oracle's Chairman for the last 10 years, was appointed Oracle's Vice Chairman of the Board.

The Oracle Board also promoted both Safra Catz and Mark Hurd to the position of CEO, Oracle Corporation. All manufacturing, finance, and legal functions will continue to report to Oracle CEO, Safra Catz. All sales, service and vertical industry global business units will continue to report to Oracle CEO, Mark Hurd. All software and hardware engineering functions will continue to report to Oracle Chairman and CTO, Larry Ellison.

"Safra and Mark will now report to the Oracle Board rather than to me," said Larry Ellison. "All the other reporting relationships will remain unchanged. The three of us have been working well together for the last several years, and we plan to continue working together for the foreseeable future. Keeping this management team in place has always been a top priority of mine."

"Larry has made it very clear that he wants to keep working full time and focus his energy on product engineering, technology development and strategy," said the Oracle Board's Presiding Director, Dr. Michael Boskin. "Safra and Mark are exceptional executives who have repeatedly demonstrated their ability to lead, manage and grow the company. The Directors are thrilled that the best senior executive team in the industry will continue to move the company forward into a bright future."

About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE: ORCL), visit www.oracle.com or contact Investor Relations at investor_us@oracle.com or (650) 506-4073.

TrademarksOracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.“Safe Harbor" Statement

"Safe Harbor" Statement: Statements in this press release relating to Oracle's future plans, expectations, beliefs, intentions and prospects, are "forward-looking statements" and are subject to material risks and uncertainties. Many factors could affect our current expectations and our actual results, and could cause actual results to differ materially. We presently consider the following to be among the important factors that could cause actual results to differ materially from expectations: (1) Economic, geopolitical and market conditions, including the continued slow economic recovery in the U.S. and other parts of the world, can adversely affect our business, results of operations and financial condition, including our revenue growth and profitability, which in turn could adversely affect our stock price. (2) We may fail to achieve our financial forecasts due to such factors as delays or size reductions in transactions, fewer large transactions in a particular quarter, unanticipated fluctuations in currency exchange rates, delays in delivery of new products or releases or a decline in our renewal rates for support contracts. (3) Our cloud computing strategy, including our Oracle Cloud Software-as-a-Service, Platform-as-a-Service, Infrastructure-as-a-Service and our new Database as a Service offerings, may not be successful. (4) We have an active acquisition program and our acquisitions may not be successful, may involve unanticipated costs or other integration issues or may disrupt our existing operations. (5) Our international sales and operations subject us to additional risks that can adversely affect our operating results, including risks relating to foreign currency gains and losses. (6) If the security measures for our software, hardware, services or Oracle Cloud offerings are compromised or if such offerings contain significant coding, manufacturing or configuration errors, we may experience reputational harm, legal claims and financial exposure. (7) If we are unable to develop new or sufficiently differentiated products and services, or to enhance and improve our products and support services in a timely manner or to position and/or price our products and services to meet market demand, customers may not buy new software licenses, cloud software subscriptions or hardware systems products or purchase or renew support contracts. A detailed discussion of these factors and other risks that affect our business is contained in our SEC filings, including our most recent reports on Form 10-K and Form 10-Q, particularly under the heading "Risk Factors." Copies of these filings are available online from the SEC or by contacting Oracle Corporation's Investor Relations Department at (650) 506-4073 or by clicking on SEC Filings on Oracle's Investor Relations website at http://www.oracle.com/investor. All information set forth in this press release is current as of September 18, 2014. Oracle undertakes no duty to update any statement in light of new information or future events.

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

Categories: Database, Vendor

Microsoft Azure Offers HDInsight (Hadoop-as-a-service) to China

Microsoft today announced that Azure HDInsight is now available for all customers in China as a public preview, making it the first global cloud provider to have a publicly available cloud Hadoop offering in China. With this launch, Microsoft is bringing Azure HDInsight’s ability to process big data volumes from unstructured and semi-structured sources to China. Both local Chinese organizations and multi-national corporations with offices in China can spin up a Hadoop cluster within minutes. 

Hadoop is an open-source platform for storing and processing massive amounts of data. By using Hadoop alongside your traditional data architecture, you can gain deep insights into data you never imagined being able to access.  As an example, Blackball, a Taiwanese Tea and Dessert restaurant chain was able to combine traditional data from its point-of-sale systems with new data from social sentiment and weather feeds to understand why a customer would purchase their products.  By combining traditional sources with new “Big Data”, Blackball found out that hot/cold weather was not really a factor in its sales of hot/cold drinks and was able to adjust accordingly to customer demand.

It is these types of results that are causing a wave of demand for big data. We invite you to try HDInsight today either in China or across the other Azure data centers. 

Learn more through the following resources:

Categories: Database

Achieve improved database interoperability with SQL and RDB aliases

IBM - DB2 and Informix Articles - Thu, 09/18/2014 - 05:00
In today's complex environments, where data is spread across numerous homogeneous and heterogeneous databases, simplification is a necessity. Three-part naming offers that simplification for database connectivity by allowing skilled data architects, programmers, and system administrators the ability to easily manage remote Distributed Relational Database Architecture (DRDA) connections within SQL applications and data centers. This article gives you insight into the options available to use DRDA more proficiently through three-part naming and RDB aliases. Understanding these concepts can enable you to improve your SQL database interoperability in your SQL applications or daily use and also gain a level of database abstraction and portability.
Categories: Database

New Optimized OLTP and Data Warehousing SQL Server Images on Azure

Microsoft Azure continues to offer customers more reasons why  Azure Virtual Machines are an ideal place to develop, test and run your SQL Server applications.  This promise is further enhanced with the release of new workload optimized images for SQL Server that provide greater performance and simplified setup when it comes to running data warehousing and OLTP workloads in Azure.   There are 4 new SQL Server images being released with benefits outlined below:

  • New Data Warehousing Optimized Image for both SQL Server 2014 and SQL Server 2012  – These images simplify the setup process for customers by adding more automation. For example, the automation of attaching a disk to the SQL Server VM running a data warehouse workload. 
  • New OLTP Optimized Image for both SQL Server 2014 and SQL Server 2012 – These new images allow a customer to get better performance for an OLTP high IO intensive workload.   One of the key improvements in this tuned image is the ability to attach many disks to the SQL Server VM.  This is critical in terms of improving IO in an OLTP workload as the number of disk has a direct impact on OLTP performance.  In addition, new Windows features are also utilized like Storage Pools for multi-disk environment to improve IO performance and latency.

The image below highlights the new optimized images being available on Microsoft Azure.

Be sure to read the blog post “New VM Images Optimized for Transactional and DW Workloads in Azure VM Gallery” for a more detailed technical overview.

Continue learning more about Microsoft Azure, Virtual Machines, and how our customers are reaping the benefits of these technologies:

Try Microsoft Azure.

Learn more about Virtual Machines.

Read how Amway and Lufthansa leveraged Microsoft SQL Server 2014 and Windows Azure.

Categories: Database

Oracle’s Primavera Unifier 10.0 Gives Project Leaders New Power to Deliver Projects on Time and on Budget

Oracle Database News - Wed, 09/17/2014 - 13:00
Oracle’s Primavera Unifier 10.0 Gives Project Leaders New Power to Deliver Projects on Time and on Budget Single, integrated solution simplifies project delivery management, cost control, and capital planningRedwood Shores, Calif. – September 17, 2014
News Summary

With increasingly complex projects and higher expectations for on-time, on-budget completion, project leaders need real-time visibility across initiatives to make the informed and timely decisions required to control costs and avoid delays. Oracle’s Primavera Unifier 10.0 makes it easier for project leaders to achieve this goal by integrating project delivery management, cost control, and capital planning in a single, easy-to-use, and cost-effective solution. The new release also includes expanded support for mobile devices, more flexible navigation, and calculation features as well as broader browser compatibility.

News Facts Oracle today announced the release of Primavera Unifier 10.0, which gives project leaders unprecedented flexibility and visibility into and control over enterprise projects to ensure on-time completion and avoid budget overages, while leveraging the simplicity, elasticity, and security of the Oracle cloud. The latest version provides an integrated and comprehensive solution for project delivery management, cost control, and capital planning. It combines Primavera Project Delivery Management, Primavera Cost Controls, and Primavera Capital Planning into one cost-effective, easy-to-manage application—Primavera Unifier Project Controls. Primavera Unifier 10.0 is more flexible and easier to use than earlier releases thanks to new navigation tools and expanded graphical interfaces—helping project leaders to optimize productivity. Users have greater flexibility to organize tabs and configure interfaces to highlight frequently used features and content. Charts, grids, and other graphical interfaces are now supported with cross-browser-compatible standard APIs—enabling consistent display across web browsers. Primavera Unifier now features expanded support for mobile devices. With Primavera Unifier 10.0, users who create business process records on a mobile device can seamlessly attach photos to records—such as requests for information, potential change orders, and work orders—in a single step rather than waiting to attach photos later in the workflow. Primavera Unifier 10.0 supports Microsoft Internet Explorer 9,10, and 11; Apple’s Safari; Mozilla Firefox; and Google Chrome web browsers, providing users with additional platform options and reducing vulnerabilities by enabling users to switch between multiple browsers.Supporting Quote “Primavera Unifier 10.0 demonstrates Oracle’s continued dedication to providing our customers with best-in-class project lifecycle management solutions for cost control, project delivery, and capital planning capabilities,” said Mike Sicilia, senior vice president and general manager, Oracle Primavera Global Business Unit. “With this latest release, Oracle further integrates these capabilities into a single easy-to-own and easy-to-use solution that reduces complexity. We also continue to expand and refine features to give users greater power and flexibility to effectively manage their enterprise initiatives and deliver them on time and on budget.”Supporting Resources Oracle Primavera Primavera Unifier 10.0 Oracle Primavera on Facebook Oracle Primavera on Twitter

 

About Oracle

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

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

Valerie Beaudett
Oracle
+1.650.400.7833
Valerie.beaudett@oracle.com

Mary Tobin
O’Keeffe & Company
+1.503.658.7396

mtobin@okco.com

Categories: Database, Vendor

Ohio Department of Taxation Improves Collection Processes and Achieves Enterprisewide Visibility with Oracle Public Sector Revenue Management

Oracle Database News - Tue, 09/16/2014 - 14:24
Ohio Department of Taxation Improves Collection Processes and Achieves Enterprisewide Visibility with Oracle Public Sector Revenue ManagementRedwood Shores, Calif. – September 16, 2014News Summary

The Ohio Department of Taxation needed to replace its proprietary tax administration system with an integrated solution that would increase efficiencies, allow the agency to adapt quickly to changing tax policies, and reduce complexity and cost. The department implemented Oracle Public Sector Revenue Management to deliver a consolidated taxpayer view across revenue sources, improving collections and taxpayer service. The Oracle solution—powered by Oracle Policy Automation enables the department to reduce administrative costs while decreasing its revenue gap via a modern, secure enterprise application and technology architecture.

News Facts The Ohio Department of Taxation, which collects and administers most Ohio state taxes and several local taxes, implemented Oracle Public Sector Revenue Management to optimize its revenue collection process and allow the department to quickly respond to tax law and regulatory changes. Working with Oracle and HP, the department deployed Oracle Public Sector Revenue Management for its sales tax, use tax, employer withholding, natural gas, replacement tire, and school district withholding tax types, which includes converting more than 30 million obligations, forms, adjustments, and financial transactions across more than 1.3 million accounts. The implementation will enable the department to retire its legacy mainframe integrated tax administration system (ITAS) application and move forward with a modern technology architecture that offers an improved user interface, enhanced functionality and increased efficiency with no more COBOL for IT staff to maintain. With Oracle Public Sector Revenue Management, the Ohio Department of Taxation will consolidate more than 23 legacy tax types from various systems into one to centralized tax management system across all major business functions including registration, forms, payments, accounting, collections and case management. The new enterprisewide taxpayer view will enable the department to improve operations and increase revenue through more efficient collections processes. Powered by Oracle Policy Automation’s rules engine, the department’s new tax solution enables business users to manage and maintain 18 different rule bases (which consist of a multitude of business rules) directly from tax legislation. The Ohio Department of Taxation plans to use Oracle Public Sector Revenue Management to support several other tax types as well, including severance, horse racing, casino, alcohol beverages, kilowatt, individual income, and motor fuels, among others. Supporting Quotes “We are very pleased with the selection of Oracle Public Sector Revenue Management, which enabled us to move away from a legacy proprietary system toward an enterprise-ready solution that facilitates content sharing across tax types and business functions. The service-oriented architecture–based off-the-shelf software solution enables us to integrate with third party systems more easily for enhanced inter- and intragovernment collaboration, improve technology choice, and reduce total cost of ownership,” said Mark Walker, chief information officer, Ohio Department of Taxation. “The Ohio Department of Taxation needed a solution that could meet the demand for increased efficiency and effectiveness today, as well as adapt to tomorrow’s inevitable policy changes. Oracle Public Sector Revenue Management is a powerful and flexible solution that helps the department improve collections and constituent services and simplify complex policy issue management,” said Mark Johnson, senior vice president, Oracle Public Sector. “Our successful implementation of this integrated solution is a huge accomplishment for the Ohio Department of Taxation, HP, and Oracle,” said David Montgomery, delivery executive, HP State and Local Government. “The ease with which the teams worked together in using the out-the-box framework and configuring the product to meet Ohio Revised Code was smoother than expected. As prime systems integrator, the HP team’s leverage of agile delivery processes and the ease of integrating the Oracle product with other third party products were critical factors in making this successful.” Supporting Resources Oracle Public Sector Oracle Public Sector Revenue Management Oracle Policy Automation PeopleSoft Financial Management applications Oracle Public Sector on Facebook Oracle Public Sector on Twitter Oracle Public Sector on Diigo

*The Ohio Department of Taxation purchased its license for Oracle Public Sector Revenue Management on May 29, 2008 and its Oracle Policy Automation license on December 10, 2012.

About Oracle

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

 

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

Contact Info

Katie Barron

Oracle

+202-904-1138

katie.barron@oracle.com

Lacy Cooper

O’Keeffe & Company

+540-364-5913

lcooper@okco.com

Categories: Database, Vendor

Join the Global MySQL Community at MySQL Central @ OpenWorld

Oracle Database News - Tue, 09/16/2014 - 13:00
Join the Global MySQL Community at MySQL Central @ OpenWorldLearn the latest best practices from Oracle’s MySQL engineers, customers, partners, and community members during Oracle OpenWorld in San Francisco Redwood Shores, Calif. – September 16, 2014 News Summary

Organizations around the world rely on MySQL to power business-critical web, cloud, and embedded applications, and many are heading to MySQL Central @ OpenWorld to brainstorm tomorrow’s innovations. Taking place September 29 through October 2, 2014, MySQL Central is the smart spot to network and build strategies for next-generation applications. You’ll hear directly from Oracle’s MySQL engineers about the latest features, enhancements, and plans, and connect with MySQL customers, partners, and community members to share best practices and success stories.

News Facts Oracle will host MySQL Central @ OpenWorld from Monday, September 29 through Thursday, October 2 at Oracle OpenWorld in San Francisco. The four-day event gives attendees access to exclusive keynotes, extensive content, and unique opportunities to learn directly from Oracle’s MySQL experts. Monday’s keynote, “The State of the Dolphin and Customer Experiences,” will be delivered by Edward Screven, Oracle chief corporate architect, and Tomas Ulin, vice president, MySQL Engineering. Booking.com, Dropbox, and Twitter will also share their MySQL experiences in the session. MySQL Central will include tutorials, technical sessions, hands-on labs, and Birds-of-a-Feather sessions from Oracle’s MySQL engineers, community members, partners, and customers, including the following: Attendees can also expect in-depth sessions on hot topics across these five tracks: MySQL 5.6 and WebScaleSQL at Facebook MySQL @ King: Scaling Candy Crush Elastic Scalability in MySQL Fabric Using OpenStack MySQL 5.7: InnoDB, What’s New Basic MySQL Troubleshooting for Oracle DBAs Attendees can also expect in-depth sessions on hot topics across these five tracks: Performance and Scalability High Availability and Replication Cloud and Big Data Database Administration and DevOps Architecture and Application Development Additional information on MySQL Central and be found here. Save $200 off the onsite registration by registering now.Supporting Quote "Millions of organizations depend on MySQL technology, and MySQL Central @ OpenWorld brings together members of these organizations for four days of unparalleled learning and discussion,” said Tomas Ulin, vice president, MySQL Engineering, Oracle. “Whether you’re an experienced MySQL user or an Oracle DBA just getting started with it, this event will help you effectively develop, deploy, and manage web, cloud, and embedded applications powered by MySQL.” Supporting Resources MySQL Central @ OpenWorld Oracle and MySQL MySQL MySQL BlogTwitterFacebook Register for Oracle OpenWorld 2014 San Francisco  Oracle OpenWorld 2014 Keynotes Follow Oracle OpenWorld on Twitter, Facebook, and LinkedInAbout OracleOpenWorld

Oracle OpenWorld San Francisco is the most important business and technology conference of the year for Oracle customers, prospective customers, and partners. This educational conference is dedicated to helping businesses optimize existing systems and understand upcoming industry trends and breakthroughs driven by technology. Oracle OpenWorld offers more than 2,500 educational sessions, hundreds of demos and hands-on labs, and exhibitions from more than 400 partners and customers from around the world showcasing applications, middleware, database, server and storage systems, industries, management, cloud, and infrastructure solutions—all engineered for innovation. Oracle OpenWorld 2014 is being held September 28 through October 2 at the Moscone Center in San Francisco. For more information; to register; or to watch Oracle OpenWorld keynotes, sessions, and more, visit www.oracle.com/openworld. Join the Oracle OpenWorld discussion on Twitter, Facebook, and the Oracle OpenWorld blog.

About Oracle

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

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

Teri Whitaker
Oracle
+1.650.506.9914
teri.whitaker@oracle.com

Danielle Tarp
Blanc & Otus
+1.415.856.5182
dtarp@blancandotus.com

Categories: Database, Vendor

InfoSphere Guardium data security and protection for MongoDB Part 2: Configuration and policies

IBM - DB2 and Informix Articles - Tue, 09/16/2014 - 05:00
This article series describes how to monitor and protect MongoDB data using IBM InfoSphere Guardium, including the configuration of the solution, sample monitoring use cases, and additional capabilities such as quick search of audit data and building a compliance workflow using an audit process. Part 2 describes how to configure InfoSphere Guardium to collect MongoDB traffic and describes how to create security policy rules for a variety of typical data protection use cases, such as alerting on excessive failed logins, monitoring privileged users, and alerting on unauthorized access to sensitive data. Many organizations are just getting started with MongoDB, and now is the time to build security into the environment to save time, prevent breaches, and avoid compliance violations.
Categories: Database

Join the Global MySQL Community at MySQL Central @ OpenWorld

MySQL AB - Tue, 09/16/2014 - 01:59
Organizations around the world rely on MySQL to power business-critical web, cloud, and embedded applications, and many are heading to MySQL Central @ OpenWorld to brainstorm tomorrow’s innovations. Taking place September 29 through October 2, 2014, MySQL Central is the smart spot to network and build strategies for next-generation applications. You’ll hear directly from Oracle’s MySQL engineers about the latest features, enhancements, and plans, and connect with MySQL customers, partners, and community members to share best practices and success stories.
Categories: Database, Vendor

Oracle Announces OPN Central @ OpenWorld: Customized for Partners

Oracle Database News - Mon, 09/15/2014 - 22:50
Oracle Announces OPN Central @ OpenWorld: Customized for PartnersWeeklong event designed to help partners accelerate innovation and extend business opportunities with OracleRedwood Shores, Calif. – September 15, 2014
News Summary

The Oracle PartnerNetwork (OPN) community is an integral part of Oracle’s success. OPN Central @ OpenWorld comprises a week of sessions and networking designed to provide more than 25,000 OPN members with the strategies and information they need to grow and profit with Oracle.

News Facts Oracle today announced OPN Central @ OpenWorld, an Oracle OpenWorld program customized for partners. OPN Central runs September 28 through October 2, 2014, at Moscone Center in San Francisco. OPN Central will provide partners with actionable content for FY 2015, highlighting how partners can leverage new and existing OPN program benefits to maximize their partnerships with Oracle. The program kicks off Sunday, September 28, with a keynote discussion that includes Oracle executives from around the globe. The keynote will celebrate Oracle’s award-winning partners and discuss ways partners can fully utilize the extensive Oracle product portfolio to extend their reach in the market and deliver new value to customers. Following Sunday’s keynote conversation, Oracle’s product executives will host an exclusive product update session for partners to discuss key selling strategies, critical product roadmap information, and unique opportunities for partners to grow their businesses. Throughout the five-day event, attendees will also have the opportunity to experience more than 2,500 Oracle OpenWorld, JavaOne, and Oracle PartnerNetwork sessions, hands-on labs, tutorials, and birds-of-a-feather sessions, as well as 500 partner and customer exhibits. Partners are also invited to participate in the OPN Test Fest, taking place at the Westin St. Francis hotel, which will include 10 Specialist testing sessions and 140 free exams for OPN members. The OPN Lounge will be available to partners Monday through Wednesday in the Moscone South Exhibition Hall, offering OPN theater sessions, social media consultations, OPN information stations, and opportunities to network with colleagues, customers, prospects, and other industry professionals. OPN Central will also feature the global OPN AfterDark reception at the Metreon on Sunday, September 28, from 7 p.m. to 10 p.m. More than 500 partners will be exhibiting in Moscone West and South during the week. Product and industry-specific sessions will enable partners to showcase their expertise and OPN Specialized solutions based on Oracle technology in areas including big data, engineered systems, ERP, HCM, SCM, CX, MySQL, Oracle Linux, industries, and more. For more information or to register for the event, visit www.oracle.com/openworld/opn.Supporting Quote “OPN Central @ OpenWorld provides partners with a unique platform to discover new ways to optimize their relationship with Oracle,” said Rich Geraffo, senior vice president, Worldwide Alliances and Channels, Oracle. “We look forward to connecting with our valued partner community to network, learn, and provide them with the strategies they need to win with Oracle.”Supporting Resources Oracle PartnerNetwork (OPN) OPN Central @ OpenWorld Oracle OpenWorld 2014 Oracle PartnerNetwork Blog Connect with the Oracle Partner community at OPN on TwitterOPN on FacebookOPN on LinkedIn, and OPN on YouTube.

 

About Oracle OpenWorld

Oracle OpenWorld San Francisco is the most important business and technology conference of the year for Oracle customers, prospective customers, and partners. This educational conference is dedicated to helping businesses optimize existing systems and understand upcoming industry trends and breakthroughs driven by technology. Oracle OpenWorld offers more than 2,500 educational sessions, hundreds of demos and hands-on labs, and exhibitions from more than 400 partners and customers from around the world showcasing applications, middleware, database, server and storage systems, industries, management, cloud, and infrastructure solutions—all engineered for innovation. Oracle OpenWorld 2014 is being held September 28 through October 2 at the Moscone Center in San Francisco. For more information; to register; or to watch Oracle OpenWorld keynotes, sessions, and more, please visit www.oracle.com/openworld. Join the Oracle OpenWorld discussion on Twitter, Facebook, and the Oracle OpenWorld blog.

About Oracle PartnerNetwork

Oracle PartnerNetwork (OPN) Specialized is the latest version of Oracle’s partner program that provides partners with tools to better develop, sell, and implement Oracle solutions. OPN Specialized offers resources to train and support specialized knowledge of Oracle products and solutions and has evolved to recognize Oracle’s growing product portfolio, partner base, and business opportunity. Key to the latest enhancements to OPN is the ability for partners to differentiate through specializations. Specializations are achieved through competency development, business results, expertise, and proven success. To find out more visit www.oracle.com/partners.

About Oracle

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

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

Candice van der Laan
Oracle
+1.650.506.0814
candice.van.der.laan@oracle.com

Kristin Reeves
Blanc & Otus
+1.415.856.5145
kreeves@bando.com

Categories: Database, Vendor

Oracle Introduces New Cloud Solutions for Transportation and Global Trade Management

Oracle Database News - Mon, 09/15/2014 - 13:00
Oracle Introduces New Cloud Solutions for Transportation and Global Trade ManagementOracle Transportation Management Cloud and Oracle Global Trade Management Cloud offer modern best-in-class transportation, customs, and trade compliance management services REDWOOD SHORES, Calif. – September 15, 2014News Summary

Until now companies looking for best-in-class transportation management and global trade management solutions who preferred a cloud solution to manage their complex, dynamic logistics and trade operations have been faced with a difficult choice - compromise on capability to get cloud, or compromise on cloud to get capability. To eliminate this difficult decision, Oracle has released Oracle Transportation Management Cloud and Oracle Global Trade Management Cloud.

Now, Oracle’s industry-leading enterprise-class transportation and global trade management solutions are available in the cloud or via the more traditional on-premise model. The newly offered cloud option enables customers of all sizes to quickly deploy and benefit from these transformative applications. Available via Oracle Cloud, the new offerings deliver enterprise-class transportation and customs and trade compliance management services via a single, unified platform that ensures reliability, scalability, and security.

News Facts Further extending its commitment to providing innovation for today’s global supply chains, Oracle announced the availability of Oracle Transportation Management and Oracle Global Trade Management via Oracle Cloud. Oracle Transportation Management Cloud and Oracle Global Trade Management Cloud provide comprehensive solutions for transportation and global trade management functionality in a single, unified platform. As part of Oracle Cloud, the new solutions help customers of any size quickly and easily support business growth and market expansion by allowing reduced transportation costs, increased operational efficiency, improved customer service, decreased supply chain lead times, and mitigated supply chain and trade compliance risk. Oracle Transportation Management Cloud and Oracle Global Trade Management Cloud provide financial flexibility, predictable costs, and no up-front investment in hardware or software licenses, affording more companies access to the same capabilities that larger organizations have benefited from for years. By enabling reduced information technology and supply chain costs, the solutions can give customers a competitive advantage by enabling them to focus on innovation and new revenue channels. Rapidly deployable in a phased manner by Oracle Consulting or specialized partners in Oracle PartnerNetwork, Oracle Transportation Management and Oracle Global Trade Management on Oracle Cloud will enable customers to achieve rapid time to value. As part of the industry’s most complete enterprise-class cloud, customers and partners can also benefit from the latest product innovations and improvements via automated product and platform upgrades. Supporting Quote “Oracle Transportation Management and Oracle Global Trade Management have long demonstrated their ability to deliver strong ROI and enhanced customer experiences, and are recognized as industry-leading solutions," said Derek Gittoes, vice president, Value Chain Execution Product Strategy, Oracle. “With this announcement, companies can now leverage the advantages of cloud to achieve these same benefits without compromise, while also accelerating deployment timelines, reducing IT capital costs, and controlling their long-term cost of ownership. This announcement is further proof of Oracle’s strategic commitment to deliver a complete suite of industry-leading supply chain solutions on the cloud.”Supporting Resources Oracle Transportation Management Cloud Oracle Global Trade Management Cloud Data Sheet: Oracle Transportation Management Data Sheet: Oracle Global Trade Management Gartner Magic Quadrant for Transportation Management SystemsAbout Oracle

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

Trademarks

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

###

Karen Hartquist
Oracle
+1.650.506.3552
karen.hartquist@oracle.com

Simon Jones
Blanc & Otus
+1.415.856.5155
sjones@blancandotus.com

Categories: Database, Vendor

Integrating Big Data into the Enterprise Data Warehouse

Database Journal News - Mon, 09/15/2014 - 08:01

Big Data implementations are more than just lots of data. Of equal importance is the analytics software used to query the data. Analyzing business data using advanced analytics is common, especially in companies that already have an enterprise data warehouse. It is therefore only natural that your big data application must be integrated with the existing warehouse.

Categories: Database

LedgerSMB 1.4.0 Released

PostgreSQL News - Mon, 09/15/2014 - 01:00

15 September 2014, London. The LedgerSMB project - all-volunteer developers and contributors - today announced LedgerSMB 1.4.0.

Based on an open source code base first released in 1999, the LedgerSMB project was formed in 2006 and saw it's 1.0 release in the same year. It has now seen continuous development for over eight years and that shows no signs of slowing down.

"LedgerSMB 1.4 brings major improvements that many businesses need," said Chris Travers, who helped found the project. "Businesses which do manufacturing or retail, or need features like funds accounting will certainly get much more out of this new release."

Better Productivity

LedgerSMB 1.4 features a redesigned contact management framework that allows businesses to better keep track of customers, vendors, employers, sales leads, and more. Contacts can be stored and categorized, and leads can be converted into sales accounts.

Additionally, a new import module has been included that allows businesses to upload csv text files to import financial transactions and much more. No longer is data entry something that needs to be done entirely by hand or involves customizing the software.

Many smaller enhancements are here as well, For example, shipping labels can now be printed for invoices and orders, user management workflows have been improved,

Better Reporting

The reporting interfaces have been rewritten in LedgerSMB 1.4.0 in order to provide greater flexibility in both reporting and in sharing reports. Almost all reports now include a variety of formatting options including PDF and CSV formats. Reports can also be easily shared within an organization using stable hyperlinks to reports. Additionally the inclusion of a reporting engine means that it is now relatively simple to write third-party reports which offer all these features. Such reports can easily integrate with LedgerSMB or be accessed via a third party web page.

Additionally, the new reporting units system provides a great deal more flexibility in tracking money and resources as they travel through the system. Not only can one track by project or department, but funds accounting and other specialized reporting needs are possible to meet.

Better Integration

Integration of third-party line of business applications is also something which continues to improve. While all integration is possible, owing to the open nature of the code and db structure, it has become easier as more logic is moved to where it can be easily discovered by applications.

There are two major improvement areas in 1.4. First additional critical information, particularly regarding manufacturing and cost of goods sold tracking, has been moved into the database where it can be easily shared by other applications. This also allows for better testability and support. Secondly LedgerSMB now offers a framework for web services, which are currently available for contact management purposes, allowing integrators to more easily connect programs together.

Commercial Options

LedgerSMB isn't just an open source project. A number of commercial companies offer support, hosting, and customization services for this ERP. A list of some of the most prominent commercial companies involved can be found at http://ledgersmb.org/topic/commercial-support

Categories: Database, Open Source

Oracle Buys Front Porch Digital

Oracle Database News - Mon, 09/15/2014 - 01:00
Oracle Buys Front Porch DigitalAdds Leading Solution for Managing Massive Amounts of Rich Media Content to Oracle’s Comprehensive Storage Portfolio

REDWOOD SHORES, Calif. – September 14, 2014

News Facts Oracle today announced that it has signed an agreement to acquire Front Porch Digital, a provider of content storage management solutions that help companies migrate, manage and monetize large-scale media assets. Front Porch Digital’s big data technologies help enterprises easily handle their rapidly expanding and complex volumes of digital media content, such as high definition films and TV shows, medical images and records, and real-time security monitoring feeds. More than 550 organizations worldwide rely on Front Porch Digital across multiple industries to ensure the availability and accessibility of their valuable content, including A&E Television, BBC, Discovery Communications, U.S. Library of Congress and NASCAR. In total, Front Porch Digital helps manage over 750 petabytes of digital content. Together, Oracle and Front Porch Digital will help organizations more effectively and efficiently manage the growing complexities associated with the migration, integration, storage, and delivery of rich media content. More information on this announcement can be found at www.oracle.com/frontporchdigital.Supporting Quotes “Organizations need a modern, integrated content storage management solution to manage and monetize their valuable rich media assets,” said John Fowler, Executive Vice President of Oracle Systems. “We will continue to build on Front Porch Digital’s success and unique capabilities, which complement Oracle’s existing high performance and scalable engineered storage solutions.” “Front Porch Digital has developed industry leading solutions that help companies manage large-scale digital content,” said Mike Knaisch, CEO, Front Porch Digital. “We are thrilled to be joining Oracle to continue our long-standing partnership. This combination will enable us to better serve and support our customers at a global scale.”Supporting Resources About Oracle and Front Porch Digital General Presentation Customer and Partner Letter FAQAbout Oracle

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

TrademarksOracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.This document is for informational purposes only and may not be incorporated into a contract or agreement.Contact Info

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

Oracle is currently reviewing the existing Front Porch Digital 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 Front Porch Digital’s product roadmap are at the sole discretion of Oracle. All product roadmap information, whether communicated by Front Porch Digital or by Oracle, does not represent a commitment to deliver any material, code, or technology, 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 Front Porch Digital, including statements that involve risks and uncertainties concerning Oracle’s proposed acquisition of Front Porch Digital, 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 Front Porch Digital, 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 Front Porch Digital 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 Front Porch Digital. 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 Front Porch Digital is under any duty to update any of the information in this document.

Categories: Database, Vendor

New VM Images Optimized for Transactional and DW workloads in Azure VM Gallery

We are delighted to announce the release of new optimized SQL Server images in the Microsoft Azure Virtual Machines Gallery. These images are pre-configured with optimizations for transactional and Data Warehousing workloads respectively by baking in our performance best practices for running SQL in Azure VMs.

What preconfigured VM images are available?

The following four new pre-configured VM images are now available in the Azure VM Gallery:

  • SQL Server 2014 Enterprise Optimized for Transactional Workloads on Windows Server 2012 R2
  • SQL Server 2014 Enterprise Optimized for Data Warehousing on Windows Server 2012 R2
  • SQL Server 2012 SP2 Enterprise Optimized for Transactional Workloads on Windows Server 2012
  • SQL Server 2012 SP2 Enterprise Optimized for Data Warehousing on Windows Server 2012

Currently we support these images on VM instances that allow up to 16 data disks attached to provide the highest throughput (or aggregate bandwidth). Specifically, these instances are Standard Tier A4, A7, A8 and A9 and Basic tier A4. Please refer to Virtual Machine and Cloud Service Sizes for Azure for further details on the sizes and options.

How to provision a VM from the gallery using the new transactional/DW images?

To provision an optimized transactional or DW VM image by using the Azure Management Portal,

  1. Sign in to the Azure Management Portal.
  2. Click VIRTUAL MACHINE in the Azure menu items in the left pane.
  3. Click NEW in the bottom left corner, and then choose COMPUTE, VIRTUAL MACHINE, and FROM GALLERY.
  4. On the Virtual machine image selection page, select one of the SQL Server for transactional or Data Warehousing images.
  5. On the Virtual machine configuration page, in the SIZE option, choose from the supported sizes.

    Please note that only Standard tier A4, A7, A8 and A9 and Basic Tier A4 are supported at this point and attempts to provision unsupported VM sizes will fail.
  6. Wait for the provisioning to finish. While waiting, you can see the provisioning status on the virtual machines page (as in the picture below). When the provisioning is finished, the status will be Running with a checkmark.

Alternatively, you can use PowerShell Commandlet New-AzureQuickVM to create the VM. You will need to pass your cloud service name, VM name, image name, Admin user name and password and so on as parameters. A simple way is to obtain the image name is to use Get-AzureVMImage to list out all the available VM images.

What are the specific configurations included in the transactional/DW images?

The optimization we include in the optimized images are based on the Performance Best Practices for SQL Server in Azure Virtual Machines. Specifically, it includes:

 

 

Transactional

DW

Disk  configurations

Number of data disks attached

15

15

Storage spaces

 

Two storage pools:

-          1 data pool with 12 data disks; fixed size 12 TB; Column = 12

-          1 log pool with 3 data disks; fixed size 3 TB; Column = 3

One data disk remaining for the user to attach and determine the usage.

Stripe size = 64 KB

Stripe size = 256 KB

Disk sizes, caching, allocation size

1 TB each, HostCache=None, NTFS Allocation Unit Size = 64KB

SQL Configurations

 

Startup Parameters

-T1117 to help keep data files the same size in case DB needs to autogrow

-T1118 to assist in TEMPDB scalability (See here for more details)

Recovery Model

No change

Set to “SIMPLE” for MODEL database using ALTER DATABASE

Setup default locations

Move SQL Server error log and trace file directories to data disks

Default locations for databases

System databases moved to data disks.

The location for creating user databases changed to data disks.

Instant File Initialization

Enabled

Locked pages

Enabled (See here for more details)

 

FAQ
  • Any pricing difference between the optimized images and the non-optimized ones?
    No. The new optimized images follow exactly the same pricing model (details here) with no additional cost. Note that with larger VM instance sizes, higher cost is associated.
  • Any other performance fixes I should consider:
    Yes, consider applying relevant performance fixes for SQL Server
  • How can I find more information on Storage Spaces?
    For further details on Storage Spaces, please refer to Storage Spaces Frequently Asked Questions (FAQ).
  • What is the difference between the new DW image and the previous one?
    The previous DW image requires customers to perform additional steps such as attaching the data disks post VM creation while the new DW image is ready for use upon creation so it is more streamlined and less error prone.
  • What if I need to use the previous DW image? Is there any way I can access it?
    The previous VM images are still available, just not directly accessible from the gallery. Instead, you can continue using Powershell commandlets. For instance, you can use Get-AzureVMImage to list out all images and once you locate the previous DW image based on the description and publish date, you can use New-AzureVM to provision it accordingly.

Visit our Azure portal and give this new SQL VM image offering a try, and let us know what you think.

Let your colleagues know about the New VM Images available by sharing via your preferred social channels and don’t forget to follow @SQLServer on Twitter and find SQL Server on Facebook

Categories: Database

2014 winners: 24 Hours of PASS

Thank you to everyone who took the time to enter the contest #pass24hop Challenge!  As always, we had a great time listening to such passionate community speakers.

Congratulations to all the winners!  You will be notified via a Direct Message (DM) with details on how to redeem your free Microsoft Certification Exam.

So without further ado, the winners are……

Session #1

Taiob Alia @SQLTaiob correctly answered the question: “What did N.U.S.E stand for?” posed by Brent Ozar who conducted the “Who Needs a DBA??”

Webcast Link: http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7273

Session #2

John Fewer @johnfewer correctly answered the question: “What is the default buffer size for SSIS pipelines?” posed by Brian Knight who conducted the “Performance Tuning SQL Server Integration Services”.

Webcast Link: http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7292

Session #3

Yang Shuai @shuaiyang correctly answered the question: “If it was required, what is the type of witness for quorum that would be used if using standalone instances of SQL Server in an availability group?” posed by Allan Hirt who conducted the “Availability Groups vs Failover Cluster Instances: What’s the Difference?

Webcast Link: http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7275

Session #4

Mike Cornell @DataMic correctly answered the question: “In the UPDATE demo, what city does John Smith move to?” posed by Kalen Delaney who conducted the “In-Memory OLTP Internals: How is a 30x Performance Boost Possible?”

Webcast Link: http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7276

Session #5

John Ludvig Brattas @intolerance correctly answered the question: “How many relationships can you define between two tables in Tabular?” posed by Marco Russo who conducted the “Create your first SSAS Tabular Model”.

Webcast Link: http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7277

Session #6

Sergio Pacheco @Sergmis correctly answered the question: “Using XE, how can you determine the number of times a query was executed during a specific timeframe?” posed by Erin Stellato and Jonathan Kehayias who conducted the “Everything You Never Wanted to Know about Extended Events”.

Webcast Link: http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7278

Session #7

The listeners were stumped on the question: “Who are the complainer hotel guests from the demo? What show are they from?” posed by Hope Foley who conducted the “Spatial Data: Looking Outside the Map”.

Webcast Link: http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7295

Session #8

The listeners were stumped on the question: “Without stats, what will the row estimation be for an equality predicate?” posed by Gail Shaw who conducted the “Guessing Games: Statistics, Heuristics, and Row Estimations”.

Webcast Link: http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7279

Session #9

@fja correctly answered the question: “What is the name of the executable that ships with SQL Server that can be used to collect diagnostic information?” posed by Tim Chapman and Denzil Ribeiro who conducted the “Troubleshoot Customer Performance Problems Like a Microsoft Engineer”

Webcast Link: http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7293

Session #10

Andrea Allred @RoyalSQL correctly answered the question: “What technology should you think about when you get a requirement to encrypt data on the fly?” posed by Argenis Fernandez who conducted the “Secure Your SQL Server Instance without Changing Any Code”.

Webcast Link: http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7280

Session #11

Theresa Iserman @Theresalserman correctly answered the question: “What are the 4 C’s of Hiring?”  posed by Joe Webb who conducted the “Hiring the Right People: Interviewing and Selecting the Right Team”.

Webcast Link: http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7294

Session #12

Andy Pho @andycsuf correctly answered the question:  “Why does Chris (@SQLShaw) recommend database mirroring as his primary technology choice to upgrade SQL Server?” posed by Chris Shaw and John Morehouse who conducted the “Real World SQL 2014 Migration Path Decisions”.

Webcast Link: http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7291

Session #13

Stephen Radford @stephen_radford correctly answered the question: “What are the first two cmdlets you should learn, when learning PowerShell?” posed by Robert Cain, Bradley Ball and Jason Strate who conducted the " Zero to Hero with PowerShell and SQL Server”.

Webcast Link: http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7281

Session #14

Mark Holmes @SQLJuJu correctly answered the question: “Which Excel data mining add-in offers functionality for the entire data mining lifecycle?” posed by Peter Myers who conducted the “Past to Future: Self-service Forecasting with Microsoft BI”

Webcast Link: http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7283

Session #15

P K Towett @pthepebble correctly answered the question: “SQL Server 2014 adds one piece of functionality to statistics maintenance, what is it?” posed by Grant Fritchey who conducted the “Query Performance Tuning in SQL Server 2014”.

Webcast Link: http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7284

Session #16

Allen Smith @cognitivebi correctly answered the question: “What is your first mission when trying to determine if indexes help or hurt you?” posed by Jes Borland who conducted the “Are your Indexes Hurting you or Helping You?”

Webcast Link: http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7296

Session #17

Andre Ranieri @sqlinseattle correctly answered the question: “What behavior is sometimes called 'the king of irreplaceable behaviors'?” posed by Kevin Kline who conducted the “Techniques to Fireproof Your IT Career”.

Webcast Link: http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7285

Session #18

Ginger Grant @DesertisleSQL correctly answered the question: “In what part of a predictive analytics project to people typically spend 60-80% of their time?” posed by Carlos Bossy who conducted the “Predictive Analytics in the Enterprise”.

Webcast Link: http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7286

Session #19

The listeners were stumped on the question: correctly answered the question: “What WSMan feature do you need to set up on your client system to remote to Azure VMs?” posed by Allen White who conducted the “Manage Both On-Prem and Azure Databases with PowerShell?”

Webcast Link: http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7287

Session #20

@wBob_uk correctly answered the question: “What is the name of the base theme used in the Adventure Works Power View demo today?” posed by Julie Koesmarno who conducted the “I Want It NOW!" Data Visualization with Power View”.

Webcast Link: http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7290

Session #21

Conan Farrell @SQL_Dub correctly answered the question: “What is the "mantra" for engineering a DWH solution?” posed by Davide Mauri who conducted the “Agile Data Warehousing: Start to Finish”.

Webcast Link: http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7289

Session #22

Nicky @ ADA @NickyvV correctly answered the question: “Which DAX function lets you access columns in other tables?” posed by Alberto Ferrari who conducted the “DAX Formulas in action”.

Webcast Link: http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7274

Session #23

Regis Baccaro @regbac correctly answered the question: “What R package do you need to use to connect R and PowerBI?” posed by Jen Stirrup who conducted the “Business Intelligence Toolkit Overview: Microsoft Power BI & R”.

Webcast Link: http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7288

Session #24

Anil Maharjan @Anil_Maharjan correctly answered the question: “Can the SSRS databases be clustered?” posed by Ryan Adams who conducted the “SQL Server AlwaysOn Quickstart”.

Webcast Link: http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7282

 

This is just a taste of what you can expect from PASS Summit 2014. To ensure you have a seat, register today at PASS Summit 2014 registration page.  

Categories: Database

Oracle Bloom Filters

Database Journal News - Thu, 09/11/2014 - 08:01

In Oracle releases 10.2.0.x and later join processing can be made more efficient by the use of Bloom filters, primarily to reduce traffic between parallel query slaves. Read on to learn more.

Categories: Database

Azure SQL Database new service tiers now generally available

We are excited to announce that the new SQL Database service tiers, Basic, Standard, and Premium are now generally available. These service tiers raise the bar for what you can expect from a database-as-a-service with business-class functionality that is both built-in and seamless to use—allowing you to dramatically increase the number of databases managed under a single database administrator.

Today is an important milestone for the Azure SQL Database community. Since the first public introduction in 2009, our journey has been influenced by our direct and deep engagements with customers and partners.  Along the way we have increased the global scale and reach of the service, database size, and made it easier to run database diagnostics, to name a few. Your drive to push the boundaries on what is possible in the cloud brought us to a million databases. Your feedback on what you need from a relational database-as-a-service helped us reimagine an approach that aligns best with the unique needs of cloud-based database workloads.

In April, we introduced the Basic, Standard, and Premium tiers into preview. These tiers address the needs of today’s demanding cloud applications by providing predictable performance for your light- to heavy-weight transactional applications while also ensuring the performance of your apps are no longer affected by other customer workloads. Additionally, the new tiers provide you with the following new capabilities:

  • Higher uptime SLA, previously at 99.9%, uptime is now 99.99%--one of the highest in the database-as-a-service industry
  • Point-in-time-restore, with built-in backups and up to 35 days of data retention
  • Active geo-replication and standard geo-replication options for continuous data replication to geographically dispersed secondaries
  • Larger database sizes, previously at 150 GB, database max size is now up to 500 GB
  • Auditing for added security confidence (remains in preview)

Since the preview release in April, we listened to important feedback on the new tiers and as a result pre-announced changes to GA based on this direct dialogue. A summary of the key changes are:

  • New S0 performance level:  Within the Standard service tier, we have introduced an S0 performance level to ease the transition from Basic to Standard.
  • Premium and Standard price reductions:  Final pricing reflects up to 50% savings from previously-published GA pricing. GA pricing will take effect on November 1, 2014.
  • Hourly billing:  Starting today, Azure SQL Database will move to hourly billing in the new service tiers. 

I am incredibly excited about the value our ongoing investments will continue to deliver to you. Our customers Samsung, ESRI, Callaway Golf, and Pottermore, to name a few, are already using Azure SQL Database as a relational database service platform to help grow their cloud-based businesses. With an expanding portfolio of cloud services, including DocumentDB, Azure Search, Azure Machine Learning, and Azure HDInsight and complimentary data services from our partners, we’re committed to delivering a complete data platform that makes it easier for you to work with data of any type and size—using the tools, languages and frameworks you want in a trusted cloud environment. 

Try the new SQL Database service tiers today.

Categories: Database

Predict What's Next: How to Get Started with Machine Learning Part 2

Earlier this week we talked about getting up and running on Azure to start exploring the new machine learning service. From here, you can really start to dig in and try out the capabilities of a cloud ML and put predictive analytics into practice.

Below you’ll find several more video tutorials that help you learn your way around the service. Check them out, and let us know what predictions you uncover or big ideas you solve.

  1. Getting and Saving Data in Azure ML Studio: Data Access is the first step of data science workflow. Azure Machine Learning supports numerous ways to connect to your data. This video illustrates several methods of data ingress in Azure Machine Learning.


     
  2. Pre-processing data in Azure ML Studio: Data preprocessing is the next step in data science workflow and general data analysis projects.  This video illustrates the commonly used modules for cleaning and transforming data in Azure Machine Learning


     
  3. R in Azure ML Studio: Azure Machine Learning supports R. You can bring in your existing R codes in to Azure Machine Learning and run it in the same experiment with provided learners and publish this as web service via Azure Machine Learning. This video illustrates how to incorporate your R code in ML studio


     
  4. Predictive Modeling with Azure ML: Azure Machine Learning features a pallets of modules to build a predictive model, including state of the art ML algorithms such as Scalable boosted decision trees, Bayesian Recommendation systems, Deep Neural Networks and Decision Jungles developed at Microsoft Research. This video walks through steps to building, scoring and evaluating a predictive model in Azure Machine Learning


     
  5. Deploying a Predictive Model as a Service – Part 1: This video walks through creating a Web service graph for a predictive model and putting the predictive model into staging, using the Azure Machine Learning API service


     
  6. Deploying a Predictive Model as a Service – Part 2: Azure Machine Learning enables you to put staging service into production via the Azure Management portal.  This video walks through putting the predictive model staging service into production


     

As a reminder, there are a ton of resources you can use to continue your learning:

Categories: Database