Temporal Table Triumph! - Alex Purice
All about temporal tables in SQL Server!
+ Temporal table usage.
+ Slowly Changing Dimension Types 2 and 4.
+ Key elements for enabling temporal tables.
+ Columns - Regular and Temporal.
+ The missing “Edit” option!
+ History schema.
+ Why having history schema is a good idea.
+ Explicit names for historical records tables.
+ Dropping temporal tables.
+ Upgrading existing tables to temporal tables.
+ Hiding period columns!
+ The EXCEPT example!
+ Useful reading materials!
Alex is passionate about SQL Server, enjoys sharing his SQL Server knowledge with others, is an active member of the Sacramento SQL Server User Group and will be speaking at SQLSaturday Sacramento on July 28, 2018!
2700 Gateway Oaks Drive is located in the Sutter Health business park at the northeast corner of the intersection of Gateway Oaks Drive and West El Camino in Sacramento. The 2700 building is at the back of the complex; you can see I-5 from the parking lot. Enter the building from the parking lot side, not the courtyard side. Once inside the building, take the stairs or elevator to the second floor, then enter Suite 2600. In the reception area, check the monitor to find our room for the evening and then proceed to that room.
Claim the event and start manage its content.I am the organizer