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

Oracle Joins the White House’s Advanced Wireless Research Initiative

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

Redwood Shores, Calif.—Jul 18, 2016

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

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

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

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

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

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

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

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

Trademarks

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

Safe Harbor

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

Talk to a Press Contact

Katie Barron

  • +1 202.904.1138

Follow Oracle Corporate

Categories: Database, Vendor

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

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

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

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

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

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

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

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

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

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

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

The full call for papers is available on the website

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

Categories: Database, Open Source

JDBC 1209 released

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

Notable changes include :

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

The full changelog can be found here

Categories: Database, Open Source

Database .NET 18.9 released!

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

I am happy to announce the new major release of Database .NET 18.9. It is an innovative, powerful and intuitive multiple database management tool, With it you can browse objects, design tables, edit rows, export data, run queries and migrate data with a consistent interface.

Free, All-In-One, Portable, Single executable file and Multi-language.

Major New features from version 18.1 to 18.9:

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

Microsoft JDBC Driver 6.0 for SQL Server is now released!

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

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

What’s new Always Encrypted

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

Azure Active Directory (AAD)

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

Table-Valued Parameters (TVPs)

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

Parameterized queries

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

Internationalized Domain Names (IDNs)

IDNs allow your web server to use Unicode characters for server name, enabling support for more languages. Using the new Microsoft JDBC Driver 6.0 for SQL Server, you can convert a Unicode serverName to ASCII compatible encoding (Punycode) when required during a connection.

AlwaysOn Availability Groups (AG)

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

Next steps

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

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

Roadmap

We are committed to bringing more feature support for connecting to SQL Server, Azure SQL Database and Azure SQL DW. We invite you to explore the latest the Microsoft Data Platform has to offer via a trial of Microsoft Azure SQL Database or by trying the new SQL Server 2016.

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

Categories: Database

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

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

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

Categories: Database

SQL Server 2014 SP2 is now available

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

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

SQL Server 2014 SP2 now includes:

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

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

Categories: Database

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

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

Redwood Shores, Calif.—Jul 12, 2016

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

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

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

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

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

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

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

About Oracle Hospitality Sports & Entertainment

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

About Turnkey Intelligence

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

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

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

Trademarks

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

Safe Harbor

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

Talk to a Press Contact

Katie Barron

  • 202-904-1138

Follow Oracle Corporate

Categories: Database, Vendor

The elastic future of data warehousing

This post was authored by Joseph Sirosh, Corporate Vice President, Data Group.

Announcing the general availability of Azure SQL Data Warehouse, an elastic, parallel, columnar data warehouse as a service.

A defining characteristic of cloud computing is elasticity – the ability to rapidly provision and release resources to match what a workload requires – so that a user pays no more and no less than what they need to for the task at hand. Such just-in-time provisioning can save customers enormous amounts of money when their workloads are intermittent and heavily spiked. And in the modern enterprise, there are few workloads that have a desperate need for such elastic capabilities as data warehousing. Traditionally built on-premises with very expensive hardware and software, most enterprise Data Warehouse (DW) systems have very low utilization except during peak periods of data loading, transformation and report generation.

With the general availability of the Azure SQL Data Warehouse, we are delivering the true promise of cloud elasticity to data warehousing. It is a fully managed DW as a Service that you can provision in minutes and scale up to 60 times larger in seconds. With a few clicks in the Azure Portal, you can launch a data warehouse, and start analyzing or querying data at the scale of hundreds of terabytes. Our architecture separates compute and storage so that you can independently scale them, and use just the right amount of each at any given time. A very unique pause feature allows you to suspend compute in seconds and resume when needed while your data remains intact in Azure storage. And SQL Data Warehouse offers an availability SLA of 99.9% – the only public cloud data warehouse service that offers an availability SLA to customers.

According to Gartner, “For years, many data warehousing vendors have been operating from a playbook of tightly balanced storage and compute configuration units. Cloud architectures are forcing a shift in this approach, with vendors starting to decouple storage and compute, and allowing them to independently scale. We believe this approach to be the correct one, and that other vendors in the space will need to adopt this methodology if they are to stay competitive.”1

Azure SQL Data Warehouse uses an elastic massively parallel processing (MPP) architecture built on top of the industry-leading SQL Server 2016 database engine. It allows you to interactively query and analyze data using the broad set of existing SQL-based tools and business intelligence applications that you use today. It uses column stores for high performance analytics and storage compression, a rich collection of aggregation capabilities of SQL Server, and state of the art query optimization capabilities. With built-in capabilities such as Polybase, it allows you to query Hadoop systems directly, enabling a single SQL-based query surface for all your data.

