Monthly Archives: May 2017

SSAS high availability

If you are looking at providing high availability (HA) for SSAS, here are 3 options: Install SSAS on a Windows Server Failover Cluster (WSFC) Here’s a good article. The main issue with this option is that SSAS isn’t cluster-aware, so … Continue reading

Posted in SQLServerPedia Syndication, SSAS | 5 Comments

SQL Data Warehouse reference architectures

With so many product options to choose from for building a big data solution in the cloud, such as SQL Data Warehouse (SQL DW), Azure Analysis Services (AAS), SQL Database (SQL DB), and Azure Data Lake (ADL), there are various combinations … Continue reading

Posted in Azure SQL DW, Data Lake, Data warehouse, SQLServerPedia Syndication | 6 Comments

Microsoft Build event announcements

Another Microsoft event and another bunch of exciting announcements.  At the Microsoft Build event this week, the major announcements in the data platform space were: Azure Cosmos DB Azure Cosmos DB is the next big leap in the evolution of … Continue reading

Posted in SQLServerPedia Syndication | 2 Comments

Power BI Premium, Report Server, Apps and API

Announced today are some really cool new Power BI features: Power BI Premium Previously available were two tiers, Power BI Free and Power BI Pro ($10/user/month).  The problem with Power BI Pro is that for large organizations, this can add … Continue reading

Posted in Power BI, SQLServerPedia Syndication | 15 Comments