sqlsathistory

Nr: 644

Back to Main list

SQLSaturday #644 - Bratislava 2017

Start Time (24h) Speaker Track Title
10:15:00 Dejan Sarka BI Platform Architecture, Development Administration Forecasting with MS BI Suite
10:15:00 Dejan Dular Application Database Development In the name of the resources: Aggregating data
11:30:00 Mario Meir-Huber Cloud Application Development Deployment Doing Hadoop with Azure HDInsight
11:30:00 Hugo Kornelis Application Database Development T-SQL User-Defined Functions, or: How to kill performance in one, easy step
11:30:00 Roman Rehak Enterprise Database Administration Deployment Building Disaster Recovery solution with AlwaysOn
13:30:00 Marek Chmel Strategy and Architecture Running SQL Server as a Container
14:45:00 Dr. Subramani Paramasivam Analytics and Visualization Beginning Data Science-From Novice to Professional
14:45:00 Miloš Radivojević Application Database Development Parameter Sniffing Problem with Stored Procedures
16:00:00 Andrea Martorana Tusa BI Information Delivery Mobile BI with Microsoft tools
16:00:00 Dejan Dular Application Database Development Window functions are your friends

SessionID: 62831

Forecasting with MS BI Suite

Back to calendar

Event Date: 24-06-2017 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Dejan Sarka

Title: Forecasting with MS BI Suite

Abstract:

SessionID: 64261

In the name of the resources: Aggregating data

Back to calendar

Event Date: 24-06-2017 - Session time: 10:15:00 - Track: Application Database Development

Speaker: Dejan Dular

Title: In the name of the resources: Aggregating data

Abstract:

The queries that are used for reports are usually the least efficient because you are dealing with huge amounts of data from tables sometimes joined many, many times. In this session we will go through good and bad examples of aggregating the data from your relational database. You will see tips on how to get good use of the indexes, how to lower the number of actual table queries and other tricks that will make your queries run faster.

SessionID: 62835

Doing Hadoop with Azure HDInsight

Back to calendar

Event Date: 24-06-2017 - Session time: 11:30:00 - Track: Cloud Application Development Deployment

Speaker: Mario Meir-Huber

Title: Doing Hadoop with Azure HDInsight

Abstract:

SessionID: 63169

T-SQL User-Defined Functions, or: How to kill performance in one, easy step

Back to calendar

Event Date: 24-06-2017 - Session time: 11:30:00 - Track: Application Database Development

Speaker: Hugo Kornelis

Title: T-SQL User-Defined Functions, or: How to kill performance in one, easy step

Abstract:

User-defined functions in SQL Server are very much like custom methods and properties in .Net languages. At first sight, they seem to be the perfect tool to introduce code encapsulation and reuse in T-SQL. So why is this feature mostly avoided by all T-SQL gurus?

The reason is performance. In this session, you will learn how user-defined functions feed the optimizer with misleading and insufficient information, how the optimizer fails to use even what little information it has, and how this can lead to shocking query performance. However, you will also see that there is a way to avoid the problems. With just a little extra effort, you can reap the benefits of code encapsulation and reuse, and still get good performance.

SessionID: 64027

Building Disaster Recovery solution with AlwaysOn

Back to calendar

Event Date: 24-06-2017 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Roman Rehak

Title: Building Disaster Recovery solution with AlwaysOn

Abstract:

This presentation will cover generic issues and challenges involved in building a Disaster Recovery site, and then show you how you can build a hot DR site using the AlwaysOn Availability Groups technology in SQL Server 2016. It will provide tips and recommendations based on real life implementation. While the focus of the session will be on building a remote DR solution, much of the content will also be applicable to maintaining a local standby server using AlwaysOn.

SessionID: 62886

Running SQL Server as a Container

Back to calendar

Event Date: 24-06-2017 - Session time: 13:30:00 - Track: Strategy and Architecture

Speaker: Marek Chmel

Title: Running SQL Server as a Container

Abstract:

In this session we'll see how you can quickly benefit from using the new Windows Server 2016 feature called containers to run SQL servers in your environment. We will talk about the container technology which can be directly used for DevOps with SQL.

SessionID: 62877

Beginning Data Science-From Novice to Professional

Back to calendar

Event Date: 24-06-2017 - Session time: 14:45:00 - Track: Analytics and Visualization

Speaker: Dr. Subramani Paramasivam

Title: Beginning Data Science-From Novice to Professional

Abstract:

Where to begin the step 1 of data science to become a Data scientist? What are these Data Scientists up to? This is an initial data science session, for a novice and learn how easily you can step in to Data Science and start to become a professional.

How can we see and try using a data scientist statistical model in our day to day familiar tool like Microsoft SQL Server?

Thanks to Microsoft for integrating R Revolution within SQL Server 2016. We all now have the opportunity to use R packages and see the results within SQL 2016 and also to utilize it for any applications and/or Reporting services.

SessionID: 64491

Parameter Sniffing Problem with Stored Procedures

Back to calendar

Event Date: 24-06-2017 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Miloš Radivojević

Title: Parameter Sniffing Problem with Stored Procedures

Abstract:

Your stored procedure is slow in the application, but works perfect in SSMS! In this presentation it will be clarified why this happens and why parameter sniffing is a problem in SQL Server stored procedures. Of course, several solutions will be presented and it will be discussed which solution is applicable in which scenario.

SessionID: 62924

Mobile BI with Microsoft tools

Back to calendar

Event Date: 24-06-2017 - Session time: 16:00:00 - Track: BI Information Delivery

Speaker: Andrea Martorana Tusa

Title: Mobile BI with Microsoft tools

Abstract:

In SQL Server 2016 Microsoft added support for mobile reports to Reporting Services.

They also released the Mobile Report Publisher for authoring and creation of mobile reports. This application is based on Datazen technology, a company that Microsoft acquired in 2015. As Microsoft stated, using only one mobile BI app users will access dashboards and reports on mobile devices.

Now developers must choose a tool for developing BI optimized for mobile devices: SSRS, Mobile Report Publisher (former Datazen) or Power BI? The question is: which one to choose? What are the key factor for supporting the correct decision? We will provide a clear and understandable overview of each product, highlighting strengths and weaknesses. Based on some real examples we will set out a comparison matrix to find the best way to meet your needs with the right mobile reporting tool.

SessionID: 64262

Window functions are your friends

Back to calendar

Event Date: 24-06-2017 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Dejan Dular

Title: Window functions are your friends

Abstract:

What does SUM(Salary) OVER (ORDER BY EmployeeID RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) do exactly? Did you know that you can delete all duplicates in a table with just one query?

Window functions are great! They open a whole new world of elegant data analysis. Their only problem is that they seem complicated at first glance. In this session we will get OVER() them and see how can we use them together with aggregation, analytic and ranking functions. After this session creating queries with things like running totals will be a piece of cake!