sqlsathistory

Nr: 889

Back to Main list

SQLSaturday #889 - Prague 2019

Start Time (24h)	Speaker	Track	Title
09:00:00	Janusz Rokicki	Database Administration	Anomaly Detection in Predictive Maintenance for Sql Server
09:00:00	Angela Henry	Database Development	Profiling Your Data
09:00:00	Karel Rejthar	Business Intelligence	Maps in Power BI
10:15:00	Alexander Klein	Business Intelligence	Build your next BI solution in Azure
10:15:00	Neil Hambly	Database Administration	Performance Troubleshooting Using DMVs
10:15:00	Tomas Tucek	Data DevOps	CI, CD, CDE and DevOps Explained
11:30:00	Dejan Sarka	Data Science Machine Learning	Comparing Predictive Models from R, Python, SSAS, and Azure ML
11:30:00	Marcos Freccia	Database Administration	My 10 favorite PowerShell commands
11:30:00	Jiří Neoral	Business Intelligence	Power BI Row Level Security Deep Dive
12:35:00	Oleg Ulyanov	Database Administration	Successfully Virtualizing SQL Server on VMware vSphere: Straight from the Source
12:35:00	Tasty Lunch	Data DevOps	.
13:30:00	Luis Beltran	Data Science Machine Learning	Clever data: Building a chatbot from your database
13:30:00	Michal Chmelár	Business Intelligence	Power BI as a universal analytic tool
13:30:00	Dmitry Pilugin	Database Development	Intelligent Query Processing in SQL Server 2019
14:45:00	Christina Leo	Business Intelligence	Analytics on Azure: What to Use When
14:45:00	Ivan Donev	Business Intelligence	Designing your tabular/PowerBI model for performance and scalability
14:45:00	Cédric Charlier	Data Science Machine Learning	Data scientists have left ... How will I deploy their work?
16:00:00	Dr. Subramani Paramasivam	Data Science Machine Learning	Azure Machine Learning with Power BI
16:00:00	Damian Widera	Database Administration	Transaction Isolation Levels - that could be funny
17:15:00	Pinal Dave	Database Administration	Practical Real-World Performance Tuning for Accidental DBAs
17:15:00	Nicky van Vroenhoven	Business Intelligence	Power BI (Premium) Implementation at a Financial Institute
17:15:00	Tomaž Kaštrun	Data Science Machine Learning	Common Data Science Mistakes

SessionID: 93775

Anomaly Detection in Predictive Maintenance for Sql Server

Back to calendar

Event Date: 21-09-2019 - Session time: 09:00:00 - Track: Database Administration

Speaker: Janusz Rokicki

Title: Anomaly Detection in Predictive Maintenance for Sql Server

Abstract:

The amount of data we collect, store and process is rapidly growing and goes hand in hand with growing amount of work related to managing it. Automation is a key if we want to stay in control and AIOps represents its next major level with potential to revolutionise IT operations. This session explains what AIOps is, provides common use cases and gives practical examples that help to avoid costly Sql Server disruptions and eliminate firefighting. Presented solution addresses limitations of Query Store and automates the identification and resolution of common performance issues.

SessionID: 96718

Profiling Your Data

Back to calendar

Event Date: 21-09-2019 - Session time: 09:00:00 - Track: Database Development

Speaker: Angela Henry

Title: Profiling Your Data

Abstract:

Have you ever started a warehouse or ETL project and realized that the data wasn't as "clean" as you were told? If only you had profiled your data before you started then you wouldn't have to rework design elements, change code or redesign your database. In this session we will talk about what data profiling is, why you should do it and how you can do it with tools that are already included in the SQL Server BI stack.

SessionID: 98311

Maps in Power BI

Back to calendar

Event Date: 21-09-2019 - Session time: 09:00:00 - Track: Business Intelligence

Speaker: Karel Rejthar

Title: Maps in Power BI

Abstract:

In this session I show you what kind of maps can be used in Power BI. What type of map is useful for. Practically we will try 4 kinds of maps.

SessionID: 94158

Build your next BI solution in Azure

Back to calendar

Event Date: 21-09-2019 - Session time: 10:15:00 - Track: Business Intelligence

Speaker: Alexander Klein

Title: Build your next BI solution in Azure

Abstract:

