sqlsathistory

Nr: 601

SQLSaturday #601 - Belgrade 2017

Start Time (24h)	Speaker	Track	Title
09:00:00	Goran Milanov	Information Delivery	Welcome note - Room 1
09:00:00	Vladimir Markovic	Information Delivery	Welcome note - Room 2
09:00:00	Dejan Pervulov	Information Delivery	Welcome note - Room 3
09:15:00	Zoltán Horváth	BI Platform Architecture, Development Administration	SSAS Query Performance Tuning
09:15:00	Janos Berke	Enterprise Database Administration Deployment	What is new in SQL Server 2016 Availability Group [EN]
09:15:00	Veljko Vasic	Cloud Application Development Deployment	Achieve great performance with Azure SQL Database using built-in intelligence
10:30:00	Christopher Adkin	Enterprise Database Administration Deployment	Problem Solving With The In-Memory Engine
10:30:00	Maja Damjanic	Analytics and Visualization	Big data solutions on Microsoft Azure
11:45:00	Dejan Sarka	BI Platform Architecture, Development Administration	High-Performance Statistical Queries
11:45:00	Catalin Gheorghiu	Application Database Development	SQL database on IoT devices, could you? should you? would you?
11:45:00	Jovan Popovic	Application Database Development	SQL Server and JSON in real applications
13:45:00	Tomaž Kaštrun	Analytics and Visualization	Microsoft Azure Machine Learning Algorithms
13:45:00	Milos Todic	Application Database Development	Columnstore Index Internals
13:45:00	Dragoslav Ogar	Enterprise Database Administration Deployment	Row-level security
15:00:00	Dr. Subramani Paramasivam	Analytics and Visualization	Think work like a Data Scientist with SQL 2016 R
15:00:00	Miloš Radivojević	Enterprise Database Administration Deployment	Call 555 - 333 for Query Store
15:00:00	Mladen Andzic	Analytics and Visualization	Spatial Analytics with SQL Server 2016 and Azure SQL Database
16:15:00	Ivan Donev	Application Database Development	Notes from the field of a Microsoft SQL Engineer
16:15:00	Mihail Mateev	Cloud Application Development Deployment	Creating Custom BI Solutions with Power BI Embedded

SessionID: 63421

Welcome note - Room 1

Back to calendar

Event Date: 18-03-2017 - Session time: 09:00:00 - Track: Information Delivery

Speaker: Goran Milanov

Title: Welcome note - Room 1

Abstract:

Keynote session

SessionID: 63422

Welcome note - Room 2

Back to calendar

Event Date: 18-03-2017 - Session time: 09:00:00 - Track: Information Delivery

Speaker: Vladimir Markovic

Title: Welcome note - Room 2

Abstract:

Keynote session

SessionID: 63423

Welcome note - Room 3

Back to calendar

Event Date: 18-03-2017 - Session time: 09:00:00 - Track: Information Delivery

Speaker: Dejan Pervulov

Title: Welcome note - Room 3

Abstract:

Keynote session

SessionID: 59397

SSAS Query Performance Tuning

Back to calendar

Event Date: 18-03-2017 - Session time: 09:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Zoltán Horváth

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.

SessionID: 61703

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

Back to calendar

Event Date: 18-03-2017 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Janos Berke

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.

SessionID: 62571

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

Back to calendar

Event Date: 18-03-2017 - Session time: 09:15:00 - Track: Cloud Application Development Deployment

Speaker: Veljko Vasic

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.

SessionID: 56945

Problem Solving With The In-Memory Engine

Back to calendar

Event Date: 18-03-2017 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Christopher Adkin

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

SessionID: 61738

Big data solutions on Microsoft Azure

Back to calendar

Event Date: 18-03-2017 - Session time: 10:30:00 - Track: Analytics and Visualization

Speaker: Maja Damjanic

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.

SessionID: 56914

High-Performance Statistical Queries

Back to calendar

Event Date: 18-03-2017 - Session time: 11:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Dejan Sarka

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.

SessionID: 61150

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

Back to calendar

Event Date: 18-03-2017 - Session time: 11:45:00 - Track: Application Database Development

Speaker: Catalin Gheorghiu

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

SessionID: 61740

SQL Server and JSON in real applications

Back to calendar

Event Date: 18-03-2017 - Session time: 11:45:00 - Track: Application Database Development

Speaker: Jovan Popovic

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.

SessionID: 58059

Microsoft Azure Machine Learning Algorithms

Back to calendar

Event Date: 18-03-2017 - Session time: 13:45:00 - Track: Analytics and Visualization

Speaker: Tomaž Kaštrun

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.

SessionID: 62435

Columnstore Index Internals

Back to calendar

Event Date: 18-03-2017 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Milos Todic

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.

SessionID: 63099

Row-level security

Back to calendar

Event Date: 18-03-2017 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Dragoslav Ogar

Title: Row-level security

Abstract:

Row-level security

SessionID: 57938

Think work like a Data Scientist with SQL 2016 R

Back to calendar

Event Date: 18-03-2017 - Session time: 15:00:00 - Track: Analytics and Visualization

Speaker: Dr. Subramani Paramasivam

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.

SessionID: 59303

Call 555 - 333 for Query Store

Back to calendar

Event Date: 18-03-2017 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Miloš Radivojević

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).

SessionID: 62507

Spatial Analytics with SQL Server 2016 and Azure SQL Database

Back to calendar

Event Date: 18-03-2017 - Session time: 15:00:00 - Track: Analytics and Visualization

Speaker: Mladen Andzic

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.

SessionID: 57055

Notes from the field of a Microsoft SQL Engineer

Back to calendar

Event Date: 18-03-2017 - Session time: 16:15:00 - Track: Application Database Development

Speaker: Ivan Donev

Title: Notes from the field of a Microsoft SQL Engineer

Abstract:

SessionID: 57572

Creating Custom BI Solutions with Power BI Embedded

Back to calendar

Event Date: 18-03-2017 - Session time: 16:15:00 - Track: Cloud Application Development Deployment

Speaker: Mihail Mateev

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.

This site is open source. Improve this page.