Damir Matešić

Information & Communications Technology

SQL Sever T-SQL Azure SQL Database Azure SQL Managed Instance SQL Azure SQL DB Data Platform Microsoft SQL Server Performance Tunning

Zagreb, City of Zagreb, Croatia

Damir Matešić

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

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.

Current sessions

What's new in MS SQL for developers?

MS SQL 2019 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 and syntax's like COMPRESS, STRING_SPLIT, STRING_AGG, DROP IF EXISTS (a.k.a. DIE), UTF8 Support and many more. How are they performing compared to some old solutions?
Accompanied with multiple examples, this session will show you many interesting topics.


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


Past and future events

Advanced Technology Days 16

8 Dec 2021 - 9 Dec 2021
Zagreb, City of Zagreb, Croatia

DBA Fundamentals: Advanced data types – JSON ~ Damir Matešić

9 Nov 2021

Data Saturday Sofia

9 Oct 2021
Sofia, Sofia-Capital, Bulgaria

KulenDayz 2021

3 Sep 2021 - 5 Sep 2021
Osijek, Osječko-Baranjska, Croatia

Cloud Data Driven: Advanced data types – JSON

8 Jul 2021

Virtual 2021 Data.SQL.Saturday.LA

12 Jun 2021

DataMinutes #1

11 Jun 2021

GroupBy Europe Dev & BI: MS SQL New functions, syntaxes, tips & tricks

26 May 2021

Techorama 2021 Spring Edition

17 May 2021 - 19 May 2021
Antwerpen, Flanders, Belgium

SQL Friday: Historical data with Temporal Tables

9 Apr 2021

SQL Server Virtual Conference

29 Jan 2021 - 30 Jan 2021

Data Saturday Guatemala 2021

23 Jan 2021

Global AI BootCamp Bulgaria 2021

16 Jan 2021

Humanitarian conference for earthquake victims in Croatia

16 Jan 2021

SQLSaturday #980 - Plovdiv, Bulgaria: MS SQL New functions, syntaxes, tips & tricks

12 Dec 2020
Plovdiv, Bulgaria

Data Platform Summit: MS SQL New functions, Syntaxes, Tips & Tricks

4 Dec 2020

GroupBy: Advanced data types – JSON

28 Oct 2020

SQLSaturday #989 - Sofia, Bulgaria: Advanced data types – JSON

10 Oct 2020
Sofia, Sofia-Capital, Bulgaria

SQLSaturday #988 - Gothenburg, Sweden: MS SQL New functions, syntaxes, tips & tricks

5 Sep 2020
Göteborg, Västra Götaland, Sweden

SQL Friday: Advanced Data Types – JSON

29 May 2020

SQL Saturday #910 - Slovenia: What's new in MS SQL for developers?

14 Dec 2019
Ljubljana, Slovenia

Advanced Technology Days 15

4 Dec 2019 - 5 Dec 2019
Zagreb, City of Zagreb, Croatia

SQL Saturday #873 - Bratislava: Advanced data types – JSON

8 Jun 2019
Bratislava, Bratislavský kraj, Slovakia

SQL Saturday #873 - Bratislava: MS SQL New functions, syntaxes, tips & tricks

8 Jun 2019
Bratislava, Bratislavský kraj, Slovakia

SQL Server User Group Croatia: SQL & JSON

10 Oct 2018
Zagreb, City of Zagreb, Croatia

SQL Server User Group Croatia: Nove SQL 2016/2017 funkcije i sintakse

11 Apr 2018
Zagreb, City of Zagreb, Croatia