Recently a client asked me whether they should use tabular or multidimensional model for creating the BI (business intelligence) semantic model. I choose the tabular route due to the following reasons. Reasons to go the Tabular route If you want to use DAX (based on Excel formulas, but is often seen as having a steep […]
SQL Server is Microsoft’s flagship database product and has been in use for more than a decade. Microsoft recently announced to release SQL Server 2016 next year and has already released the preview version. The new 2016 release will have significant improvements in security features, in-memory OLTP, analytics and Stretch Database. Here is a list of […]
Why Big Data? Big data solutions are primarily meant to address the three core data-related challenges faced at enterprise level. These are also called the “3 V’s Problem”. Volume: A Big data solution stores and queries 100’s of TB of data. The total volume of data grows by 10 times every five years. Storage must […]