Azure SQL Data Warehouse is also part of the Cortana Intelligence Suite, which is a fully managed big data and advanced analytics suite to transform your data into intelligent action. It easily integrates with components of the suite such as Azure Data Factory for data integration pipelines, with Azure Machine Learning for predictive analytics, Power BI for business intelligence, HDInsight for big data insights, R and Spark for big data analytics. For an example of such integration, see the airline industry sample on PowerBI.com. This shows a Power BI report based on a real world predictive maintenance solution for a major airline. The data for this report comes from a variety of sources including IoT streams from aircraft engines, air traffic control information, route restrictions and fuel usage data. All this is integrated and landed into a Azure SQL DW and processed with Azure Machine Learning to detect operational anomalies and trends.  The report is “live” and you can interact with it and experience Power BI in conjunction with Azure SQL DW and Azure ML.

The distinct capabilities of Azure SQL Data Warehouse include:

Data warehousing as a service

Gone are the pains associated with administering, managing, patching and manual tuning of data warehouses. There are no knobs to turn, no physical or virtual infrastructure to manage and the service is simple, resilient and secure with reliable storage. This enables the focus on driving the analytics and getting the value from your data rather than on managing your data warehousing software and hardware; Azure SQL Data Warehouse handles it all for you.

Unmatched security and access control

With malicious and even insider attacks becoming a key concern for enterprises, an alarm system over your critical enterprise data is a must have to avoid serious damage to your business and reputation. Only Azure SQL Data Warehouse delivers auditing and threat detection built into the service, with advanced machine learning to detect abnormal query patterns and alert you of potential security issues before it is too late. Data at rest is protected by Transparent Data Encryption.

Additionally, SQL Data Warehouse is the only cloud data warehouse service that works seamlessly with Azure Active Directory which currently supports 1.3 billion daily authentications across 600 million user accounts. This enables Single Sign-On (SSO) and role-based access control. You can even have finer-granularity permissions that let you control which operations a user can do on individual columns, tables, views, procedures, and other objects in the database. These features further protect data by ensuring just the right users have access to the right data—a critical capability when centralizing vast amounts of proprietary and sensitive data for analytics in an enterprise.

Multidimensional elasticity

Currently the majority of cloud database and data warehouse services are provisioned with fixed storage and compute resources. Resizing of resources typically compromises availability and/or performance. This means that service users typically end up with over-provisioned and expensive underutilized resources to accommodate possible peak demand or in the worst case, under-provisioned resources unable to handle sudden work overloads.

Unlike existing cloud services which can take anywhere from a couple of hours to a couple of days to do the data warehouse resizing, SQL Data Warehouse’s unique elastic technology decouples storage and compute, enabling each layer to become independently scalable almost instantaneously. This makes it possible to provision one or more data warehouses in minutes, and then independently scale users, data, and workloads in seconds to optimally match the demand. Further, elastic scaling also makes it possible to simultaneously load and query data, because every user and workload can have exactly the resources needed, without contention, and with minimal impact to production queries.

Getting featured in the iOS App Store was a big deal for a small company like ours as our users increased from 3,000 to 300,000 in 48 hours. To keep up with this 100x increase in workload, we simply added data warehouse compute capacity by moving a slider and our services just scaled in minutes—we didn’t miss an insight,” notes Paul Ohanian, CTO, PoundSand.

Save as you go, with fast pause and resume

Starting and shutting data warehouse clusters may take a considerable amount of time. Leaving the data warehouse running continuously incurs potentially high and unnecessary costs, especially if you are running your jobs periodically and the data warehouse is sitting idle in-between for extended periods of time. Now you can pause your data warehouse for the required time, saving compute costs, and quickly resume it later when needed. You can even write a PowerShell script, then automate the schedule with Azure Automation to automatically pause or resume the cluster based on the specific needs of your business.

When we learned about the pause and resume capabilities of SQL Data Warehouse and integrated services like Azure Machine Learning and Data Factory, we switched from AWS Redshift, migrating over 7TB of uncompressed data over a week for the simple reasons of saving money and enabling a more straight-forward implementation for advanced analytics. To meet our business intelligence requirements, we load data once or twice a month and then build reports for our customers. Not having the data warehouse service running all the time is key for our business and our bottom line,” said Bill Sabo, managing director of information technology at Integral Analytics.

Seamless querying of structured and unstructured data

An increasing amount of data in today’s rapidly digitizing world is unstructured data such as clickstreams, sensor data, location data, customer support emails and chat transcripts, much of which is harnessed for analysis in big data systems. The ability to integrate and join such data with your core relational enterprise data is often a highly desired capability. With built-in PolyBase technology, SQL Data Warehouse allows you to access and combine both non-relational and relational data. You can run queries on external data in Hadoop or Azure blob storage using familiar SQL, often without making any changes to the existing queries. Underneath, the queries are optimized for optimal execution without any burden on the user for tuning. Furthermore, you can quickly import and export data back and forth between relational tables in SQL Data Warehouse and non-relational data in Hadoop or Azure Blob Storage using simple T-SQL statements. The rich SQL programmability support (stored procs, functions and PolyBase) empower users to query the data however they want.

