Skip to main content

Watch the Video

YouTube

By loading the video, you agree to YouTube's privacy policy.
Learn more

Load video

PGlmcmFtZSB0aXRsZT0iVGltZXpvbmUgdG8gYmUgdXNlZCBmb3IgVGltZXN0YW1wcyIgd2lkdGg9IjUwMCIgaGVpZ2h0PSIyODEiIHNyYz0iaHR0cHM6Ly93d3cueW91dHViZS1ub2Nvb2tpZS5jb20vZW1iZWQvd1RucXBUb2FaT2M/ZmVhdHVyZT1vZW1iZWQiIGZyYW1lYm9yZGVyPSIwIiBhbGxvdz0iYWNjZWxlcm9tZXRlcjsgYXV0b3BsYXk7IGNsaXBib2FyZC13cml0ZTsgZW5jcnlwdGVkLW1lZGlhOyBneXJvc2NvcGU7IHBpY3R1cmUtaW4tcGljdHVyZTsgd2ViLXNoYXJlIiByZWZlcnJlcnBvbGljeT0ic3RyaWN0LW9yaWdpbi13aGVuLWNyb3NzLW9yaWdpbiIgYWxsb3dmdWxsc2NyZWVuPjwvaWZyYW1lPg==

As part of our engaging Data Vault Friday series, our distinguished CEO, Michael Olschimke, delves into a pertinent question posed by an inquisitive member of our audience.

“In DV2.0 it is advised to use the UTC zone. How to store income timestamps from incoming sources that are in other time zones (e.g. GMT)? E.g. in Azure SQL server.”

In addressing this query, Michael provides valuable insights into the best practices for handling timestamps, especially when dealing with diverse time zones within the Data Vault 2.0 methodology. Emphasizing the recommendation to utilize the UTC zone, he navigates through the considerations and strategies for storing incoming timestamps that originate from sources operating in different time zones, such as GMT.

This illuminating discussion serves as a testament to our commitment to fostering knowledge and expertise in the realm of data architecture, making our Data Vault Friday series a valuable resource for data professionals.

Meet the Speaker

Michael Olschimke

Michael has more than 15 years of experience in Information Technology. During the last eight years he has specialized in Business Intelligence topics such as OLAP, Dimensional Modelling, and Data Mining. Challenge him with your questions!

Get Updates and Support

Please send inquiries and feature requests to [email protected]

For Data Vault training and on-site training inquiries, please contact [email protected] or register at www.scalefree.com.

To support the creation of Visual Data Vault drawings in Microsoft Visio, a stencil is implemented that can be used to draw Data Vault models. The stencil is available at www.visualdatavault.com.

Scalefree

Leave a Reply