Data Activator looks promising for this use case, and I started a Fabric trial a few days ago to try doing a refresh based on data in SQL Server. Note...

There are so many dead-to-me technologies, though as others have said, most live on in some form for some users.

SQL Server Reporting Services (SSRS) is dead to me. The last...

This is a great view into how you approach database CI. Thank you!

How do you manage code reviews after code is deployed to the Development environment?

I too have seen many different conventions, from ancient Greeks on UNIX boxes in college to Japanese novelists at a globalization/localization vendor. I work for a big company, and as...

Alvin, I have a few suggestions on free data modeling tools:

1. MySQL Workbench: I've seen it used for physical modeling with SQL Server, but I haven't done it myself.

2. Oracle...

I too thought that this was the intro to an in-depth article. While the post may inspire us to consider new ways to design and implement a data warehouse, it...

Quick answer on building OLAP cubes by month's end: try adjusting the expectations of whoever gave you that requirement. You can slap something together after reading SQL Server Books...