Christoph Leinemann, senior director data engineering at Jet.com says, “with Azure SQL Data Warehouse, we use PolyBase to ingest data from HDInsight then run thousands of analytical queries per day over tens of billions of records—about 20TB of data. This enables us to monitor price history and market dynamics to adjust pricing and ensure we’re offering our customers the best price.”

Integration with the SQL Server tool ecosystem you already use and love

Azure SQL Data Warehouse already fits into the tool ecosystem you already use, with native JBDC and ODBC connectors, and with a broad set of independent software vendors and partners who already support SQL Server, such as Alteryx, Attunity, Informatica, Redgate and SnapLogic. For BI capabilities, it integrates with the industry-leading Power BI service in Azure, and even with Microsoft Excel. For a beautifully visualized walkthrough of Microsoft Power BI and SQL Server 2016 Reporting Services including Mobile BI, please watch this demo. Microsoft also works with a set of popular BI partners to ensure the tools your teams use work great with SQL Data Warehouse, including Looker Data Sciences, Tableau Software and Qlik Technologies.

Experience modern data warehousing in the cloud for yourself

Today we have thousands of customers who are already using Azure SQL Data Warehouse. Many of these customers are experiencing significant performance gains over existing multi-million dollar data warehouses on-premises. With SQL Data Warehouse, some multi-hour queries in our customer environments finish now in under an hour, and some queries that took five to ten minutes now complete in seconds. Get started with SQL Data Warehouse today and experience the speed, scale, elasticity, security and ease of use of a true modern data warehouse as a service for yourself.

– Joseph

 

1Source: Gartner, The Data Warehouse and DMSA Market: Current and Future States, 201, June 16, 2016.

Categories: Database

repmgr 3.1.4 released!

PostgreSQL News - Tue, 07/12/2016 - 01:00

2ndQuadrant is delighted to announce the release of repmgr 3.1.4 - the most popular tool for PostgreSQL failover management.

First introduced in 2010, repmgr 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.

Several improvements and bug fixes have been implemented, particularly better path handling and node shutdown detection during switchover operations. To view the release notes, please click here.

Categories: Database, Open Source

MySQL Tuning for Large Datasets

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

While there is no silver bullet to keeping your MySQL database running briskly, there are a few performance tweaks that you can do to keep things chugging along when the data starts to pile up.  In today’s article, we’ll take a look at a few of these.

Categories: Database

Introduction to Azure SQL Database Temporal Tables

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

As announced on June 1, 2016, SQL Server 2016 has reached its general availability. This means that you finally have the option to implement some of its new features in the production environment. While we still have to wait for their full support in Azure SQL Database V12, it is likely that their preview stage will be concluded soon. In this article, we will focus on Temporal tables, which is one example of these new features.

Categories: Database

New version of Postgres Migration Tookit has been released

PostgreSQL News - Wed, 07/06/2016 - 01:00

New versions of Postgres Migration Tookit has been released with improved support for schemas, default values, "pure" time and many other improvements.

Visit http://www.convert-in.com/pgskit.htm for details.

Categories: Database, Open Source

Fujitsu and Oracle Team Up to Drive Cloud Computing

Oracle Database News - Tue, 07/05/2016 - 17:41
Press Release Fujitsu and Oracle Team Up to Drive Cloud Computing Strategic alliance provides robust cloud offering to customers in Japan and their subsidiaries around the world

Tokyo and Redwood Shores, Calif.—Jul 5, 2016

Fujitsu Limited, Oracle Corporation, and Oracle Corporation Japan today announced that they have agreed to form a new strategic alliance to deliver enterprise-grade, world-class cloud services to customers in Japan and their subsidiaries around the world.

In order to take advantage of cloud computing to speed innovation, reduce costs and drive business growth, organizations need IT partners that can deliver the performance, security and management capabilities that are demanded by enterprise workloads. To help organizations in Japan capitalize on this opportunity and confidently move enterprise workloads to the cloud, Oracle Cloud Application and Platform services—such as Oracle Database Cloud Service and Oracle Human Capital Management (HCM) Cloud—will be powered by Fujitsu’s datacenters in Japan. Under the new strategic alliance, Fujitsu will work to drive sales of robust cloud offerings to companies in Japan and their subsidiaries around the world.

By bringing Oracle Cloud Application and Platform services to FUJITSU Cloud Service K5, Fujitsu and Oracle will provide a high-performance cloud environment to meet the IT and business needs of customers. Specifically, Fujitsu will install the Oracle Cloud services in its datacenters in Japan and connect them to its K5 service in order to deliver enterprise-grade cloud services. The first Oracle Cloud Application that will be offered to Fujitsu customers under the joint offering is Oracle HCM Cloud. As part of the agreement, Fujitsu will implement Oracle HCM Cloud to gain unprecedented insight into its workforce throughout the company’s worldwide network of offices.

