Microsoft on Wednesday appear a accessible examination of SQL Server 2016.
The examination can be downloaded from this Microsoft Evaluation Center page. In its announcement, Microsoft describes the absolution as the “first accessible preview,” although the download folio labels it “Community Technology Examination 2.” CTP is a appellation that Microsoft has about acclimated for software releases above-mentioned the aboriginal accessible beta. Application a CTP suggests that a user has active up to assay a product, but it appears that the SQL Server 2016 CTP2 accessible examination is accessible to anyone. The change in classification conceivably reflects Microsoft’s faster software assembly approach.
Microsoft has been architecture its abutting SQL Server artefact aboriginal in the cloud, which “has absolutely afflicted how we body software,” according to Shawn Bice, an engineering accomplice administrator at Microsoft, in an Ignite 2015 affair captivated beforehand this month. Bice said that SQL Server 2016 includes “mission-critical” workload improvements, enables “deeper insights beyond data” and adds “hyperscale cloud” capabilities.
Microsoft now gets its user acknowledgment aboriginal from its Azure SQL Database all-around deployments and brings those learnings aback into SQL Server. That access has resulted in the “fastest and best box releases,” starting with SQL Server 2016, Bice said.
Mission-Critical ImprovementsOn the mission-critical side, Microsoft has bigger in-memory capabilities in SQL Server to accommodate both rows and columns. The archetype presented at the Ignite affair was about isolating counterfeit responses in chump acknowledgment abstracts by audition anomalies in the data. Bice said Microsoft’s barter capital to advance transactional abstracts into a abstracts barn for assay but they capital to accomplish artifice apprehension on that abstracts first. Microsoft’s technology in SQL Server 2016 that improves this analytic adequacy is alleged “in-memory OLTP” (online transaction processing).
The new “Always Encrypted” affection in SQL Server 2016 is addition mission-critical improvement. Bice said that one gap in abstracts aegis with SQL Server was abstracts in motion, which could be accountable to man-in-the-middle types of attacks. With SQL Server 2016, that argument isn’t beatific in the bright but campaign as “cipher text,” Bice explained.
He presented this arbitrary accelerate of SQL Server 2016’s mission-critical improvements:
Analytics ImprovementsOn the analytics side, SQL Server 2016 is bringing PolyBase integration, which allows Big Abstracts queries application T-SQL beyond Hadoop, Azure accumulator and relational database administration systems. The archetype presented during the Ignite affair was sending car telemetry abstracts to Hadoop and abutting that advice with chump annal kept by an allowance company.
Microsoft additionally added the accessible antecedent statistical programming accent R as an addendum that can be angry on in SQL Server 2016. It can be acclimated with Machine Learning templates in the Azure Marketplace to set up models for exploring things like transactional data.
Bice showed this arbitrary accelerate of SQL Server 2016’s analytics enhancements:
Cloud ImprovementsAn archetype of the hyperscale billow improvements in SQL Server 2016 is its “Stretch Database” feature. It’s a apparatus for actual ample databases that stretches tables in SQL Server into Azure, Bice explained. It works with a SQL Azure annual and leverages the Always Encrypted affection for security. The Stretch Database affection is disabled by default, so users accept to about-face it on first, which they can do while ambience up an Azure account.
Bice provided the afterward accelerate summarizing SQL Server 2016’s billow improvements:
Microsoft lists abounding added SQL Server 2016 improvements in its advertisement of the CTP2 absolution from aboriginal May. According to that announcement, testers will accept the advantage of accepting common updates SQL Server 2016 CTP2 instead of cat-and-mouse for CTP3 to arrive, although it’s not bright how to set that up.
Kurt Mackie is chief account ambassador for the 1105 Enterprise Computing Group.
Insurance Client Database Template 5 Ways On How To Prepare For Insurance Client Database Template – insurance client database template
| Allowed to help my personal weblog, on this occasion I will explain to you in relation to keyword. And after this, this is actually the primary photograph: