SQL Server 2016 – What's exciting?


Having completed a week of training on SQL Server 2016, PowerBI, Cortana Analytics at HQ and spending time with the product team, I am super excited of what Microsoft's data platform is going to enable your business to achieve by unleashing the power of analytics on your data. Don't take my word for it, see what some of them are doing:

Dartmouth-Hitchcock delivers lower cost, more personalized healthcare - https://youtu.be/-wVeHZNn8aU

Tangerine knows that staying innovative is key to standing out in the crowded world of online banking. By giving its business leaders easier access to customer feedback, the bank has a better sense of exactly the kinds of services customers are looking for. Using this approach, Tangerine can lead in a competitive industry - https://customers.microsoft.com/Pages/CustomerStory.aspx?recid=14594

Data Analytics Vision - https://www.youtube.com/watch?v=JCDD2BdY8Yc 

All of these capabiiltes is being powered by SQL Server on premise and Cortana Analytics in the cloud. With SQL Server 2016 releasing next year, following are the areas you can excpect your business to start taking advantage of:

Performance - SQL Server 2014 bought in-memory to relational databases, maintaining ACID properties. SQL Server 2016 continues to innnovate in this space and delivers Operational Analytics - the ability to combine both OLTP/OLAP workloads in-memory and deliver real time insights to your business. You will not have to create and maintain operational data stores and replicate data, you will be able to place updatable non-clustered column store indexes right on your OLTP tables. This amongst many other performance enhancing capabilities will accelerate your time to insight.


Security - this has been an major area of focus for the engineering team, given organisations are embarking their journey onto the cloud. However putting your data into the cloud still a major barrier, however with the capability of Always Encrypted coming to SQL Server 2016 and already available in SQL Database in Azure, this can give you the confidence of placing your data in the cloud. The reason for this is the data is encrypted at rest, in transit, the only place it gets decrypted is at the client with the new enhanced ADO.NET connector. This is advanced technology from MS Research that will ensure your data is only available to those who have authority to it. This feature combined with other capabiliteis such as enhanced Transparent Database Encyrption (TDE), Row Level Security and Dynamic Data masking will provide the peace of mind your business demands of your data when in the cloud.

Cloud Integration - of course there will be situations where the data may not be able to moved into the cloud due to legislation, or other security requirements. However with the tight Hybrid integration with Azure, there maybe scenarios such as for archiving purposes you can utilise the Stretch Table feature that can enable you to move historical data into the cloud to reduce your storage costs while still ensuring your data is accessible without requiring any application changes. This amongst other tight integrations such as easily enabling Azure as a target destination for DR purposes via tight integration with AlwaysOn Wizard.

 

Business Intelligence - with the release of PowerBI version 2, you can immediately drive insight into your data with direct connectors into most popular software as a service offerings and also tight connectivity to many other sources such as Teradata, DB2, Sybase, ODBC sources. In case you haven't seen them, you can also download some great sample workbooks at - https://support.powerbi.com/knowledgebase/articles/514904-download-the-power-bi-samples-excel-workbooks

We all know that visulisation is like the icing on the cake, we need to ensure that the underlying base is solid - meaning the data is of quality, meaningful and timely. On this note SQL Server 2016 has several enhancements to the BI components such as MDS (performance and features),SSRS (new HTML5 compliant visualisations, parameter enhancements). SQL Server Analysis services is also getting many enhancements in Tabular model, including DirectQuery, this will enable you to get real time data not only leveraging SQL Server's in-memory capability however also allowing you to query non-SQL Server environments such as Oracle.

Analytics - this is a very exciting space, as not only does this enable a business to go from data to insights, it actually can enable them to automate decision making process and provide their customers with a delightful experience. In this space we acquried Revolution Analytics in April 2015. You will be able to continue to get access to RRO and RRE products, however with SQL Server 2016 you will have integration of RevoR, which will enable you to bring the power of R to your data. This will enable you to quickly operationalise your R models/scripts.


SQL Server 2005 is going to be End of Support by April 2016 - so now is great time to start planning your upgrades and start to take advantage of the more modern SQL Server 2012, 2014 and soon 2016. Microsoft® SQL Server 2016® Upgrade Advisor Preview - https://www.microsoft.com/en-us/download/details.aspx?id=48119

