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
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.
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.
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.
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.
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