Similar to SQL Server, Hive has a number of performance-related features. Hive supports indexes and, like the clustered ColumnStore index introduced in SQL Server 2014, an optimized table format called Optimized Row Columnar (ORC). Note: the use...

In late 2011, Dr. David Dewitt presented a Big Data keynote session, focused primarily on Hadoop, at the Professional Association for SQL Server (PASS) Summit event. Dr. Dewitt's keynote session is a great primer for learning more about Hadoop...

Embrace the inevitable analytics market evolution or be left behind

In the latest September round of monthly Power BI updates, a really cool addition for Power Map was released called Custom Maps. Custom Maps empower you to get incredibly creative with regards to your position related visualizations in retail s...

Common REST API for developing the backend for mobile and web apps

In a refreshing change of pace, new Microsoft Business Intelligence General Manager, James Phillips, revealed upcoming Power BI user experience changes at World Partner Conference (WPC) last week. Phillips brings a brilliant, practical, fast-mo...