Skip to articles

EXPLORE THE ARCHIVE

Month: November 2024

Browse all Insights

LLM Adventures: Microsoft Copilot Studio (The Good, The Bad, and The Ugly)

"A momentary lapse of reason That binds a life to a life You won't regret, you will never forget There'll be no sleep in here tonight" "The Slip", Pink Floyd Happy Thanksgiving! What a better way for me to spend a Thanksgiving week than doing more AI? After a year of letting it (and other Microsoft LLM offerings) simmer and awaken by the latest AI…

Read article

Atlanta Microsoft BI Group Meeting on December 2nd (Semantic Modeling as Code)

Atlanta BI fans, please join us online for our next meeting on Monday, December 2nd at 5PM ET (please note the change to our usual meeting time to accommodate the presenter). Rui Romano (Product Manager at Microsoft) will discuss how the new TMDL language for Power BI models can unlock new scenarios that previously weren't possible. For more details and sign up, visit our group…

Read article

Temporal Tables

I like SQL Server temporal tables for implementing ODS-style tables and change data tracking (CDS) for three main reasons: SQL Server maintains the system versioning. By contrast, I have witnessed erroneous Start/End dates for pretty much all home grown implementation. Further, SQL Server grains the changes at millisecond level. There is a clean separation between the current state of data and historical data. SQL Server…

Read article