"We at Fujitsu support the digital transformation of our customers, and aim to contribute to optimized customer systems and business growth with the roll out of our Digital Business Platform MetaArc," said Shingo Kagawa, SEVP, Head of Digital Services Business & CTO, Fujitsu Limited. "In particular, we offer the core cloud service on MetaArc, K5, which addresses systems of engagement (SoE)(*1) and systems of record (SoR)(*2). Oracle is a leader in Japan's database market segment and possesses strong capabilities in the SoR domain. Now, as we look to strengthen MetaArc and K5, taking part in this strategic alliance with Oracle will work to meet the cloud needs of our customers."

“In order to realize the full business potential of cloud computing, organizations need secure, reliable and high-performing cloud solutions,” said Edward Screven, Chief Corporate Architect, Oracle. “For over three decades, Oracle and Fujitsu have worked together using our combined R&D, product depth and global reach to create innovative solutions enabling customers to scale their organizations and achieve a competitive advantage. Oracle’s new strategic alliance with Fujitsu will allow companies in Japan to take advantage of an integrated cloud offering to support their transition to the cloud.”

“We strongly believe this cloud alliance will support Japanese companies to drive digital transformation,” said Hiroshige Sugihara, President and CEO, Oracle Corporation Japan. “This will be a gateway for customers to achieve standardization, modernization, and globalization.  This initiative will differentiate us from other cloud providers by emphasizing real enterprise cloud solutions, while offering Japanese companies access to best of breed technology in the new Cloud era.”

The combination of these innovative solutions including Oracle Database Cloud Service, Oracle HCM Cloud, and K5, will enable Fujitsu and Oracle to deliver mission critical systems over a cloud environment within Fujitsu’s datacenters while maintaining the high levels of performance and reliability that had previously been achieved in on-premise environments. Furthermore, with the Oracle Cloud provided from Fujitsu’s state-of-the-art datacenters, which boast a high level of capabilities in Japan, customers using K5 or Fujitsu’s hosting services will have access to use invaluable cloud services.

Contact Info Fujitsu Limited
Public and Investor Relations Division
Candice van der Laan
Oracle
+1.650.464.3186
candice.van.der.laan@oracle.com Junko Ishikawa, Norihito Yachita
Oracle Japan
pr-room_jp@oracle.com Notes

1. Systems-of-Engagement (SoE)
Systems that implement digital transformations, including business-process transformation and new-business development.

2. Systems-of-Record (SoR)
Existing systems that record company data and perform business processes.

About Fujitsu

Fujitsu is the leading Japanese information and communication technology (ICT) company, offering a full range of technology products, solutions, and services. Approximately 156,000 Fujitsu people support customers in more than 100 countries. We use our experience and the power of ICT to shape the future of society with our customers. Fujitsu Limited (TSE: 6702) reported consolidated revenues of 4.7 trillion yen (US$41 billion) for the fiscal year ended March 31, 2016. For more information, please see www.fujitsu.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.

About Oracle Japan

Oracle Corporation Japan was established in 1985 as Oracle Corporation’s subsidiary in Japan. With the goal of becoming the number one cloud company, it provides a comprehensive and fully integrated stack of cloud applications and cloud platforms, a suite of products to generate valuable information from big data, and a wide variety of services to support the use of these products. It was listed on the first section of the Tokyo Stock Exchange in 2000 (Company code: 4716). Visit oracle.com/jp.

Fujitsu and Oracle Alliance History

Since entering into a database OEM contract in 1989, the two companies have been providing customers with optimal solutions. Currently, as an Oracle Partner Network (OPN) Diamond level partner, Fujitsu is providing system integration services worldwide. In addition, in the SPARC/Solaris server business, Fujitsu entered into a sales contract with Sun Microsystems in 1983 and a development agreement for SPARC chips in 1988, and further strengthened the relationship with Sun Microsystems through a Solaris OEM contract in 1993. Since Oracle's subsequent acquisition of Sun Microsystems, the two companies have maintained a close, collaborative relationship to the present day.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates in the US and other countries. Other names may be trademarks of their respective owners. This press release is solely for the purpose of providing information and does not constitute an implied contract.

All company or product names mentioned herein are trademarks or registered trademarks of their respective owners. Information provided in this press release is accurate at time of publication and is subject to change without advance notice.

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

Fujitsu Limited

Candice van der Laan

  • +1.650.464.3186

Junko Ishikawa, Norihito Yachita

Follow Oracle Corporate

Categories: Database, Vendor

Temporal Data Part 2 - Creating and Deleting System-Versioned Tables

Database Journal News - Tue, 07/05/2016 - 08:01

Greg Larsen expands on his topic of how to modify an existing table to take advantage of the new temporal data feature in SQL Server 2016. In this article he shows you how to create and deleted system-versioned tables and the associated history temporal table.

Categories: Database

