Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type


Sessions Found: 26
How does the AI make my BI applications smarter?

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques & Machine Learning

Level: Beginner

Session Code:

Date: May 11

Time: 9:15 AM - 10:15 AM

Room: ROOM 3

Extended Events, Dynamic Management Views, and Query Store are highly useful tools that give you a lot of data when analyzing performance problems. The challenge is which tool to use for which problems and how to correlate the data.

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Architecture, Administration & Deployment

Level: Intermedia

Session Code:

Date: May 11

Time: 1:40 PM - 2:40 PM

Room: ROOM 1

AI is everywhere, and of course also in Power BI. AI can aid you in your data exploration by automatically finding patterns, help you to understand what the data means, and in predicting future outcomes to drive better business results. The recently added AI features in the Power BI Service allow you to enrich your dataflow solutions with Artificial Intelligence. Whether you are a business user, analyst or data scientist, there is something to use and learn for all of you. Let's take a journey along all these powerful features! 
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
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques & Machine Learning

Level: Beginner

Session Code:

Date: May 11

Time: 4:00 PM - 5:00 PM

Room: ROOM 2

Last year we had the version 1 of this session. Now Azure SQL DW has evolved one year more, and we are seeing it evolving at faster and faster pace. If last year it was great it is even better this year. Same hopefully goes for the session also! Full of demos, examples, some bad jokes and deep internal explanations why you should pick Azure SQL DW for your Cloud-born data warehouse solution.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques & Machine Learning

Level: Advanced

Session Code:

Date: May 11

Time: 10:30 AM - 11:30 AM

Room: ROOM 1

In this session we will discuss about tempdb contention in SQL Server on-premises, Azure SQL Managed Instance and Azure SQL Database. We will analyze both, Allocation Contention and Metadata contention, describing in detail WHEN and HOW it occurs, How to diagnose it, Best Practices and how to prevent it. The session will have both approaches in on-premisses and in Azure Managed Instance: - Theoretical, to understand what and why it occurs. - Practical, with examples causing it, offering alternatives to solve it and to prevent it.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Architecture, Administration & Deployment

Level: Intermedia

Session Code:

Date: May 11

Time: 12:30 PM - 1:30 PM

Room: ROOM 2

In this session let us find about (technical overview)what are the foundations and design goals of Azure CosmosDB.  There are many benefits which will fit for web, mobile and globally distributed applications that need elastic scaling, high availability with a predictable performance which can elevate ease of development with NoSQL capabilities that every developer/architect/DBA should know about.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: May 11

Time: 9:15 AM - 10:15 AM

Room: ROOM 4

ETL OR ELT? What actually is the T and if I just want to do something else than CTAS? Just bring me my SSIS Data Flow in modern flavour and I would be happy. Here you have it: Azure Data Factory Data Flow. How it works? What's in it? And is it for any good?
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: May 11

Time: 2:50 PM - 3:50 PM

Room: ROOM 2

Power BI Dataflow might just the missing link for many companies regarding their Data Platform strategy and goal to enable more effective self-service analytics. In this session, we'll review typical Data Platform architectures, use cases, related stakeholders and governance practices and talk about scenarios where Dataflow can fill the gaps and how it should be governed in order to be adopted successfully. CDM aspects? Yes, in the scope.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 11

Time: 1:40 PM - 2:40 PM

Room: ROOM 2

Database Administrators have been safeguarding the business critical data assets of the organizations for decades, managing not just the data but often also the infrastructure in the on-premise environments. However the times are rapidly changing and so are the expectations towards the DBA profession. These new expectations revolve around the ongoing digital transformation across different industries and the DBAs ability to answer to challenges presented by the modern, disruptive technologies.

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)*
Speaker:

