Azure SSAS. Cubes in Clouds

Autumn of 2016 was full of events from Microsoft dedicated to analytics. In practice, the company began aggressive promotion of its predictive analytics and BI platform in the cloud. Finally, it has happened – Microsoft has released the preview of Azure SSAS Tabular. In fact, the company has transferred SSAS Tabular to the cloud. Therefore, SQL Server Analysis Enterprise Edition in cloud  supports DirectQuery, partitions, row-level security, bi-directional relationships, and has compatibility level 1200.

(more…)

Query Performance Insight: Discovering What Consumes Resources of Your Azure SQL Database?

In this post, I’d like to take a brief look at the Query Performance Insight — SQL Azure tool which will help you to identify the most expensive queries in your database.

Query Performance Insights was announced in early October 2015. To understand what it is, let’s think about how do you usually learn that the database performance got down? Probably, you are receiving emails from your clients or it takes an hour to create a weekly report instead of a several minutes, or maybe, your application starts throwing exceptions. (more…)