Speaker

Damir Matešić

Damir Matešić

Microsoft Data Platform MVP | Senior Database Developer @Span | SQL Server User Group Croatia - Lead

Zagreb, Croatia

For many years Damir is a passionate programmer and a Microsoft SQL Server developer (ver. 2000+).
He is a certificated Microsoft professional on various technologies.
He leads the Croatian SQL Server User Group and he introduced SQL Saturday Event in Croatia. He organizes various Data Platform events in Croatia.
Founder and organizer of #DataWeekender. #DataWeekender is a popup online conference, organized by a group of European based Microsoft data platform professionals. Originally created as a response to Covid-19, this is now a regular online event.
He is currently working as Senior Database Developer @Span.eu.
Damir speaks on various community events, conferences and user groups.
When free he blogs about SQL @ https://blog.matesic.info.

Awards

Area of Expertise

  • Information & Communications Technology

Topics

  • SQL Sever
  • T-SQL
  • Azure SQL Database
  • Data Platform
  • Microsoft SQL Server
  • Performance Tunning

What's new in MS SQL for developers?

MS SQL 2022 is here. Maybe you're still using old versions of the engine and not sure why you should upgrade to the new version? Let's explore together some of the new features and enhancements that Microsoft team has brought to us in their inventive kitchen. Accompanied with multiple examples, this session will show you many interesting topics.

Historical data with MS SQL System-Versioned (Temporal) Tables

Before the existence of system-versioned temporal tables, tracking changes in a database table forced us to implement some custom solutions based on triggers, stored procedures etc.
System-versioned temporal tables offer us the possibility to keep a full history of data changes and allowing us easy point in time analysis. Using this solution, we can easily time travel through the data and see what the exact state of the data in a point of time was.
In this session we will see what system-versioned temporal tables are, how we can create and use them and what are the limitations and benefits of such implementation.

MS SQL New functions, syntaxes, tips & tricks

In this session we will see what bring us some newly introduced MS SQL functions. Accompanied with multiple examples, this session will show you many interesting topics from SQL 2016 to 2022.

Advanced data types – JSON

JSON (JavaScript Object Notation) is a language in depended, very popular, open standard format for data exchange between applications and services. On this session accompanied by numerous examples we should pass through the usage of JSON in MS SQL.
Main topics:
- Format MS SQL data in JSON format
- Read JSON data in MS SQL - Modify JSON data using JSON_MODIFY
- JSON functions, tips & tricks

Advanced Technology Days 16

December 2021 Zagreb, Croatia

Data Saturday Sofia

October 2021 Sofia, Bulgaria

KulenDayz 2021

September 2021 Osijek, Croatia

DataMinutes #1

June 2021

Techorama 2021 Spring Edition

May 2021 Antwerpen, Belgium

Humanitarian conference for earthquake victims in Croatia

January 2021

Advanced Technology Days 15

December 2019 Zagreb, Croatia

SQL Server User Group Croatia: SQL & JSON

October 2018 Zagreb, Croatia

Damir Matešić

Microsoft Data Platform MVP | Senior Database Developer @Span | SQL Server User Group Croatia - Lead

Zagreb, Croatia