sqlsathistory

Nr: 873

Back to Main list

SQLSaturday #873 - Bratislava 2019

Start Time (24h) Speaker Track Title
09:15:00 Mikael Wedham Enterprise Database Administration Deployment A Masters view on Locking and blocking
09:15:00 Michal Chmelár Analytics and Visualization Power BI as a universal analytic tool 1/2
10:30:00 Damir Matesic Application Database Development Advanced data types – JSON
10:30:00 Michal Chmelár Analytics and Visualization Power BI as a universal analytic tool 2/2
11:45:00 Gergely Csom Advanced Analysis Techniques Power BI loves AI and Azure AI Services
11:45:00 Aleksandar Talev Enterprise Database Administration Deployment How to choose the right data model: SQL Server or Azure Cosmos DB. Which, When and Where ?
13:45:00 Marek Chmel Enterprise Database Administration Deployment SQL Server Big Data Clusters
15:00:00 Oskari Heikkinen BI Platform Architecture, Development Administration Introduction to Azure Data Lake
15:00:00 Damir Matesic Application Database Development MS SQL New functions, syntaxes, tips tricks

SessionID: 90572

A Masters view on Locking and blocking

Back to calendar

Event Date: 08-06-2019 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Mikael Wedham

Title: A Masters view on Locking and blocking

Abstract:

How do the wait stats show you that you have a locking issue?

This session will show you how to detect and view blocking and lock waits, and understand the cause of it. An extensive walkthrough of the different isolation levels and their respective benefits and drawbacks. And finally a real-world quick list of suggestions on what you can do to solve some of the common issues I come across in my daily work.

SessionID: 94210

Power BI as a universal analytic tool 1/2

Back to calendar

Event Date: 08-06-2019 - Session time: 09:15:00 - Track: Analytics and Visualization

Speaker: Michal Chmelár

Title: Power BI as a universal analytic tool 1/2

Abstract:

In Power BI, you can also do other kinds of analyses than just business analytics. In this lecture you’ll see, how you can use Power BI together with cloud services for quick check of facts from freely available data sources, even if they aren’t published in a particularly suitable format. You will also see, how you can quickly analyze unstructured text (e.g. communication with customers). At the end we will take a look at PowerApps, using which you can not only quickly create a new business app in your web browser, but also integrate it in your Power BI reports, so that you can quickly react to results and take action from a single environment. Because Power BI is capable of doing much more than “just” business analyses.

SessionID: 92006

Advanced data types – JSON

Back to calendar

Event Date: 08-06-2019 - Session time: 10:30:00 - Track: Application Database Development

Speaker: Damir Matesic

Title: Advanced data types – JSON

Abstract:

Main topics:

SessionID: 94211

Power BI as a universal analytic tool 2/2

Back to calendar

Event Date: 08-06-2019 - Session time: 10:30:00 - Track: Analytics and Visualization

Speaker: Michal Chmelár

Title: Power BI as a universal analytic tool 2/2

Abstract:

In Power BI, you can also do other kinds of analyses than just business analytics. In this lecture you’ll see, how you can use Power BI together with cloud services for quick check of facts from freely available data sources, even if they aren’t published in a particularly suitable format. You will also see, how you can quickly analyze unstructured text (e.g. communication with customers). At the end we will take a look at PowerApps, using which you can not only quickly create a new business app in your web browser, but also integrate it in your Power BI reports, so that you can quickly react to results and take action from a single environment. Because Power BI is capable of doing much more than “just” business analyses.

SessionID: 92774

Power BI loves AI and Azure AI Services

Back to calendar

Event Date: 08-06-2019 - Session time: 11:45:00 - Track: Advanced Analysis Techniques

Speaker: Gergely Csom

Title: Power BI loves AI and Azure AI Services

Abstract:

Power BI - Microsoft's favorite analytics tool has played a very significant role in spreading data driven culture among organizations. From the beginning Power BI was enhanced with many AI techniques, and plays a vital role in Microsoft's recent mission on "Democratizing AI".

In my demo heavy presentation I will give a minimal overview on Power BI and Power BI Premium to give a context, and after it we will examine how AI is infused into PowerBI helping analysts became more productive in discovering hidden gems with functionality as of today from QA, Quick Insight, Explain differences etc. to R and Python integration In the second part of the presentation we will overview and try Microsoft's recent announcement arount integrating more deeply AI/ML into the product with functionalities like Automated ML, Azure ML integration and Azure Cognitive Services integration.

SessionID: 93352

How to choose the right data model: SQL Server or Azure Cosmos DB. Which, When and Where ?

Back to calendar

Event Date: 08-06-2019 - Session time: 11:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Aleksandar Talev

Title: How to choose the right data model: SQL Server or Azure Cosmos DB. Which, When and Where ?

Abstract:

When it comes to choosing a database, always there are considerations about picking a relational (SQL) or non-relational (NoSQL) data structure. While both are viable options, there are certain key differences between these two options that users must keep in mind.This session will cover the most important distinctions and will make a difference between two of a key players in the Microsoft database world: SQL Server and Azure Cosmos DB. The session will also illustrate some of the fundamental differences between these databases - the language, scalability and structure which cause this distinctions to have implications for the right choice.So which database is right for your business the attendance will take informations in this session.

SessionID: 90567

SQL Server Big Data Clusters

Back to calendar

Event Date: 08-06-2019 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Marek Chmel

Title: SQL Server Big Data Clusters

Abstract:

SQL Server big data clusters allow you to deploy scalable clusters of SQL Server, Spark, and HDFS containers running on Kubernetes. We'll dive into all the technologies to see how can you leverage SQL Server to be your big data platform.

SessionID: 90532

Introduction to Azure Data Lake

Back to calendar

Event Date: 08-06-2019 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Oskari Heikkinen

Title: Introduction to Azure Data Lake

Abstract:

Azure Data Lake is an umbrella term consisting of multiple Azure services. As the name implies, these services are built for big data processing purposes. During this session, you will gain the understanding of which service to use and when - as well as when not to use. My aim is to deliver the fundamentals around the topic so that you can feel comfortable before your first dive into the Lake. I will also do demos using the latest and greatest services.

SessionID: 93629

MS SQL New functions, syntaxes, tips tricks

Back to calendar

Event Date: 08-06-2019 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Damir Matesic

Title: MS SQL New functions, syntaxes, tips tricks

Abstract:

Maybe you are still using some old MS SQL database engine and you are unsure why you should upgrade to 2016 or newer versions?

In this session we will see what bring us some newly introduced MS SQL functions and syntaxes like COMPRESS, STRING_SPLIT, STRING_AGG, DROP IF EXISTS (a.k.a. DIE) and many more. How are they performing compared to some old solutions? Accompanied with multiple examples, this session will show you many interesting topics.

This site is open source. Improve this page.