Session Type:
Sponsor session (30 minutes) (30 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: May 11

Time: 12:30 PM - 1:00 PM

Room: ROOM 3

Working in manufacturing industry means that you must deal with product failures. As a BI and/or Data Scientist developer, your task is not only monitor and report product’s health state during its lifecycle, but also predict the likelihood of a fail in the production phase or when product has been delivered to the customer. 
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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Advanced

Session Code:

Date: May 11

Time: 1:40 PM - 2:40 PM

Room: ROOM 4

Aure Data Lake is an umbrella term consisting of multiple Azure services, most notably Azure Data Lake Store and Azure Data Lake Analytics. As the name implies, these services are built for big data processing purposes. During this session, you will gain the understanding of the use cases you should consider using these in particular. I will introduce both Data Lake Store and Data Lake Analytics, and how they have been built under the hood. In addition, I will do a couple of demos to show you how you actually can get started with them.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: May 11

Time: 9:15 AM - 10:15 AM

Room: ROOM 2

Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2017 has introduced many new features. This session is carefully crafted to help overcome the beginner’s inertia for DBAs who have been using SQL Server for a while but aren't sure how to get started with the new features introduced in SQL Server 2017. 

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 11

Time: 4:00 PM - 5:00 PM

Room: ROOM 1

Moving to the cloud means that we need to take a different approach when it comes to how we design and tune databases. Managed Instance is a case in point, get the storage configuration wrong and it will not perform. Together we will look at the storage options and architecture for Managed Instance before demonstrating how to get tune the storage layer to get the performance we need. Of course none of this is any use without knowing what level of performance you need so we will look at how you can get this information before you start testing.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Architecture, Administration & Deployment

Level: Advanced

Session Code:

Date: May 11

Time: 10:30 AM - 11:30 AM

Room: ROOM 4

Data lake concept has evolved a lot recent years. Traditionally, data lake is used interchangeably with Hadoop. In Hadoop data and compute are co-located to reduce data transfer latency, thus improving the  performance. However, in Cloud era, data lake concept is dramatically evolved. Nowadays in cloud, compute nodes and data storage are normally decoupled, which brings significant benefit for scalability, cost optimization, upgradability etc. Modern cloud data ecosystem is all built upon this concept. The data lake storage is the foundation for most of the Azure data services, e.g. data factory, databricks, Azure datawarehouse, PowerBI. The concept of common data model enables business application and Azure services to work with same data in Azure data lake storage and makes different roles in organization e.g. data engineer, data scientists, business analysts to work in a much more seamless way.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 11

Time: 4:00 PM - 5:00 PM

Room: ROOM 3

In this session, we will deep-dive into the ocean of SQL Server monitoring alerts in large-scale and mission critical systems, from basic alerting and baselines into alerts assisted by machine learning. SQL Servers have dozens of important performance counters that DBA’s should follow on server, instance, and database level. It is practically impossible to monitor all of these performance counters over time without a proper alerting strategy, methodology, and implementation. How to maximize your uptime? How to avoid unplanned unavailability situations?

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Architecture, Administration & Deployment

Level: Intermedia

Session Code:

Date: May 11

Time: 10:30 AM - 11:30 AM

Room: ROOM 3

I want to show you how just a little neater and tighter code can also run a lot faster. These are some of the instant performance improvements that won’t change a lot of code, won’t generate weeks of testing and validation for your colleagues, and can be relatively quick to implement.

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.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 11

Time: 9:15 AM - 10:15 AM

Room: ROOM 1

In this demo-rich session, Dave & Marc discuss the Power BI Cheat Sheet that went viral on social media. The sheet is crammed with Power BI tips and best practices based on years of experience, but with little to no room for comments. No worries! We will describe, demonstrate and discuss all the items! And of course, there will be a Cheat Sheet for everyone attending!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: May 11

Time: 9:15 AM - 10:15 AM

Room: ROOM 4

Power BI Premium introduces a new developer layer for embedding Power BI in custom applications, and a new on-premises deployment option as well. Microsoft Power BI Embedded applications enables developers to integrate Power BI reports into their web or mobile applications so they don’t need to build custom solutions to visualize data for the users. It helps Independent Software Vendors to use Power BI data experiences within their applications.
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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 11

Time: 12:30 PM - 1:30 PM

Room: ROOM 2

Running SQL Server in containers has huge benefits for Data Platform professionals but there are challenges to running SQL Server in stand alone containers. Orchestrators provide a platform and the tools to overcome these challenges.

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Architecture, Administration & Deployment

Level: Intermedia

Session Code:

Date: May 11

Time: 4:00 PM - 5:00 PM

Room: ROOM 4

New and old things from sql server 2019 HA and disaster recovery point of view. Also tips what to consider if you bundle more than just database engine component into HA plan.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Architecture, Administration & Deployment

Level: Intermedia

Session Code:

Date: May 11

Time: 2:50 PM - 3:50 PM

Room: ROOM 4

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