4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

milos_radivojevic.jpg

Milos Radivojevic

Milos Radivojevic is a database developer and consultant, speaker, and trainer located in Vienna, Austria. He has been working with SQL Server over 12 years. He is Microsoft SQL Server MVP and MCT and specializes in SQL Server for application developers and performance and query tuning. Currently he works as senior database developer in bwin.party (the largest regulated online gaming company in the world) where he works with some of the largest SQL Server databases. He is co-leader of the SQL Server PASS Austria. He is a speaker in international conferences (SQLBits, SQL Saturday, SQLU Summit) and speaks regularly at SQL Server PASS Austria meetings. He has developed two courses: SQL Server For Application Developers and (for SolidQ) SQL Server 2012 for Experienced Developers and DBAs (Co-author with Herbert Albert and Gianluca Hotz). His Twitter handle is @MilosSQL.

http://www.bwinparty.com http://milossql.wordpress.com/feed
Milos Radivojevic has submitted 2 sessions for SQLBits XIV, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

In this session we'll talk about the new cardinality estimator. We'll see what's definitely better compared to the old CE, what is just different and finally where you can expect significant regressions and how to avoid them.
Your stored procedure is slow in the application, but works perfect in SSMS! In this presentation it will be clarified why this happens and we will offer several solutions for this problem and discuss which solution is applicable in which scenario.

Previous Sessions

In this presentation it will be clarified when and why parameter sniffing is a problem in SQL Server stored procedures. Of course we will offer several solutions for this problem and discuss which solution is applicable in which scenario.
In this section we will show how to avoid performance problems caused by poor query design (functions in WHERE clause, data type conversions…) and explain how local variables and parameters affect the generation of execution plan.
SQL Server optimizer doesn't use and index seek for execution of your query although the query is high selective? What is better, when and why: LIKE vs: SUBSTRING, IN vs. EXISTS, SUBQUERY vs. JOIN. Why you should not use the UPPER or LOWER functions?
In this session we will advice how to avoid common developer mistakes and show how bad designed queries reduce the SQL Server optimizer's capabilities for choosing an optimal execution plan.

Blog posts RSS

Beyond Statistics Histogram – Part 3 (TF 2389 feat. TF 4139) 22 Dec 2014
In the previous article we’ve shown how can we use TF 2390 to handle queries with literals beyond statistics histogram in SQL Server 2012. We saw that SQL Server creates some statistics on the fly for all columns used in filter expressions. If we would enable trace flag on the instance level that ...

Speaking at Deutsche SQL Server Konferenz 2015 in Darmstadt 20 Dec 2014
I am honored  to have been selected to speak at the largest SQL Server conference in the German speaking area “SQL Konferenz 2015“. The 2-day conference will be held from 4 to 5 February 2015, with a pre-con day on 3rd February. I’ll be presenting a session about Key Ascending ...

Naj ti poljub nariše ustnice – SQL Sat Slovenia T-16 24 Nov 2014
In 16 days starts SQL Sat Slovenia conference and I am recalling today an old great song from the Slovenian band “Lačni Franz” in a new, acoustic arrangement. Naj ti poljub nariše ustnice as introduction to another pre-Christimas SQL Saturday Slovenia. Enjoy!        

Beyond Statistics Histogram – Part 2 (TF 2390) 24 Nov 2014
In the previous article of this series we introduced the problem with queries using literals which are beyond statistics histogram, but exist in the table. We saw that this can be a serious problem in large tables in SQL Server 2012. We saw also that SQL Server 2014 handles it better. In this ...

Speaking at SQLSaturday Slovenia 22 Nov 2014
I’m proud to announce that I will present at SQLSaturday Slovenia on December 13th, 2014. This time I will talk about Hekaton topic. The session name is “SQL Server 2014 In-Memory OLTP Challenges for Developers”. This will be second SQLSaturday conference in Slovenia. I was ...