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

Updating Production Environments to Feed a Big Data Application

Database Journal News - Tue, 01/17/2017 - 09:01

Your big data application needs regular extracts from your production systems. While many best practices exist for big data extract, transform and load (ETL) processes, we sometimes forget that these data-intensive procedures can affect the operational environment’s performance. Here are some suggestions to mitigate such performance risks.

Categories: Database

Panda Retail Company Deploys Oracle to Optimize Operations and Support Business Transformation

Oracle Database News - Mon, 01/16/2017 - 18:00
Press Release Panda Retail Company Deploys Oracle to Optimize Operations and Support Business Transformation Saudi Arabian Hypermarket, Supermarket and Convenience Store Chain Leverages Oracle Retail Solutions to Drive Performance

Redwood Shores, Calif.—Jan 16, 2017

Today, Oracle announced that Saudi Arabia’s largest supermarket retailer, The Panda Retail Company, has deployed the suite of Oracle Retail Merchandising, Oracle Retail Planning, Oracle Retail Supply Chain, and Oracle Retail Store Inventory Management to optimize core retail operations and underpin additional business diversity in line with its planned growth and customer centric strategy. The Panda Retail Company employs 25,000 people and operates more than 475 hypermarket, supermarket and convenience stores throughout Saudi Arabia, United Arab Emirates and Egypt.

The Oracle solutions will enable Panda to surface salient insights to critical performance indicators including sales, margin, inventory, and supplier activities, and will equip the business to make decisions that increase profitability and will enhance the customer experience. This empowered the organization to drive operations with one single version of the truth across all lines of business and to enable better decision making, including achieving the right balance between item availability and inventory position.

“To achieve our corporate goals, planned transformation initiatives and customer centric strategy, we needed the right systems, processes, and people in place. Oracle is uniquely qualified to support our current and future business strategy with retail rich end to end capabilities and best in class technology,” said Fawaz Kilfaden, Director of Information Technology at Panda Retail Company. “Ultimately, the goal of the program is to enrich the customer experience, improve performance and enhance our business governance across the enterprise.”

Panda adopted a flexible implementation strategy for its complete suite of solutions, including Oracle Retail Merchandise Operations Management, Oracle Retail Merchandise Financial Planning, Oracle Retail Demand Forecasting, Retail Merchandising Analytics and Oracle Retail Store Inventory Management.  The Oracle solutions replace legacy in-house and outdated vendor solutions that limited data access and lacked the roadmap to meet changing retail trends.  Panda wanted to put in place a system that would account for all of its retail and enterprise operations, and would afford greater flexibility for growth and innovation.

“We are pleased to continue to be part of Panda’s vibrant business and innovation, as the company expands its international presence. By leveraging the full suite of Oracle Retail, Panda is achieving the benefits of deep retail and global grocery expertise across their operations. We owe a debt of gratitude to our customers and partners who continue to inform our roadmap and vision,” said Ray Carlin, Senior Vice President and General Manager, Oracle Retail.

Oracle Retail at NRF 2017

Oracle Retail will be showcasing the full suite of Oracle Retail solutions and cloud services at the National Retail Federation Big Show Jan. 15-17, 2017, in New York City at the Jacob K. Javitz Convention Center. Oracle Retail will be located at booth #2521. For more information check out: www.oracle.com/nrf2017

  Contact Info Matt Torres
Oracle
4155951584
matt.torres@oracle.com About Oracle

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

Trademarks

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

Safe Harbor

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

Talk to a Press Contact

Matt Torres

  • 4155951584

Follow Oracle Corporate

Categories: Database, Vendor

Belk, Hot Topic and Torrid Choose Oracle Retail Stores Solutions to Unify Brand Experiences

Oracle Database News - Mon, 01/16/2017 - 12:42
Press Release Belk, Hot Topic and Torrid Choose Oracle Retail Stores Solutions to Unify Brand Experiences Department store retailers empower store associates with modern technology

Redwood Shores, Calif.—Jan 16, 2017

Oracle announced today that Belk, Hot Topic and Torrid have invested in Oracle Retail Xstore Point-of-Service to improve their in-store guest experiences. All three companies are owned by Sycamore Partners, a New York-based private equity firm whose portfolio generates more than $10 billion in annual sales.

Retailers compete on the basis of brand experience. The store is the nucleus of the human touch point. Consumers are embracing mobile devices and transformative in-store technologies that redefine their shopping experiences. Belk, Hot Topic and Torrid will leverage this same technology to empower associates and provide them with more information to better serve consumers.

With a modern and intuitive user interface, Oracle Retail easily delivers and demonstrates best practices in retailing as a platform for unified commerce and transparency.

“The success of all three companies is dependent on the commitment and dedication of our associates,” said Don Hendricks, executive vice president and chief operating officer, Belk. “The investment in Oracle Retail Xstore Point-of-Service empowers and inspires our associates to deliver a personalized shopping experience.”

“By using Oracle Retail solutions, these retailers empower associates to sell their products quickly, consistently and knowledgably from wherever they engage their customers,” said Mike Webster, senior vice president and general manager, Oracle Retail and Hospitality. “Oracle empowers commerce by investing in complimentary cloud services that provide retailers with a single view of customer and order starting at the point of sale.”

Oracle Retail at NRF 2017

Oracle Retail will be showcasing the full suite of Oracle Retail solutions and cloud services at the National Retail Federation Big Show Jan. 15-17, 2017, in New York City at the Jacob K. Javitz Convention Center. Oracle Retail will be located at booth #2521. For more information check out: www.oracle.com/nrf2017

Contact Info Matt Torres
Oracle
4155951584
matt.torres@oracle.com About Oracle

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

Trademarks

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

Safe Harbor

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

Talk to a Press Contact

Matt Torres

  • 4155951584

Follow Oracle Corporate

Categories: Database, Vendor

Ricardo Eletro Reduces Operational Cost by 40m Brazilian Reais per Month with Oracle Retail

Oracle Database News - Fri, 01/13/2017 - 18:00
Press Release Ricardo Eletro Reduces Operational Cost by 40m Brazilian Reais per Month with Oracle Retail Brazilian Consumer Electronics Retailer Streamlines Operations with Oracle Retail Merchandising and Fiscal Management Solutions

Redwood Shores, Calif.—Jan 13, 2017

