Warehouses, Lakes, and Lakehouse

February 18, 2025Posted inData Storage
The modern data ecosystem is like a real estate market for your bytes except instead of bidding wars, we’ve got schema-on-write vs. schema-on-read drama. Let’s break down the contenders: Data Warehouses, Data Lakes, Lakehouses, and crack open…

How do you choose an index type?

March 22, 2021Posted inMS SQL
Indexes are on-disk structures tied with a table/view that helps reduce I/O. Implementing a good indexing solution can have dramatic performance gains in the database. However, too many indexes will…

Database Files and Filegroups

March 13, 2021Posted inMS SQL
Managing database files and filegroups appropriately will help with the availability of a database and of course its performance. FilesThere are at least two file types and you can have…

DBA tricks to tune SQL Server

March 12, 2021Posted inMS SQL
In a perfect world, DBA installs SQL Server and clicks "Make my SQL Server run faster", and everyone's happy. But until Microsoft builds that switch, there are different configurations both…