Oracle Statement

Oracle Database News - Fri, 07/01/2016 - 00:55
Press Release Oracle Statement

Redwood Shores, Calif.—Jun 30, 2016

"Five years ago, Oracle made a software development announcement which accurately reflected the future of the Itanium microprocessor. Two trials have now demonstrated clearly that the Itanium chip was nearing end of life, HP knew it, and was actively hiding that fact from its customers. Oracle never believed it had a contract to continue to port our software to Itanium indefinitely and we do not believe so today; nevertheless, Oracle has been providing all its latest software for the Itanium systems since the original ruling while HP and Intel stopped developing systems years ago. Further, it is very clear that any contractual obligations were reciprocal and HP breached its own obligations. Now that both trials have concluded, we intend to appeal both today's ruling and the prior ruling from Judge Kleinberg."
-Dorian Daley, Executive Vice President, General Counsel, and Secretary, Oracle

Contact Info Deborah Hellinger
Oracle Corporate Communications
1.212.508.7935.
deborah.hellinger@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

Deborah Hellinger

  • 1.212.508.7935.

Follow Oracle Corporate

Categories: Database, Vendor

Celebrating with Hadoop and Red Hat communities

This post was authored by Joseph Sirosh, Corporate Vice President of the Data Group at Microsoft

This week I had the opportunity to represent Microsoft in keynotes at both the Hadoop and Red Hat Summits in San Jose and San Francisco, and during that time speak to many customers and members of the open source and big data communities. The energy in these communities is incredible and I’m proud to see Microsoft engage as an active participant and contributor. Below I want to share a quick summary of recent news related to both these events and communities.

Hadoop Summit

This year we celebrated 10 years of Hadoop and along with the rest of the community we’re working hard to make big data easier for customers, no matter the type of data, what they need to do or what platform they’re on. At Hadoop Summit, Hortonworks also announced Microsoft Azure HDInsight as its Premier Connected Data Platforms solution to deliver Apache Hadoop in a cloud environment. This announcement culminates a long-standing partnership with Hortonworks that started in 2011 when Hortonworks was three-months-old. It’s been rewarding to see how far Hadoop has come, and it’s now deployed in thousands of organizations. As an example, Jet.com is using Hadoop with HDInsight to help redefine the e-commerce category by providing consumers with completely transparent pricing that dynamically changes based on the actual costs of the transaction – warehouse location, payment method, and number of items shipped.

Looking back at our journey with Hadoop, it’s also been gratifying to see our contributions accelerate its adoption. Members of Microsoft have been contributing to the development of Apache YARN since its inception. We’ve also been leading or contributing to projects like bringing Hadoop onto Azure and Windows, speeding up the query processing of Hive, making cloud-based stores accessible via WebHDFS, and making Spark execution available through a REST endpoint. Recently, we also announced our commitment to Apache Spark at Spark Summit 2016 including:

  • Spark for Azure HDInsight General Availability, is a fully managed Spark service from Hortonworks that is enterprise ready and easy to use
  • R Server for HDInsight in the cloud powered by Spark, in preview today and will be generally available later this summer makes Spark integration easy no matter if you are working on premises or in the cloud.
  • R Server for Hadoop on-premises now powered by Spark, as the leading solution in the world to run R at scale, R Server for Hadoop now supports both Microsoft R and native Spark execution frameworks made available this week. Combining R Server with Spark gives users the ability to run R functions over thousands of Spark nodes letting you train your models on data 1000x larger and 100x faster than was possible with open source R and nearly 2x faster than Spark’s own MLLib.
  • Free R Client for Data Scientists, a new free tool for data scientists to build high performance analytics using R.
  • Power BI support for Spark Streaming, General Availability, Spark support in Power BI now allows you to publish real-time events from Spark Streaming.

With our investments in R combined with Spark & Hadoop, statisticians and data scientists can rapidly train a variety of predictive models on large-scale data, limited only by the size of their Spark clusters. With Spark, R Server’s compiled code algorithms and transparent parallelization of regression, clustering, decision trees and other statistical algorithms speeds analysis 100x faster on terabytes of data.

Hadoop63016

Red Hat Summit

At Microsoft, we’re serious about building an intelligent cloud through a comprehensive approach that includes the open source ecosystem. Today, our cloud offerings range from support for Linux in Azure Virtual Machines – and nearly 1 in 3 VMs are running Linux today – to a Hadoop solution in HDInsight, or deep integration of Docker Swarm and Apache Mesos in Azure Container Service that represent our commitment to the ecosystem and highlight the value of our partnerships. In November, Microsoft and Red Hat announced a partnership to add value to the open source investments in the enterprise. At Red Hat Summit, we announced a number of important partnership milestones, including:

  • The general availability of .NET Core 1.0 and ASP.NET Core 1.0, a platform for creating modern applications for Windows, Linux and Mac OS X
  • In partnership with Red Hat and 21Vianet, this week we are extending support for Red Hat Enterprise Linux to Azure China operated by 21Vianet
  • Red Hat is making CloudForms 4.1 generally available, with deep support for Azure including state analysis, metrics, chargeback and retirement, making Azure the best supported cloud in CloudForms
  • Availability of a new OpenShift solution template on GitHub that makes it simple to deploy OpenShift in Azure

