Category - Speaking

Speaking Engagements

Speaking at IT-Tage 2019 Conference in Frankfurt

I am honored to have been selected to speak at one of the largest database conferences in the German-speaking area “IT-Tage 2019” in Frankfurt. The 3-day conference will be held from 10th to 12th December 2019, with a pre-con day on 9th December.

itt1I’ll be presenting features within Intelligent Query Processing in SQL Server 2019. The session will cover briefly all these features: Batch Mode on Rowstore, Batch and Row Mode Memory Grant Feedback, Scalar UDF Inlining, Table Variable Deferred Compilation, and Approximate Query Processing. If time permits (session takes 45 minutes only), I’ll mention Batch Mode Adaptive Join and Interleaved Execution.

There are 160 sessions on the three conference days, the conference agenda you can see here.

See you in Frankfurt!

Slovak SQL Server & BI Meeting on 19th November

Next week I’ll be back in Bratislava. I have the honor to present at the Slovak SQL Server & BI User Group‘s meeting. This time, I am gonna talk about developer’s features in SQL Server 2019.

BratislavaWe’ll go through all important new features: Intelligent Query Processing, Memory-Optimized TempDB Metadata, Accelerated Database Recovery, Optimize for Sequential Key, SQL Graph and other “small” database engine and programming enhancements.  After the session, attendees should have a clue, which of new features would bring benefits for their workloads, and where and why they could have regressions and how they can mitigate them.

You can use this link to register for the event. Uvidíme sa v Bratislave!

Quo vadis iliti j*** te fičer koji sve radi umesto mene a ja moram ništa

Ovaj post ima previše psovki da bi bio napisan na engleskom jeziku, al računam da nije malo i to što će dopreti do onih koji se služe srpskohrvatskim jezikom.

G1Postalo je gotovo nesnosno kako predstavnici mnogog proizvođača softvera (ne samo iz ogranka marketinga) najnovije fičere, alate i servise prodaju koristeći sintagmu “to sve radi za vas ispod haube,  ne morate kurcem mrdnuti, ne morate ništa znati o tome, ne morate programirati, sve je transparentno, dva-tri klika, malo drag and drop i fičer će sve uradit za vas”. Tome se pridružuje sve više predavača i tzv. eksperata ističući u prvi plan da je neki fičer do jaja jer njegov korisnik gotovo ništa ne mora da zna i ne mora više da brine o sistemu. Doduše i ne mora da brine, al sve dok ga sistem kurčinom ne tresne po čelu.

Toliko je novih stvari koje ne znaš, da prosto ne znaš gde i kako da počneš da ih učiš, a vremena nikad dovoljno. I onda ti neko kaže e ovo uopšte ne moraš da znaš, to radi samo, naravno da ćeš to malo vremena da posvetiš nečemu drugom, potpuno se oslanjajući na taj moćni fičr. Dok god ta stvar radi ono što korisnik očekuje i to radi dovoljno brzo, nema nikakvih problema. Dođe li do neželjenih efekata ili je stvar prespora onda kompania od tebe očekuje da nešto preduzmeš. A ako ne znaš kako to radi, ako ne razumeš concept, nemaš workaround, nisi se pripremio za tu situaciju onda možeš kurac.

Nove softverske verzije, novi alati samo su oruđe koje vam može pomoći da dođete do proizvodnog cilja: bržeg razvoja, skalabilnog sistema, boljih performansi. Ali to su samo jebeni alati. Oni ne rade za vas ili umesto vas; vi njih koristite i vi treba da radite sa njima. Treba dobro da ih poznajete, da znate šta i koliko mogu i možda još bitnije šta ne mogu. I valja gvirnuti poda haubu da vidiš kako to sve radi da bi znao da li je to za tebe.

Kad javno kažeš ovaj fičer je do jaja, biće ti query do 100 puta brži, a ne kažeš kad neće (a većini jebeno neće) i da može pod nekim uslovima i da bude i sporiji time si uljuljkao posetioca svoje sesije i potencijalno ga naveo na lošu poslovnu odluku. On obično nema vremena da nakon konferencije dalje razrađuje tu temu – bio je, čuo od eksperta i uzeće to kao istinu. I kad se suoči sa teškoćama u vezi sa tim fičerom, vendor ili spiker će bu obećati noviji, brži, jači i bolji.

Zato treba ljude podsećati na to da je baš lepo imati super fičere i alate, i da nesumljivo u njih treba investirati, ali da je još uvek jebeno najbitnije znanje i da treba da što više uče i znaju i da se prema svemu odnose kritički, a ne da se poput šiparica primaju na pojedine stvari pa se onda u javnim blog-postovima razočaravaju. I da treba da investiraju u znanje.

 

Common Database Design Mistakes u Kragujevcu

DBDes

U četvrtak 18. aprila 2019. u saradnji sa KG Code, a u organizaciji brta Đorđa Đokića (twitter) upriličen je juzer grup sastanak u Kragujevcu na temu dejtabejz dizajna (Database Design – najčešći mitovi i greške), na kome je moja neznatnost izložila svoja iskustva, viđenja i ostala smatranja u vezi sa tipičnim problemima koji prate dizajn relacionih baza podataka.

