September 9, 2020: Introduction to SQL Server Temporal Tables

In support of social distancing, Oregon Data Community meetings will be online until further notice.
6:30PM – 8:30PM Pacific

Congratulations to Khanh Pham, the winner of the August 2020 ODC raffle of a year’s worth of training from Pragmatic Works.


Register NowDon’t miss this meeting!


Download the presentation material here.

Tim Mitchell
Introduction to SQL Server Temporal Tables

SQL Server temporal tables are a relatively new introduction to the SQL Server stack, representing a unique way to store temporal (time-based) data. These system-versioned temporal tables can be used to create versions of your data over time, allowing for point-in-time historical analysis of changed data.
In this presentation, we will introduce and review the essentials of system-versioned temporal tables in SQL Server. We will cover the concept of temporal storage, and demonstrate how these are implemented in SQL Server. Finally, we will demonstrate the use of temporal tables through several realistic examples.

Tim Mitchell
Tim Mitchell is a business intelligence architect, author, and trainer. He has been building data solutions for over 17 years, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and has been recognized as a Microsoft Data Platform MVP each year since 2010. Tim is the founder and principal data architect at Tyleris Data Solutions, a consulting firm focused on delivering on-premises and cloud-based solutions on the Microsoft data platform.
As an active member of the community, Tim has spoken at international, regional, and local venues including the SQL PASS Summit, SQLBits, SQL Connections, SQL Saturday events, and various user groups and webcasts. Tim is the author of the book The SSIS Catalog: Install, Manage, Secure, and Monitor your Enterprise ETL Infrastructure, coauthor of the book SSIS Design Patterns, and is a contributing author on the charity book project MVP Deep Dives 2. He is a member of the Boulder BI Brain Trust, a Melissa Data MVP, and is active in the North Texas SQL Server User Group in the Dallas area.
You can visit his website and blog at TimMitchell.net or follow him on Twitter at twitter.com/Tim_Mitchell.

 


ServerLogic


Register NowDon’t miss this meeting!


Arnie Rowland

DevOps and Databases: An Intro

In this brief discussion, we will examine planning and techniques to successfully incorporate databases into a DevOps strategy.

Arnie RowlandArnie is a Microsoft Data Platform (and SQL Server) MVP (for 14 years), a Subject Matter Expert (SME) working on SQL Server training courses and the development of the Microsoft Certification Exams. He was a Microsoft Certified Trainer for over a decade, and has served a technical editor for several publishers, including multiple SQL Server titles in the Microsoft Official Curriculum, and has served as adjunct faculty at both University and Community College. Clients include Fortune 500 and Multi-National companies, Federal and State agencies, foreign governments, nationally recognized training facilities, and local enterprises –both public and private. Arnie is a Senior Moderator on the MSDN and TechNet SQL Server related Forums, a founding member of the TechNet Wiki Governing Council, founder of the Oregon SQL User group (now the Oregon Data Community), and has been a lead facilitator for SQLSaturday Oregon for the past eleven years.


 

Posted in Announcements | Comments Off on September 9, 2020: Introduction to SQL Server Temporal Tables