Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type

Sessions Found: 21
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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database & Application Development

Level: Intermedia

Session Code:

Date: December 08

Time: 10:15 AM - 11:15 AM

Room: Tower

Once in a while I need to deploy dozens of reports, data sources, permissions and subscriptions across multiple Reporting Services folders. 
Some time ago, I accomplished this by hand, wasting hours of my life. Nowadays it takes me a couple of minutes and I'm done.

In this session I will share how you can leverage on ReportingServicesTools PowerShell module to deploy your reports, manage permissions and subscriptions and stop waste your time with some of those trivial tasks.

We will see examples for both Reporting Services and PowerBI Report Server.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration & Deployment

Level: Intermedia

Session Code:

Date: December 08

Time: 9:00 AM - 10:00 AM

Room: Panorama

If you want to accelerate the testing of your BI solutions, the best strategy is the automation of your tests with the help of a dedicated framework. During this session, we’ll take a look to the features of the open-source framework named “NBi” (www.nbi.io). This framework is providing support for automated tests on the fields of databases, cubes, reports and ETLs, without the need of .Net skills. The demos will show us the best approaches to quickly and effectively assert the quality of BI developments. We'll go a step further, generating the tests by an interesting system of templates and test-cases sources.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: December 08

Time: 1:30 PM - 2:30 PM

Room: Tower

Have you ever imagined throwing away all of the index maintanance, deadlocks, page files and database micro-management, but keeping the same query performance? Imagine a tool where you can easily cooperate with a Python/Scala/Java developer or Python/R data scientist. Imagine a tool where you can do not only end-to-end ETL but also machine learning, stream processing or graph analysis. Imagine Spark Databricks.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Science & Machine Learning

Level: Beginner

Session Code:

Date: December 08

Time: 4:00 PM - 5:00 PM

Room: Panorama

Data Modeling is a crucial part of every BI or Data Warehouse project. This topic was the main topic for Data Warehouses but new Big Data solutions (e.g. Data Lake) can also benefit from this interesting topic. This session will introduce participants into basic data modeling techniques and will show some basic example how to properly use them.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: December 08

Time: 4:00 PM - 5:00 PM

Room: Empiria

This is a session about practical approach to the data analysis. I do not know much about mushrooms but I know that some of them could be poisonous. But what about other mushrooms? Should I eat them or not? If you have the same doubts than you should attend the session. I would like to  show you the machine learning and neural networks approach in such type of problems. And then you will see how you can generalize the approach to other types of problems as well.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Science & Machine Learning

Level: Intermedia

Session Code:

Date: December 08

Time: 1:30 PM - 2:30 PM

Room: Panorama

Do you have more than 1 server and database to manage? Then, this session is absolutely for you. Dbatools is the Open Source PowerShell module for managing SQL Server. You will learn tips and tricks that will help you manage SQL Servers and get more with a single button click. Dbatools is becoming the number 1 PowerShell module for DBAs that need to manage several databases. If you want to get improve your efficiency in your work you should attend this session.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration & Deployment

Level: Beginner

Session Code:

Date: December 08

Time: 2:45 PM - 3:45 PM

Room: Tower

SQL (the language) is not a third generation language, where the developer tells the computer every step it needs to take. It is a declarative language that specifies the required results. SQL Server itself will figure out what steps it takes to get to those results. Most of the time, that works very well.

But sometimes it doesn't. Sometimes a query takes too much time. You need to find out why, so you can fix it. That's where the execution plan comes in. In the execution plan, SQL Server exposes exactly which steps it took for your query, so you can see why it's slow.

However, execution plans can be daunting to the uninitiated. Especially for complex queries. Where do you even start?

In this session you will learn how to obtain execution plans. and how to start reading and understanding them.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database & Application Development

Level: Beginner

Session Code:

Date: December 08

Time: 1:30 PM - 2:30 PM

Room: Empiria

Regardless of what football league you follow, some years the title chase can be quite boring. A football podcast in the US (Men in Blazers) came up with an interesting idea - what if we ranked the English Premier League by the Twitter sentiment of the supporters at the end of the match? I heard that episode and created the Premier League Mood Table for them to discuss on the podcast. While the premise of a mood table might be quite silly, the underlying concepts and technology are relevant to any company with a social media sales presence. Join me as I walk us through using Azure Logic Apps, Cognitive Services, and Azure SQL Database to store and analyze Twitter sentiment that can impact your company's bottom line - and potentially yours as well!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Data Science & Machine Learning

Level: Beginner

Session Code:

Date: December 08

Time: 5:15 PM - 6:15 PM

Room: Tower

If you flirt with SSAS Tabular or you are forced by circumstances to start you journey as SSAS Tabular developer. If you work with Power BI and wand to understand the engine better. Or if you just want to understand basics of SSAS Tabular technology and its traps. Join me for a short ride around SSAS Tabular galaxy. We will look into basic concepts, architecture and development process of SSAS Tabular.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: December 08

Time: 2:45 PM - 3:45 PM

Room: Panorama

The VertiPaq engine used by SQL Server Analysis Services Tabular, Power BI, and Power Pivot, is a columnar database capable of incredible performances, both in speed and compression ratio. In this session, we will perform a deep dive in the internals of the database architecture, discovering how Vertipaq stores information, in order to gain better insights into the engine and understand the best way to model your data warehouse to leverage the features of VertiPaq. We will show common and useful techniques to increase the compression ratio and obtain better performances from your Tabular data model.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Advanced

Session Code:

Date: December 08

