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...
2017-03-09
565 reads
James Serra's Blog
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....
2017-03-01
427 reads
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...
2017-02-08
330 reads
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...
2017-01-18
336 reads
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...
2017-01-04
267 reads
Data gateway confusion
Microsoft has created data gateways as a way that cloud products such as Power BI and Azure Machine Learning can...
2016-12-21
404 reads
What is HTAP?
I have been seeing the term “HTAP” mentioned a lot recently, and I thought I would briefly explain the term....
2016-12-14
310 reads
Total Cost of Ownership (TCO) Calculator
For a long time clients would ask me how to determine the cost savings by migrating their applications and databases...
2016-12-06
1,163 reads
Azure Advisor
Azure Advisor is a really cool personalized recommendation engine that provides you with proactive best practices guidance on High Availability,...
2016-12-01
308 reads
Analytics Platform System 2016 Release
Microsoft has a new release for the Analytics Platform System (APS). This appliance update is called APS 2016 and has...
2016-11-29
516 reads
Blogs
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
Have a Plan for Your Personal Downtime
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Forums
Count of Total Appointments within 30 days of each Appointment Date
Good Afternoon. I have a Table where each Record: 1) Represents an Appointment. 2)...
Reporting Services in Managed Instance
Hi , one of my on-premises servers one server is having databases and one...
EXTENDED EVENTS Track What's Logging In
Simple one looking for a script that can track what's logging in from where...