{"id":752,"date":"2012-03-19T00:12:37","date_gmt":"2012-03-19T00:12:37","guid":{"rendered":"http:\/\/bicortex.com\/?p=752"},"modified":"2012-07-27T06:13:23","modified_gmt":"2012-07-27T06:13:23","slug":"top-bi-features-of-sql-server-2012","status":"publish","type":"post","link":"http:\/\/bicortex.com\/bicortex\/top-bi-features-of-sql-server-2012\/","title":{"rendered":"Top BI Features of MS SQL Server 2012"},"content":{"rendered":"<p style=\"text-align: justify;\">Microsoft has introduced SQL Server 2012 to the world (out 1<sup>st<\/sup> April) with a number of new features exclusive to this version only. DBAs will be happy at the announcement of such facades of this release as \u2018AlwaysOn\u2019 availability groups, user-defined server roles or enhanced auditing features; however it is the BI components additions\/changes that really define this version as class-leading. Microsoft has been saying for a while that the core data base engine is already very good thus concentrating on the BI functionality in more details and it certainly shows. Analytics and BI gained a number of features; some of the most prominent ones are as follows:<\/p>\n<ul>\n<li style=\"text-align: justify;\">\u00a0 Columnstore Indexes &#8212; This a powerful new feature that is completely unique to SQL Server. They are special type of read-only index designed to be use with Data Warehouse queries. Basically, data is grouped and stored in a flat, compressed column index, greatly reducing I\/O and memory utilization on large queries.<\/li>\n<li style=\"text-align: justify;\">BI Semantic Model &#8212; This is replacing the Analysis Services Unified Dimensional Model (or cubes most people referred to them). It&#8217;s a hybrid model that allows one data model will support all BI experiences in SQL Server. Additionally, this will allow for some really professional text infographics.<\/li>\n<li style=\"text-align: justify;\">PowerView &#8212; You may have heard of this under the name &#8220;Project Crescent&#8221; it is a fairly powerful self-service BI toolkit that allows users to create mash ups of BI reports from all over the Enterprise.<\/li>\n<li style=\"text-align: justify;\">Big Data Support &#8212; Introduced at the PASS (Professional Association for SQL Server) conference last year, Microsoft announced a partnership with Hadoop provider Cloudera. One part of this involves MS releasing an ODBC driver for SQL Server that will run on a Linux platform. Additionally, Microsoft is building connectors for Hadoop, which is an extremely popular NoSQL platform. With this announcement, Microsoft has made a clear move into this very rapidly growing space.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft has introduced SQL Server 2012 to the world (out 1st April) with a number of new features exclusive to this version only. DBAs will be happy at the announcement of such facades of this release as \u2018AlwaysOn\u2019 availability groups, user-defined server roles or enhanced auditing features; however it is the BI components additions\/changes that [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,28],"tags":[14,18,20,19,52],"class_list":["post-752","post","type-post","status-publish","format-standard","hentry","category-sql","category-this-and-that","tag-big-data","tag-microsoft","tag-powerview","tag-sql-server","tag-this-and-that"],"aioseo_notices":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/bicortex.com\/bicortex\/wp-json\/wp\/v2\/posts\/752","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bicortex.com\/bicortex\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bicortex.com\/bicortex\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bicortex.com\/bicortex\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/bicortex.com\/bicortex\/wp-json\/wp\/v2\/comments?post=752"}],"version-history":[{"count":5,"href":"http:\/\/bicortex.com\/bicortex\/wp-json\/wp\/v2\/posts\/752\/revisions"}],"predecessor-version":[{"id":756,"href":"http:\/\/bicortex.com\/bicortex\/wp-json\/wp\/v2\/posts\/752\/revisions\/756"}],"wp:attachment":[{"href":"http:\/\/bicortex.com\/bicortex\/wp-json\/wp\/v2\/media?parent=752"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bicortex.com\/bicortex\/wp-json\/wp\/v2\/categories?post=752"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bicortex.com\/bicortex\/wp-json\/wp\/v2\/tags?post=752"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}