| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:15:00 | Satya Jayanty | Cloud Application Development Deployment | Azure Cosmos DB - What you need to know to build globally distributed apps? |
| 09:15:00 | Alexander Klein | Advanced Analysis Techniques Machine Learning | 101 BI and AI |
| 09:15:00 | Oskari Heikkinen | BI Platform Architecture, Development Administration | Introduction to Azure Data Lake |
| 09:15:00 | Daniel Hutmacher | Application Database Development | Not just polish – How good code also runs faster |
| 09:15:00 | Dave Ruijter | Analytics and Visualization | Power BI Cheat Sheet explained! |
| 10:30:00 | John Martin | Enterprise Database Architecture, Administration Deployment | Making Managed Instance Perform, a dive into storage. |
| 10:30:00 | Vedran Kesegic | Application Database Development | SQL Server Magic Show |
| 10:30:00 | Jani K. Savolainen | Enterprise Database Architecture, Administration Deployment | Monitoring Mission-critical SQL Servers: How to utilize alerting to predict system bottlenecks |
| 10:30:00 | Arun Justus | Advanced Analysis Techniques Machine Learning | Arun's and Vesa's Azure SQL DW deep-dive version 2 for Gen2 |
| 12:30:00 | Andrea Martorana Tusa | Application Database Development | T-SQL advanced: Grouping and Windowing |
| 12:30:00 | Mihail Mateev | BI Platform Architecture, Development Administration | Power BI Premium vs Power BI Embedded for Modern BI Solutions |
| 12:30:00 | Jose Manuel Jurado Diaz | Enterprise Database Architecture, Administration Deployment | Attention Contention!!! |
| 12:30:00 | Kevin Kline | Application Database Development | Ten Query Tuning Techniques Every SQL Programmer Should Know |
| 12:30:00 | Mika Sutinen | Other | DBA as the Cloud era Data Professional |
| 13:40:00 | Andrea Martorana Tusa | Analytics and Visualization | Failure prediction for manufacturing industry with SQL Server R |
| 13:40:00 | Pekka Korhonen | Advanced Analysis Techniques Machine Learning | SQL Server Machine Learning Services with R and Python |
| 13:40:00 | Jouko Nyholm | BI Platform Architecture, Development Administration | Dataflow - The Power BI Version - Role in Data Platform strategy, |
| 13:40:00 | Ola Hallengren | Enterprise Database Architecture, Administration Deployment | Analyzing Performance Problems Using XEvents, DMVs Query Store |
| 14:50:00 | Erland Sommarskog | Application Database Development | When Things go Wrong - Error Handling in SQL Server |
| 14:50:00 | Marc Lelijveld | Analytics and Visualization | Storytelling interactive reports with Power BI Bookmarks Drillthrough |
| 14:50:00 | Rami Laine | Enterprise Database Architecture, Administration Deployment | SQL Server 2019 Architecture - High Availability and Disaster rec |
| 14:50:00 | Vesa Tikkanen | BI Platform Architecture, Development Administration | Data Flow - The Azure version deepdive |
| 16:00:00 | Andrew Pruski | Enterprise Database Architecture, Administration Deployment | SQL Server Kubernetes |
| 16:00:00 | Dave Ruijter | Advanced Analysis Techniques Machine Learning | Artificial Intelligence for the business analyst, leveraging new AI features in Power BI |
| 16:00:00 | Pinal Dave | Application Database Development | Kick Start! SQL Server 2017 Performance Tips and Tricks |
| 16:00:00 | Zhenbo Zhang | BI Platform Architecture, Development Administration | Mondern Data Lake - Foundation for Advanced Analytics and Busines |
Event Date: 11-05-2019 - Session time: 09:15:00 - Track: Cloud Application Development Deployment
Event Date: 11-05-2019 - Session time: 09:15:00 - Track: Advanced Analysis Techniques Machine Learning
How can the AI make my BI application smarter? Everybody is talking about AI but what can you do with it today? Currently there are tools like the Cognitive Services, Azure ML or Azure Bot Framework, which can help in the classic ETL process to prepare or enrich data. Examples are the analysis of large data streams from the IoT area, how can I improve my demand planning of a call center or the analysis of social media regarding trends. If you already have your BI application in the cloud, Azure Data Factory, Logic App or Azure Stream Analytics would be the right components for an AI extension.
Event Date: 11-05-2019 - Session time: 09:15:00 - Track: BI Platform Architecture, Development Administration
Event Date: 11-05-2019 - Session time: 09:15:00 - Track: Application Database Development
But most of all, they’ll make the code prettier and easier to understand for the next person.
We’ll look at common ways that null values, implicit datatype conversions and foreign key constraints can radically affect the performance of your queries. Inspired by an actual client case, where I tuned a 20 hour query down to a few minutes, with only a minor code change.
This presentation is all-code, some execution plans, and no-powerpoint.
Event Date: 11-05-2019 - Session time: 09:15:00 - Track: Analytics and Visualization
Event Date: 11-05-2019 - Session time: 10:30:00 - Track: Enterprise Database Architecture, Administration Deployment
Event Date: 11-05-2019 - Session time: 10:30:00 - Track: Application Database Development
The tricks: Select count(*) from table - returns wrong count (any # you like) Deadlock - single statement, without transactions Database - without files Online index changes - on Standard edition Reading plaintext data of TDE-encrypted database - without SQL access
Event Date: 11-05-2019 - Session time: 10:30:00 - Track: Enterprise Database Architecture, Administration Deployment
This session goes through 10 different pain points in SQL Server monitoring and covers the ideology and mechanisms on why, how and when to utilize alerts.
Event Date: 11-05-2019 - Session time: 10:30:00 - Track: Advanced Analysis Techniques Machine Learning
Event Date: 11-05-2019 - Session time: 12:30:00 - Track: Application Database Development
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.
Event Date: 11-05-2019 - Session time: 12:30:00 - Track: BI Platform Architecture, Development Administration
This talk is abou the best practices designing and implementing in business solutions Power BI Embeded and Power Bi Premium: which version to use and how to take the best advantage from different version and tier of Power BI, offered from Microsoft.
Event Date: 11-05-2019 - Session time: 12:30:00 - Track: Enterprise Database Architecture, Administration Deployment
Event Date: 11-05-2019 - Session time: 12:30:00 - Track: Application Database Development
Goal 1: Implement a reusable Transact-SQL test harness for reliable query results. Goal 2: Learn ten patterns that kill the performance of SELECT statements and how to avoid them. Goal 3: Discover the high-impact metadata that shows how a SELECT statement behaves … or misbehaves.
Attend this session to take your query writing and query tuning skills to the next level!
Event Date: 11-05-2019 - Session time: 12:30:00 - Track: Other
When it comes to disruptiveness, very few technologies can match the public cloud and as a company working with all the major hyperscalers, Nordcloud has a unique perspective on the requirements on the skillsets needed to manage data in the cloud. Join our session to learn what core DBA skills will still be relevant in the cloud era, and what are the technologies and skills to learn!
Norcloud - Gold Sponsor Session (30 minutes)
Event Date: 11-05-2019 - Session time: 13:40:00 - Track: Analytics and Visualization
Machine Learning techniques can help us to accomplish this task. Starting from past failure data, we can build up a predictive model to forecast the likelihood for a product to fail or giving an estimate on its duration. And now it is possible to develop an end-to-end solution in SQL Server, because of the introduction of advanced analytics tools like R since release 2016. In this session, we start from the real case of a manufacturing company to create some predictive models: a) Regression model ; b) binary and multivariate models. Binary or multi-class classification problem. Some reports are also created to deliver the outcome to the stakeholders.
Event Date: 11-05-2019 - Session time: 13:40:00 - Track: Advanced Analysis Techniques Machine Learning
Event Date: 11-05-2019 - Session time: 13:40:00 - Track: BI Platform Architecture, Development Administration
Event Date: 11-05-2019 - Session time: 13:40:00 - Track: Enterprise Database Architecture, Administration Deployment
You are troubleshooting a performance problem in a business-critical database, a query is not completing, the users are complaining, and you are trying to understand what is happening. You have data from Extended Events, you are looking in the execution related DMVs, and now you are trying to find the query in Query Store. How do you put it all together?
In this session, we will look at how the tools work in different scenarios, how to correlate the data, and how you can use them in your performance troubleshooting.
Event Date: 11-05-2019 - Session time: 14:50:00 - Track: Application Database Development
This presentation starts with a horror show of the many different actions SQL Server can take in case of an error. We will then learn how should deal with this - what we should do and what we should not and that with SET XACT_ABORT we get better consistency. We will learn how TRY-CATCH works in SQL Server, and we will get a recipe for how to write CATCH blocks. More generally, we will learn why it pays off to be simple-minded to survive in this maze. The session mainly looks at traditional T-SQL code, but the session ends with a quick look at natively compiled stored procedures, where everything is different.
Event Date: 11-05-2019 - Session time: 14:50:00 - Track: Analytics and Visualization
By using Story telling it is possible to tell the story behind the data. Where does the information need come from and how did we get to an answer? The complete storyline covered in your reports and dashboards to make sure the data is interpreted in the right way by the users.
During this session I well tell more about the principles of story telling. Beside of that this session will be covered with lots of Power BI demos. During these demos I will give examples of functionality within Power BI which can be used to create your own story in Power BI. I will not only show the end result, but also how to create a report or dashboard like that to tell your own story!
Event Date: 11-05-2019 - Session time: 14:50:00 - Track: Enterprise Database Architecture, Administration Deployment
Event Date: 11-05-2019 - Session time: 14:50:00 - Track: BI Platform Architecture, Development Administration
Event Date: 11-05-2019 - Session time: 16:00:00 - Track: Enterprise Database Architecture, Administration Deployment
This session will provide an overview of running SQL Server in Kubernetes, which is the leading orchestrator.
Topics covered will be: - An overview of Kubernetes. Definition of deployments, pods, and services. Deploying SQL Server containers to Kubernetes. Persisting data for SQL Server in Kubernetes.
This session is aimed at SQL Server DBAs and Developers who want to learn the what, the why, and the how to run SQL Server in Kubernetes.
Event Date: 11-05-2019 - Session time: 16:00:00 - Track: Advanced Analysis Techniques Machine Learning
In this session you will learn: • How to use R or Python in Power BI • How to do Key Driver Analysis • How to invoke Azure Cognitive Services • How to integrate existing Azure Machine Learning models • How to create a Machine Learning model directly in Power BI using the new AutoML capability
Event Date: 11-05-2019 - Session time: 16:00:00 - Track: Application Database Development
Here is a glimpse of the features we will cover in this session: • Adaptive query plans • Batch mode adaptive join • New cardinality estimates for optimal performance • Indexing Improvements • Automatic Tuning • Memory optimizations
At the end of the session, DBAs will learn 3 essential processes which can be game changers for their career. After implementing the suggestions discussed in this session, DBAs will have extra time to handle more pressing issues which they were not able to focus on earlier.
This 75 minutes will be the most productive time for any DBA or Developer.
Event Date: 11-05-2019 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration