Fresh from aftermost week’s Build developer appointment in San Francisco, Microsoft admiral appeared at the company’s first-ever Ignite appointment in Chicago and provided added capacity about the company’s new Azure SQL Abstracts Warehouse.
The aggregation bygone demoed the aboriginal “sneak peek” at the new “elastic abstracts barn in the cloud,” and today exec Tiffany Wissner bound a blog column to highlight specific functionalities.
Wissner explained how Azure SQL Abstracts Barn expands aloft the company’s flagship relational database administration arrangement (RDBMS), SQL Server.
“Azure SQL Abstracts Barn is a aggregate of enterprise-grade SQL Server aggrandized with the massively alongside processing architectonics of the Analytics Platform Arrangement (APS), which allows the SQL Abstracts Barn account to calibration beyond actual ample datasets,” Wissner said. “It integrates with absolute Azure abstracts accoutrement including Adeptness BI for abstracts visualization, Azure Machine Acquirements for avant-garde analytics, Azure Abstracts Factory for abstracts chart and movement as able-bodied as Azure HDInsight, our 100 percent Apache Hadoop account for Big Abstracts processing.”
Just over a year ago, Microsoft alien the APS as a concrete apparatus bells its SQL Server Alongside Abstracts Barn (PDW) with HDInsight. APS is declared by Microsoft as “the change of the PDW artefact that now supports the adeptness to concern beyond the acceptable relational abstracts barn and abstracts stored in a Hadoop arena — either in the apparatus or in a abstracted Hadoop cluster.”
Wissner accustomed the pervasiveness of SQL Server as a affairs point of the new solution, as enterprises can advantage developer abilities and adeptness acquired from its years of accustomed use.
“The SQL Abstracts Barn extends the T-SQL constructs you’re already accustomed with to actualize indexes, partitions, functions and procedures which allows you to calmly drift to the cloud,” Wissner said. “With built-in integrations to Azure Abstracts Factory, Azure Machine Acquirements and Adeptness BI, barter are able to bound blot data, advance acquirements algorithms, and anticipate abstracts built-in either in the billow or on-premises.”
PolyBase in the billow is addition adorable feature, Wissner said. PolyBase was alien with PDW in 2013 to accommodate abstracts stored in the Hadoop Distributed File Arrangement (HDFS) with SQL Server, one of abounding arising SQL-on-Hadoop solutions.
“SQL Abstracts Barn can concern baggy and semi-structured abstracts stored in Azure Storage, Hortonworks Abstracts Platform, or Cloudera application accustomed T-SQL abilities authoritative it attainable to amalgamate abstracts sets no amount area it is stored,” Wissner said. “Other vendors chase the acceptable abstracts barn archetypal that requires abstracts to be confused into the instance to be accessible.”
Although Wissner didn’t analyze any of those “other vendors,” Microsoft took pains to position Azure SQL Abstracts Barn as an advance aloft the Redshift billow database offered by Amazon Web Casework Inc. (AWS), which Microsoft is arduous for accessible billow supremacy.
One of the advantages Microsoft sees in its artefact over Redshift is the adeptness to save costs by pausing billow compute instances. This was mentioned at Build and echoed today by Wissner.
“Dynamic abeyance enables barter to optimize the appliance of the compute basement by ramping bottomward compute while constant the abstracts and eliminating the charge to advancement and restore,” Wissner said. “With added billow vendors, barter are appropriate to aback up the data, annul the absolute cluster, and, aloft resume, accomplish a new array and restore data. This is both time arresting and circuitous for scenarios such as abstracts marts or authoritative abstracts warehouses that charge capricious compute power.”
Again answer the Build message, Wissner additionally discussed Azure SQL Abstracts Warehouse’s adeptness to abstracted compute and accumulator services, ascent them apart up and bottomward anon as needed.
“With SQL Abstracts Barn you are able to bound move to the billow after accepting to move all of your basement forth with it,” Wissner concluded. “With the Analytics Platform System, Microsoft Azure and Azure SQL Abstracts Warehouse, you can accept the abstracts barn band-aid you charge on-premises, in the billow or a amalgam solution.”
Users absorbed in aggravating out the new offering, accepted to hit accepted availability this summer, can assurance up to be notified back that happens.
Posted by David Ramel on 05/05/2015 at 12:04 PM
Is Redshift Developer Resume Any Good? 13 Ways You Can Be Certain | Redshift Developer Resume – redshift developer resume
| Allowed for you to the website, in this particular period I’ll show you regarding redshift developer resume