Tag Archives: data warehousing

The Data Warehousing Choice

Each time I compile and curate the Database Weekly newsletter, I find lots of Fabric content from the various sources I watch to compose the newsletter. Since I primarily deal with the Microsoft Data Platform stack, this makes sense. Most … Continue reading

Posted in Editorial | Tagged | Comments Off on The Data Warehousing Choice

The Load of Real Time Data Warehouses

If you have a data warehouse, what do you think your ratio of reads to writes is on any given day? Do you think 1:1, as in one read for each write? Is it 10:1, with 10 reads for each … Continue reading

Posted in Editorial | Tagged | Comments Off on The Load of Real Time Data Warehouses

Archive to the Lake

Microsoft Fabric was announced at Build in May 2023. This is the next evolution of data warehousing from Microsoft, folding in Synapse and a number of other technologies to create a simpler location for storing and analyzing data. We’ve published … Continue reading

Posted in Editorial | Tagged , , , , | Comments Off on Archive to the Lake

Faster Cloud Warehouses

I think the cloud is a perfect place for a data warehouse. In many organizations, I’ve found that a data warehouse system is often the largest SQL Server database, both in size of database and also in terms of resources … Continue reading

Posted in Editorial | Tagged | Comments Off on Faster Cloud Warehouses