In March, we announced our plans to bring SQL Server to Linux, starting with a private preview. In the research note Microsoft Diversifies With Linux Support for SQL Server, Gartner wrote “SQL Server on Linux represents a bold statement that the company understands there is more to the overall IT world than just Windows and this flexibility is necessary to compete in the DBMS market.” Today, at the Red Hat Summit, I will show SQL Server running on Red Hat Enterprise Linux. Our goal is to make SQL Server the platform of choice to support any data, any application, on-premises or in the cloud, and providing you with platform choice. Bringing SQL Server to Red Hat Enterprise Linux will provide enterprise Linux customers with SQL Server’s mission-critical performance, industry-leading TCO, the least vulnerable database,[1] and hybrid cloud innovations like Stretch Database to access data on-premises or in the cloud.  We’ll first release the core relational database capabilities on Linux targeting mid-calendar year 2017.

MongoDB on Microsoft Azure

Additionally, this week, MongoDB announced MongoDB Atlas, a new elastic on-demand cloud service that will provide comprehensive infrastructure and management for its popular database. MongoDB Atlas will become available for Azure customers via a strategic partnership between the two companies. This partnership with MongoDB further reinforces Microsoft’s commitment to providing customers with open source solutions and the most comprehensive cloud platform on the market.

– Joseph

[1] National Institute of Standards and Technology, National Vulnerability Database statistics as of 2/1/2016.

Categories: Database

SQL PowerShell: July 2016 update

This post was authored by Ayo Olubeko, Program Manager, Data Developer Group.

The July update for SSMS includes the first substantial improvement in SQL PowerShell in many years. We owe a lot of thanks for this effort to the great collaboration with our community. We have several new CMDLETs to share with you, but firstly, there is a very important change we had to make to be able to ship monthly updates to the SQL PowerShell component.

Historically, SQL Server’s PowerShell components are included in both the SSMS (tools) installer as well as with the SQL Server engine install. In order to be able to ship SQL PowerShell update, we had to change the identity of the SQL PowerShell module as well as the wrapper known as SQLPS.exe. This change has an impact to scripts doing Import-Module.

This month we introduce CMDLETs for the following areas:

  • Always Encrypted
  • SQL Agent
  • SQL Error Logs

Additionally, we have made some nice improvements to Invoke-SqlCmd and the SQL provider.

New SQL PowerShell module

As alluded to above, in order to ship monthly updates, we have created a new SQL PowerShell module as well as have introduced a new wrapper EXE that SSMS uses to instantiate the SQL PowerShell environment. The SQL PowerShell module that ships with SSMS has changed from SQLPS to SqlServer (there is no change to the module used by SQL Agent). This means that if you have a PowerShell script doing Import-Module SQLPS, it will need to be changed to be Import-Module SqlServer in order to take advantage of the new provider functionality and new CMDLETs. The new module will be installed to “%Program Files\WindowsPowerShell\Modules\SqlServer” and hence no update to $env:PSModulePath is required. Additionally, if you happen to have a script that is using a 3rd-party or community version of a module named SqlServer, you should add use of the Prefix parameter to avoid name collisions.

The motivation for these changes is that the tooling components are being moved to be “application local” and not share any components with the SQL Server engine. This is an important step to enable monthly tooling updates while not negatively impacting the components setup and updated by the SQL Server setup program.

SSMS has been updated to integrate with SQLTOOLSPS.exe rather than SQLPS.exe. Hence, if you launch PowerShell from within SSMS, it will launch PowerShell and configure the session with the new SQL PowerShell module. It is advised to avoid using these EXE wrappers; they exist for legacy reasons within SSMS and are likely to be removed in a future monthly update.

The new version of SQL Server PowerShell included with SSMS does not update the version of PowerShell used by SQL Server. This means that scripts executed by SQL Agent will not be able to use the new CMDLETs. Updates to SQLPS (the version used by SQL Agent) will be done through the traditional SQL Server update mechanisms; more specifically, major changes will be done as part of the next major version of SQL Server as it becomes available.

New CMDLETs

In the July SSMS update, you will find several new CMDLETs. Once again, we owe thanks to our SQL PowerShell community leaders for helping us prioritize these investments. The CMDLETs all provide help within PowerShell for detailed information. As with the majority of the features in SSMS, the SQL PowerShell CMDLETs work against all supported versions of SQL Server. In some cases, such as Always Encrypted, the CMDLETs obviously only work on versions of SQL Server that support that specific feature set.