Time: 10:15 AM - 11:15 AM

Room: Empiria

Who does not know the problem, you sit in the bar and just don't know which cocktail to order?
The Cogntive services offer here with face, emotion and recommendation three APIs that can help you. How do you best combine these services to get a suggestion for your cocktail?
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Data Science & Machine Learning

Level: Beginner

Session Code:

Date: December 08

Time: 9:00 AM - 10:00 AM

Room: Tower

Session will cover how to use Power BI as a tool for monitoring of BI solutions and more. Topics covered will include SSRS usage logging. ETL load runs. Consumption of Power BI reports & dashboards in Power BI service
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: December 08

Time: 12:15 PM - 1:15 PM

Room: Panorama

Depending on a query plan SQL Server may choose to process a query in a serial or a parallel way. With a parallel query processing a server may utilize more CPUs and complete a query faster, however, managing parallel execution is not simple and demands additional resources, so for some quires a serial execution is better. The balance is important.

In this session we will look at the balance from the Query Processor prospective. We will learn the reasons: how and why does a server choose a parallel or a serial plan. We will learn how to read and interpret parallel plans and look at some important aspects of a parallel plan analysis. After this session you will know what to look at, when the next time you have to deal with parallelism in SQL Server.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database & Application Development

Level: Advanced

Session Code:

Date: December 08

Time: 9:00 AM - 10:00 AM

Room: Empiria

Every user wants to have his/hers reports generated quickly. But reality isn't so cute. Sometimes you have to wait and wait, and wait again while looking at the rotating green circle.
During my session you will learn how to monitor Reporting Services with the Execution Log.  I will show the structure of the log and some useful queries to get precise insights into report generating process. Analysing the log gives you a quick way to find bottlenecks and sources of your problems. Especially when you use a tool like Power BI or Excel to create a functional dashboard. You also will learn how to use R powered models in Power BI to predict problems with your reports execution.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: December 08

Time: 5:15 PM - 6:15 PM

Room: Panorama

Developer’s best practice is to check query plan before the query or procedure is ready for testing or moving into production. We have two kinds of plans for this purpose -  Estimated and Actual Execution Plan. Both plans can be obtained easily during development – just make an appropriate action before you run the query and you will get what you want – either Estimated or Actual Execution plan.
The situation in production is a bit complicated. In some cases exploring the plan cache and analyzing Estimated plans can be good enough to fix problematic queries. In other cases we would need to analyze runtime statistics, available in Actual Execution Plans only. 
In this session we will cover query profiling infrastructure available in SQL Server since SQL Server 2008 (including SQL Server 2019) and query profiling options on global, session and query level.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database & Application Development

Level: Beginner

Session Code:

Date: December 08

Time: 4:00 PM - 5:00 PM

Room: Tower

There are weird things in life. Even weirder for developers... "It should work!"... What you see is NOT what you get... There's a bug, a feature, a workaround...
Disclaimer: No feline was harmed in the making of this session. Please do not report it to the Pražský spolek ochráncu zvírat...
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration & Deployment

Level: Beginner

Session Code:

Date: December 08

Time: 12:15 PM - 1:15 PM

Room: Empiria

Machine learning isn't just a buzzword anymore. It's everywhere! Text-sentiment analysis, face recognition in images/videos, real-time text/voice translation... you name it! Tons of applications use powerful Artificial Intelligence algorithms which analyze and process millions of data in order to provide a suitable, reliable experience.

But... did you know that you can use SQL Server to create powerful machine learning models with Python code and deploy them to your SQL instance? What about building predictive models in R using a SQL Server datasource so you can foresee the future? Well, with SQL Server Machine Learning Services this is possible (and more, much more!).

In this session, I will show you how to prepare your environment to do ML in SQL Server, as well as some cool demos.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Data Science & Machine Learning

Level: Beginner

Session Code:

Date: December 08

Time: 10:15 AM - 11:15 AM

Room: Panorama

It is very common to use temporary data structures in the database. In SQL Server, we can choose between temporary tables (#MyTable) and table variables (@MyTable). There are many differences between these two structures, some are obvious and well known, and some might surprise you.
The main difference in terms of performance is statistics, which exist for a temporary table, but do not exist for a table variable. For that reason, there can be a huge difference in performance of a stored procedure that uses one data structure or the other.
In this session, we will demonstrate the differences and analyze performance for various use cases. We will cover all kinds of ways to work with these data structures, such as OPTION (RECOMPILE) and trace flag 2453.
By the end of this session you will know exactly when and how to use each one in order to achieve the desired functionality with the best performance.
This is a must session for every SQL Server developer.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database & Application Development

Level: Intermedia

Session Code:

Date: December 08

Time: 5:15 PM - 6:15 PM

Room: Empiria

This session aims to explore all the features offered by the language T-SQL for aggregating and calculating data. There's much more of the clause GROUP BY.
With grouping and ranking functions you can calculate in your query grandtotal, running totals, find islands in intervals, select the last-not-null value, etc.
Windows functions apply directly on a set of rows defined by the OVER clause ("a window"). Windows function do not perform aggregation on group level and do not hide row details.
So they allow mixing detail and total elements in the same query.
The session is mainly based on a copious array of demos, to make explicit every concept introduced taking into account the impact on performances for every solution.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database & Application Development

Level: Advanced

Session Code:

Date: December 08

Time: 12:15 PM - 1:15 PM

Room: Tower

Sessions Found: 21
Back to Top cage-aids
cage-aids
cage-aids
cage-aids