Temporal Tables and Their Roles in ETL and Data Warehouse

Posted by on May 19, 2016 in ETL, Presentations, SQL Server, SQL Server 2016 | No Comments
Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail

2016-05-19_22h32_01

It is my pleasure to speak in PASS 24 Hours session for Evolution of Data Platform on the topic above. I look forward to meet you all in this webinar. registration is free, but limited. So reserve your seat now. Here are some information about my session and 24HOP.

24HOP

24 Hours of PASS is the virtual PASS conference that happens in 24 consecutive hours, 1 session each hour; that makes 24 sessions in 24 hours! Amazing, isn’t it? If you haven’t been in such conference I have to tell that this is a marathon for you. Many great sessions from great speakers around the world on particular topic. Once you join you want to be involved in all. You will be surprised by the amount of high level content presented in this 24 hours.

Next 24HOP is dedicated to Evolution of Data Platform, means SQL Server 2016, Cortana Intelligence, Azure ML, R, Azure HD Insight, Hadoop and more. It is my pleasure to speak in this 24HOP on a data warehouse/ETL topic, and I invite all of you to join if you are interested to learn new features of SQL Server 2016 for Temporal Tables and its role in ETL and DW.

My Session: Temporal Tables and Their Roles in ETL and Data Warehouse

http://www.sqlpass.org/24hours/2016/edp/Sessions/Details.aspx?sid=48617

Description

Temporal tables are new type of database tables introduced in SQL Server 2016, these tables are system-versioned and keep history of changes (insert, delete, update) of everything happened on data rows. Retrieving change log from these tables are easy. These tables can simply tell you what was the data at specific point of the time in the table. These tables works with datetime2 columns to keep FROM DATE and TO DATE information of each change. This means these tables can be used for implementing changes in dimensions, yes you know what it called; Slowly Changing Dimension!

In this session you will learn how Temporal Tables works, and you will also learn through live demos how to use it in your Data Warehouse for Slowly Changing Dimension. You also learn some tips and tricks when you work with Temporal Tables for SCD implementation.

Date and Time

26 May 2016 00:00 GMT

Link to Join

http://www.sqlpass.org/24hours/2016/edp/Registration.aspx

List of all Sessions

Search sessions by track:
Application & Database Development
BI Information Delivery
BI Platform Architecture, Development & Administration
Cloud Application Development & Deployment
Enterprise Database Administration & Deployment

There are heaps of great sessions by great speakers, and here is the agenda:

http://www.sqlpass.org/24hours/2016/edp/Sessions.aspx

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail
rssyoutuberssyoutube
Reza Rad
Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for eight continuous years (from 2011 till now) for his dedication in Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of Difinity conference in New Zealand.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: http://www.radacad.com/blog.
He wrote some books on MS SQL BI and also is writing some others, He was also an active member on online technical forums such as MSDN and Experts-Exchange, and was a moderator of MSDN SQL Server forums, and is an MCP, MCSE, and MCITP of BI. He is the leader of the New Zealand Business Intelligence users group. He is also the author of very popular book Power BI from Rookie to Rock Star, which is free with more than 1700 pages of content and the Power BI Pro Architecture published by Apress.
He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer.
Reza’s passion is to help you find the best data solution, he is Data enthusiast.

Leave a Reply

Your email address will not be published. Required fields are marked *