SQLSaturday #601 - Belgrade 2017

Event Date: 03/18/2017 00:00:00

Event Location:

  • Univerzitet Singidunum
  • Kumodraška 261, Beograd
  • Belgrade, Belgrade, Serbia

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).


This is a list of sessions from the event, based on the schedule in the XML files.

Title: High-Performance Statistical Queries

Abstract: Transact-SQL language in latest editions of SQL Server has so many business intelligence (BI) improvements that it might become your primary analytic database system. You might even decide to use T-SQL for advanced analyses directly, without including R, SSAS or Azure ML. However, to get the maximum out of these language constructs, you need to learn how to properly use them. This in-depth session shows extremely efficient statistical queries that use the new window functions and are optimized through algorithms that use mathematical knowledge and creativity. During the session, the formulas and usage of those statistical procedures are explained as well. This session is useful not only for BI developers; database and other developers can successfully learn how to write efficient queries. Or maybe you want to become a data scientist? Then you need to know statistics and programming. You get the best of both in this session.


  • Dejan Sarka

Track and Room: BI Platform Architecture, Development Administration - Room 005

Title: Microsoft Azure Machine Learning Algorithms

Abstract: Machine learning service is Microsoft Azure drag and drop tool for building,testing and deploying any kind of predictive model on your data-set. Finalized solution is published and used by daily business in larger stack of your Microsoft Azure services. With easy and interactive creation of models, algorithms and decisions do not tend to be that simple! Especially when one has to make business decision on results.

Focus on this session will be mathematical and graphical explanation of algorithms available for predictive analytics in Azure Machine Learning service. Algorithms - grouped by learning type - will be examined and crossed referenced through all available and ready-to-use. Understanding the the basics - data inference, data splitting, data stratification, to sweeping, to theory of algorithms: regression, decision trees, Clustering and Naive Bayes. We will clarify the confusion over algorithms, suitable data for algorithms and what type of problem can be tackled with.


  • Tomaž Kaštrun

Track and Room: Analytics and Visualization - Room 001

Title: SSAS Query Performance Tuning

Abstract: Slow cubes? Don’t worry, you have a lot of options. Join this session and let me show you how aggregations and partitioning work (even on Standard Edition with a workaround!), and how to scale your solution to deal with heavy workloads.


  • Zoltán Horváth

Track and Room: BI Platform Architecture, Development Administration - Room 001

Title: Achieve great performance with Azure SQL Database using built-in intelligence

Abstract: Microsoft Azure SQL Database’s built-in smart tuning models help you achieve great performance for your database apps while saving you time and effort in the process. We demo the state-of-the-art capabilities, including tailored actionable recommendations, auto-tuning and insights into query performance. In addition, we present real-life case studies to illustrate how SQL Database built-in tuning will make a difference for your app performance.


  • Veljko Vasic

Track and Room: Cloud Application Development Deployment - Room 015

Title: Welcome note - Room 2

Abstract: Keynote session


  • Vladimir Markovic

Track and Room: Information Delivery - Room 001

Title: Notes from the field of a Microsoft SQL Engineer

Abstract: Being part of Microsoft is challenging. But also rewarding. With the countless cases of pretty and not so pretty SQL Servers. With so many good, but also bad practices. Cases going from badly written code to cases with improper plan caching. And I want to share them all with you. So let’s hope we have enough time to do that!


  • Ivan Donev

Track and Room: Application Database Development - Room 005

Title: Think work like a Data Scientist with SQL 2016 R

Abstract: What are these DATA Scientists up to? How can we see their statistical model in our day to day familiar tool like Microsoft SQL Server?

You now have answers to these questions and thanks to Microsoft for integrating R Revolution within new SQL Server 2016. We all now have the opportunity to use R packages and see the results within SQL 2016.

In this session, you will definitely take away a breakthrough concept of Advanced R Analytics within SQL 2016 and get ready to kick your creative horse, and go beyond your imagination on how you can build advanced analytics and impress your employers/customers.


  • Dr. Subramani Paramasivam

Track and Room: Analytics and Visualization - Room 001

Title: Welcome note - Room 1

Abstract: Keynote session


  • Goran Milanov

Track and Room: Information Delivery - Room 005

Title: Problem Solving With The In-Memory Engine

Abstract: There is a vast array of material in the SQL Server community that covers the in-memory engine in great detail, this session will cover some of the internals of the in-memory engine, however what it will also do is fill in the void as to common performance issues and how they can be solved with the in-memory engine, specifically:

  • Staging data as fast as possible
  • Turbo charging scalar aggregate functions
  • Implementing a scalable sequence
  • Overcoming the performance limitations of temporary tables
  • Making the critical path in your code base run faster


  • Christopher Adkin

