Monthly Archives: March 2017

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

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 | 2 Comments

SQL DB now supports 4TB max database size

Azure SQL Database (SQL DB) has increased its max database size from 1TB to 4TB at no additional cost. Customers using P11 and P15 premium performance levels can use up to 4 TB of included storage at no additional charge. … Continue reading

Posted in Azure SQL Database, SQLServerPedia Syndication | Leave a comment

Power BI and Excel options for Hadoop

Below I have attempted to list the various options for reporting off of Hadoop (HDInsight, HDP, Cloudera) using Power BI Desktop and Excel.  Some of the data sources prompt you to choose the Data Connectivity mode of either Import or … Continue reading

Posted in Excel, PolyBase, Power BI, SQLServerPedia Syndication | Leave a comment

Azure Data Factory and SSIS compared

I see a lot of confusion when it comes to Azure Data Factory (ADF) and how it compares to SSIS.  It is not simply “SSIS in the cloud”.  See What is Azure Data Factory? for an overview of ADF, and I’ll assume … Continue reading

Posted in Azure Data Factory, SQLServerPedia Syndication, SSIS | 4 Comments