If the SQL Server databases being manged are a few GB in size each, then having a single .mdf file for data is fine. However, if the size is anywhere in the hundreds of GB or more, then a single .mdf file is certainly not the way to go. Related to this, please checkout my … Continue reading SQL Server – Breakup A Monolithic Data File (Database) Into Multiple Small Files And Breakaway From Shrinking!
This post shows how I created, generated data for and used "StorageDimension" with PowerBI to slice and dice by that dimension.
This blog post shows how I created, generated data for and used a "Duration" dimension with SQL Server and PowerBI