Today Oracle announced that Ricardo Eletro, the third largest retailer of consumer electronics in Brazil, has deployed Oracle Retail Merchandise Operations Management and Oracle Retail Fiscal Management to enable converged commerce, empower associates and increase operational efficiency. Ricardo Eletro faced the challenge of integrating more than 900 stores and 12 distribution centers in the midst of company transformation. 

The partnership between Oracle Retail and Ricardo Electro began eight years ago. In January 2016, following several mergers and the costly support of disparate systems and varying IT infrastructure maturity levels, the decision was to unify Ricardo Eletro under one brand, and a unified Oracle IT infrastructure. This collaboration empowered the Ricardo Eletro commercial department to optimize the market structure to facilitate open to buy, centralize management, and streamline pricing, while enabling adherance to federal regulations. 

"We needed to establish a foundation for the new organization. We evaluated the systems and existing investment of all our companies. Oracle emerged as the clear choice to establish a foundation for growth for Ricardo Eletro," said Edson Tavares, CIO of Ricardo Eletro.

“The ‘Unification’ project transformed the company with a simplified infrastructure, a unified workforce and a better appreciation of customers while reducing operation costs by 40M Brazilian Reais per month,” Said Vinicius Hamzi, Planning and Management Vice president of Ricardo Eletro. “Our team empowered the holding and operations teams with a culture of transparency and efficiency. We launched a Zero-Based Budget (ZBB) and we adopted the best practices and retail rich functionality of Oracle Retail and Oracle E-Business Suite.”

Ricardo Eletro selected Oracle Retail implementation partner BRX Retail to support this project. BRX Retail provided local resources with product experience, local understanding of Brazilian tax regulation and the implementation knowledge to deliver and respond quickly.

“With the implementation of Oracle, Ricardo Eletro has proven that there is power in simplicity. Ricardo Electro can now anticipate the needs of the stores and the online channels to better serve the consumers with a simplified an inspiring experience,” said Ray Carlin, Senior Vice President and General Manager, Oracle Retail. “Oracle has dedicated resources to localize the requirements for the Brazil market. Oracle Retail is thrilled to partner with Ricardo Eletro to extend its foundation for growth.”

Oracle Retail at NRF 2017

Oracle Retail will be showcasing the full suite of Oracle Retail solutions and cloud services at the National Retail Federation Big Show Jan. 15-17, 2017, in New York City at the Jacob K. Javitz Convention Center. Oracle Retail will be located at booth #2521. For more information check out: www.oracle.com/nrf2017

Contact Info Matthew Torres
Oracle
+415.595.1584
matt.torres@oracle.com About Oracle

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

Trademarks

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

Safe Harbor

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

Talk to a Press Contact

Matthew Torres

  • +415.595.1584

Follow

Follow Oracle Corporate

Categories: Database, Vendor

Hamleys Deploys Oracle Retail Xstore Point-of-Service in 8 Months

Oracle Database News - Thu, 01/12/2017 - 14:00
Press Release Hamleys Deploys Oracle Retail Xstore Point-of-Service in 8 Months International Specialty Retailer Empowers Store Associates with In-Store Innovation

Redwood Shores, Calif.—Jan 12, 2017

Today Oracle announced leading International Toy Retailer Hamleys has deployed Oracle Retail Xstore Point-of-Service across its UK, Republic of Ireland and Finnish store estate. Hamleys is a respected international brand operating in 23 markets across EMEA, Asia and the Americas. Hamleys differentiates itself through its in-store experience for children and families with a product assortment that includes key brands as well as quality private/own brand products.

Hamleys partnered with MICROS prior to the acquisition by Oracle. Hamleys is one of the first customers to successfully and quickly transition from an older version of MICROS RJ to Oracle Retail Xstore Point-of-Service, a more global and strategic solution that supports the organization’s global needs.

“Oracle were identified as an opportunity for Hamleys to introduce a new epos solution which gives us many enhancements to improve customer offering whilst also offering improved trading terms as well as being compliant to the current version of PCI,” said David Oakley, Head of Information Technology, Hamleys. “Oracle delivered on time to support our critical Christmas trading season.”

Hamleys deployed the new Point-of-Service solution in less than 8 months on-time and within budget with Oracle Retail Consulting. The first store was live in six months followed by a rollout across the UK and Ireland. By late October, Hamleys was able to upgrade the 50 tills at the Regent Street London England flagship store location.

 “Oracle is dedicated to providing customers with a path to the latest and most appropriate version of mission-critical solutions like Point-of-Service. Our converged commerce solutions unify experiences, deliver common execution across touch points and provide consistent views of customer, order and inventory,” said Ray Carlin, Senior Vice President and General Manager, Oracle Retail. “We are empowering store associates to work the way they live, and use mobile devices to better participate in empowered commerce-retailing.”

Oracle Retail at NRF 2017

Oracle Retail will be showcasing the full suite of Oracle Retail solutions and cloud services at the National Retail Federation Big Show Jan. 15-17, 2017, in New York City at the Jacob K. Javitz Convention Center. Oracle Retail will be located at booth #2521. For more information check out: www.oracle.com/nrf2017

Contact Info Matthew Torres
Oracle
+415.595.1584
matt.torres@oracle.com About Oracle

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

Trademarks

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

Safe Harbor

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

Talk to a Press Contact

Matthew Torres

  • +415.595.1584

Follow

Follow Oracle Corporate

Categories: Database, Vendor

Oracle Cloud Applications Drive Carbon’s Quest to Lead in 3D Printing and Additive Manufacturing

Oracle Database News - Thu, 01/12/2017 - 14:00
Press Release Oracle Cloud Applications Drive Carbon’s Quest to Lead in 3D Printing and Additive Manufacturing Carbon to streamline business processes across organizational development, manufacturing, finance, and services

Redwood Shores, Calif.—Jan 12, 2017

Carbon (Carbon, Inc.), whose CLIP (Continuous Liquid Interface Production) technology allows commercial customers to 3D print manufacturing grade components, has selected Oracle Cloud Applications to modernize its systems, transform business processes, and help ensure a secure, scalable, and connected cloud suite for the next phase of the company’s growth. Oracle’s Cloud Applications will enable Carbon to maintain a competitive edge in the dynamic additive manufacturing market by helping to increase business agility, lower costs, and reduce IT complexity.

Working at the intersection of hardware, software, and molecular science to deliver on the promise of 3D printing, Carbon sought a cloud solution that could be configured to its business needs and could keep pace with its anticipated rapid growth both domestically and globally. Carbon selected Oracle Enterprise Resource Planning (ERP) Cloud, Oracle Human Capital Management (HCM) Cloud, Oracle Supply Chain Management (SCM) Cloud, and Oracle Service Cloud over SAP because of the strength of Oracle’s integrated breadth and depth of offerings, embedded analytics, and the modern, easy-to-use interface of its applications.

