Welcome to the Columbus SQL Server Users Group

 Our local meetings are free and open to all! We meet the second Tuesday of every month. Our current meetings are being held at:


IGS

6100 Emerald Parkway

Dublin, OH

Important travel note: Your best option for getting to the meeting is to take the Tuttle Crossing exit (15) and take Tuttle Crossing Blvd. west to Emerald Parkway, and turn right. IGS is about a mile on the right.

In an ongoing attempt to make the content presented useful to our members we start each meeting with a short introduction and Q&A session.  Unless noted in the meeting notes the schedule for each meeting will be:

6:00 - 6:20 - Networking & social time

6:20 - 6:30 - Welcome & Announcements

6:30 - 6:45 - Warm Up Presentation

6:45 - 7:45 - Main Presentation

7:45 - 8:00 - Meeting Wrap Up and Door Prizes

PASSChapterLogo100.jpg

sql_micro_sm.gif

  

Upcoming Meeting

Our next meeting will be on Tuesday June 12th, 2018.

Time Travel with SQL Server 2016 Temporal Tables

In many industries, it is necessary for data professionals to be able to show what a dataset looked like at a previous point in time. Whether it’s calculating insurance or tax rates based on a policy date, quickly comparing data changes over time for trend analysis or just recovering from an accidental data change, it’s useful to be able to look back in time through our data. Solutions like Change Data Capture or trigger-based audit tables are usually slow and require a lot of extra code to be effective. SQL Server 2016 introduces system-versioned tables, also known as Temporal Tables, which track data through time with far less overhead than other solutions. In this session, you’ll learn how to create temporal tables, how SQL Server manages data within those tables, and how to query data at a specific point in time using several real-world examples. Attendees will leave with a fundamental understanding of practical use cases for temporal tables and the knowledge to implement them.

Bio:

My name’s David Maxwell.  I’m a Microsoft Data Platform professional in Columbus, OH. While I know enough Integration Services or Reporting Services to solve most problems, and I poke my way around Analysis Services, for the most part, I think the database engine is really where it’s at. I like learning and taking stuff apart to see how it works. This blog is geared solely towards SQL Server with maybe a little Azure thrown in there, but I occasionally write on other topics elsewhere. If you’re actually interested in what I have to say, or in what I’m up to, feel free to comment on any of my posts, or follow me on Twitter, and send me questions there.


 RSVP HERE

 

SQL Saturday Columbus is July 28th and pre-con registration is live.

Pre-cons:

"Azure for the SQL Server DBA with Tim Radney"   

"Enter the Tidyverse: R for the Data Professional with Kevin Feasel"   

"Advanced PowerBI with Ginger Grant"

SQL Saturday and pre-con details can be found here:

http://www.sqlsaturday.com/736/EventHome.aspx



http://www.sqlsaturday.com/736/EventHome.aspx

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