Pages

▼
Showing posts with label data warehousing. Show all posts
Showing posts with label data warehousing. Show all posts
20 February 2025

💠🛠️🗒️SQL Server: Nulls [Notes]

›
Disclaimer: This is work in progress intended to consolidate information from various sources. It considers only on-premise SQL Serve...
16 February 2025

💠🛠️🗒️SQL Server: Columnstore Indexes [Notes]

›
Disclaimer: This is work in progress intended to consolidate information from various sources. It considers only on-premise SQL Serve...
13 February 2025

🧊💠🗒️Data Warehousing: Table Partitioning in SQL Server [Notes]

›
Disclaimer: This is work in progress intended to consolidate information from various sources for learning purposes. Last update...
02 February 2025

🏭 💠Data Warehousing: Microsoft Fabric (Part VIII: More on SQL Databases)

›
Business Intelligence Series Last week Microsoft had a great session [1] on the present and future of SQL databases , a “light” version...
07 May 2024

🏭🗒️Microsoft Fabric: The Metrics Layer [Notes] 🆕

›
Disclaimer: This is work in progress intended to consolidate information from various sources for learning purposes. For the latest informat...
06 May 2024

🧭🏭Business Intelligence: Microsoft Fabric (Part III: The Metrics Layer) 🆕

›
Introduction One of the announcements of this year's Microsoft Fabric Community first conference was the introduction of a metrics layer...
18 April 2024

🏭Data Warehousing: Microsoft Fabric (Part II: Data(base) Mirroring) [New feature]

›
Data Warehousing Series Microsoft recently announced [4] the preview of a new Fabric feature called Mirroring , a low-cost, low-latency full...
22 March 2024

🧭Business Intelligence: Monolithic vs. Distributed Architecture (Part III: Architectural Applications)

›
  Business Intelligence Series Now considering the 500 houses and the skyscraper model introduced in thee previous post , which do you think...

🧭Business Intelligence: Monolithic vs. Distributed Architecture (Part II: Architectural Choices)

›
Business Intelligence Series One metaphor that can be used to understand the difference between monolith and distributed architectures, resp...