Track and Room: Enterprise Database Administration Deployment - Room 005

Title: Spatial Analytics with SQL Server 2016 and Azure SQL Database

Abstract: Spatial dimension of business such as ‘where are things happening’ and ‘where are my customers’ becomes more and more important. An unprecedented amount of location-referenced data that will be produced in years to come has to be not just stored, but more important analyzed on strategic, tactical and operational level, sometimes in (near) real time. This session covers use cases and best practices for spatial analytics and shows significant performance improvements in spatial with SQL Server 2016 and demonstrates synergy offered in Azure ecosystem.


  • Mladen Andzic

Track and Room: Analytics and Visualization - Room 015

Title: SQL Server and JSON in real applications

Abstract: JSON support that was introduced in SQL Server 2016 and Azure SQL Database enables you to get the best both from relational and NoSQL worlds. You can easily combine relational design that provides high query performance and non-relational concepts that provide you flexibility and rapid development to create optimal design for your application. In this session, we will see how you can combine relational data and JSON, query and index JSON data, load semi-structured data from log files, create REST/OData services, and easily integrate your database with modern web apps.


  • Jovan Popovic

Track and Room: Application Database Development - Room 015

Title: Columnstore Index Internals

Abstract: Columnstore technology in SQL Server has been continuously improved with new features and capabilities. In this session we will talk about Columnstore Index basics, and then dive into some of the internal details. Let’s cover all available Columnstore Index flavors and when each of them should be used. We’ll go through some of the features and how to utilize them the best. We’ll also talk about maintenance of Columnstore Index internal structures to keep the best possible performance, as well as other best practices, tips and tricks.


  • Milos Todic

Track and Room: Application Database Development - Room 015

Title: SQL database on IoT devices, could you? should you? would you?

Abstract: The current IoT devices are pretty powerful, so could very well run a version of SQL engine. It would be a good idea? What will be the use of it? How to make it work and make the most of it? How does all fit with the field gateway concept? During the presentation, we will take a real word scenario, real hardware, and together we will try to answer these questions


  • Catalin Gheorghiu

Track and Room: Application Database Development - Room 001

Title: Row-level security

Abstract: Row-level security


  • Dragoslav Ogar

Track and Room: Enterprise Database Administration Deployment - Room 005

Title: Big data solutions on Microsoft Azure

Abstract: Today, data is everywhere, in all forms and sizes and being generated faster then ever before. In the same time, falling storage costs for data make it cheap to store vast amounts of information and cloud solutions offer compute power on demand. With all the technology innovation, today, easier then ever, any organization can start gaining insights and making data driven decisions. Microsoft in no exception here, so we build bunch of solutions for our own teams. Now, we’re taking everything we’ve learned on this journey and bringing it to our customers. Joint the session to learn about different big data solutions which Microsoft offers on Azure and how to get started with some of them.


  • Maja Damjanic

Track and Room: Analytics and Visualization - Room 015

Abstract: SQL Server 2012 introduced an important extension to its integrated Full-text Search, namely the Statistical Semantic Search. In this session you will learn how to install and configure this new functionality, how to use it to extend your existing full-text search capabilities, and how to utilize it properly to improve your information management solutions. You will learn how to automatically extract key phrases from your documents, and how to find similarities between individual documents of your information corpus based on the key phrases that they contain.


  • Matija Lah

Track and Room: Application Database Development - Room 001

Title: Welcome note - Room 3

Abstract: Keynote session


  • Dejan Pervulov

Track and Room: Information Delivery - Room 015

Title: Call 555 - 333 for Query Store

Abstract: U ovoj sesiji potrudiću se da dočaram zašto je Query Store najvažnije dostignuće Database Engine-a nakon 2005. i OPTION(RECOMPILE).


  • Miloš Radivojević

Track and Room: Enterprise Database Administration Deployment - Room 005

Title: What is new in SQL Server 2016 Availability Group [EN]

Abstract: SQL Server 2016 has lots of new features and changes in Availability Group. This session is about the new things and demo about the followings: Workgroup cluster + AAG, Direct Seeding, DB_FAILOVER and Load balancing secondary replica.


  • Janos Berke

Track and Room: Enterprise Database Administration Deployment - Room 005

Title: Creating Custom BI Solutions with Power BI Embedded

Abstract: Microsoft Power BI Embedded is a Microsoft Azure that enables developers to integrate Power BI reports into their web or mobile applications so they don’t need to build custom solutions to visualize data for the users. Microsoft Power BI Embedded helps Independent Software Vendors to use Power BI data experiences within their applications. Customers, who use applications with Power BI Embedded don’t need to have a Power BI account or to know anything about this Azure service. This talk is a practical session on Microsoft Power BI Embedded concept with many examples how to create custom BI solutions using this technology.


  • Mihail Mateev