Moram da priznam da me je zaista iznenadio broj prisutnih s obzirom da tema nije nimalo atraktivna te da su mi broj učesnika, topao prijem i spremnosti na interakciju pričinili veliko zadovoljstvo. Kad te u rodnom gradu toko ljudi dočeka na predavanju može da znači da se postigo neki …to u životu. A svakako da znači i da je brat Đoca odradio odličan marketing, pa braćo i sestre ako vam treba neko da vam podigne prodaju znate kome da se obratite; ako je uspo da proda diskusiju o dejtabejz dizajnu prodaće i to vaše, šta god da je.

Ovde možete da downloadujete slajdove sa prezentacije.

Veliko hvala svima koji su došli, a posebno onima koji su omogućili da se sve to desi: Đorđe Đokić, Ivan Mihajlović, KG Code & co. I, razume se, ugostiteljskom objektu Stara Srbija.

Videćemo se mi opet, nećete me se tako lako otarasiti.

M.

 

Workshop: Performance and Query Tuning with SQL Server 2017 and 2019

PFTAs part of the SQL Saturday Linz conference, I will have a performance tuning workshop on 17th January in Tabakfabrik in Linz. The full workshop name is Performance and Query Tuning with SQL Server 2017 and 2019. As the name suggests, the workshop covers performance tuning techniques specific for two recent SQL Server versions. It is aimed at application and database developers who already work or plan to work with the latest versions of SQL Server – 2017 and 2019. The first part of the workshop is focused on execution plans, statistics and query optimizer. It covers common mistakes made by developers that lead to poor performing queries and brings tips how to avoid them.

The second part of the workshop includes a detailed view of Query Store, a new powerful troubleshooting tool introduced in SQL Server 2016 and improved in the later versions. You can see how you can use it not only to troubleshoot, but also to fix regressed queries, and it will be demonstrated its power by upgrade to new SQL Server version or changing compatibility level. At the end, you can learn about database engine improvements in the SQL Server 2019 CTP2 feature with the most promising name – Intelligent Query Processing.

The workshop will cover the following topics:

  • How SQL Server uses statistics and what are common issues with them
  • Quick overview of index usage; how to create a useful index
  • Typical mistakes made by developers that lead to poor performing queries
  • Troubleshooting parameter sniffing issues in different SQL Server versions
  • Cardinality estimation issues and tuning queries with large tables
  • Tips for writing well-performed queries
  • Query Store as game changer in SQL Server performance troubleshooting
  • Fixing execution plans for regressed queries by using Query Store
  • Improvements in SQL Server 2019 Intelligent Query Processing

Level: 300 – Advanced

Here is the link for registration: https://bit.ly/2rkj4wX.

Hope to see you in Linz!

Rgds,
M.

Speaking at the BLBit user group and SQL Saturday conference in Banja Luka

sqlsat791_headerLast week, we had a great time in Banja Luka. On 1st November, together with my friend and fellow Data Platform MVP and book author Dejan Sarka I talked about common database design mistakes made by application and database developers. It was really pleasure to deliver the session in that audience – more than 70 people attended the session, we were very surprised and impressed!

Two days later, on 3rd November, at the SQL Saturday Banja Luka conference, I delivered two sessions:  Common Developer Mistakes with SQL Server and Transact-SQL Performance Tips. I was very happy to see so many people in the room for my sessions  and want to thank all the attendees. It was really pleasure to be part of this successfull conference.

Regards,
M.

I am speaking at Microsoft Sinergija 18 Conference Belgrade

iamspeak.2jpgI’m very glad that I will present again at Microsoft Sinergija 18 conference in Belgrade on October 25th 2018.

Microsoft Sinergija 18 will be held from October 24 through 26 at the Crowne Plaza hotel in Belgrade under the slogan “Digital breakthrough”.

This time, my topic is related to cardinality estimation issues, and I will describe root causes, workarounds and solutions for issues with executions for queries against large tables.

The session name is “Cardinality Estimation Issues with Large Tables” and is scheduled for the second conference day, on 25th Oct at 09.00.

See you in Belgrade!

Speaking at CI SQLPort Meeting in Lisbon

As always, I had a great time in Lisbon. I enjoyed this beatiful city and also visited Cascais and spent some time in the Atlantic ocean. But, Lisbon and Portugal are not only natural beauties, but also warm, openminded and cordial people. I meet again my friend Niko Neugebauer (blog | twitter) , an icreadible guy, database expert and community leader and we enjoyed together the Real Madrid’s win in Champions League final game.

Logo-200px-pureOn Monday 28th May, I had honour to present on the CI (101.) meeting of the SQLPort user group. In a two hour presentation, I covered performance troubleshooting and tuning with SQL Server 2017.

Here you can download slides decks from it.

 

#Tarabica 18 Conference– Slide Decks and Sample Code

tarabicaoutoftheboxAs always, I had a great time in Belgrade, at the large IT conference in Serbia #Tarabica18. I was very happy to see so many people in the room for my session SQL Server 2017 za developere and want to thank all the attendees. It was really pleasure to deliver the session in that audience. Here you can download slides decks and sample code from it.

Regards,

M.