Fabric Analytics for SQL folks: Part 1 – Fabric demystified
Summary In a landscape abundant with AI innovations and promises, a crucial question arises: « Is leveraging SQL and […]
Data Warehouse
Data Warehouse Considerations – SCD Type 2 vs Overwrite Dimension ...
The post Data Warehouse Considerations – SCD Type 2 vs Overwrite Dimension Tables appeared first on SQLServerCentral.
Granting Permissions in a Fabric Data Warehouse and Lakehouse
We are becoming used to being a bit lazy when granting permissions to Data Warehouses and lakehouses […]
Choosing Between the Lakehouse and Warehouse in Microsoft Fabric
Microsoft Fabric is a new centralized, AI-powered cloud data platform hosted by Microsoft. It combines several services […]
Dimensional Modelling Case Study Part 1 – Age Group
Background Age plays an important role in medicine and medical research. A patient’s ages is commonly grouped into […]
Semantic Model: More than a Simple Name Change
The animation on the top of this article tries to track the evolution of the enterprise architecture […]
Warehouse Load Patterns – Part 1 – Requirements and General ...
No matter the ETL tool used, there are some basic patterns to follow when transferring data between […]
Updates about Database Projects for Microsoft Fabric
comp A few weeks ago, I wrote a blog about Database Projects for Microsoft Fabric. It’s an […]
Time-Series Data Analysis with Apache Druid
In the era of data-driven decision-making, the ability to efficiently analyze and derive insights from time-series data is […]
Fabric Data Warehouse News you need to know
Microsoft Fabric, including the Data Warehouse, evolves faster than we can analyze and write about it. Here […]
Database Projects for Microsoft Fabric Data Warehouse
Database Projects for Fabric Data Warehouse is one of the most recent news of Fabric for SDLC […]
Fabric: My Content compilation
Microsoft Fabric was first announced during Microsoft BUILD. Since then, I’m publishing content about Microsoft Fabric, creating […]
Microsoft Fabric: Loading On-Premises and External Data
Loading On-Premises and external data is a fundamental need for a Data Platform such as Microsoft Fabric. […]
Upserts in Amazon Redshift
Amazon Redshift was first announced in 2012 as a new cloud-based analytical data warehousing service. Since then, it […]
A Overview of Amazon Redshift
Introduction In the world of big data analytics and data warehousing, Amazon Redshift has emerged as a powerful […]
Building a Kimball Data Warehouse
Introduction I sat through a YouTube webinar on Data Lakes, and I’ll have to admit that it was […]
Microsoft Fabric: Enabling your Free Trial
After the great announcement of Microsoft Fabric this week, it’s time to get a trial and start […]
Microsoft Fabric: Data Warehouse Ingestion using T-SQL and more
.In this blog I will illustrate how we can ingest data from a blog storage to a […]