“As we evaluated our business needs, we knew we needed a future-proof cloud-based solution that could scale as we grow. Not only did we need a sales-ready product, but we also needed a sales-ready business organization,” said Chris Hutton, director of business operations at Carbon. “Oracle’s Cloud Applications help ensure our business processes are seamless so we can focus on delivering the best experience to every customer.”

Carbon’s deployment of Oracle’s comprehensive and modern suite of Cloud Applications will streamline business processes, and optimize collaboration and efficiencies in the following ways:

  • Oracle HCM Cloud will allow Carbon to leverage talent and workforce management offerings to provide an engaging and collaborative HR experience, and enhance how they find and retain quality employees
  • Oracle SCM Cloud will help transform supply chain operations to optimize cost, service levels, and the supply chain network
    • Oracle Manufacturing Cloud will streamline manufacturing processes through visualizations and real-time views into shop floor operations and work orders, while controlling costs
  • Oracle ERP Cloud will allow finance to spend more time on higher-value activities, such as analyzing results and advising the business on strategy
  • Oracle Service Cloud will help differentiate Carbon’s brand with intuitive, engaging experiences through the cloud for customers and employees alike

“Carbon has a vision to enable every member of their company to have a comprehensive 360-degree view of each customer. We are pleased to work with them to ensure our Cloud Applications deliver this visibility to support their ongoing success,” said Gretchen Alarcon, group vice president of product strategy at Oracle. “Oracle’s enterprise-grade Cloud Applications work together seamlessly to empower everyone from a relationship manager to Carbon’s CEO to see how all parts of the business are performing.”

Oracle delivers the industry’s broadest suite of enterprise-grade Cloud services, including Software as a Service (SaaS), Platform as a Service (PaaS), Infrastructure as a Service (IaaS), and Data as a Service (DaaS).

For additional information, visit Carbon, Oracle Cloud, and connect with Oracle Cloud on Facebook and Twitter.

Contact Info Joann Wardrip
Oracle
+1.650.607.1343
joann.wardrip@oracle.com About Carbon

Carbon is working at the intersection of hardware, software and molecular science to deliver on the promise of 3D printing, enabling creators to think beyond the limitations of convention to design the parts and products that will drive the businesses of the future. Carbon’s Continuous Liquid Interface Production technology (CLIP) was introduced simultaneously at TED 2015 and to the scientific community on the cover of Science Magazine (Science, March 2015). In April 2016, Carbon introduced the M1, its first commercial CLIP-based additive manufacturing machine, created as a comprehensive solution for the next era of design and manufacturing. To date Carbon has received $141 Million in funding. For more information please visit Carbon3D.com or follow Carbon on Twitter @Carbon.

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

Joann Wardrip

  • +1.650.607.1343

Follow

Follow Oracle Corporate

Categories: Database, Vendor

Oracle's pga_max_size and _pga_max_size Control Two Different Areas

Database Journal News - Thu, 01/12/2017 - 09:01

Oracle has two PGA size parameters that look the same but aren't.  Read on to see what areas each covers and why you can't get them confused.

Categories: Database

Mexican Retailer Almacenes García Deploys Best in Class Oracle Retail Planning Solutions

Oracle Database News - Wed, 01/11/2017 - 14:00
Press Release Mexican Retailer Almacenes García Deploys Best in Class Oracle Retail Planning Solutions Fast Fashion Retailer Increases Inventory Turnover and Localizes Assortment

Redwood Shores, Calif.—Jan 11, 2017

Today, Oracle announced that fashion retailer Almacenes García has deployed Oracle Retail Planning and Optimization solutions to support growth and transformation. Almacenes García is a 70-year-old retailer that has shifted from a traditional apparel retailer to a fast fashion retailer. Today Garcia serves insatiable fashion-oriented millennial shoppers.

The demands of fast fashion retailing required Almacenes García to consider finding a solution provider who can help facilitate new production introduction, assortment planning and lifecycle pricing. The fashion retailer selected Oracle Retail to replace an outdated planning solution, to reduce the total cost of ownership through automation, adopt best practices and create a unified technology infrastructure.

“Garcia drives loyalty and gains market share through a single price strategy, the right mix of private label brands, fast inventory turnover and a compelling assortment specific to store type. With the Oracle Retail implementation, we transformed disparate and disconnected functions into a centralized and streamlined process with a collaborative and holistic planning approach,” said Andrei Savtchenko, Director IT, Almacenes García.

Almacenes Garcia selected Retail Consult to deploy Oracle Merchandise Financial Planning, Oracle Retail Assortment Planning, Oracle Retail Clearance Optimization and Oracle Retail Item Planning to support over 150 store locations across Mexico in just under 16 months.

“The Oracle Retail solutions include a rich tapestry of retail best practices, process workflows and architecture recommendations called the Retail Reference Library. This library gives you the confidence to deploy a vanilla implementation, and rapidly realize benefits.” said Andrei Savtchenko, Director IT, Almacenes García.

“At Oracle Retail, we are honored to serve over 5,000 retailers around the world. The power of this community is reflected in the development of our solutions,” said Ray Carlin, Senior Vice President and General Manager, Oracle Retail. “As an early adopter of Oracle Retail Assortment Planning and Clearance Optimization, Almacenes García’s experience will help to enhance future releases and improve the solutions for future customers.”

Oracle Retail at NRF 2017

Oracle Retail will be showcasing the full suite of Oracle Retail solutions and cloud services at the National Retail Federation Big Show Jan. 15-17, 2017, in New York City at the Jacob K. Javitz Convention Center. Oracle Retail will be located at booth #2521. For more information check out: www.oracle.com/nrf2017

Contact Info Matthew Torres
Oracle
+415 595 1584
matt.torres@oracle.com About Oracle

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

Trademarks

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

Safe Harbor

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

Talk to a Press Contact

Matthew Torres

  • +415 595 1584

Follow

Follow Oracle Corporate

Categories: Database, Vendor

Announcing Columnstore Indexes and Query Store support in Database Engine Tuning Advisor

The latest version of Microsoft SQL Server Database Engine Tuning Advisor (DTA) supports two new features: (a) Ability to recommend columnstore indexes in addition to rowstore indexes, and (b) Ability to automatically select a workload to tune from the Query Store. These new features are available when tuning for SQL Server 2016 Database Engine (or later) versions.

