SQLSaturday #601 - Belgrade 2017
Event Date: 03/18/2017 00:00:00
Event Location:
- Univerzitet Singidunum
- Kumodraška 261, Beograd
- Belgrade, Belgrade, Serbia
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).
Sessions
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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- Veljko Vasic
Track and Room: Cloud Application Development Deployment - Room 015
Title: Welcome note - Room 2
Abstract: Keynote session
Speaker(s):
- 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!
Speaker(s):
- 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.
Speaker(s):
- Dr. Subramani Paramasivam
Track and Room: Analytics and Visualization - Room 001
Title: Welcome note - Room 1
Abstract: Keynote session
Speaker(s):
- 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
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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
Speaker(s):
- Catalin Gheorghiu
Track and Room: Application Database Development - Room 001
Title: Row-level security
Abstract: Row-level security
Speaker(s):
- 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.
Speaker(s):
- Maja Damjanic
Track and Room: Analytics and Visualization - Room 015
Title: SQL Server 2012+ Statistical Semantic Search
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.
Speaker(s):
- Matija Lah
Track and Room: Application Database Development - Room 001
Title: Welcome note - Room 3
Abstract: Keynote session
Speaker(s):
- 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).
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- Mihail Mateev
Track and Room: Cloud Application Development Deployment - Room 015
Speakers
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
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.
Sponsors
The following is a list of sponsors that helped fund the event: