Category Archives: SQLServerPedia Syndication

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

IoT Hub vs. Event Hub

There can sometimes be confusion, in IoT scenarios, between IoT Hub and Event Hub, as they can both be valid choices for streaming data ingestion.  My Microsoft colleague, Steve Busby, an IoT Technology Specialist, is here to clear up the … Continue reading

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

Microsoft Products vs Hadoop/OSS Products

Microsoft’s end goal is for Azure to become the best cloud platform for customers to run their data workloads.  This means Microsoft will provide customers the best environment to run their big data/Hadoop as well as a place where Microsoft … Continue reading

Posted in Hadoop, SQLServerPedia Syndication | Comments Off on Microsoft Products vs Hadoop/OSS Products

Create quick queries quickly with SSAS in Azure

In a perfect world a data warehouse would always return all queries very quickly, no matter what the size or complexity of the data warehouse.  But the reality is that sometimes we won’t get the performance we need from the … Continue reading

Posted in SQLServerPedia Syndication, SSAS | 6 Comments

Data gateway confusion

Microsoft has created data gateways as a way that cloud products such as Power BI and Azure Machine Learning can access on-prem data, often called a hybrid model.  This is most useful for companies that do not want to put … Continue reading

Posted in SQLServerPedia Syndication | 2 Comments

What is HTAP?

I have been seeing the term “HTAP” mentioned a lot recently, and I thought I would briefly explain the term.  HTAP stands for Hybrid Transactional and Analytical Processing. HTAP is used to describe the capability of a single database that can … Continue reading

Posted in SQLServerPedia Syndication | 1 Comment