Microsoft MVP Data Platform. BI Front-End engineer in Pandora. Contributing to establish a data-driven culture, through the adoption of a new data architecture. Admin of the company's Power BI tenant with duties of governance, monitoring and auditing. Product Owner for the common Content Management platform built on Sharepoint Solution Owner for the Data Analytics and Identity Access Management Azure platform. Common speaker in events and conferences around Europe (SQL Saturdays, PASS Summit, SQL Nexus, Intelligent Cloud, SQL Konferenz, SQL Day Poland, dataMinds Connect, Power BI Summit, Power Platform Bootcamp, etc). Speaker for DW/BI and the Italian Virtual Chapter. Author for sqlservercentral.com, sqlshack.com, UGISS (User Group Italiano SQL Server).
Temporal tables were introduced in SQL Server 2016 as a feature for providing information about the data that was stored at any point in time, rather than just the current record. Using temporal tables is it possible to track all the changes occurred to the records, making it easy to "travel into the time" to figure out what has changed, when and why. During the session will be discussed some of the most common business scenarios for the introduction of temporal tables. All cases are based on real implementation to customers and on the experience gained on the field: - Data audit. What has changed and when. - Point in time analysis. Check the history of changes over the time. - Warehouse inventory stock. Review fluctuation for product quantity. - Anomaly Detection. Detect anomalies and identify trends. - Slowly changing dimension. Query valid data for a specified period of time - Reproduce financial reports invoices and statements.