CMDLET Description Add-SqlAzureAuthenticationContext Performs authentication to Azure and acquires an authentication token. Add-SqlColumnEncryptionKeyValue Adds a new encrypted value for an existing column encryption key object in the database. Complete-SqlColumnMasterKeyRotation Completes the rotation of a column master key. Get-SqlColumnEncryptionKey Returns all column encryption key objects defined in the database, or returns one column encryption key object with the specified name. Get-SqlColumnMasterKey Returns the column master key objects defined in the database, or returns one column master key object with the specified name. Invoke-SqlColumnMasterKeyRotation Initiates the rotation of a column master key. New-SqlAzureKeyVaultColumnMasterKeySettings Creates a SqlColumnMasterKeySettings object describing an asymmetric key stored in Azure Key Vault. New-SqlCertificateStoreColumnMasterKeySettings Creates a SqlColumnMasterKeySettings object referencing the specified certificate. New-SqlCngColumnMasterKeySettings Creates a SqlColumnMasterKeySettings object describing an asymmetric key stored in a key store supporting the Cryptography Next Generation (CNG) API. New-SqlColumnEncryptionKey Crates a new column encryption key object in the database. New-SqlColumnEncryptionKeyEncryptedValue Produces an encrypted value of a column encryption key. New-SqlColumnEncryptionSettings Creates a new SqlColumnEncryptionSettings object that encapsulates information about a single column’s encryption, including CEK and encryption type. New-SqlColumnMasterKey Creates a new column master key object in the database. New-SqlCspColumnMasterKeySettings Creates a SqlColumnMasterKeySettings object describing an asymmetric key stored in a key store with a Cryptography Service Provider (CSP) supporting Cryptography API (CAPI). Remove-SqlColumnEncryptionKey Removes the column encryption key object from the database. Remove-SqlColumnEncryptionKeyValue Removes an encrypted value from an existing column encryption key object in the database. Remove-SqlColumnMasterKey Removes the column master key object from the database. Set-SqlColumnEncryption Encrypts, decrypts or re-encrypts specified columns in the database.   Get-SqlAgent Returns a SQL Agent (JobServer) object that is present in the target instance of the SQL Server. Get-SqlAgentJob Returns a SQL Agent Job object for each job that is present in the target instance of SQL Agent. Get-SqlAgentJobHistory Returns the JobHistory present in the target instance of SQL Agent. Get-SqlAgentJobSchedule Returns a JobSchedule object for each schedule that is present in the target instance of SQL Agent Job. Get-SqlAgentJobStep Returns a SQL JobStep object for each step that is present in the target instance of SQL Agent Job. Get-SqlAgentSchedule Returns a SQL JobSchedule object for each schedule that is present in the target instance of SQL Agent.   Get-SqlErrorLog Retrieves the SQL Server Logs. Set-SqlErrorLog Sets or resets the maximum number of error log files before they are recycled. Invoke-SqlCmd improvements

Invoke-SqlCmd now supports an OutputAs parameter (or its alias -As). This parameter allows you to specify DataRows, DataTables or DataSet as the object type to return. These types map to the .Net types you find in System.Data. DataRows is the default, and corresponds to the old behavior.

Additionally, we added the ConnectionString parameter which allows the script author complete control over the connection context. This unlocks new capabilities such as connecting to SQL Azure using Azure Active Directory authentication.

SQL PowerShell provider enhancements

The SQL PowerShell provider now properly supports the WhatIf and Confirm parameters. This allows you to see the potential impact of a script operation and have the ability to confirm an operation before it is executed.

Categories: Database

PostgreSQL Maestro 16.6 released

PostgreSQL News - Thu, 06/30/2016 - 01:00

SQL Maestro Group announces the release of PostgreSQL Maestro 16.6, a powerful Windows GUI solution for PostgreSQL database server administration and database development.

The new version is immediately available for download.

Top 10 new features:
  1. PostgreSQL 9.6 compatibility.
  2. Support for Row Security Policies (PostgreSQL 9.5+).
  3. Support for BRIN indexes (PostgreSQL 9.5+).
  4. Support for "Allow Connections" and "Is Template" options (PostgreSQL 9.5+).
  5. Generate Updatable View tool becomes available for PostgreSQL 9.2 and lower.
  6. Support for indexes for materialized views.
  7. Improved "Show SQL Help" command flexibility.
  8. Support for Adobe Reader DC in BLOB Editor.
  9. Default Data Import settings can now be set up in the Program Options dialog.
  10. Some performance and usability improvements.

There are also some other useful things. Full press release is available at the SQL Maestro Group website.

Categories: Database, Open Source

SQL Server 2016: Broader access, better reporting, faster analytics

We want to make it easier for businesses to use their data. Otherwise, what’s the point? In SQL Server 2016 you’ll find a virtual tool chest full of features, all with one primary goal: unlocking your data and helping you create new ways of analyzing, visualizing and sharing it.

