Speaker

Dean Savović

Dean Savović

Dinofni, Data Management Consultant

Dinofni, Data Management Consultant

Zagreb, Croatia

Dean is Senior DBA practicing SQL Server since version 7.0 and main areas of interest are performance tuning and troubleshooting SQL Server database. Primary focus is on OLTP databases with occasional adventures with Business Intelligence. He finished Faculty of Electrical Engineering and Computing and MBA on Faculty of Economics in Zagreb. His premise was that it is very useful to combine technical knowledge with management process knowledge that help us in our everyday work. He works in Dinofni which is specialized in data management field on Microsoft SQL Server.

Dean je senior DBA koji se bavi SQL serverom od verzije 7.0, a glavna područja interesa su performance tuning i troubleshooting SQL Server baza podataka. Iskusan je predavač sa predavanjima na Microsoft Windays Croatia, ATD Croatia, SSWUG, KulenDayz Croatia i SQLSaturday eventima. Primarno se bavi OLTP bazama podataka sa povremenim izletima u područje Business Intelligence. Završio je FER i MBA na Ekonomskom fakultetu. Zaključio je da je vrlo poželjno spojiti tehnička znanja sa upravljačkim procesnim znanjima koje pomažu u svakodnevnom poslu. Radi u Dinofni koji je specijaliziran za područje upravljanja podacima na Microsoft SQL serveru.

Area of Expertise

  • Information & Communications Technology
  • Business & Management

Topics

  • Performance Tuning
  • Azure
  • SQL Server
  • Optimization

Query Store i optimizacija upita

Govorit cu o prednostima Query Storea, mogucnostima, konfiguraciji i optimizaciji upita koristeci Query Store. Kako možemo pratiti performanse upita, kako Query Store prikuplja podatke te koje su najbolje prakse u korištenju Query Storea. Tijekom predavanja pokazivat cu razne demoe.

Bulk Load i minimal logging

Tema predavanja je bulk load i minimal logging. Pokazat ćemo na raznim demoima kako se ponaša bulk load i minimal logging na heap i cluster tablicama, in-memory tablicama, clustered i non-clustered columnstore tablicama kao i svim kombinacijama.

Parameter Sniffing on SQL Server 2017

Kada je dobar, kada je loš po performanse Vaše baze podataka? Kako možemo iskoristiti dobre strane, a kako izbjeći loše strane parameter sniffinga? Na ova pitanja pružit ćemo odgovore tijekom predavanja popraćenog mnogim primjerima.

SQL Server 2019 Intelligent Query Processing

I will talk about new intelligent query processing features in SQL Server 2019. The features that will be described are adaptive joins, interleaved execution, memory grant feedback, table variable deferred execution, batch mode on rowstore, T-SQL scalar UDF inlining and approximate count distinct.

KulenDayz 2019 Sessionize Event

September 2019 Osijek, Croatia

Advanced Technology Days 14 Sessionize Event

December 2018 Zagreb, Croatia

KulenDayz 2018 Sessionize Event

August 2018 Osijek, Croatia

Advanced Technology Days 13 Sessionize Event

December 2017 Zagreb, Croatia

Advanced Technology Days 12 Sessionize Event

November 2016

Dean Savović

Dinofni, Data Management Consultant

Zagreb, Croatia

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top