Azure offers a variety of services that can be combined to form a BI solution in the cloud. What options does Azure currently offer to create a modern BI architecture? The components currently available range from Azure SQL DB and SQL DWH to Data Factory, Stream Analytics, Logic App, Databricks, Analysis Services and Power BI to name a few. This is a very good toolbox, with which you can achieve your first successes very quickly. Step by step you will learn how to create the classic ETL in the cloud and analyze the results in Power BI.

SessionID: 95870

Performance Troubleshooting Using DMVs

Back to calendar

Event Date: 21-09-2019 - Session time: 10:15:00 - Track: Database Administration

Speaker: Neil Hambly

Title: Performance Troubleshooting Using DMVs

Abstract:

Performance troubleshooting is a complex subject with many factors under consideration when you find poorly performing SQL statements, using proven methodologies, and evaluating performance data available in the Dynamic Management Views and Functions. In this session, we’ll go over a foundation of how and which DMVs to use to identify those problematic statements for versions of SQL Server from 2005 – 2017 and will also include improvements for the 2019 release.

We’ll be demonstrating using practical examples, including code that can be taken away and used on attendees’ own SQL Servers. We’ll also discuss how to identify common causes of performance issues, and learn how to quickly review and understand the wealth of performance data available.

SessionID: 98328

CI, CD, CDE and DevOps Explained

Back to calendar

Event Date: 21-09-2019 - Session time: 10:15:00 - Track: Data DevOps

Speaker: Tomas Tucek

Title: CI, CD, CDE and DevOps Explained

Abstract:

We, at Joyful Craftsmen, we are all the time meeting people asking

"... am I really able to deploy our data solution more often than once in a 3-6 months? Is that real? ..." The answer always is "Yes it is and yes you are!!!" Let's meet and have a light talk about how is that possible, what actually the buzzwords like CI (continuous integration), CD (continuous delivery), CDE (continuous deployment) and DevOps in our data platform world means and why it is important. Also with some real examples showing how simple that actually is ...

SessionID: 93235

Comparing Predictive Models from R, Python, SSAS, and Azure ML

Back to calendar

Event Date: 21-09-2019 - Session time: 11:30:00 - Track: Data Science Machine Learning

Speaker: Dejan Sarka

Title: Comparing Predictive Models from R, Python, SSAS, and Azure ML

Abstract:

There is a lot of overlapping in Microsoft BI suite. For advanced analytics, like data mining, you can use SQL Server Analysis Services (SSAS), or R, or Python, or Azure ML. The question arises which tool to use. The answer is simple, through another question. Why not all of them?

In data mining, you typically create multiple predictive models for the same task, and then evaluate them to select the best one. So why wouldn’t you even use different tools for different models? You will learn how to evaluate the predictive models. Then you will see how to bring all of the mining models together and compare them no matter of the source they come from. You will see how you can use SQL Server Integration Services, Excel, and other tools for this task.

SessionID: 93298

My 10 favorite PowerShell commands

Back to calendar

Event Date: 21-09-2019 - Session time: 11:30:00 - Track: Database Administration

Speaker: Marcos Freccia

Title: My 10 favorite PowerShell commands

Abstract:

As a DBA I am always trying to automate the tasks that I have to do. In this session, I want to show you 10 Powershell commands that will make your life easier and increase your productivity.

I promise that at least one new thing you will learn it

SessionID: 95462

Power BI Row Level Security Deep Dive

Back to calendar

Event Date: 21-09-2019 - Session time: 11:30:00 - Track: Business Intelligence

Speaker: Jiří Neoral

Title: Power BI Row Level Security Deep Dive

Abstract:

Common requirement for Power BI reports is displaying different data in same data model for different report consumers. During this session you will learn how to prepare your data model infrastructure and make Row Level Security work. Several approaches will be covered. Session is going to be applicable also for SSAS tabular.

SessionID: 96844

Successfully Virtualizing SQL Server on VMware vSphere: Straight from the Source

Back to calendar

Event Date: 21-09-2019 - Session time: 12:35:00 - Track: Database Administration

Speaker: Oleg Ulyanov

Title: Successfully Virtualizing SQL Server on VMware vSphere: Straight from the Source

Abstract:

Let us connect DBAs and Infrastructure Admins providing to DBAs vital information how to get best SQL Server deployment on top of VMware virtual platform. The session will cover both the design and the configuration of a SQL Server virtual machine with the special focus on:

• vCPU allocation and deep dive in vNUMA • Memory allocation and configurations options • Storage configuration best practices including PMem/NFS/Snapshots • Network configuration myths and best practices

