SQL Server 2016, now with vitamin R: Microsoft emits new preview

Execute R in the database for speedy analysis


Microsoft is releasing a new preview of SQL Server 2016, including integration with the R language for statistical analysis.

In April 2015, Microsoft completed the acquisition of Revolution Analytics, a commercial provider of software and services for the open source R language.

The new Community Tech Preview of SQL Server 2016, CTP3, integrates with the Revolution Analytics R package so you can run R analytics in the database, rather than pulling out data for analysis on a separate machine.

You can also execute R scripts via a system-stored procedure so you can query data, pass it to R, and get the results.

Another new feature in the latest preview is Transactional Replication from SQL Server to Azure SQL, where Azure SQL is Microsoft's cloud-hosted version of SQL Server. The idea is to make it easier to migrate data to the Azure service without downtime.

There are also improvements to in-memory OLTP (online transaction procession), the technology codenamed Hekaton, and to the Stretch database technology that archives historical data to Azure SQL transparently.

New JSON support in T-SQL, the SQL Server query language, includes OPENJSON to parse JSON text and return tabular data, JSON_VALUE and JSON_QUERY for querying JSON data, and ISJSON for validating JSON-formatted text.

Other enhancements cover SQL Server Analysis Services, Reporting Services, and Master Data Services. A full list is in Microsoft's post here.

Another key feature in SQL Server 2016, already previewed in the May 2016 CTP2, is called Always Encrypted. This feature enables SQL Server to operate on encrypted data. The encryption key resides in the application, so that data is only decrypted locally.

SQL Server 2016 Reporting Services, now in responsive HTML 5

SQL Server 2016 Reporting Services, now in responsive HTML5

SQL Server Reporting Services (SSRS) has been revamped so that reports are formatted in responsive HTML5, for richer reports with better browser compatibility and mobile support.

Finally, Microsoft is talking up its Azure Data Lake repository and analytics service, designed for big data processing. The technology is built on Apache Hadoop and Apache YARN, the new generation of MapReduce for filtering and sorting large datasets.

The SQL Server 2016 release date is not yet announced, but note that SQL Server 2014 was completed in March 2014, so sometime in the first quarter of 2016 would not be a surprise.

The download for SQL Server 2016 is not available at the time of writing, but has been promised before the end of the SQL PASS Summit under way in Seattle. In due course you will find it here. ®


Other stories you might like

  • Pentester pops open Tesla Model 3 using low-cost Bluetooth module
    Anything that uses proximity-based BLE is vulnerable, claim researchers

    Tesla Model 3 and Y owners, beware: the passive entry feature on your vehicle could potentially be hoodwinked by a relay attack, leading to the theft of the flash motor.

    Discovered and demonstrated by researchers at NCC Group, the technique involves relaying the Bluetooth Low Energy (BLE) signals from a smartphone that has been paired with a Tesla back to the vehicle. Far from simply unlocking the door, this hack lets a miscreant start the car and drive away, too.

    Essentially, what happens is this: the paired smartphone should be physically close by the Tesla to unlock it. NCC's technique involves one gadget near the paired phone, and another gadget near the car. The phone-side gadget relays signals from the phone to the car-side gadget, which forwards them to the vehicle to unlock and start it. This shouldn't normally happen because the phone and car are so far apart. The car has a defense mechanism – based on measuring transmission latency to detect that a paired device is too far away – that ideally prevents relayed signals from working, though this can be defeated by simply cutting the latency of the relay process.

    Continue reading
  • Google assuring open-source code to secure software supply chains
    Java and Python packages are the first on the list

    Google has a plan — and a new product plus a partnership with developer-focused security shop Snyk — that attempts to make it easier for enterprises to secure their open source software dependencies.

    The new service, announced today at the Google Cloud Security Summit, is called Assured Open Source Software. We're told it will initially focus on some Java and Python packages that Google's own developers prioritize in their workflows. 

    These two programming languages have "particularly high-risk profiles," Google Cloud Cloud VP and GM Sunil Potti said in response to The Register's questions. "Remember Log4j?" Yes, quite vividly.

    Continue reading
  • Rocket Lab is taking NASA's CAPSTONE to the Moon
    Mission to lunar orbit is further than any Photon satellite bus has gone before

    Rocket Lab has taken delivery of NASA's CAPSTONE spacecraft at its New Zealand launch pad ahead of a mission to the Moon.

    It's been quite a journey for CAPSTONE [Cislunar Autonomous Positioning System Technology Operations and Navigation Experiment], which was originally supposed to launch from Rocket Lab's US launchpad at Wallops Island in Virginia.

    The pad, Launch Complex 2, has been completed for a while now. However, delays in certifying Rocket Lab's Autonomous Flight Termination System (AFTS) pushed the move to Launch Complex 1 in Mahia, New Zealand.

    Continue reading

Biting the hand that feeds IT © 1998–2022