Tag: Xvelocity

SQL Server

Microsoft SQL Server 2014 Community Technology Preview 1 (CTP1) is ready to download

SQL server 2014 Community Technology Preview 1 (CTP1) is ready to download here: http://technet.microsoft.com/en-us/evalcenter/dn205290.aspx

Key Features

Project code-named “Hekaton”

One of the most exciting features in this version is a project code-named “Hekaton” that provides in-memory OLTP capabilities. As Hekaton is built into core SQL Server database it will improve the performance of the database applications significantly. It is more interesting that Hekaton is installed with SQL Server 2014 engine that means no additional action is needed to use the benefits of in-memory processing without rewriting the database application. It is really awesome that it can increase performance of existing database application without having to upgrade the hardware. Microsoft claims that Hekaton is easy to deploy and allows to access the other features in SQL Server, while taking the advantage of in-memory performance.

Continue reading “Microsoft SQL Server 2014 Community Technology Preview 1 (CTP1) is ready to download” →

Business Intelligence - BI, SQL Server Analysis Services - SSAS

Three different approaches for creating a BISM in SSAS 2012, Tabular vs. Multidimensional vs. PowerPivot

SSAS 2012 supports three different approaches for creating a BISM (Business Intelligence Semantic Model):

1. Tabular

a. Uses relational modelling constructs like such as tables and relationships

b. Uses xVelocity in-memory analytics engine for sorting and data calculations

c. Needs to use SSDT (SQL Server Data Tools) to implement

d. Can import data from relational data sources using OLE DB native and managed providers

e. Tabular solutions only support one model.bim file per solution, which means that all work must be done in a single file. Development teams that are accustomed to working with multiple projects in a single solution might need to revise how they work when building a shared tabular solution.

f. support DAX calculations, DAX queries, and MDX queries

g. Tabular model databases can use row-level security, using role-based permissions in Analysis Services (DAX implementation required)

h. It might be not a good choice for the systems that are going to load terabytes of data

Continue reading “Three different approaches for creating a BISM in SSAS 2012, Tabular vs. Multidimensional vs. PowerPivot” →