Recommendations for columnstore indexes

Data warehousing and analytic workloads often need to scan large amounts of data, and can greatly benefit from columnstore indexes. In contrast, rowstore (B+-tree) indexes are most effective for queries that access relatively small amounts of data searching for a particular range of values. Since rowstore indexes can deliver rows in sorted order, they can also reduce the cost of sorting in query execution plans. Therefore, the choice of which rowstore and columnstore indexes to build for your database is dependent on your application’s workload.

The latest version of DTA can analyze the workload and recommend a suitable combination of rowstore and columnstore indexes to build on the tables referenced by the workload. This article highlights the performance improvements achieved on real customer workloads by using DTA to recommend a combination of rowstore and columnstore indexes.

Tune Database using Workload from SQL Server Query Store

The Query Store feature in SQL Server automatically captures a history of queries, plans, and runtime statistics, and persists this information along with a database. It stores query execution statistics summarized over time intervals so you can see database usage patterns and understand when query plan changes happened on the server. DTA now supports a new option to analyze the Query Store to automatically select an appropriate workload for tuning. For many DTA users, this can take away the burden of having to collect a suitable workload file using SQL Server Profiler. This feature is only available if the database has Query Store turned on.

Next Steps

Download the latest version of Database Engine Tuning Advisor
For additional documentation on these features see also:
Columnstore Index Recommendations in Database Engine Tuning Advisor (DTA)
Tuning Database Using Workload from Query Store
Performance Improvements using Database Engine Tuning Advisor (DTA) recommendations

Categories: Database

Sur La Table Selects Oracle Commerce Cloud to Complement Oracle Retail Xstore Point-of-Service

Oracle Database News - Tue, 01/10/2017 - 14:00
Press Release Sur La Table Selects Oracle Commerce Cloud to Complement Oracle Retail Xstore Point-of-Service Specialty Midmarket Retailer Connects Stores, Online, and Distribution Center Operations

Redwood Shores, Calif.—Jan 10, 2017

Today Oracle announced that Sur La Table has deployed Oracle Retail Xstore Point-of Service and has selected Oracle Commerce Cloud to deliver a converged commerce experience across all channels. Catering to the growing number of consumers visiting its commerce site and more than 130 stores nationwide, Sur La Table is creating a cohesive shopping experience, personalizing offers and streamlining order fulfillment. A popular destination for exclusive and premium-quality goods for the kitchen and table, Sur La Table is a place where cooks find a surprising selection of culinary tools and foods from around the world, with helpful, knowledgeable employees.

“We are empowering our associates in the stores to improve the customer experience with the Oracle Retail Xstore Point-of-Service solution. We selected Oracle Commerce Cloud to deliver a consistent brand experience across channels,” said Tracy Cioffi, Senior Vice President of Marketing, Sur La Table.  

Sur La Table continues to transform its IT infrastructure by using Oracle to compliment or replace customized legacy applications that hindered growth and were costly to maintain. Before transitioning to Oracle, Sur La Table evaluated the savings against ongoing cost of maintaining its legacy systems.

“Oracle is providing the retail industry’s leading, most comprehensive enterprise solutions to retailers of all sizes,” said Ray Carlin, Senior Vice President and General Manager, Oracle Retail. “We are pleased to partner with Sur La Table and will continue to deliver innovation backed by world class technology.”

Oracle Retail at NRF 2017

Oracle Retail will be showcasing the full suite of Oracle Retail solutions and cloud services at the National Retail Federation Big Show Jan. 15-17, 2017, in New York City at the Jacob K. Javitz Convention Center. Oracle Retail will be located at booth #2521. For more information check out: www.oracle.com/nrf2017

Contact Info Matthew Torres
Oracle
+415 595 1584
matt.torres@oracle.com About Oracle

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

Trademarks

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

Safe Harbor

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

Talk to a Press Contact

Matthew Torres

  • +415 595 1584

Follow

Follow Oracle Corporate

Categories: Database, Vendor

Oracle Retail Suite 16 Introduces New Cloud Services to Maximize Retail Profit and Productivity

Oracle Database News - Mon, 01/09/2017 - 14:00
Press Release Oracle Retail Suite 16 Introduces New Cloud Services to Maximize Retail Profit and Productivity Platform Upgrades Bring Extensive New Services to the Cloud and Mobile POS

Redwood Shores, Calif.—Jan 9, 2017

Oracle announced today the availability of Oracle Retail Release 16, which empowers retailers to deliver unified consumer experiences across ecommerce and brick and mortar locations. The new release reflects insights of our global customer community regarding shared business challenges and more than 100,000 development days invested via Oracle’s renowned research and development team, culminating in the retail industry’s most advanced and mobile-enabled cloud services and on-premise solutions.

“As retailers invest in new markets and offerings for 2017, having the right infrastructure, optimization science and mobile solutions will become a critical competitive advantage,” said Ray Carlin, senior vice president and general manager of Oracle Retail. “Oracle’s Cloud First strategy enables us to deliver a steady cadence of innovation to our global retail customers, and we are taking the industry’s leading retail science and best practices to a new level with Oracle Retail Release 16.”

Expanding Cloud Services for Retailers

Oracle Retail recognizes the industry is in a period of migration to cloud technologies and has put in place a strategy that will support cloud and on-premise solutions, empowering customers to migrate to the cloud at a pace that meets their strategic needs.

“Access to retail-specific cloud services is a critical differentiator for brands to streamline operations, expand offerings and scale at a fast pace,” said Ray Carlin, senior vice president and general manager of Oracle Retail. “With Oracle Retail Release 16, brands of all sizes can access best-in-class industry solutions through our world-class cloud services.”

  • On-Premise to Cloud: Oracle extends its industry-leading Oracle Retail Planning and Optimization technology to the cloud and enables retailers to reduce implementation costs with the Oracle Retail Planning Enterprise Cloud Service platform.  The shift to next generation cloud-based planning capabilities allows retailers to plan by exception and scale when needed by paying for capacity used.
  • The Power of the Cloud: Oracle now offers over 33 Oracle Retail cloud services including its industry leading merchandising solution with documented best practices and automation of key process at a lower cost.

Making Critical Merchandising Operations Mobile