It all that you want to know about virtual platform configuration but hesitated to ask! Directly from the source with the ton of hands-on from VMware Professional Services.

SessionID: 98556

.

Back to calendar

Event Date: 21-09-2019 - Session time: 12:35:00 - Track: Data DevOps

Speaker: Tasty Lunch

Title: .

Abstract:

Tasty Lunch

SessionID: 94086

Clever data: Building a chatbot from your database

Back to calendar

Event Date: 21-09-2019 - Session time: 13:30:00 - Track: Data Science Machine Learning

Speaker: Luis Beltran

Title: Clever data: Building a chatbot from your database

Abstract:

The development of Artificial Intelligence is increasingly present in our lives and as time goes by, its presence will grow thanks to the momentum that enterprises are currently providing.

One of the most engaging AI applications are chatbots, which interact with real-time users in order to assist them to perform a task -such as booking a hotel, answering a question or looking for specific information on the Internet- while simulating that a real human is behind the scene.

Data is knowledge, and the data that has been stored in your Azure SQL database can be used as an input for a bot which assists a company's customers in order to process the information for them and return expected results.

This session will be focused on explaining the actors involved when building a bot capable of obtaining data from your storage, including Azure SQL Database, Microsoft Bot Framework and LUIS (Language Understanding Intelligent Services). A mobile app built with Xamarin will be used as demo.

SessionID: 95320

Power BI as a universal analytic tool

Back to calendar

Event Date: 21-09-2019 - Session time: 13:30:00 - Track: Business Intelligence

Speaker: Michal Chmelár

Title: Power BI as a universal analytic tool

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: 96274

Intelligent Query Processing in SQL Server 2019

Back to calendar

Event Date: 21-09-2019 - Session time: 13:30:00 - Track: Database Development

Speaker: Dmitry Pilugin

Title: Intelligent Query Processing in SQL Server 2019

Abstract:

Performance is one of the most important parts of a healthy database system, but sometimes a query performance may suffer, for a variety of reasons. In one case we may find a reason and fix it easily, while in the other case, it is much harder.

SQL Server 2017 introduced a new approach for solving performance problems called Adaptive Query Processing. SQL Server 2019 evolves those mechanisms and the entire feature family now is named – Intelligent Query Processing.

The Intelligent query processing in SQL Server 2019 includes the following:

• Adaptive Query Processing enhancements
• Table Variable Deferred Compilation
• Approximate Query Processing
• Scalar UDF Inlining

In this session we will see how do these features work and in what cases they might be helpful.

SessionID: 94559

Analytics on Azure: What to Use When

Back to calendar

Event Date: 21-09-2019 - Session time: 14:45:00 - Track: Business Intelligence

Speaker: Christina Leo

Title: Analytics on Azure: What to Use When

Abstract:

Azure offers a comprehensive set of big-data solutions that help you gather, store, process, analyse and visualise data of any variety, volume or velocity, so you can discover new opportunities and take quick action. In this overview session, we’ll look at the various components within Azure that make up the Modern Data Warehouse, enable Real-Time Analytics, and support Advanced Analytics scenarios. You should leave with a high level understanding of the capabilities and limitations of each of the products within the Azure Analytics portfolio.

SessionID: 95298

Designing your tabular/PowerBI model for performance and scalability

Back to calendar

Event Date: 21-09-2019 - Session time: 14:45:00 - Track: Business Intelligence

Speaker: Ivan Donev

Title: Designing your tabular/PowerBI model for performance and scalability

Abstract:

You developed a PowerBI or an Analysis Services Tabular model and you run it on a server with plenty of cores and memory. But your queries does not scale or your users are not happy with the performance! So what can you do? You can fine tune the settings of your AS Tabular (usually does not bring a large benefit), you can scale up (which is costly) or you can apply the techniques I am going to show you in this session. Techniques, that range from optimizing the storage of your model, to how to effectively implement DAX patterns for maximum performance. And all of that, complemented with digging into engine execution plans, DMVs, tracing activity and tabular engine internals.

SessionID: 96529

Data scientists have left ... How will I deploy their work?

Back to calendar

Event Date: 21-09-2019 - Session time: 14:45:00 - Track: Data Science Machine Learning

Speaker: Cédric Charlier

Title: Data scientists have left ... How will I deploy their work?

Abstract:

Description

