Sacramento SQL Server User Group

Next Meeting

Wednesday,

August

01

Temporal Table Triumph! - Alex Purice

  • Patrick Hays Learning Center (map)
  • 2700 Gateway Oaks Drive, Suite 2600
  • Sacramento, CA 95833
  • 6:00 PM to 8:00 PM
  • RSVP via Meetup

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!

RSVP on Meetup!
https://www.meetup.com/Sacramento-SQL-Server-User-Group/events/252955685/


Sponsors:
TEKsystems
http://www.teksystems.com
Idera
http://www.idera.com

Sacramento SQL Server User Group
https://www.meetup.com/Sacramento-SQL-Server-User-Group
http://sac.pass.org
https://twitter.com/sacsqlug
https://www.linkedin.com/groups/2825448

Meeting Schedule and Structure

The Sacramento SQL Server User Group meets the first Wednesday of every month. Most meetings will have a presentation, while others are open group sessions which allow attendees to discuss SQL Server questions, issues and news as a group.

We start each meeting with some time to network and get situated. Unless otherwise noted, the schedule for each meeting will be:

6:00 PM - 6:15 PM: Mingle/networking, get food & beverages, presentation setup
6:15 PM - 6:30 PM: Group announcements, agenda, introduce speaker
6:30 PM - 7:30 PM: Presentation
7:30 PM - 8:00 PM: Post-meeting discussions

Our Sponsors

PASSChapterLogo100.jpg

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids