In this video, Scot Reagin couples discussion with demonstration to give you not just an understanding of the functional differences between multidimensional and tabular models, but also the context to understand where and why each should be implemented.

This article will show you how to execute DBCC for Analysis Services using XMLA queries. Database Console Commands (DBCC), a collection of Transact-SQL statements, allow you to perform maintenance tasks, validate operations on a database or database component, retrieve SQL Server information, and other miscellaneous tasks such as enabling a trace flag.

Scot Reagin and Steve Nogradi will be speaking at SQL Saturday in Philadelphia June 3rd. Agility and Business Intelligence are two good things that often struggle to be good together. A primary cause of this struggle is the inability of traditional Data Warehouse models to respond to change in a (business) timely manner. Data Vault is Read more about SQL Saturday Philadelphia June 3, 2017[…]

Every organization struggles to ensure data is up to date and consistent across multiple systems. Failing to solve this problem means managers spend more time resolving issues than running the company. Read how the Hub can help.