Posts

Temporal tables in SQL

-
Image
SQL Server 2016 introduced support for temporal tables (also known as system-versioned temporal tables) as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time. Temporal is a database feature that was introduced in ANSI SQL 2011. Real data sources are dynamic and more often than not business decisions rely on insights that analysts can get from data evolution. Use cases for temporal tables include: ·          Auditing all data changes and performing data forensics when necessary ·          Reconstructing state of the data as of any time in the past ·          Calculating trends over time ·          Maintaining a slowly changing dimension for decision support applications · ...
Post a Comment
Read more

TMDL View on the web: Edit semantic models as code in your browser (Preview)

-
Image
What is TMDL View on the Web? TMDL View on the Web is a feature in Power BI that enables developers to view and edit semantic models as code directly in the browser using TMDL. It expands the Power BI web modelling experience by introducing a rich code editor for working with TMDL scripts—giving pro developers full transparency into the semantic model code and enabling more efficient workflows through code editing.   TMDL View was initially introduced in Power BI Desktop in January 2025 and became generally available in September 2025. Now, we’re bringing the same code-first modelling experience to published semantic models in the workspace—directly in your browser.   No downloads. No switching tools. Just seamless modelling on the web. Key capabilities and benefits of TMDL View on the Web Whether you're investigating model metadata, making bulk updates, reusing model components, or recovering from mistakes, TMDL View on the Web helps keep advanced semantic modeling workflows ...
Post a Comment
Read more