Eventil - Find Tech Events
Official mobile app
FREE - In Google Play
Official mobile app
FREE - In App Store

Temporal Table Triumph! - Alex Purice

Aug 1, 2018 · Sacramento, United States of America

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!
+ Versioning.
+ 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!


Sacramento SQL Server User Group

Meeting location:

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.

Event organizers
  • Sacramento SQL Server User Group

    The Sacramento SQL Server User Group is a local chapter of the Professional Association for SQL Server (PASS). The mission of PASS is to empower data professionals who leverage Microsoft technologies to connect, share, and learn through networking, knowledge sharing, and peer-based learning. We meet the first Wednesday of each month (6PM to 8PM) to discuss anything SQL Server.  Additionally, we host a SQLSaturday event every July. We are new to Meetup.com, but we are not a new group; we've been meeting si

    Recent Events

Are you organizing Temporal Table Triumph! - Alex Purice?

Claim the event and start manage its content.

I am the organizer

based on 0 reviews