{"id":4452,"date":"2016-05-16T08:08:04","date_gmt":"2016-05-16T07:08:04","guid":{"rendered":"http:\/\/www.onomi.co.uk\/?p=4452"},"modified":"2018-08-21T11:12:20","modified_gmt":"2018-08-21T10:12:20","slug":"sql-server-2016-new-features","status":"publish","type":"post","link":"http:\/\/content.n4stack.io\/2016\/05\/16\/sql-server-2016-new-features\/","title":{"rendered":"What IT leaders need to know about SQL Server 2016"},"content":{"rendered":"

[et_pb_section admin_label=”section”][et_pb_row admin_label=”row”][et_pb_column type=”4_4″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left” use_border_color=”off” border_color=”#ffffff” border_style=”solid”]<\/p>\n

Introducing SQL Server 2016….<\/strong><\/h2>\n

It case you have missed all the \u201cdata drivel\u201d, sorry \u201cdata driven\u201d marketing around the release of SQL Server 2016, Microsoft\u2019s latest offering is available to buy on 1st\u00a0<\/span>June. There is already a lot of information available around the new version but it\u2019s either marketing hype (picture fast blue car overtaking slightly slower (Oracle) red car) or a propeller headed in depth technical analysis. I wanted to try and have a stab at summarising what\u2019s changing for the less technical person that wants to get underneath the hyperbole.<\/p>\n

Hype aside, SQL Server 2016 looks like it\u2019s going to be a significant release and it seems like Microsoft are really defending their territory against a wave of new database technologies, stepping up to match Oracle for a number of enterprise features and starting to flex their cloud muscle. Here\u2019s a quick rundown of the key points, note I have flagged which editions (Standard or Enterprise) benefit from the feature:<\/p>\n

Stretch Database:<\/strong> This new feature is really aimed at customers with millions\/ billions of rows in their tables and the best use case is for archiving cold data. At a granular level (row level) you can pick the data that is infrequently used and farm it out to Azure, it\u2019s a very simple wizard that handles the migration of data in the background. Therefore, if you are considering a blended storage strategy for your database which includes archiving this could be a good fit. You\u2019ll need to buy a compute node on Azure (from \u00a3568 per month) and then the great news is you only need the RA-GRS blob storage which is \u00a30.0229\/GB\/ Month, there are some outbound data transfer costs but if the data isn\u2019t requested very often this should be minimal.\u00a0 As this is all handled natively in SQL Server the application doesn\u2019t need to worry that some of the data isn\u2019t held locally, you can\u2019t beat the speed of light so there will be some network latency but the integration is very impressive. (STD\/ ENT)<\/p>\n

A new BAG: <\/strong>Basic Availability Groups makes an entrance for Standard edition replacing Database Mirroring. BAG is a bit of a taster for\u00a0AAG with a couple of restrictions namely, you can\u2019t read from the second node and it only covers one database. Having done a bit of testing it looks like you can create multiple BAG\u2019s but it may end up a bit messy. It will prove useful in a few use cases, but I don\u2019t think will help too many customers who buy Enterprise for just the AAG functionality (which is greatly improved in 2016) and run multiple databases on an instance. (STD)<\/p>\n

Vastly improved security: <\/strong>A big improvement area in Standard Edition are two security features called Data Masking and Row Level Security. They provide a lot more control around user\u2019s ability to view data, Data Masking will obfuscate data at table or column level so the query data remains protected from prying eyes (useful for credit cards or personal data). Row Level Security provides the access policy at a row level around which user can see what data, this will be very useful to prevent human error especially in SaaS environments where you need to be very vigilant with multiple customers. The killer Enterprise feature is Always Encryption which builds on the previous TDE feature to ensure data is encrypted in memory and in transit, moving to a model whereby the encryption keys stay on the application \u201ctrusted\u201d side.<\/p>\n

RIP BI Edition:<\/strong> It looks like Business Intelligence edition has been removed therefore, if you are currently using this and have a CAL based agreement I would check with your Microsoft rep around your options. There will be an upgrade path but you will more than likely need to move up to Enterprise. Therefore, it may be worth bagging a few extra CALs over the next couple of weeks for any growth requirements in your current financial year.<\/p>\n

Happy Developers: <\/strong>One of the biggest requested features for 2016 was JSON support. With more and more development teams using object orientated languages you may have heard the moans around all the extra pain working with a RDBMS system and a business case for NoSQL may have even landed on your desk. Microsoft hasn\u2019t gone the whole hog, they haven\u2019t provide a specific JSON data type as it\u2019s represented as a NVARCHAR type, but it\u2019s a step in the right direction and will certainly help development teams. (STD\/ENT)<\/p>\n

Happy Analysts: <\/strong>Your analysts and data scientists can roll around in a grassy meadow full of wonderful new and improved integration, topped off with improved in-memory analytics. Support for R will be well received by the rapidly growing user community and improved Polybase provides the ability to use T-SQL queries to run against data stores such as Hadoop. With the demand especially in industries such as Retail and Finance for real time analytics to either send a product offer in real time whilst you are shopping or detect fraud, the enhanced in-memory capability provides more scope to keep a larger working set in RAM minimising query time significantly. Microsoft are even questioning the need in some use cases for a separate data warehouse, it seems all these new features may reflect a trend for using Hadoop for Offline Analytics and a RAM heavy database for Real time. (Largely ENT, Basic R integration in STD).<\/p>\n

Free Licences: <\/strong>If you are an unhappy Oracle customer and are thinking of moving to SQL Server, then you need to get your skates on as Microsoft are offering free licences until the end of June (may be extended). There are a few stipulations i) There is a 50 core minimum that you\u2019ll need to agree to for SQL Server, this can be phased though over time; ii) you do need to buy software assurance for the free licences and iii) you\u2019ll need to sign up to a Server Cloud Enrolment (SCE) agreement more information on the offer can be found here<\/a><\/span>.<\/p>\n

