Data Warehouse

Azure Synapse

Azure Synapse Shorts – Table Distributions

Chris Seferlis explains why Azure Synapse is one of the leading platform for Cloud Scale Analytics in any Cloud. Part of the reason for that is the flexibility and capability that is provided to build your analytic solutions that will work best for you and your data. Of course that starts with performance, and most […]

Read More
Data Warehouse Databricks

Becoming a Data Driven Organization with Modern Lakehouse

I often say that “Data is the new oil,” but to transform it into anything useful, you need a high performing oil refinery. This talk by Databricks highlights the emerging “Lakehouse” pattern that’s taking enterprises by storm.

Read More
Data Driven

Dave Wentzel on Why You Don’t Need a Data Warehouse

In this episode of Data Driven, Frank and Andy chat with Philadelphia Microsoft Technology Center Data Architect Dave Wentzel on why you do not need a data warehouse. Also, Frank discusses leaving Microsoft, Frank and Andy talk about five seasons of Data Driven, and even BAILeY has a sentimental moment.Show NotesComing Soon. Press the play […]

Read More
Azure Synapse

What Does Azure Synapse Mean for My Modern Data Warehouse?

Skill Me UP posted this session on what Synapse means for your modern data warehouse. In this session we will explore Azure Synapse, the interface, the technology and the development studio to evaluate what impact the latest Massively Parallel Processing compute engine in Azure will have on my existing or planned Modern Data Warehouse on […]

Read More
Azure Synapse

Connecting to External Data with Azure Synapse

In this video Chris Seferlis gives a quick demonstration of connecting an external data source to my Synapse environment and the differences in performance between connecting as an external table or querying directly off of blob storage. Then he goes into the difference in external table and how that differs from copying the data right […]

Read More
Databricks

Delta Lakehouse Data Profiler and SQL Analytics Demo

Coming from a data warehousing and BI background, Franco Patano wanted to have a catalogue of the Lakehouse, including schema and profiling statistics. He created the Lakehouse Data Profiler notebook using Python and SQL to analyze the data and generate schema and statistics tables. He then uses the new SQL Analytics product from Databricks to […]

Read More
Azure Azure Synapse

Azure Synapse, Predictive Maintenance, Safety, and Efficiency at GE Aviation

Microsoft Mechanics shows us a practical use case for Predictive Maintenance, Safety, and Efficiency through Microsoft Azure Synapse. Find out how Azure Synapse is part of the next-generation data and analytics platform for global aviation tech company, GE Aviation. Jeremy Chapman speaks with Luke Bowman, Senior Product Manager at GE Aviation’s Digital Group, to discuss […]

Read More
Data Warehouse Databricks

Slowly Changing Dimensions (SCD) Type 2

Databricks recently streamed this tech chat on SCD, or Slowly Changing Dimensions. We will discuss a popular online analytics processing (OLAP) fundamental – slowly changing dimensions (SCD) – specifically Type-2. As we have discussed in various other Delta Lake tech talks, the reliability brought to data lakes by Delta Lake has brought a resurgence of […]

Read More