Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type


Sessions Found: 25
Let me show you how easy it is to use PowerShell to accomplish many everyday tasks straight from the command line with the community developed module dbatools.

Afraid of PowerShell? 
Worried its too complicated?
Don't want to go through the learning curve?

Let me show you with plenty of demos how easy and straight forward it can be and I will save you time starting Monday

Want to restore an entire servers databases to the latest available point in time of the backups in just one line?
Be useful to know the Last DBCC Check for your entire estate in only one line of code?
Need to test your restores but its complicated?
and many many more
All this in a fast paced, fun session
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Architecture, Administration & Deployment

Level: Beginner

Session Code:

Date: May 12

Time: 1:30 PM - 2:30 PM

Room: Room 2 - Karjalainen

In this session, we will demonstrate the power of Discovery Hub® by building an end-to-end solution from scratch in just 30min. We automate the majority of the tedious tasks related to a DWH project with high quality auto-generated scripts, documentation, data lineage tracing managed deployment/execution and many other value-adding features. We accelerate BI projects dramatically and allows BI developers to focus their efforts on the tricky modelling tasks, rather than the majority of standard technical steps.

Speaker: Mahmoud Ismail 
Mahmoud is a Solution Architect in TimeXtenders Customer Service & Success team and has significant experience in implementing and utilizing the Discovery Hub in a number of industries and sectors. He also has excellent knowledge in regards to data modelling for both Qlik applications, OLAP Cubes and Tabular models. He takes part in a lot of projects ranging, from presales, training consulting and hands-on DWA developing.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor session (30 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: May 12

Time: 12:15 PM - 12:45 PM

Room: Room 3 - Jansson

We will cover the main aspects to migrate to one of the three architectures available in SQL Server in Azure from SQL Server On Premise. 

This session consists of:
-> What is the best platform for my environment? IaaS, PaaS, or SQL Datawarehouse.
-> Best Practices and best tools for our migration process depending on the platform chosen.
-> After the migration, we have several outstanding questions:
            Can I keep both environments synchronized?
             How is the performance of my database?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: May 12

Time: 10:15 AM - 11:15 AM

Room: Room 3 - Jansson

Are you tired of creating and updating the same SSIS packages again and again? Is your wrist hurting from all that clicking, dragging, dropping, connecting and aligning? Do you want to take the next step and really speed up your SSIS development?

Say goodbye to repetitive work and hello to Biml, the markup language for Business Intelligence projects.

In this session we will look at the basics of Biml. First learn how to use Biml to generate SSIS packages from database metadata. Then see how you can reuse code to implement changes in multiple SSIS packages and projects with just a few clicks. Finally, we will create an example project that you can download and start with to speed up your SSIS development from day one.

Stop wasting your valuable time on doing the same things over and over and over again, and see how you can complete in a day what once took more than a week!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: May 12

Time: 2:30 PM - 3:30 PM

Room: Room 2 - Karjalainen

Everybody is talking about best practices, and like standards, most everybody has them. But why do they look like they do, and why would you use a specific set of "best practices" that someone has put together? This session goes through my set of best practices that I've accumulated over 20 years of DBA work, disassembles each and every one of them to see how they came about and discusses why I still use them - or don't. There is no such thing as the ultimate best practices, but I aim to provide the attendee with as much food for thought as possible in order to let each and everyone decide on their own path forward for their own set of best practices.
The session covers primarily SQL Server 2012 to 2016, with SQL Server 2017 thrown in for good measure.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Architecture, Administration & Deployment

Level: Beginner

Session Code:

Date: May 12

Time: 10:15 AM - 11:15 AM

Room: Room 4 - Berlin Auditorium

Welcome to join this session to hear more about data platform that integrates umbarella organization's all different data touch points to new single source of truth. 

- What are the main components of the Enterprise Data Platform in Azure?
- Where to start building?
- How to keep it up and running?

In this webinar Olli Lindroos from Solita will go through how they have developed multiple organisation wide data platforms. See how for example Azure Data Lake and Power BI were leveraged in this solution and hear best practices from the project.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Architecture, Administration & Deployment

Level: Beginner

Session Code:

Date: May 12

Time: 9:00 AM - 10:00 AM

Room: Room 1 - Topelius

The software development landscape is changing. More and more, there is an increased demand for AI and cloud solutions.  As a user buying cinema tickets online, I would like to simply ask "I want to buy two cinema tickets for the movie Dunkirk, tomorrow's viewing at 1pm" instead of manually following a pre-defined process. 

In this session, we will learn how to build, debug and deploy a chatbot using the Azure Bot Service. We will enrich it using the Microsoft Cognitive suite to achieve human like interactions. 

Will it pass the Turing test, no, but we can extend the bot service using Machine Learning (LUIS), APIs (Web Apps) and Worflows (Logic Apps).
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: May 12

Time: 9:00 AM - 10:00 AM

Room: Room 3 - Jansson

Let’s go beyond the standard visuals available in Power BI for making maps. In this session we won’t talk about Bing or ArcGIS services. We want to explore all the available features for creating custom maps without having to rely on existing ones. 
Do you know what is a shapefile? Do you know how to create your own choropleth and import it into Power BI? 
What else? R support into Power BI opened the doors to the huge number of packages for spatial data analysis and statistical calculations included in the environment. 
Do you want to draw multi-layered interactive maps? Want to geocode your data with direct calls? With R in Power BI, now you can. 
Last but least, we will able to discover Synoptic Panel, an awesome component that connects areas in a custom image with attributes in the data model and draws the data on a map. There are endless possibilities; the only limit is your imagination!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: May 12

Time: 3:45 PM - 4:45 PM

Room: Room 3 - Jansson

A common requirement in database applications is that users need a function to search a set of data from a large set of possible search conditions. The challenge is to implement such searches in a way that isboth maintenanble and efficient in terms of performance. This session looks at the two main techniques to implement such searches and highlights their strengths and limitaitons.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 12

Time: 3:45 PM - 4:45 PM

Room: Room 1 - Topelius

In times past, Data Science was only for those elite few with a rare combination of skills including advanced knowledge of statistics.
Microsoft has been making sure that everyone can participate in the data revolution by giving people access to predictive API’s, in-database advanced analytics and drag-and-drop predictive experiments. All thanks to SQL Server 2016 and the Cortana Intelligence Suite in Azure.
These advances have given people with less knowledge of statistics and programming the ability to become what Gartner calls citizen data scientists. Should we be worried about creating fools-with-tools or should we embrace the democratization of data science as the golden age of data?
In this demo heavy session we explore Microsoft’s solutions to ensure democratization of data science and the possible dangers that lurk below the surface.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques & Machine Learning

Level: Beginner

Session Code:

Date: May 12

Time: 10:15 AM - 11:15 AM

Room: Room 2 - Karjalainen

Experts should work with facts, not guesstimates – how you learn to love large scale SQL Server consolidation projects

Have you ever been struggling with the consolidation or migration planning of a sizable SQL Server platform? Traditional data platform capacity planning contains a lot of time consuming manual work and is often based on rough estimates. It is seen more as a task for the data platform architect than a mathematical challenge. The truth is: It is both. Find out how to achieve highly automatized, perfectly optimized plan, based on facts rather than guesswork!

Speaker: Jani K. Savolainen. Founder & CTO @ DB Pro.
Speaker:

Session Type:
Sponsor session (30 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: May 12

Time: 2:00 PM - 2:30 PM

Room: Room 3 - Jansson

Everthing is connected. Everything is accessible. Everything is hackable.
This is a security "worst" practices session for developers (yes, yes, the boring "best" practices are also included).
As always, should you or any of your colleagues be hacked or exploited, the Demo Gods will disavow any knowledge of the speakers' actions. This session will self-destruct in 60 minutes. Luck has nothing to do with it, Jim…
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 12

Time: 9:00 AM - 10:00 AM

Room: Room 2 - Karjalainen

Ok, I know Microsoft Data Platform and I know R but where is the intersection?? What can I use and where?

In-Database R, Power BI with R, ML Server… there are a lot of tools where we have R included but what can you do with them? In this session we will go through the offering with simple examples and talk openly about what is good and what needs improvements. If you’re data platform specialist that needs to talk with data scientists about possibilities this session is for you! If you’re data scientist and want to know the contact points in Microsoft Data Plat this is very well also for you!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 12

Time: 2:30 PM - 3:30 PM

Room: Room 3 - Jansson

One of the most common problems I have encountered as a DBA is the complaints from users that a particular query is slow, just one query.  Many times one that used to run in acceptable time, but that over time has slowed down substantially.

In this session we will show some of the causes for this, with emphasis on I/O requests being too high for the query.  

First part of the session will explain how to find these numbers, looking at a few queries with some major performance issues, including explaining why they have a problem.

The second part will focus on how to reduce I/O requests.

All of this can be done without the need for any 3rd party tools, all within the scope of what is available to SQL Server, all versions, all editions, including Azure.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 12

Time: 1:30 PM - 2:30 PM

Room: Room 1 - Topelius

The last couple of years have seen the emergency of "Big Data", "Cloud" and "Internet of Things".  Subsequently, Gartner at the 2016 Gartner Summit in Barcelona declared the Enterprise data warehouse (EDW) as dead. 
Which of course is silly. Sensible companies don't just throw money out of the window.
But they need to adapt and change when new opportunities arrive.
Enter the hybrid data warehouse. Combining the power of big data and cloud with your trusty EDW.

This session will take a look at a few different approaches to a hybrid data warehouse, with components such as SQLServer 2016, Azure Data Lake, HDInsight, Azure Analysis Services, Azure SQL Data warehouse and Polybase, with some scenarios where the approaches might become
 relevant. And some pitfalls you need to know about along the way.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 12

Time: 1:30 PM - 2:30 PM

Room: Room 4 - Berlin Auditorium

Azure SQL Datawarehouse is a petabyte range Massively Parallel Processing Datawarehouse provided as a managed service in Azure. This session will delve into the architecture, new optimized for compute instances, common workload and implementation patterns, performance considerations, loading patterns and strategies and some real-life customer deployment examples.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: May 12

Time: 10:15 AM - 11:15 AM

Room: Room 1 - Topelius

In this session, database expert Martin Wild of Quest Software will lift the lid on SQL Server on Linux. He’ll explore the mechanics of deploying SQL Server on Linux, what is and is not in the current Linux build and discuss quirks, insights and observations on setup and configuration. Once the stage is set, Martin will cover tuning and performance on Linux and bring you through some new DMVs for Linux monitoring. He’ll then compare the plans produced on Linux vs. Windows for consistency… or not! 

Speaker: Martin Wild
Martin Wild is a principal systems consultant at Quest. He frequently presents at SQL Server events such as SQL Bits and SQL Saturdays, and Oracle user groups. Martin has expertise with Oracle, SQL Server, Sybase, DB2, Windows, UNIX, Linux, VMware and Hyper-V. He has worked in IT for more than 30 years, initially in manufacturing and retail organizations. For the last 17 years he has held various database pre-sales roles and is a member of the British Computer Society
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor session (30 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: May 12

Time: 12:45 PM - 1:15 PM

Room: Room 3 - Jansson

Azure Data Factory v1 has not been considered a full blown ETL solution on the market. Data Factory v2 is now introduced to fill in the gaps. We will deliver the understanding of the different features & functionalities of both versions as well as a summary comparison between the two. We will also demonstrate the latest and greatest capabilities by orchestrating an end-to-end pipeline with Data Factory v2 including machine learning workloads with Azure DataBricks.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: May 12

Time: 3:45 PM - 4:45 PM

Room: Room 4 - Berlin Auditorium

Join this session by Heidi Enho, Power BI consultant, Microsoft Certified Trainer, Data Platform and Excel MVP. Learn how to use Power BI bookmarks, buttons, drill-through filters and for example brand new report tooltips to communicate insights in your data. Heidi will show in this highly demo based session many examples and tips how to use new navigation and storytelling capabilities.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: May 12

Time: 12:15 PM - 1:15 PM

Room: Room 4 - Berlin Auditorium

Microsoft has added new performance improvements and new features to SQL Server 2016 and 2017’s implementation of Always On Availability Groups. This session will cover improvements that range from Standard Edition support for AGs to load balanced replicas to new ways to create those replicas. We’ll kick the tires on the improved Azure support and discuss the massive performance improvements in Always On as well.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Architecture, Administration & Deployment

Level: Intermedia

Session Code:

Date: May 12

Time: 12:15 PM - 1:15 PM

Room: Room 2 - Karjalainen

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