“We optimized Oracle Retail Suite 16 for a mobile environment recognizing that old and new generations want to use consistent technology at home and at work,” said Jeff Warren, vice president product strategy at Oracle Retail. “Our platform is engineered to accelerate critical decision making through a powerful interface for managers and analysts that is built upon machine learning and data analytics.”

  • Reduce Labor Cost: Oracle Retail Release 16 accelerates user productivity by leveraging persona-based dashboards at the core of the solution and highlighting opportunities that will impact service levels, inventory margins and key business metrics. These new persona-based dashboards empower users to be more efficient by surfacing key actions and metrics that are relevant to the user, driving increased productivity and ultimately empowering them.
  • Modern Exception Based Retailing: The new modern, user experience and mobile applications across Oracle Retail Merchandising Release 16 place business intelligence and analytics at the front of every process to enable collaboration & empower associates with context to make better & faster decisions.  With this release, Oracle Retail Merchandising is expanded to support Android and Apple devices which increase managerial productivity through exception-based reporting and transaction approvals. These additions extend existing buying, allocating, inventory management, sales auditing and invoice-matching capabilities to mobile devices.

Giving Store Associates a Fully Informed Mobile Solution

Oracle Retail is also bridging the productivity gaps between online and traditional point of sale functionality, through mobile experiences that inspire store associates to engage consumers away from the register.

  • Converged Commerce: Also now available, the Oracle Retail Extension Module for Oracle Commerce allows retailers to deliver a common brand experience across all touch points by using Oracle Cloud Services to manage orders, optimize fulfillment decisions, and give everyone the same single view of customers across your enterprise. Oracle’s Xstore POS also enables retailers to help customers pick up, complete, or change purchases from any location by integrating with Oracle Retail Customer Engagement Software, Oracle Retail Order Broker and Oracle Retail Order Management System.
  • Better Together: The mobile Oracle Retail Xstore Point of Service is also optimized to provide traditional web functionality like in-depth product details, ratings and reviews, and task management so associates are able to engage consumers away from the register with deep insights operating on the Oracle MICROS Family Workstation.
  • Mobility Everywhere: With this release, Oracle Retail Xstore now offers four different ways for store employees to engage – using a traditional fixed device, dockable tablets, tablets, and mobile.  All use the same POS platform and provide full check out, CRM visibility, cross- and up-sell functionality, fulfillment, search, price check and loyalty program integration from any device.

Oracle Retail at NRF 2017

Oracle Retail will be showcasing the full suite of Oracle Retail solutions and cloud services at the National Retail Federation Big Show Jan. 15-17, 2017, in New York City at the Jacob K. Javitz Convention Center. Oracle Retail will be located at booth #2521. For more information check out: www.oracle.com/nrf2017

Contact Info Matthew Torres
Oracle
+415 595 1584
matt.torres@oracle.com About Oracle

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

Trademarks

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

Safe Harbor

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

Talk to a Press Contact

Matthew Torres

  • +415 595 1584

Follow

Follow Oracle Corporate

Categories: Database, Vendor

Applying MySQL’s GROUP_CONCAT Function to Multiple Columns

Database Journal News - Mon, 01/09/2017 - 09:01

Rob Gravelle delves into the full syntax of the MySQL GROUP_CONCAT function and provides some guidance on how to use the GROUP_CONCAT function to chain together data from multiple columns in a way that’s both easy to read and parse with a script or application.

Categories: Database

Red Wing Shoe Company Deploys Oracle to Fuel Growth Among Diverse Consumer and Industrial Markets

Oracle Database News - Fri, 01/06/2017 - 17:00
Press Release Red Wing Shoe Company Deploys Oracle to Fuel Growth Among Diverse Consumer and Industrial Markets Growing Retailer Delivers Leading Work Boots and Popular Styles via 170+ Mobile Truck-Based Stores and 450+ Traditional Stores

Redwood Shores, Calif.—Jan 6, 2017

Today Oracle announced that Red Wing Shoe Company, a made in America brand selling to customers worldwide, has implemented Oracle Retail Xstore Point-of-Service to support its rapid growth among new and traditional customer markets.  Red Wing Shoes, which continues to launch new product lines and expand to new markets worldwide, plans to increase its store count over a five-year period by 25% - 30%.

Red Wing Shoes’ styles appeal to diverse consumer groups – from construction workers to hipsters – and getting the experience right for each buyer persona requires thoughtful execution of brand interactions.  The Oracle Retail solution enables Red Wing Shoes’ to empower store associates and elevate customer service by allowing store associates to work via mobile, tablet and stationary workstation devices.

“Oracle ensures our customer experience and retail operations are world class, and scales with us as fast as we are growing,” said Marc Kermisch, VP and CIO at Red Wing Shoes.  “The Oracle Retail Xstore solution delivers rich functionality that reflects Oracle’s deep retail focus; it works across mobile platforms in a manner that is intuitive to our employees.”

Among commercial customers, Red Wing Shoes has long been ahead of its peers in extending access and customer service beyond traditional brick-and-mortar stores.  The company’s fleet of 170+ trucks provides easier access to the right footwear by bringing fully stocked stores to work sites, where employees get help with sizing and order items for delivery at home or work.  Today, the Red Wing Shoe Company trucks are equipped with Oracle Retail Xstore to ensure accurate inventory planning and to provide immediate access to sizes and models and order fulfillment when customers at commercial sites need items shipped.

Red Wing Shoes chose Oracle Retail Xstore to replace a home-grown, highly customized point-of-sale solution that simply could not scale to meet evolving business requirements. Red Wing Shoes selected BTM Global to implement the Oracle solution.

“Oracle empowers retailers to deliver a flexible, rich customer experience and to optimize retail operations serving markets from multiple store formats including mobile stores,” said Ray Carlin, Senior Vice President and General Manager, Oracle Retail. “We are honored to be part of the success story at Red Wing Shoe Company, and we look forward to the company’s growth as they bring their unique brand to more consumers worldwide.”

Oracle Retail at NRF 2017

Oracle Retail will be showcasing the full suite of Oracle Retail solutions and cloud services at the National Retail Federation Big Show Jan. 15-17, 2017, in New York City at the Jacob K. Javitz Convention Center. Oracle Retail will be located at booth #2521. For more information check out: www.oracle.com/nrf2017

Contact Info Matthew Torres
Oracle
+415 595 1584
matt.torres@oracle.com About Oracle

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

Trademarks

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

Safe Harbor

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

Talk to a Press Contact

Matthew Torres

  • +415 595 1584

Follow

Follow Oracle Corporate

