|Start Time (24h)||Speaker||Track||Title|
|08:30:00||Alexander Klein||BI||ETL meets Azure|
|08:30:00||Uwe Ricken||DBA||Investigate, analyze and solve common wait stats scenarios|
|08:30:00||Alex Yates||Dev||Database version control deployment: model or migration scripts|
|09:40:00||Stijn Wynants||Dev||Index Tuning for the developer|
|09:40:00||Prathy Kamasani||BI||Power BI deployment strategy for publishing and maintenance|
|09:40:00||Angela Henry||DBA||Data Types Do Matter|
|10:50:00||Andrew Pruski||DBA||Partitioning 101|
|10:50:00||Regis Baccaro||Dev||Hybrid BI DevOps|
|10:50:00||Bent Pedersen||BI||Mindset for doing DWH in the cloud|
|12:00:00||Jacob Ross Andersen||BI||Automate DWH BI development using TimeXtender Discovery Hub®|
|12:50:00||Paul Andrew||BI||ADFv2 - Data Integration in Azure Just Got a lot Better|
|12:50:00||Vedran Kesegic||DBA||Tuning optional filters|
|12:50:00||David Postlethwaite||Dev||SQL 2017 New feature - Graph Data|
|14:00:00||Stephane Haby||DBA||Security via policies|
|14:00:00||Simon Whiteley||BI||Modern Data Warehousing - The Lambda Approach to Azure BI|
|14:00:00||Jan Mulkens||Dev||Rub DevOps on all the things!|
|15:10:00||Thomas Hütter||BI||From SQL to R and beyond|
|15:10:00||Kevin Chant||DBA||Migrating to the cloud options for SQL Server Professionals|
|15:10:00||André Melancia||DBA||Never Say Hacking SQL Server Again|
|16:20:00||Alexander Arvidsson||DBA||Boring is stable, stable is good - best practices in practice|
|16:20:00||Dejan Sarka||BI||Temporal Data in SQL Server|
|16:20:00||Chrissy LeMaire||Dev||PowerShell Simplified: dbatools dbachecks|
Event Date: 10-03-2018 - Session time: 08:30:00 - Track: BI
Event Date: 10-03-2018 - Session time: 08:30:00 - Track: DBA
Event Date: 10-03-2018 - Session time: 08:30:00 - Track: Dev
At the same time, leaders and shakers of our industry including ThoughtWorks, Pramod Sadalge and Paul Stovell promote an iterative, migration script driven approach asserting that deployment scripts should be tested early and not generated by a tool.
I'm irritated whenever I go to a "how to do database continuous delivery" session and the speaker presents one way as good and the other as bad. Like most things, it depends.
I'll illustrate the limitations of each approach with a simple scenario. I'll describe which projects are better suited to a model or a migrations approach, and whether it's possible to get the best of both worlds
Event Date: 10-03-2018 - Session time: 09:40:00 - Track: Dev
Event Date: 10-03-2018 - Session time: 09:40:00 - Track: BI
Yes, it takes minutes to create and share Power BI reports. Which means every user who has relevant Power BI access can create Workspaces, Apps, reports, dashboards and schedules. With no deployment strategy, maintaining Power BI service could become a terrible job. In this session, I will cover how having a having deployment strategy can make a terrible maintenance job seamless.
This session will include: What happens when a user creates a Power BI app workspace How to control user access Working with different environments Creating and sharing reports using Power BI Apps How to monitor dataset schedules and failure notifications How to use Power BI API to document your organisation Power BI Service
Event Date: 10-03-2018 - Session time: 09:40:00 - Track: DBA
Event Date: 10-03-2018 - Session time: 10:50:00 - Track: DBA
This session will give attendees a refresher through partitioning concepts and the implementation of those concepts through live demos.
Topics covered will be: - Paritioning definition Potential benefits and pitfalls Overview of partitioning functions and schemes Table design considerations Splitting and merging partitions Switching data Implementing sliding windows
Event Date: 10-03-2018 - Session time: 10:50:00 - Track: Dev
We use Visual Studio Online for source control, development and integration. Development changes are automatically deployed to on-premises or the Cloud using SQL Server, Azure SQL Databases, Azure VMs and Azure Data Factory v2. We will show how we can build a continuous integration and deployment pipeline between environments, pushing the schema changes and upgrading the version numbers in a seamless manner upon successful build of the solutions. Furthermore we'll come with a list of best practices to follow and pitfalls to avoid when going down the DevOps road.
Event Date: 10-03-2018 - Session time: 10:50:00 - Track: BI
Second part of the session will focus on the differences and benefits of different approaches ( On-premises, IaaS, PaaS) the following perspectives to undertand and consider the right approach:
Event Date: 10-03-2018 - Session time: 12:00:00 - Track: BI
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.
The session will include steps like:
Connect to a data source Build an Operational Data Exchange Stage data with examples of common ETL tasks Create a Data Warehouse Define a Semantic Model Visualize data with visualization tool”
Event Date: 10-03-2018 - Session time: 12:50:00 - Track: BI
Event Date: 10-03-2018 - Session time: 12:50:00 - Track: DBA
Event Date: 10-03-2018 - Session time: 12:50:00 - Track: Dev
This presentation is the culmination of my investigations. If you design complex OLTP relational databases or have data that doesn't fit the rigid hierarchy of a relational database then this talk is for you. You may be in for a surprise!
Some of the questions we will look at: What is Graph Data? Who uses it? What is it used for? How does it compare to traditional relational database design? What other companies support graph databases? How does it work in SQL 2017? Is there a new language to learn? What is the so-called Kevin Bacon problem?
And finally. Will it replace traditional relational database design within the next 10 years?
Event Date: 10-03-2018 - Session time: 14:00:00 - Track: DBA
Which types of control should be set up at instance and database levels? How to manage multiple servers? And finally, generate beautiful reports and send feedback emails. We will try to answer all these questions we have during security audits...
Event Date: 10-03-2018 - Session time: 14:00:00 - Track: BI
This session will take you through the pattern known as the Lambda architecture, a reference pattern for building data analytics systems that can handle any combination of data velocity, variety and volume. The session will outline the set of tools and integration points that can underpin the approach. Do you design real-time reporting systems? Or crunch petabytes of data? Perhaps you are adopting a cloud architecture and just want to handle anything the future throws at you? This session is for you.
We will follow the movement of data through batch and speed layers via Azure Data Lake Store Analytics and Streaming Analytics before considering the serving layer with Azure SQL DataWarehouse and downstream reporting tools.
Event Date: 10-03-2018 - Session time: 14:00:00 - Track: Dev
In this session we'll explore, through demo's, how a DevOps mindset changed my personal way of working and development of database and BI solutions. In the demo's we'll automate the deployment of databases, SSIS, SSRS and SSAS and you'll experience the simple patterns to start automating the deployment of just about anything.
Event Date: 10-03-2018 - Session time: 15:10:00 - Track: BI
You’ll get a short introduction how R came to be, and what the R ecosystem looks like today. Then we will extract sales data from different companies off a Navision ERP database on SQL Server.
Our data will be cleaned, aggregated and enriched in the RStudio environment. We’ll generate different diagrams on-the-fly to gain first insights.
Finally we’ll see how to use the Shiny framework to display our data on a map, interactively changing our criteria, and showing us where the white spots really are.
Event Date: 10-03-2018 - Session time: 15:10:00 - Track: DBA
After that we’ll dive into in to an overview of the main cloud providers and providing some examples where they might be a good fit for various SQL Server environments; as well as what you might want to take into consideration during for your migration like your HADR strategy and if your SQL Server data would be better suited in another solution that your chosen cloud provider offers.
Event Date: 10-03-2018 - Session time: 15:10:00 - Track: DBA
This is a demo-driven session, suited for DBAs, developers and security consultants. Both exploits and security recommendations to avoid them will be covered. Disclaimer: No actual crimes will be committed. Please do not send agents to my house again.
Event Date: 10-03-2018 - Session time: 16:20:00 - Track: DBA
The session covers primarily SQL Server 2012 to 2016, with SQL Server 2017 thrown in for good measure.
Event Date: 10-03-2018 - Session time: 16:20:00 - Track: BI
This session introduces the temporal problems, deals with solutions that go beyond SQL Server 2016 and 2017 support, and shows out-of-the-box solution in SQL Server 2016 and 2017, including: • Defining temporal data • Application versioned tables • System versioned tables • What kind of temporal support is still missing
Event Date: 10-03-2018 - Session time: 16:20:00 - Track: Dev
In this session, you'll learn how these open source tools can simplify your life and even help you sleep better at night. Join us to learn how you can easily integrate PowerShell into your daily toolset, no matter if you are Dev or Ops.