Download - http://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016

 

Imagine how Cortana Analytics Suite can help your organization set new records 🙂  - https://www.youtube.com/watch?v=YxmAEMmwXYU

Comments (7)
  1. wq says:

    http://www.tommyhilfiger.net.co/ with the
    http://www.woolrich-clearance.com/ big motor
    http://www.soccer-shoes.net/ and
    http://www.ralphlaurenoutlet-online.us.com/ not fishing
    http://www.outletonline-michaelkors.com/ at
    http://www.giuseppezanotti.com.co/ all.
    http://www.michael-kors-handbags.us.com/ But
    http://www.louis-vuitton-taschen.com.de/ don’t forget,
    http://www.rolex-watches.us.com/ you
    http://www.adidas-superstar.nl/ have http://www.nikerosherun.us/ to
    http://www.levisjeans.com.co/ sit down
    http://www.ralph-lauren.ca/ and start the motor,
    http://www.christianlouboutinshoesoutlet.org/ which takes
    http://www.swarovskijewelry.com.co/ a few seconds,
    http://www.michaelkors.com.se/ then
    http://www.pandora-charms-canada.ca/ an equal amount of
    http://www.tommy-hilfiger.co.nl/ seconds
    http://www.the-northface.us.org/ to
    http://www.michael-kors.com.es/ shut it down
    http://www.ferragamoshoes.net/ and
    http://www.michael-kors-outlet-online.us.org/ get back
    http://www.michael–kors.us.com/ to the
    http://www.abercrombie-and-fitch.us.com/ front
    http://www.uggsoutlet.com.co/ of http://www.giuseppe-zanotti.net/ the boat.
    http://www.uptocoachoutlet.com/ Then
    http://www.christian-louboutin-shoes.ca/ factor
    http://www.guccishoes.us.org/ in the
    http://www.bottega.us/ unattractive
    http://www.hollistercanada.ca/ noise that
    http://www.coco-chanelbags.us.com/ the idling makes,
    http://www.rayban-sunglasses.org.uk/ the excessive
    http://www.mcm-bags.in.net/ buzz the http://www.nikeair-max.es/ trolling
    http://www.louis-vuitton-australia.com.au/ motor
    http://www.coco-chanel.com.de/ makes
    http://www.oakleysunglasses.mex.com/ on
    http://www.nike-air-max.us/ high speed, and
    http://www.raybanwayfarer.in.net/ the fact that
    http://www.swarovskiuk.me.uk/ you
    http://www.newoutletonlinemall.com/ might get hung
    http://www.burberryhandbagsoutlet.in.net/ on
    http://www.chiflatiron.net.co/ the something
    http://www.p90xworkout.in.net/ random
    http://www.newbalance-shoes.org/ while
    http://www.ferragamo.com.co/ casting and
    http://www.beatsbydre.com.co/ waste http://www.oakley.com.de/ more time.
    http://www.guccihandbags.net.co/ All
    http://www.michaelkors-outlet-online.com.co/ in
    http://www.vans-shoes.net/ all,
    http://www.raybans.us.org/ you http://www.nikefactory.org/ could actually
    http://www.coachoutletstore-online.com.co/ conclude that you’re doing
    http://www.michael-kors-canada-outlet.ca/ more
    http://www.tiffany-andco.com.au/ damage
    http://www.hollisterclothingstore.org/ to
    http://www.swarovskicrystal.com.co/ the productivity of the
    http://www.thomassabo.uk/ area
    http://www.hermesbags.jp.net/ by
    http://www.new-balance-schuhe.de/ going
    http://www.converse.net.co/ fast http://www.swarovskicanada.ca/ than
    http://www.true-religion.com.co/ all
    http://www.beats-by-dre.com.co/ that
    http://www.hollister.us.org/ exhausting
    http://www.nfl-jersey.us.com/ behavior is worth.

  2. aw says:

    I think your article is very useful, it might be in more detail further suggest the method clearer method, can be of several categories that you created or any of several methods that should be done in the process of it, thank you very much
    http://www.lokerjobindo.com
    http://www.kerjabumn.com
    http://www.lokerjobindo.com/2015/10/lowongan-bumn-brantas-abipraya-persero.html
    http://www.kerjabumn.com/2015/10/lowongan-bumn-brantas-abipraya-persero.html
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-terbaru.html
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bumn-pt-nindya-karya.html
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bank-cimb-niaga.html
    http://www.lokerjobindo.com/2015/11/info-kerja-bumn-pt-sarana-multi.html
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-terbaru-pt-citilink.html
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-d3-s1-pt-hk-realtindo.html
    http://www.lokerjobindo.com/2015/11/info-kerja-bank-bri-frontliner.html
    http://www.lokerjobindo.com/2015/11/info-lowongan-kerja-staf-hubungan.html
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-pt-pertamina-retail.html
    http://www.lokerjobindo.com/2015/11/info-kerja-professional-insurance.html
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-it-programmer.html
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bank-bca-syariah.html
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bank-danamon.html
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-d3.html
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-pt-bni-life-insurance.html
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-pt-axa-mandiri.html
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bank-sinamrmas.html
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bank-mandiri-syariah.html
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-bank-btn.html
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-pt-astra-international.html
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-adira-finance.html
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-pertamina-geothermal.html
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-bank-bca.html
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-bank-jatim.html
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-terbaru-icon-pln.html
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-terbaru-s1-kalbe.html

  3. awerty says:

    http://www.lokerjobindo.com/2015/10/lowongan-kerja-terbaru-bank-central.html Lowongan Kerja Terbaru Bank Central Asia (Bank BCA)
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-terbaru-eni-indonesia.html Lowongan Kerja Terbaru Eni Indonesia
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-terbaru-frontliner-dll.html Lowongan Kerja Terbaru Frontliner DLL Bank Jatim
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-terbaru-icon-pln.html Lowongan Kerja Terbaru Icon PLN
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-terbaru-kemenko.html Lowongan Kerja Terbaru Kemenko Perekonomian
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-terbaru-pt-adaro-energy.html Lowongan Kerja Terbaru PT Adaro Energy Tbk
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-terbaru-pt-arutmin.html Lowongan Kerja Terbaru PT Arutmin Indonesia
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-terbaru-pt-citilink.html Lowongan Kerja Terbaru PT Citilink Indonesia
    http://www.lokerjobindo.com/2015/08/lowongan-kerja-terbaru-pt-darma-henwa.html Lowongan Kerja Terbaru PT Darma Henwa Tbk
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-terbaru-pt-honda.html Lowongan Kerja Terbaru PT Honda Prospect Motor 4 Posisi
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-terbaru-pt-pertamina.html Lowongan Kerja Terbaru PT Pertamina Retail
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-terbaru-pt-perusahaan.html Lowongan Kerja Terbaru PT Perusahaan Gas Negara (Persero) Tbk
    http://www.lokerjobindo.com/2015/08/lowongan-kerja-terbaru-pt-rekayasa.html Lowongan Kerja Terbaru PT Rekayasa Industri (Rekind)
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-terbaru-pt-yamaha.html Lowongan Kerja Terbaru PT Yamaha Indonesia Motor Mfg
    http://www.lokerjobindo.com/2015/11/lowongna-kerja-terbaru-pt-astra.html Lowongan Kerja Terbaru PT. Astra International, Tbk
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-terbaru-pt-infomedia.html Lowongan Kerja Terbaru PT. Infomedia Nusantara by Telkom Indonesia
    http://www.lokerjobindo.com/2015/09/lowongan-kerja-terbaru-pelaksana-back.html Lowongan Kerja Terbaru Pelaksana Back Office PT. Bank Mandiri (Persero) Tbk
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-terbaru-perum-lkbn-antara.html Lowongan Kerja Terbaru Perum LKBN Antara
    http://www.lokerjobindo.com/2015/09/lowongan-kerja-terbaru-program.html Lowongan Kerja Terbaru Program Pengembangan Staff (PPS) IT – PPS IT BRI
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-terbaru-s1-kalbe.html Lowongan Kerja Terbaru S1 KALBE Nutritionals
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-terbaru-staff-produksi.html Lowongan Kerja Terbaru Staff Produksi PT. Asian Isuzu Casting Center (AICC)

  4. awertyu says:

    http://www.lokerjobindo.com/2015/10/lowongan-kerja-terbaru-treasury-officer.html Lowongan Kerja Terbaru Treasury Officer PT Citilink Indonesia
    http://www.lokerjobindo.com/2015/08/lowongan-kerja-terbaru-unilever.html Lowongan Kerja Terbaru Unilever Indonesia
    http://www.lokerjobindo.com/2015/09/lowongan-kerja-training-development.html Lowongan Kerja Training Development Manager PT. Telkom Akses
    http://www.lokerjobindo.com/2015/09/lowongan-kerja-trans-7-terbaru-2015.html Lowongan Kerja Trans 7 Terbaru 2015
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-trans7.html Lowongan Kerja Trans7
    http://www.lokerjobindo.com/2015/09/lowongan-kerja-unilever-4-posisi.html Lowongan Kerja Unilever (4 Posisi)
    http://www.lokerjobindo.com/2015/08/lowongan-kerja-web-developer-pt-sarana.html Lowongan Kerja Web Developer PT Sarana Multi Infrastruktur (Persero)
    http://www.lokerjobindo.com/2015/09/lowongan-kerja-di-pt-syncore-indonesia.html Lowongan Kerja di PT. Syncore Indonesia – Yogyakarta (Programmer Web, Konsultan Akuntansi)

  5. werty says:

    http://www.lokerjobindo.com/2015/10/lowongan-kerja-terbaru-treasury-officer.html Lowongan Kerja Terbaru Treasury Officer PT Citilink Indonesia
    http://www.lokerjobindo.com/2015/08/lowongan-kerja-terbaru-unilever.html Lowongan Kerja Terbaru Unilever Indonesia
    http://www.lokerjobindo.com/2015/09/lowongan-kerja-training-development.html Lowongan Kerja Training Development Manager PT. Telkom Akses
    http://www.lokerjobindo.com/2015/09/lowongan-kerja-trans-7-terbaru-2015.html Lowongan Kerja Trans 7 Terbaru 2015
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-trans7.html Lowongan Kerja Trans7
    http://www.lokerjobindo.com/2015/09/lowongan-kerja-unilever-4-posisi.html Lowongan Kerja Unilever (4 Posisi)
    http://www.lokerjobindo.com/2015/08/lowongan-kerja-web-developer-pt-sarana.html Lowongan Kerja Web Developer PT Sarana Multi Infrastruktur (Persero)
    http://www.lokerjobindo.com/2015/09/lowongan-kerja-di-pt-syncore-indonesia.html Lowongan Kerja di PT. Syncore Indonesia – Yogyakarta (Programmer Web, Konsultan Akuntansi)

  6. aw says:

    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Depnaker
    http://www.lokerjobindo.com
    http://lokerjobindo.com
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Agustus
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20April
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Desember
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Februari
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Januari
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Juli
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Juni
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Maret
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Mei
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20November
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Oktober
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20September
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20BursaKerja
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20CPNS
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20BRI
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20Mandiri
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Banyak%20Posisi
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20BUMN
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Terbaru
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Terkini
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20CPNS
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20D1
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20D2
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20D3
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20D4
    http://www.lokerjobindo.com/2015/12/lowongan-kerja-terbaru-2016-pt-yamaha.html
    http://www.lokerjobindo.com/2015/12/lowongan-kerja-terbaru-tahun-2016-pt.html
    http://www.lokerjobindo.com/2015/12/lowongan-kerja-2016-pt-bank-uob.html
    http://www.lokerjobindo.com/2015/12/lowongan-kerja-bumn-pt-bhanda-ghara.html
    http://www.lokerjobindo.com/2015/12/lowongan-kerja-bumn-pt-sucofindo.html
    http://www.lokerjobindo.com/2015/12/lowongan-kerja-bank-bukopin_15.html
    http://www.lokerjobindo.com/2015/12/lowongan-kerja-s1-bank-central-asia.html
    http://www.lokerjobindo.com/2015/12/lowongan-kerja-stm-sma-smk-pt-darma.html
    http://www.lokerjobindo.com/2015/09/lowongan-kerja-2016.html
    http://www.lokerjobindo.com/2015/08/info-lowongan-kerja-bulan-januari-2016.html

Comments are closed.

Skip to main content