Categories: Database, Vendor

Announcing The Release Of repmgr 3.3

PostgreSQL News - Fri, 01/06/2017 - 01:00

Oxford, United Kingdom - January 6, 2017

2ndQuadrant is proud to announce the release of repmgr version 3.3, the popular tool for PostgreSQL failover since 2010.

repmgr 3.3 provides a number of usability improvements for the repmgr command line utility, particularly for the ‘standby clone’ and ‘standby register’ commands. These changes are primarily aimed at making repmgr easier to use when provisioning complex replication clusters.

repmgrd users should take note of the changes to repmgr logging behaviour.

From repmgr 3.3, support for the upcoming PostgreSQL 10 release will be provided as far as possible. PostgreSQL 10 is still under development with significant changes expected to the implementation of replication functionality; anyone wishing to test repmgr with PostgreSQL 10 should build from the repmgr master branch. Links

repmgr is an open source package that helps DBAs and System Administrators manage a cluster of PostgreSQL databases. By taking advantage of the Hot Standby capability introduced in PostgreSQL 9, repmgr greatly simplifies the process of setting up and managing databases with high availability and scalability requirements.

repmgr is distributed under GPL v3 and maintained by 2ndQuadrant.

Categories: Database, Open Source

How six lines of code + SQL Server can bring Deep Learning to ANY App

Deep SQL Server

The link to the source code is here.

The What Part

Deep Learning is a hot buzzword of today. The recent results and applications are incredibly promising, spanning areas such as speech recognition, language understanding and computer vision. Indeed, Deep Learning is now changing the very customer experience around many of Microsoft’s products, including HoloLens, Skype, Cortana, Office 365, Bing and more. Deep Learning is also a core part of Microsoft’s development platform offerings with an extensive toolset that includes: the Microsoft Cognitive Toolkit, the Cortana Intelligence Suite, Microsoft Cognitive Services APIs, Azure Machine Learning, the Bot Framework, and the Azure Bot Service. Our Deep Learning based language translation in Skype was recently named one of the 7 greatest software innovations of the year by Popular Science, and this technology has now helped machines achieve human-level parity in conversational speech recognition. To learn more about our Deep Learning journey, I encourage you to read a recent blog From “A PC on every desktop” to “Deep Learning in every software”.

The applications of Deep Learning technology are truly so far reaching that the new mantra, of Deep Learning in Every Software, may well become a reality within this decade. The venerable SQL Server DBMS is no exception. Can SQL Server do Deep Learning? The response to this is enthusiastic “yes!” With the public preview of the next release of SQL Server, we’ve added significant improvements into R Services inside SQL Server including a very powerful set of machine learning functions that are used by our own product teams across Microsoft. This brings new machine learning and deep neural network functionality with increased speed, performance and scale to database applications built on SQL Server. We have just recently showcased SQL Server running more than one million R predictions per second, using SQL Server as a Machine Learning Model Management System and I encourage you all to try out R examples and machine learning templates for SQL Server on GitHub.

In this blog, I wanted to address the finer points of the matter – the what, the why and the how part of Deep Learning in SQL Server. With this new clarity, it will be easier to see a picture of the road forward for data-driven machine intelligence using such a powerful data platform like SQL Server.

The Why Part

Today, every company is a data company, and every app is a data app.

When you put intelligence (AI, ML, AA, etc.)  close to where the data lives, then every app becomes an intelligent app. SQL Server can help developers and customers everywhere realize the holy grail of deep learning in their applications with just a few lines of code.  It enables It enables data developers to deploy mission critical operational systems that embed deep learning models. So here are the 10 whys for deep learning in SQL Server.

The 10 Whys of Deep Learning inside SQL Server

  1. By pushing intelligence close to where your data lives (i.e., SQL Server), you get security, compliance, privacy, encryption, master data services, availability groups, advanced BI, in-memory, virtualization, geo-spatial, temporal, graph capabilities and other world-class features.
  2. You can do both near “real-time intelligence” or “batch intelligence” (similar in spirit to OLTP and OLAP, but applied to Deep Learning and intelligence).
  3. Your apps built on top of SQL Server don’t need to change to take advantage of Deep Learning, and a multitude of apps (web, mobile, IoT) can share the same deep learning models without duplicating code.
  4. You can exploit a number of functionalities that come in machine learning libraries (e.g., MicrosoftML) that will drive the productivity of your data scientists, developers and DBAs and business overall. This might be faster and far more efficient than doing it in the house.
  5. You can develop predictable solutions that can evolve/scale up as you need. With the latest service pack of SQL Server, many features that were only available in the Enterprise Edition are now available in the Standard/Express/Web Edition of SQL Server. That means you can do Deep Learning using a standard SQL Server without high costs.
  6. You can use heterogeneous external data sources (via Polybase) for training and inference of deep models.
  7. You can create versatile data simulations and what-if scenarios inside SQL Server and then train a variety of rich Deep Learning models in those simulated worlds to enable intelligence even with a limited training data.
  8. You can operationalize Deep Learning models in a very easy and fast way using stored procedures and triggers.
  9. You get all the tools, monitoring, debugging and ecosystem around SQL Server applicable to intelligence. SQL Server can literally become your Machine Learning Management System and handle the entire life cycle of DNN models along with data.
  10. You can generate new knowledge and insights on the data you are storing already and anyways without having any impact on your transactional workload (via HTAP pattern).

Let’s be honest, nobody buys a DBMS for the sake of DBMS. People buy it for what it enables you to do. By putting deep learning capabilities inside SQL Server, we can scale artificial intelligence and machine learning both in traditional sense (scale of data, throughput, latency), but we also scale it in terms of productivity (low barrier to adoption and lower learning curve). The value that it brings results in so many shapes and forms – time, better experience, productivity, lower $ cost, higher $ revenue, opportunity, higher business aspirations, thought-leadership in an industry, etc.

Real-life applications of Deep Learning running inside SQL Server span banking, healthcare, finance, manufacturing, retail, e-commerce and IoT. With applications like fraud detection, disease prediction, power consumption prediction, personal analytics, you have the ability to transform existing industries and apps. That also means whatever workloads you are running using SQL Server, be it CRM, ERP, DW, OLTP, BD… you can add Deep Learning to them almost seamlessly.  Furthermore, it’s not just about doing deep learning standalone, but it’s rather about combining it with all kinds of data and analytics that SQL Server is so great at (e.g., processing structured data, JSON data, geo-spatial data, graph data, external data, temporal data). All that is really left to be added to this mix is… your creativity.

