Working with time: Timeseries data in SQL Server

Time series data is omnipresent in today's data landscapes. Technical logging, financial transactions or IoT devices all generate data that is typically associated with a timestamp and can be categorized as time series data.
Even tough time series data stem from a plethora of sources, the structure of the data and the queries that are typically executed against this type of data are very similar throughout the different applications. Thus, it makes sense that a whole ecosystem of different databases evolved for working with time series data. The benefits of such specialized databases is that they are equipped with structures for supporting the different types of queries while at the same time providing techniques for the ingress of time series data as a stream of data.
One of the most popular specialized tools for working with time series data is the TimeScale extension for PostgreSQL databases. Installing and enabling this extension will result in the creation of indexes, triggers and procedures that facilitate working with time series data.
In our session, we will take a closer look at time series data and explain the different operations and data structures that can be utilized when working with time series data. We will discuss a strategy for benchmarking the efficiency of working with time series data. Next, we will take a closer look at the TimeScale extension for PostgreSQL and analyze its components. Finally, we will show which of these components can be implemented in an Azure SQL database and which need to be adjusted.
Speaker
Uwe Ricken is working with IT systems since the 90’s. The start of experiences with Microsoft SQL Server came with the assignment for development of membership administration software for the American Chamber of Commerce in Germany. The software has been distributed to five additional European countries. The primary passion for developments with Microsoft SQL Server expanded in 2007 with his engagement as a DBA for Deutsche Bank AG in Frankfurt am Main. After 6 years of operational experiences as a DBA and over 14 years as a developer of complex database models he achieved the “Microsoft Certified Master - SQL Server 2008” certification which “was” the highest technical certification. The year 2013 finished with the first MVP award for his support to the Microsoft SQL Server community in Germany and Europe.
To provide his deep knowledge about Microsoft SQL Server to the interested community Uwe Ricken is blogging since 2010 at www.sqlmaster.de about his daily experiences with Microsoft SQL Server. His blog posts are in German language only to provide the German speaking SQL community inside views into the technology of Microsoft SQL Server.
Uwe Ricken is a speaker on many international conferences and events and preferred topics are “Database Internals”, “Indexing” and “Development”.
website: www.db-berater.de
blog: www.db-berater.de/sql-server-...
demos and slides: t1p.de/Timelines