Category Archives: SQLServerPedia Syndication

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 | Leave a comment

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 | 3 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 | Leave a comment

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

Microsoft Data Amp event announcements

Yesterday was the Microsoft Data Amp event where a bunch of very exciting announcements were made: SQL Server vNext CTP 2.0 is now available and the product will be officially called SQL Server 2017: Runs on Linux and Docker Support … Continue reading

Posted in Azure, Azure SQL Database, Cortana Intelligence Suite, SQLServerPedia Syndication | 1 Comment

Using Azure for free

There are a number of options for using Azure for free.  This is very useful for those of you who are not familiar with Azure and want to “play” with it: Create a free Azure account and get $200 in … Continue reading

Posted in Azure, SQLServerPedia Syndication | 1 Comment

Artificial Intelligence defined

The new buzzword in the industry is “Artificial Intelligence” (AI).  But exactly what is AI and how does it compare to “machine learning” and “deep learning”?  The best definitions I have seen come from the excellent article “Why Deep Learning … Continue reading

Posted in SQLServerPedia Syndication | 2 Comments

Microsoft database migration tools

There are various Microsoft tools that you can use to help you migrate your database: Data Migration Assistant (DMA) – enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your … Continue reading

Posted in SQL Server, SQLServerPedia Syndication | 3 Comments

U-SQL Defined

Azure Data Lake Analytics (ADLA) is a distributed analytics service built on Apache YARN that allows developers to be productive immediately on big data.  This is accomplished by submitting a job to the service where the service will automatically run it … Continue reading

Posted in Azure Data Lake, PolyBase, SQLServerPedia Syndication | 2 Comments

PolyBase use cases clarified

I previously talked about PolyBase and its enhancements (see PASS Summit Announcements: PolyBase enhancements).  There is some confusion on PolyBase use cases as they are different depending on whether you are using PolyBase with Azure SQL Data Warehouse (SQL DW) or … Continue reading

Posted in PolyBase, SQLServerPedia Syndication | 3 Comments