SQL Server and Deep Learning

The How Part

Here is a great scenario to show all of this in reality. I am going to use an example of predicting galaxy classes from image data – using the power of Microsoft R and its new MicrosoftML package for machine learning (which has been built by our Algorithms and Data Science team). And I am going to do all this in SQL Server with R Services on a readily available Azure NC VM. I am going to classify the images of galaxies and other celestial objects into 13 different classes based on the taxonomy created by astronomers – mainly elliptical and spirals and then various sub-categories within them. The shape and other visual features of galaxies change as they evolve. Studying the shapes of galaxies and classifying them appropriately helps scientists learn how the universe is evolving. It is very easy for us humans to look at these images and put them in the right buckets based on the visual features. But in order to scale it to the 2 trillion known galaxies I need help from machine learning and techniques like deep neural networks – so that is exactly what I am going to use. It’s not a big leap to imagine that instead of astronomy data, we have healthcare data or financial data or IoT data and we are trying to make predictions on that data.

An app

Imagine a simple web app that loads images from a folder and then classifies them into different categories – spiral or elliptical and then sub-types with those categories (e.g., is it a regular spiral or does it have a handlebar structure in the center).

Use Deep Neural Nets

The classification can be done incredibly fast on vast amounts of images. Here is an example output:

Classifier
The first two columns are the elliptical types and the others are of different spiral types.

So how does this simple app do this amazingly complex computation?

The code for such an app actually isn’t doing much – it just writes the paths to the new files to classify into a database table (the rest of the app code is plumbing and page layout, etc).

