| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | Arne Bartels | Application Database Development | SSIS Custom Pipeline Component |
| 08:30:00 | Marek Matuszewski | Cloud Application Development Deployment | Reaching the Clouds on the BI Rocket |
| 08:30:00 | Andre Batista | Enterprise Database Administration Deployment | Challenges in HA\DR scenarios in SQL Server 2017 vNext on Linux |
| 08:30:00 | Ben Weissman | BI Platform Architecture, Development Administration | Biml: Your 3D Printer for SSIS |
| 08:30:00 | Stephanie Locke | Strategy and Architecture | DataOps - DevOps for analytics |
| 10:00:00 | André Melancia | Enterprise Database Administration Deployment | Hacking SQL Server |
| 10:00:00 | John Martin | Strategy and Architecture | Always On Multi-Site Patterns |
| 10:00:00 | Mihail Mateev | Cloud Application Development Deployment | Dealing with CosmosDB |
| 10:00:00 | Damian Widera | BI Platform Architecture, Development Administration | U-SQL in great depth |
| 10:00:00 | Jens Vestergaard | Advanced Analysis Techniques | Delivering BI Continuously |
| 12:30:00 | André Melancia | Advanced Analysis Techniques | If a machine can learn, why can't YOU learn Azure Machine Learning? |
| 12:30:00 | David Postlethwaite | Enterprise Database Administration Deployment | Microsoft Azure for the DBA |
| 12:30:00 | Alex Yates | Strategy and Architecture | €20M+ fines and prison: General Data Protection Regulation (GDPR) is coming, are you compliant? w/ Pete Moore |
| 12:30:00 | Alexander Klein | BI Platform Architecture, Development Administration | ETL meets Azure |
| 12:30:00 | Niels Skytte | BI Platform Architecture, Development Administration | From SSAS to Azure Analysis Services - Lessons learned |
| 13:45:00 | Andrew Pruski | Enterprise Database Administration Deployment | SQL Server Containers |
| 13:45:00 | Just Blindbaek | BI Platform Architecture, Development Administration | Reporting the reporting services database |
| 13:45:00 | Kalen Delaney | Enterprise Database Administration Deployment | A Look Inside SQL Server Distribution Statistics |
| 13:45:00 | Damian Widera | Application Database Development | SQL Server 2016. Meet the Row Level Security. Practical notes |
| 13:45:00 | Stephanie Locke | Cloud Application Development Deployment | Build your first bot – no code required! |
| 15:15:00 | Andrea Martorana Tusa | BI Platform Architecture, Development Administration | Power BI behind the scene: security and user management |
| 15:15:00 | Alex Yates | Application Database Development | Database version control and deployment: model or migration scripts? |
| 15:15:00 | Bent Pedersen | BI Platform Architecture, Development Administration | Power BI Infrastructure |
| 15:15:00 | Daniel Otykier | BI Platform Architecture, Development Administration | Boosting SSAS productivity with Tabular Editor |
| 15:15:00 | Gabi Münster | BI Platform Architecture, Development Administration | Azure Analysis Services - An important step for BI in the cloud? |
| 16:30:00 | Bartosz Ratajczyk | BI Platform Architecture, Development Administration | Automate your SSIS deployment process |
| 16:30:00 | Daniel Hutmacher | Application Database Development | Management Studio level-up |
| 16:30:00 | Andreas Wolter | Enterprise Database Administration Deployment | Monitoring Troubleshooting Availability Groups |
| 16:30:00 | Alexander Klein | Cloud Application Development Deployment | Let the Cognitive Services to help you to find your favourite cocktail. |
| 16:30:00 | Kamil Nowinski | Application Database Development | Maintenance of a DB project and Continuous Delivery using SSDT |
Event Date: 07-10-2017 - Session time: 08:30:00 - Track: Application Database Development
Event Date: 07-10-2017 - Session time: 08:30:00 - Track: Cloud Application Development Deployment
Event Date: 07-10-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 07-10-2017 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration
We will look into manual Biml code to understand the general idea of Biml, then take it from there and generate a whole staging area from scratch and end with a complete manageable solution to completely maintain your staging process using SQL tables.
Have you ever spent hours fixing your SSIS due to a schema change on the source? Ever wanted to add a "load timestamp" to 370 tables in your staging area but refrained because it would have taken you weeks to do so? If so, this is the session for you!
Event Date: 07-10-2017 - Session time: 08:30:00 - Track: Strategy and Architecture
These are big issues that have faced the data analytics world for years, and tools have been slow to be delivered. This is changing though, so now we can start using the concepts from DevOps and applying them to analytics.
Taking you through the principles, the tools, and the journey to DataOps, this session will help you do work with data.
Event Date: 07-10-2017 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment
In this session we'll see examples on how to exploit SQL Server, modify data and take control, while at the same time not leaving a trace. We'll start by gaining access to a SQL Server (using some "creative" ways of making man-in-the-middle attacks), escalating privileges and tampering with data at the TDS protocol level (e.g. changing your income level and reverting without a trace after payment), hacking DDM, and more. Most importantly, we'll also cover recommendations on how to avoid these attacks, and take a look at the pros and cons of new security features in SQL Server 2016. This is a demo-driven session, suited for DBAs, developers and security consultants. Disclaimer: No actual crimes will be committed. Please do not send agents to my house again.
Event Date: 07-10-2017 - Session time: 10:00:00 - Track: Strategy and Architecture
Together we will walk through the architecture patterns, technology requirements, and configuration options that you need to know in order to build a solid Data Platform. Understanding the implementation differences between on-premises and cloud based deployments is important. Especially as there are specific requirements that need to be met for up-time SLAs to be applicable, as well as mitigating for region failures.
All of these elements mean that it is more than just simple wizards to follow in order to have a solid, reliable, and robust SQL Server Data Platform.
Event Date: 07-10-2017 - Session time: 10:00:00 - Track: Cloud Application Development Deployment
In this presentation, you will learn: • How to get started with DocumentDB you provision a new database account. • How to index documents • How to create applications using CosmosDb (using REST API or programming libraries for several popular language) • Best practices designing applications with CosmosDB • Best practices creating queries.
Event Date: 07-10-2017 - Session time: 10:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 07-10-2017 - Session time: 10:00:00 - Track: Advanced Analysis Techniques
In detail we will be looking at these components: Visual Studio Online 3rd. Party Add-Ons Build Agents Powershell Codeplex projects
And these processes: Build Test Release
Event Date: 07-10-2017 - Session time: 12:30:00 - Track: Advanced Analysis Techniques
AzureML isn't just for "data scientists"... Anyone can use it! And after this session you'll be using it too... Disclaimer: Sadly, AzureML still can't predict what's on your girlfriend's mind. Nothing ever will.
Event Date: 07-10-2017 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment
We will then go onto look in depth at SQL Azure Database; creating, configuring, scaling, connecting, using, securing, monitoring, uploading, scheduling, high availability and DR.
Event Date: 07-10-2017 - Session time: 12:30:00 - Track: Strategy and Architecture
Do you hold data on EU citizens? If so GDPR applies to you.
From the 25th May 2018 organisations who fail to implement appropriate technical and organisational measures that ensure and demonstrate that they are compliant will be liable for a fine of €20M or 4% of annual global turnover – whichever is GREATER. Also, prison.
As a professional who works with data it is wise to ensure that you understand GDPR.
DISCLAIMER: I am not a lawyer.
Let me repeat: I AM NOT A LAWYER.
I am not qualified to give legal advice. However, I do know a thing or two about delivering software. In this talk I will bring your attention to the main aspects of GDPR and discuss some of the consequences this has on the use of production data and database lifecycle management (DLM).
I will focus on technical problems that we need to address. You can (and should) hire your own lawyers to provide legal advice.
Event Date: 07-10-2017 - Session time: 12:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 07-10-2017 - Session time: 12:30:00 - Track: BI Platform Architecture, Development Administration
Promises of using level 1400 features, easy/better sharing to our customers, no management overhead, and all the usual cloud benefits, well, being a small company, the decision seemed like a slam dunk. After the initial test deployment, reality set in and we had to deal with: Deployment, Processing, Security, Monitoring, Debugging, Stability, Performance and Capacity. Without having all the answers I’ll share our experience in terms of benefits, challenges and how we made it work.
Event Date: 07-10-2017 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment
My session aims to take attendees through what containers are and how they can benefit us. There are drawbacks which will also be covered but I'm hoping after this session, attendees will be able to go back to their respective companies and be able to evaluate container technology to determine whether or not it will be of benefit.
Attendees will be taken through the following: - The definition of containers Virtual Machines vs Containers Container networking fundamentals Configuring Windows Server 2016 to run containers Installing the docker engine Pulling SQL images from the docker repository Running SQL Server containers Creating custom container images A real world implementation of containers
Event Date: 07-10-2017 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration
The session will walk-through the creation and all the attendees will get all the reports from the demonstrations.
Event Date: 07-10-2017 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment
Goals: • Explore the output of DBCC SHOW_STATISTICS • Describe when the density information is useful • Look at some problem scenarios for which the statistics can’t give good estimates • Understand why cardinality estimation involves more than just the statistics
Event Date: 07-10-2017 - Session time: 13:45:00 - Track: Application Database Development
Event Date: 07-10-2017 - Session time: 13:45:00 - Track: Cloud Application Development Deployment
I’ll be using Microsoft’s qnamaker.io site to build an FAQ bot and the putting it live with an Azure Bot Service and the Skype Web Control. The end result is a little snippet you can add to any web page, making implementation a breeze.
You can follow along as I build the bot live, or just soak it all in. Either way, you’ll see how easy it is to build a bot and you’ll know the next steps to follow to start building more complex bots.
Event Date: 07-10-2017 - Session time: 15:15:00 - Track: BI Platform Architecture, Development Administration
But, what about the new licensing model recently introduced for Power BI? How it can fits to your needs? Every organization is a complex system with rules and limitations. Users belong to groups each with visibility profile. So you need to know how security in Power BI works: how to configure and restrict access, how to filter data based on the logged user, how to implement static and dynamic Row-level security (RLS), how to control usage of specific features.
Furthermore you deal with a large number of users you can’t leverage by hand. Power BI provides an admin portal that allows you to manage users and groups in the Office 365 admin center. Come to this session to discover what’s behind the scenes in Power BI and how to implement a solution compliant to your security and governance model.
Event Date: 07-10-2017 - Session time: 15:15:00 - Track: Application Database Development
At the same time, leaders and shakers of our industry including Jez Humble, 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: 07-10-2017 - Session time: 15:15:00 - Track: BI Platform Architecture, Development Administration
During this ession you will be provided with a complete and comprehensive overview cover:
Event Date: 07-10-2017 - Session time: 15:15:00 - Track: BI Platform Architecture, Development Administration
Event Date: 07-10-2017 - Session time: 15:15:00 - Track: BI Platform Architecture, Development Administration
But why should you switch from your existing on-premise solution to the cloud or plan your new approach with it? What are the big advantages of Azure Analysis Services? And what actually are the differences to PowerBI? Why is Azure Analysis Services an important step to enhancing the possibilities for BI in the cloud? This session offers answers to your questions and provides insight to support the positioning of Azure Analysis Services in your Business Intelligence strategy.
Event Date: 07-10-2017 - Session time: 16:30:00 - Track: BI Platform Architecture, Development Administration
On this session I will show you how to put all that tasks to the server side. You'll see how to use Powershell and API available in .NET. Or MSBuild. I will add a bit of TFS to it to automate all things and you'll see that testing and deployment of subsequent project versions doesn't have to be so bothersome.
You will see what to look at when designing your own solution, what resources to use, what limitations await and how to overcome them.
Event Date: 07-10-2017 - Session time: 16:30:00 - Track: Application Database Development
Some of the things I’ll cover:
No undocumented stuff, no registry editor, and nothing you wouldn’t put into production. Just really clever productivity tips that will take some of the burden off your everyday work.
But I’m not going to sugarcoat it. Your code may still run slow, and you’ll probably write just as many bugs – but you’ll write them a lot quicker and with so much more style and panache.
Event Date: 07-10-2017 - Session time: 16:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 07-10-2017 - Session time: 16:30:00 - Track: Cloud Application Development Deployment
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?
Event Date: 07-10-2017 - Session time: 16:30:00 - Track: Application Database Development
I will explain all these topics on the session focused on practical aspects of work with Microsoft Visual Studio Data Tools.