I have picked out the main points there are more, but hopefully it gives you a flavour of what\u2019s coming in SQL Server 2016.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

Introducing SQL Server 2016…. It case you have missed all the \u201cdata drivel\u201d, sorry \u201cdata driven\u201d marketing around the release of SQL Server 2016, Microsoft\u2019s latest offering is available to buy on 1st\u00a0June. There is already a lot of information available around the new version but it\u2019s either marketing hype (picture fast blue car overtaking […]<\/p>\n","protected":false},"author":1,"featured_media":52832,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"

Introducing SQL Server 2016....<\/strong><\/h2>

It case you have missed all \u201cdata drivel\u201d, sorry \u201cdata driven\u201d marketing around the release of SQL Server 2016 Microsoft\u2019s latest offering is available to buy on 1st\u00a0<\/span>June. There is already a lot of information available around the new version but it\u2019s either marketing hype (picture fast blue car overtaking slightly slower (Oracle) red car) or a propeller headed in depth technical analysis. I wanted to try and have a stab at summarising what\u2019s changing for the less technical person that wants to get underneath the hyperbole.<\/p>

Hype aside, SQL Server 2016 looks like it\u2019s going to be a significant release and it seems like Microsoft are really defending their territory against a wave of new database technologies, stepping up to match Oracle for a number of enterprise features and starting to flex their cloud muscle. Here\u2019s a quick rundown of the key points, note I have flagged which editions (Standard or Enterprise) benefit from the feature:<\/p>

Stretch Database:<\/strong> This new feature is really aimed at customers with millions\/ billions of rows in their tables and the best use case is for archiving cold data. At a granular level (row level) you can pick the data that is infrequently used and farm it out to Azure, it\u2019s a very simple wizard that handles the migration of data in the background. Therefore, if you are considering a blended storage strategy for your database which includes archiving this could be a good fit. You\u2019ll need to buy a compute node on Azure (from \u00a3568 per month) and then the great news is you only need the RA-GRS blob storage which is \u00a30.0229\/GB\/ Month, there are some outbound data transfer costs but if the data isn\u2019t requested very often this should be minimal.\u00a0 As this is all handled natively in SQL Server the application doesn\u2019t need to worry that some of the data isn\u2019t held locally, you can\u2019t beat the speed of light so there will be some network latency but the integration is very impressive. (STD\/ ENT)<\/p>

A new BAG: <\/strong>Basic Availability Groups makes an entrance for Standard edition replacing Database Mirroring. BAG is a bit of a poor man\u2019s AAG with a couple of restrictions namely, you can\u2019t read from the second node and it only covers one database. Not many customers will just have one database, having done a bit of testing it looks like you can create multiple BAG\u2019s but it may end up a bit messy and I don\u2019t think will help too many customers who buy Enterprise for just the AAG functionality (which is greatly improved in 2016). (STD)<\/p>

Vastly improved security: <\/strong>A big improvement area in Standard Edition are two security features called Data Masking and Row Level Security. They provide a lot more control around user\u2019s ability to view data, Data Masking will obfuscate data at table or column level so the query data remains protected from prying eyes (useful for credit cards or personal data). Row Level Security provides the access policy at a row level around which user can see what data, this will be very useful to prevent human error especially in SaaS environments where you need to be very vigilant with multiple customer. The killer Enterprise feature is Always Encryption which builds on the previous TDE feature to ensure data is encrypted in memory and in transit, moving to a model whereby the encryption keys stay on the application \u201ctrusted\u201d side.<\/p>

RIP BI Edition:<\/strong> It looks like Business Intelligence edition has been removed therefore, if you are currently using this and have a CAL based agreement I would check with your Microsoft rep around your options. There will be an upgrade path but you will more than likely need to move up to Enterprise. Therefore, it may be worth bagging a few extra CALs over the next couple of weeks for any growth requirements in your current financial year.<\/p>

Happy Developers: <\/strong>One of the biggest requested features for 2016 was JSON support. With more and more development teams using object orientated languages you may have heard the moans around all the extra pain working with a RDBMS system and a business case for NoSQL may have even landed on your desk. Microsoft hasn\u2019t gone the whole hog, they haven\u2019t provide a specific JSON data type as it\u2019s represented as a NVARCHAR type, but it\u2019s a step in the right direction and will certainly help development teams. (STD\/ENT)<\/p>

Happy Analysts: <\/strong>Your analysts and data scientists can roll around in a grassy meadow full of wonderful new and improved integration, topped off with improved in-memory analytics. Support for R will be well received by the rapidly growing user community and improved Polybase provides the ability to use T-SQL queries to run against data stores such as Hadoop. With the demand especially in industries such as Retail and Finance for real time analytics to either send a product offer in real time whilst you are shopping or detect fraud, the enhanced in-memory capability provides more scope to keep a larger working set in RAM minimising query time significantly. Microsoft are even questioning the need in some use cases for a separate data warehouse, it seems all these new features may reflect a trend for using Hadoop for Offline Analytics and a RAM heavy database for Real time. (Largely ENT, Basic R integration in STD).<\/p>

Free Licences: <\/strong>If you are an unhappy Oracle customer and are thinking of moving to SQL Server, then you need to get your skates on as Microsoft are offering free licences until the end of June (may be extended). There are a few stipulations i) There is a 50 core minimum that you\u2019ll need to agree to for SQL Server, this can be phased though over time; ii) you do need to buy software assurance for the free licences and iii) you\u2019ll need to sign up to a Server Cloud Enrolment (SCE) agreement more information on the offer can be found here<\/a>.<\/p>

I have picked out the main points there are more, but hopefully it gives you a flavour of what\u2019s coming in SQL Server 2016.<\/p>","_et_gb_content_width":""},"categories":[484,344],"tags":[345,346],"yst_prominent_words":[404,269,1892,159,1890,212,1889,1894,660,1891,1865,1893,1887,1886,409,1888,570,175,1640,1845],"_links":{"self":[{"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/posts\/4452"}],"collection":[{"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/comments?post=4452"}],"version-history":[{"count":1,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/posts\/4452\/revisions"}],"predecessor-version":[{"id":52833,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/posts\/4452\/revisions\/52833"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/media\/52832"}],"wp:attachment":[{"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/media?parent=4452"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/categories?post=4452"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/tags?post=4452"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/yst_prominent_words?post=4452"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}