Track and Room: Cloud Application Development Deployment - Room 015


This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Veljko Vasic

Program manager 2 in Microsoft. Last 5 years worked as developer, data scientist and program manager.

Matija Lah

Twitter: - @MatijaLah

LinkedIn: Matija Lah

Contact: http://milambda.blogspot.com

Matija Lah has more than a decade of experience working with Microsoft SQL Server, mostly architecting data-centric solutions in the legal domain. His contributions to the SQL Server community have led to the Microsoft Most Valuable Professional award in 2007 (Data Platform), which he held until 2017. In 2008 Matija joined SolidQ as a Mentor, located in Central and Eastern Europe. He spends most of his time on projects involving advanced information management, and natural language processing.

Dejan Sarka

Twitter: - DejanSarka

Contact: http://blogs.solidq.com/dsarka/Home.aspx

Dejan Sarka, MCT and Data Platform MVP, is an independent trainer and consultant that focuses on development of database and business intelligence applications. Besides projects, he spends about half of his time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or co-author of eighteen books about databases and SQL Server. Dejan Sarka has also developed many courses and seminars for Microsoft, Radacad, SolidQ, and Pluralsight.

Milos Todic

LinkedIn: Milos Todic

I am Milos Todic, Software Engineer at Microsoft. I started working at Microsoft in 2009 after I finished studies of Electrical Engineering at university of Belgrade. My initial role was Software Development Engineer in Test. I worked on several projects related to SQL Server and HDInsight. For the last several years I’m working as Software Engineer on numerous projects related to Columnstore Index technology in SQL Server engine (Columnstore index reorganize, snapshot versioning, compression delay, Tuple mover, LOB support in clustered Columnstore, etc.)

Dragoslav Ogar

LinkedIn: Dragoslav Ogar

Dragoslav Ogar is a CEO/Consultant/Trainer of A4ATCP d.o.o. Belgrade. He has 25 years of real-life and theoretical experience with information technologies. He is a tch.math. As Microsoft trainer, he delivered about 70 different MOCs at all and more than 15,000 hours. On five Microsoft conferences, Sinergija 04, 06, 10, 11 and 13, held in Serbia, he was awarded as one of best speakers. Except SQL Server field, his favorite areas are Entity Framework, OData, MVC, and SOLID, also.

Janos Berke

Twitter: - @JanosBerke

LinkedIn: Janos Berke

Contact: http://www.iamberke.com

I am an IT professional with over a decade of technical and management experience. I am using SQL Server since version 6.5. Currently I am a consultant and helping companies in SQL Server design, migrations, operation and developments as well as providing customized training .

Maja Damjanic

LinkedIn: Maja Damjanic

Program Manager based in Microsoft Development Center Serbia, currently contributing to some of key Microsoft big data solutions such as Azure Data Lake Analytics

Dr. Subramani Paramasivam

Twitter: - https://twitter.com/dageop

LinkedIn: Dr. Subramani Paramasivam

Contact: http://www.yoursqlman.com/index.php/blogs

Dr.SubraMANI Paramasivam is a Microsoft MVP, PhD, Microsoft Certified Trainer and Head of Data AI at DAGEOP Ltd having 21 years of DB, BI, Analytics and AI experience. Mani has also spoken in various events like MS IGNITE, PASS Summit, MS Inspire, SQLBITS, Power Platform Summit, Global AI Bootcamp, Data BI Summit, SQLRelay, Power BI World Tour, Data Platform Summit, INSIDESQL UK, Global AI Nights, SQLServerGeeks Summit, MCT Global Summits, Data Day Events and various user group events. Mani also believes in Empowering Every Person in the planet and spreads the awareness on Global challenges via www.EmpoweringEveryPerson.com. He is also a co-owner of 1 Global AI Meetup and 3 Power BI PUG PASS local / user groups.

Vladimir Markovic

LinkedIn: Vladimir Markovic

Contact: https://rs.linkedin.com/in/vlmarkovic


Zoltán Horváth

Twitter: - @zoltanhorvath

LinkedIn: Zoltán Horváth

Contact: http://addictivemeasures.blogspot.com

Zolt#225;n is a BI specialist with more than a decade of expertise. He leads the Hungarian User Group of Microsoft SQL Server (HUG-MSSQL), the Hungarian Chapter of PASS. MCSE: BI and MCSE: Data Platform. SQL Server MVP since 2015.

Ivan Donev

Twitter: - https://twitter.com/ikdonev

LinkedIn: Ivan Donev

I am a Data platform MVP with more than 10 years of real-life experience with SQL Server and its stack of services. Besides the support and project work, I am also a trainer, conference speaker and user group organizer (and volunteer).

Catalin Gheorghiu

Twitter: - MrSmersh

LinkedIn: Catalin Gheorghiu

Contact: http://ronua.ro/author/catalin/

Catalin Gheorghiu is a solution architect from Romania. He has more than 15 years of experience in developing solutions, especially on Microsoft technologies in very demanding environments. Is contributing articles and blogs to several user groups (MrSmersh), lecturing all over Romania and abroad, is also RONUA Timisoara (PASS Chapter) user group leader. Since 2011, every year he was awarded the Microsoft MVP Award.

Miloš Radivojević

Twitter: - MilosSQL

LinkedIn: Miloš Radivojević

Contact: https://milossql.wordpress.com/

Miloš Radivojević is a database consultant located in Vienna, Austria. He is Data Platform MVP and specializes in SQL Server for application developers and performance and query tuning. Currently, he works as a principal database consultant in bwin GVC (the largest regulated online gaming company in the world). He is co-founder of the SQL Pass Austria and speaks regularly at local and international database conferences. He is also co-author of the books SQL Server 2016 Developer’s Guide, SQL Server 2017 Developer’s Guide and Mastering SQL Server 2017.

Christopher Adkin

Twitter: - ChrisAdkin8

LinkedIn: Christopher Adkin

Contact: http://www.chrisadkin.io

Chris is a freelance SQL consultant who has been working with SQL Server since 2000, his passion is for squeezing every last drop of performance out of SQL Server and understanding the database engine at a level which conventional tools cannot provide any insights on.

Mladen Andzic

LinkedIn: Mladen Andzic

Mladen is a Senior Program Manager in Azure SQL Database team, working on the SQL Managed Instance and data estate modernization in Azure. His current focus areas are high availability and service integration. Prior to joining Microsoft in 2016 Mladen spent 15 years in the software and financial services industry mostly working on the mission-critical systems. Ask him also about geospatial analytics - he loves it.

Jovan Popovic

Twitter: - https://twitter.com/JovanPop_MSFT

LinkedIn: Jovan Popovic

Senior program manager working in Microsoft Data Platform Group on different relational database systems such as SQL Server 2016+, Azure SQL Database, and Azure SQL Managed Instance. Worked on many features delivered in SQL Server 2016+, for example, JSON Support, T-SQL language, In-memory OLTP (Hekaton), Columnstore indexes, Temporal, Intelligent database features, etc. Jovan was presenter on many internal and public Microsoft events such as TechReady, PASS Summit, SQLSaturdays, etc. Jovan holds PhD degree in computer science.

Goran Milanov

LinkedIn: Goran Milanov

Contact: http://www.goranmilanov.rs

My areas of interest are Microsoft SQL Server and its services as the bases for development of Data Warehouse and Business Intelligence Systems (SSAS, SSRS, SSIS, MDS, DQS, PowerPivot, Tabular Model …). For the last five years I have been one of the coordinators of the Belgrade SQL Server User Group. In April 2012, I got the first Microsoft MVP award.

Tomaž Kaštrun

Twitter: - @tomaz_tsql

LinkedIn: Tomaž Kaštrun

Contact: http://www.tomaztsql.wordpress.com

Tomaž Kaštrun is BI developer and data analyst. His main focus are data mining, T-SQL development, programming and query optimization. He has been working with SQL server since version 2000. He is Microsoft Certified Professional, Microsoft MVP for data platform and Microsoft trainer.

Mihail Mateev

Twitter: - mihailmateev

LinkedIn: Mihail Mateev

Contact: https://mmateev.wordpress.com/

Mihail Mateev is a technical consultant, community enthusiast, PASS Regional Mentor for CEE, chapter lead, Microsoft Azure MVP, Microsoft Regional Director. He works as a Senior Solutions Architect at EPAM Systems, focused on Data Platform, IoT and cloud related solutions. He also worked many years like a Technical evangelist in the Infragistics. Last years Mihail was focused on various areas related to technology Microsoft: Data Platform, Visual Studio, ASP.Net, Windows client apps, Data Platform, and Microsoft Azure. Michael also has a PhD in cloud computing area. He is a university lecturer on Smart Homes and Smart Energy IoT Solutions.

Dejan Pervulov

Twitter: - @dekiper

As a technical consultant Dejan participated in numerous ERP, CRM and DWH / BI projects in the CEE region. He is also involved in development with Microsoft technologies for last 18 years. Holds MCT, MCSE, MCSA, MCSD, MCDBA, MCTS and MCITP certifications. As a Microsoft Certified Trainer he was involved in preparation and delivery of trainings in several school centers in Serbia. Since October 2014, he is a Microsoft MVP for SQL Server.


The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page