Building data-rich biz apps

The advent of machine learning and natural language processing made it easier to analyze unstructured data. The challenge was effectively integrating it with structured data, leading to more meaningful discoveries.

Enter SQL Server PolyBase, a feature in SQL Server 2014 that was specific to the Microsoft Analytics Platform System, through which you could access data in a Hadoop Distributed File System. With SQL Server 2016 we cut the strings, making it possible to query data in Hadoop, as well as Azure Blob Storage. Now you can combine the results of your findings with relational data stored in SQL Server.

But that’s just the beginning. PolyBase becomes a data-rich foundation upon which to build powerful business applications. It dynamically creates columnar tables for your structured data, parallelizes the extraction of data from Hadoop and Azure—even pushing data to Hadoop clusters for additional processing.

Meanwhile, on the front end users can continue using their apps, consuming data and discovering new insights, all without needing to understand the finer points of data base management.

You can install PolyBase in one of two ways: using the SQL Server Installation Wizard or from the command-prompt window. See below for an example of the installation script.

Installing PolyBase

Subsequently, you’ll also need to configure to PolyBase to connect either to Hadoop or Azure Blog Storage, using one of the following values:

  • 0 Disable Hadoop connectivity
  • 1 Hortonworks HDP 1.3 on Windows Server and blob storage
  • 2 Hortonworks HDP 1.3 on Linux
  • 3 Cloudera CDH 4.3 on Linux
  • 4 Hortonworks HDP 2.0 on Windows Server and blob storage
  • 5 Hortonworks HDP 2.0 on Linux
  • 6 Cloudera 5.1 on Linux
  • 7 Hortonworks 2.1 and 2.2 on Linux, Hortonworks 2.2 on Windows Server and blob storage

To achieve optimum app performance, even when dealing with larger datasets, consider creating a PolyBase scale-out group. PolyBase scale-out groups include one or more compute nodes, each of which includes a database engine and database movement service, as well as a head node that includes the SQL Server database engine, the PolyBase engine service and the PolyBase movement service. The following diagram gives you a better sense of how PolyBase scale-out groups can keep the data flowing.

Polybase scale out groups

Advanced analytics, at scale

For the first time, SQL Server 2016 gives you the ability to work directly with R, introducing a range of new capabilities around advanced analytics, data exploration and modeling.

SQL Server R Services provides a platform for developing intelligent applications that uncover new insights. You can use the rich and powerful R language and the many open source packages to create models and generate predictions using your SQL Server data. Because SQL Server R Services integrates the R language with SQL Server, you can keep analytics close to the data and eliminate the costs and security risks associated with data movement.

With SQL Server R Services you can tap into the robust capabilities of R and combine them with a comprehensive set of SQL Server tools and technologies that offer superior performance, security, reliability and manageability. You can deploy R solutions using convenient, familiar tools, and your production applications can call the R runtime and retrieve predictions and visuals using Transact-SQL. With Enterprise Edition, you also get the Scale R libraries to overcome R’s inherent performance and scale limitations.

SQL Server R Services

To store a procedure you must first serialize it as a hexadecimal string, which is sent to the server and stored in a varbinary(max) column. Check out the sample script:

Storing an R procedure

Making data mobile

These days, there is so much that can be done with a smart phone and an Internet connection. As such, SQL Server 2016 Reporting Services has made it easier to build concise and consumable mobile reports. And with the Power BI mobile apps you can view, interact with and share data through the Power BI dashboard and SQL Server Reporting Services web portal. Check out this Power BI blog post for the unique capabilities of Power BI for iOS, Power BI app for Android phones and Power BI mobile app for Windows 10.

With the Mobile Report Publisher you can create reports based on shared data sources. An extensive array of charts, gauges, grids and other visuals help users gain greater clarity when consuming data via their mobile device. And with navigator elements, users can filter data based on time, date, location or other pre-determined values.

SQL Server Mobile Report Publisher

When designing a report, the Mobile Report Publisher optimizes the report for mobile devices and automatically populates it based on simulated data, allowing you to review with your business user, find the right layout before you connect the report to the data. Once ready, you can import data either from a local file, or from a report server. The first time you select the report server, the “Connect to a Server” prompt appears, at which point you’ll need to enter the following information:

  • In the Server Address Box: <servername>/reports, where servername is the name of the server hosting Reporting Services.
    NOTE: If the report server is not configured to use Secure Socket Layer, clear the Use Secure Connection box.
    NOTE: If the data set uses a database login, or if you want to use a different Windows account, clear the Use Current Windows Account box and supply the appropriate credentials.
Summary

SQL Server 2016 offers a range of new features that transform information into insight and help your employees to make more decisive and strategic decisions, wherever they are. To learn more about the features in SQL Server 2016, download the SQL Server 2016 e-book, or visit the  SQL Server 2016 product page.

Categories: Database