SQL Server for Developers by Miloš Radivojević
Clearly, it’s impossible to cover everything a developer needs to know about SQL Server in one one-day workshop, but this one certainly covers the most important ones. Course will take place on September 10th 2021 at Hotel International, Miramarska 24, 10000 Zagreb, Croatia.
Session abstract
Clearly, it’s impossible to cover everything a developer needs to know about SQL Server in one one-day workshop, but this one certainly covers the most important ones.
Let's start with the basics, with tips on table design, why it's so important, what are the typical mistakes made by developers (and not just developers) and how to avoid them, with a couple of nice anecdotes.
The workshop continues with a favorite work for developers - how to write queries that will adorn a good performance. It is followed by implementations of typical database-related programming tasks (elegant duplicate removal, computing running totals ...), as well as a demonstration of how a foreach loop can be very painful and how good knowledge of Transact-SQL pays off.
In the second part of the workshop, we will briefly look at the problems posed to developers by the so-called parameter sniffing, and how to avoid the excitement of SQL injection in their companies.
Finally, there will be an exhibition of typical errors that developers tirelessly make when working with SQL Server objects: in terms of performance, functionality, as well as the (un) understanding of the way in which SQL Server handles errors.
The workshop will bring something for everyone: inexperienced and beginners will avoid typical mistakes and will be guided on how to deepen their knowledge in the field, the more experienced will receive additional advice and suggestions, with a recapitulation of typical mistakes. It may not be best to learn from other people’s mistakes, but it’s certainly less painful.
Croatian:
Nemoguće je pokriti sve što programeri trebaju znati o SQL Serveru jednodnevnim workshopom, ali ovaj svakako pokriva najvažnije.
Krećemo od temelja, savjetima za dizajn tablica, zašto je to toliko važno, koje su tipične greške koje prave developeri (i ne samo developeri) i kako ih izbjeći.
Workshop se nastavlja omiljenim dijelom za developere; kako napisati upite nadograđene dobrim performansama, popraćeno implementacijom tipičnih programerskih zadataka vezanih sa bazom podataka (elegantno uklanjanje duplikata, računanje kunulativnog totala...). Slijedi demonstracija foreach petlje (koja nas može skupo koštati) i kako se u tom slučaju dobro isplati znanje Transact-SQL-a.
U drugom djelu workshopa osvrnut ćemo se kratko na probleme koje programerima predstavlja tzv. parameter sniffing, te kako kompanije poštedjeti neugodnih iznenađenja koje SQL injection izaziva.
Na kraju ćemo predstaviti nekoliko tipičnih slučajeva gdje programeri često griješe radeći sa objektima SQL Servera; kako se nositi sa problemima performansi, lošom funkcionalnošću, kao i (ne)razumijevanjem načina na koji SQL Server obrađuje greške.
Workshop donosi ponešto za svakoga: početnici i manje iskusni developeri učiti će izbjegavanje tipičnih grešaka i usmjeriti će se na načine produbljivanje znanja, a iskusniji developeri će dobiti dodatne savjete i prijedloge, uz rekapitulaciju tipičnih grešaka.
Na kraju, možda nije najbolje učiti na tuđim greškama, ali je svakako manje bolno nego rješavati vlastite.
About the speaker
Miloš Radivojević is a Microsoft Data Platform MVP x7, database development manager at bwin, co-author of three books on SQL Server and co-founder of PASS Austria.
Croatian:
Miloš Radivojević je Microsoft Data Platform MVP x7, rukovodilac database developmenta u kompaniji bwin, koautor tri knjige o SQL Serveru i suosnivač PASS Austria.