SqlCommand Cmd = new SqlCommand("INSERT INTO [dbo].[GalaxiesToScore] ([path] ,[PredictedLabel]) "

 

CodeDemo
What is happening in the database? Prediction and operationalization part:

Let’s look at the table where the app writes the image paths. It contains a column with paths to the galaxy images, and a column to store the predicted classes of galaxies. As soon as a new row of data gets entered into this table, a trigger gets executed.

Image Path Table 1

 

The trigger in turn invokes a stored procedure – PredictGalaxiesNN as shown below (with R script portion embedded inside the stored proc):

Image Path Table 2

This is where the magic happens – in these few lines of R code. This R script takes two inputs – the new rows of data (that have not been scored yet) and the model that is stored in a table as varbinary(max). I will talk about how the model got there in a minute. Inside the script, the model gets de-serialized and is used by the familiar scoring function (rxPredict) in this line:

scores <- rxPredict(modelObject = model_un, data = InputDataSet,  extraVarsToWrite="path")

to score the new rows and then write the scored output out. This is a new variant of rxPredict which understands the ML algorithms included in the new Microsoft ML package. This line

 [ library("MicrosoftML") ]

loads the new package that contains the new ML algorithms. In addition to DNN (the focus of this blog), there are five other powerful ML algorithms in this package – fast linear learner, fast tree, fast forest, one class SVM for anomaly detection, regularized logistic regression (with L1 and L2) and neural nets. So, with just 6-7 lines of R code, you can enable any app to get the intelligence from a DNN based model. All that the apps needs to do is connect to SQL Server. By the way, you can now very easily generate a stored procedure for R Code using the sqlrutils package.

What about training the model?

Where was the model trained? Well, the model was trained in SQL Server as well. However, it does not have to be trained on SQL Server – it could have been trained on a separate machine with a standalone R Server running on it, on-prem or on the cloud. Today we have these new ML algorithms on Windows version of R Server, and the support for other platforms is coming soon. I just chose to do the training in the SQL server box here, but I could have done it outside as well. Let’s look at the stored proc with the training code.

Training code:

The model training is done in these lines of code.

Training Code

This new function – rxNeuralNet from the MicrosoftML package for training a DNN. The code looks similar to other R and rx functions – there is a formula, an input dataset, and some other parameters. One of the parameters here is this line “netDefinition = netDefinition”. This is where the neural network is being defined.

Network definition:

Here is the DNN definition in this portion of the code:

DNN Definition

Here, a deep neural net is defined using Net# specification language that was created for this purpose. It has 1 input, 1 output and 8 hidden layers. It starts with an input layer of 50×50 pixels and 3 colors (RGB) image data. First hidden layer is a convolution layer where we specify the kernel (small sub-part of the image) size and how many times we want the kernel to map to other kernels (convolute). There are some other layers for more convolutions, and for normalization and pooling that help stabilize the network. And finally, the output layer that maps it to one of the 13 classes. In about 50 lines of Net# specification, I have defined a complex neural network. Net# is documented on MSDN.

Training data size/GPU:

Here is the R code to do the training.

R code

Some other lines to note here are – ‘training_rows = 238000’. This model was trained on 238K images that we got from Sloan Digital Sky Survey dataset. We then created two variants of each image with 45% and 90% rotations. In all there was about 700K images to train on. That’s a lot of image data to train on – so, how long did it take to train it? Well, we were able to train this model in under 4 hours. This is a decent sized machine – 6 cores and 56GB or RAM, but then it also has a powerful Nvidia Tesla K80 GPU. In fact, it is an Azure VM – the new NC series GPU VM, readily available to anyone with an Azure subscription. We were able to leverage the GPU computation by specifying one simple parameter: acceleration = “gpu”. Without GPU, the training takes roughly 10X more time.

The What Are You Waiting For Part

So with just a few lines of R code using algorithms from the MicrosoftML package, I was able to train a DNN on tons of image data and operationalize the trained model in SQL using R services such that any app connected to SQL can get this type of Intelligence easily. That’s the power of Microsoft R and the Microsoft ML package in it combined with SQL Server. This is just the beginning, and we are working on adding more algorithms on our quest to democratize the power of AI and machine learning.  You can download the MicrosoftML: Algorithm Cheat Sheet here to help you choose the right machine learning algorithm for a predictive analytics model.

MicrosoftML Alogorithm Cheat Sheet

Don’t wait, go ahead and give it a try.

@rimmanehme

Categories: Database

Introduction to SAP HANA on Azure

Database Journal News - Thu, 01/05/2017 - 09:01

Microsoft and SAP share a long history of working together on a variety of interoperability solutions, including SAP Fiori and Office 365. In recent years, this trend has been exemplified by advancements in support for SAP-based solutions on Microsoft Azure. Marcin Policht provides an overview, focusing in particular on support for SAP HANA on Azure.

Categories: Database

IBM Datacap 9.0.1 and 9.1.0 FlexID Panel

IBM - DB2 and Informix Articles - Thu, 01/05/2017 - 06:00
The FlexID panel is included with IBM Datacap and allows manual identification of documents. While the panel provided with the install is generic and allows use with any application, the panel source is provided here to allow user-specific customization of the panel.
Categories: Database

Barman v2.1 Announced

PostgreSQL News - Thu, 01/05/2017 - 01:00

2ndQuadrant announces the release of Barman version 2.1, a Backup and Recovery Manager for PostgreSQL.

This minor release fixes a few bugs. It also introduces the --archive option to the switch-xlog command, in order to help users during the installation process of a new server.

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

Links Release notes
  • Add --archive and --archive-timeout options to switch-xlog command
  • Preliminary support for PostgreSQL 10 (#73)
  • Minor additions:
    • Add last archived WAL info to 'diagnose' output
    • Add start time and execution time to the output of 'delete' command
  • Minor bug fixes:
    • Return failure for 'get-wal' command on inactive server
    • Make 'streaming_archiver_names' and 'streaming_backup_name' options global (#57)
    • Fix rsync failures due to files truncated during transfer (#64)
    • Correctly handle compressed history files (#66)
    • Avoid de-referencing symlinks in 'pg_tblspc' when preparing recovery (#55)
    • Fix comparison of last archiving failure (#40, #58)
    • Avoid failing recovery if postgresql.conf is not writable (#68)
    • Fix output of 'replication-status' command (#56)
    • Exclude files from backups like pg_basebackup (#65, #72)
    • Exclude directories from other Postgres versions while copying tablespaces (#74)
Download About

Barman (Backup and Recovery Manager) is an open-source administration tool for disaster recovery of PostgreSQL servers written in Python. It allows your organisation to perform remote backups of multiple servers in business critical environments to reduce risk and help DBAs during the recovery phase.

Barman is distributed under GNU GPL 3 and maintained by 2ndQuadrant.

Categories: Database, Open Source

Welcome 2017! Recap of top SQL Server posts of 2016

We start off the new year with a quick recap of our most popular posts on this blog channel from the year just concluded.

Here are the posts that got the most number of views from our readers during 2016, in increasing order of readership:

10. SQL Server 2016 Express Edition in Windows containers

In October, we announced the public availability of SQL Server 2016 Express Edition in Windows Containers, a capability that comes in especially handy when you need to quickly create SQL Server instances for development or testing; or to maximize density in a test or production environment (especially in microservice architectures); or when you need to isolate and control apps in a multi-tenant infrastructure.

9. SQL Server 2016 Service Pack 1 generally available

A couple of months back, we made several new capabilities available as part of the SP1 release of SQL Server 2016. Developers can now build to a common programming surface across all editions – and do tons more, see the graphic below or read the full article for more.

SQL Server 2016 Service Pack 1

8. WideWorldImporters: The new SQL Server sample database

We figured a major release of the magnitude of SQL Server 2016 deserved its own new sample database. Besides, it was time for an upgrade of the erstwhile AdventureWorks database, which had a good run for over a decade. The new Wide World Importers sample illustrates how the rich feature set of SQL Server can be used in a real world setting. While it doesn’t attempt to use every single feature (as that would be unrealistic!) it does showcase a variety of key SQL Server 2016 capabilities and performance enhancements.

7. Preview the newest ODBC SQL Server Driver for Windows and Linux

Early last year, we announced our community technology preview of Microsoft ODBC Driver 13 for SQL Server on Windows and Linux, supporting Ubuntu, RedHat and SUSE distributions, providing robust data access to Microsoft SQL Server and Microsoft Azure SQL Database via ODBC on Windows and Linux platforms.

6. Microsoft announces major commitment to Apache Spark

Back in June last year, we announced an extensive commitment for Spark to power Microsoft’s big data and analytics offerings, including Cortana Intelligence, Power BI, and Microsoft R Server.

Spark

5. JSON in SQL Server 2016: Part 1 of 4

JSON is one of the most widely used data exchange formats, with most modern services returning information as JSON text, and web browsers using information formatted as JSON. JSON is the common format when semi-structured information needs to be stored, such as in files. Because so much data is formatted as JSON, it’s critical for SQL Server to process JSON text retrieved from other systems, and to format information retrieved from SQL Server tables as JSON text. This was the first post in a 4-part series; use the links that follow to read Part 2, Part 3 and Part 4 of the series.

4. SQL Server on Linux: How? Introduction

Many of you in the community expressed your curiosity about how we made SQL Server run on Linux, so – just before the holidays – we kicked off a blog series last month to share technical details about this very topic, starting with an introduction to the journey of offering SQL Server on Linux.

3. Announcing SQL Server on Linux public preview, first preview of next release of SQL Server

The community shared our excitement when we announced the first public preview of SQL Server on Linux in November, allowing developers to create their SQL Server solutions on Linux, Windows, Docker, or macOS (via Docker), and then deploy to Linux, Windows, or Docker, on-premises or in the cloud. There’s been tremendous interest from large enterprises as well, with a majority of Fortune 500 companies signing up for this preview release.

Microsoft Heart Pengiun

2. SQL Server 2016 is generally available today

Perhaps our biggest announcement of the year was the general availability of SQL Server 2016, back in June. There was also this post a month prior to the release, recapping key capabilities and benchmarks we achieved. As the world’s fastest, most price-performant database for HTAP (Hybrid Transactional and Analytical Processing) with updateable, in-memory columnstores and advanced analytics via deep integration with R Services, SQL Server offers industry-leading TCO and is a truly watershed product.

SQL Server 2016 leading TCO

1. Microsoft SQL Server Developer Edition is now free

The best things in life are free, as they say – and so it was certainly so for our announcement that SQL Server Developer Edition was being made a free download for all Visual Studio Dev Essentials members. Note that the SQL Server Developer Edition is only for development and testing, and not for production environments or for use with production data. This announcement was an important step in Microsoft making SQL Server ever more broadly accessible.

Stay tuned to this channel for much more exciting news during the year ahead about databases in general, and the SQL Server family in particular.

We wish all of our readers a very happy new year!
SQL Server Blog Team

Categories: Database

Simple Row Level Security for SQL Server 2016

Database Journal News - Tue, 01/03/2017 - 09:01

Have you ever had a need to place some simple row level security on a SQL Server table? Well now you can do that in SQL Server 2016 by using row level security.

Categories: Database