That's it, data scientists have left the house! Behind them, some scripts written in Python or R, thousands of CSV files, three sheets and two whiteboards of mathematical equations, many PowerPoint presentations and a clear instruction from the CEO: go to production ASAP! Unfortunately, no trace of a deployment procedure. Hopefully, this session, will explain how to industrialize data scientists' scripts. How to import and refactor code written in Jupyter Notebooks within VS Code, How to put in place the best practices of DevOps and apply them to Machine Learning with Azure Pipelines and some other tips and tricks for a successful go-live.

SessionID: 93957

Azure Machine Learning with Power BI

Back to calendar

Event Date: 21-09-2019 - Session time: 16:00:00 - Track: Data Science Machine Learning

Speaker: Dr. Subramani Paramasivam

Title: Azure Machine Learning with Power BI

Abstract:

This session covers connected Python scripts from Jupyter Notebook, executing Azure Machine Learning models and the Stream Analytics job pushing data to Power BI. This is a great feature, where users learn how Azure ML are used for Power BI output.

SessionID: 96201

Transaction Isolation Levels - that could be funny

Back to calendar

Event Date: 21-09-2019 - Session time: 16:00:00 - Track: Database Administration

Speaker: Damian Widera

Title: Transaction Isolation Levels - that could be funny

Abstract:

Every developer and DBA should know way more beyound how the default transaction isolation level to make sure they know what to expect when working with them. I will present all of the levels and show you some suprising facts about them. We will go through various if deep demos that show what goes on internally in the SQL Server

SessionID: 95242

Practical Real-World Performance Tuning for Accidental DBAs

Back to calendar

Event Date: 21-09-2019 - Session time: 17:15:00 - Track: Database Administration

Speaker: Pinal Dave

Title: Practical Real-World Performance Tuning for Accidental DBAs

Abstract:

In most of the organizations, accidental DBAs are the individuals who are often responsible for the SQL Server Performance. In the real world when we face any performance problems, we do not have the luxury to open PowerPoint and study theory. What helps us during the time of crisis are handy scripts which help us fix our performance problems.

In this quick paced, demonstration-oriented learning session, we will see how we can immediately help our application with performance if we just know what exactly to do. We will cover the following topics during our session a) Learn and Implement best deployment and configurations practices b) Indexing (and statistics) best practices deployments c) Understanding cardinality and compatibility levels and their impact d) Enabling SQL Server 2019 (on-premises and cloud) new features e) Secret Performance Tuning Scripts

SessionID: 95369

Power BI (Premium) Implementation at a Financial Institute

Back to calendar

Event Date: 21-09-2019 - Session time: 17:15:00 - Track: Business Intelligence

Speaker: Nicky van Vroenhoven

Title: Power BI (Premium) Implementation at a Financial Institute

Abstract:

Back to September 2016: Power BI is new, shiny and hot. It is the tool of the moment, so people cannot wait to get their hands on it.

Fast forward 6 months, there is more traction within the business, training is given and workshops are held. The adoption of Power BI is growing. Some departments already use Power BI very extensively and incorporate it in their day-to-day processes. Due to this quick success there is uncertainty regarding the right support team for incidents and problems. Because an app workspace creates an Office 365 group with a lot of artifacts behind the scenes, the creation workflow is controlled by IT. Unfortunately this inhibits the end users. We require more governance, not to further bother the users, but it is essential to stay in control. Responsibilities need to be better aligned between IT and the business. Throughout this session we take you along on our Power BI journey, with tips, tricks, do's and don'ts during the implementation of Power BI (Premium).

SessionID: 95682

Common Data Science Mistakes

Back to calendar

Event Date: 21-09-2019 - Session time: 17:15:00 - Track: Data Science Machine Learning

Speaker: Tomaž Kaštrun

Title: Common Data Science Mistakes

Abstract:

In the middle of deploying the model, team of data scientists realize that the predictions are "somewhat-off". Troubleshooting on the horizon and what to do. Session will guide you through most common mistakes data scientists and statisticians are making when preparing and engineering the data using T-SQL or any other database system. Further more, we will explore common statistical and data science mistakes when modeling data, extracting know-how from the data, finding the hidden patterns and running different test against the structural models using mainly R, Python, or Spark. What not-to-do will be replaced with what to-do explanations using sample datasets and sample codes. Some statistical knowledge or background is a plus!

This site is open source. Improve this page.