| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 10:00:00 | Marcin Szeliga | Advanced Analysis Techniques | Data Science that’s scale |
| 10:00:00 | Johan Ludvig Brattås | Analytics and Visualization | Introduction to the Stream Analytics query language |
| 10:00:00 | Andrii Zrobok | Application Database Development | Важливість статистики в MS SQL Server, як вона використовується. |
| 10:00:00 | Dmytro Andriychenko | BI Information Delivery | BI Application Lifecycle Management with TFS |
| 10:00:00 | Erland Sommarskog | Application Database Development | When Things go Wrong - Error Handling in SQL Server |
| 11:10:00 | Sergiy Lunyakin | BI Platform Architecture, Development Administration | Meta-Data Driven Tabular Modeling with TOM in SSAS |
| 11:10:00 | Jan Mulkens | BI Platform Architecture, Development Administration | Enabling Citizen Data Science with Microsoft |
| 11:10:00 | Vitalii Bondarenko | Advanced Analysis Techniques | Azure real-time analytics and kappa architecture with Kafka and Cassandra clusters. |
| 11:10:00 | Uwe Ricken | Application Database Development | Mastering DML Operations like a master |
| 11:10:00 | Stephanie Locke | Application Database Development | Anchor Modelling: Sixth normal form databases! |
| 11:10:00 | Satya Jayanty | Enterprise Database Administration Deployment | Stretch your HA/DR capabilities with Azure and SQL Server 2016 |
| 14:00:00 | Shehab El-Najjar | Application Database Development | T-SQL Performance Guidelines for better DB stress powers |
| 14:00:00 | Sergiy Lunyakin | BI Platform Architecture, Development Administration | Azure SQL DWH: Tips and Tricks for developers |
| 14:00:00 | André Melancia | Enterprise Database Administration Deployment | NSA Secrets - Hacking SQL Server |
| 14:00:00 | Mihail Mateev | BI Platform Architecture, Development Administration | Creating Custom BI Solutions with Power BI Embedded |
| 14:00:00 | Alexey Vasiliev | Strategy and Architecture | Supercharge your PostgreSQL with extensions |
| 14:00:00 | Eugene Polonichko | BI Platform Architecture, Development Administration | Azure Data Factory. Ingest,prepare, transform and publish your data |
| 14:00:00 | Sergii Bielskyi | Strategy and Architecture | Optimization SQL Server for SharePoint Farm |
| 15:10:00 | Jose Manuel Jurado Diaz | Cloud Application Development Deployment | SQL SERVER - Next station Azure |
| 15:10:00 | Erland Sommarskog | Application Database Development | Giving Permissions through Stored Procedures |
| 15:10:00 | Maryna Popova | Application Database Development | Development Methodology for BI teams |
| 15:10:00 | Catalin Gheorghiu | Application Database Development | SQL database on IoT devices, could you? should you? would you? |
| 15:10:00 | Anton Boyko | Cloud Application Development Deployment | Создание data-driven serverless приложений используя Azure Functions |
| 16:30:00 | Kamil Nowinski | Application Database Development | Understand better Transaction Isolation Levels |
| 16:30:00 | Andriy Pogorelov | Application Database Development | SQL Server and PowerShell. Expand your capabilities |
| 16:30:00 | Andrzej Kukula | Enterprise Database Administration Deployment | Introduction to SQL Server v.Next for Linux |
| 16:30:00 | Uwe Ricken | Enterprise Database Administration Deployment | Investigate, analyze and solve common wait stats scenarios |
| 16:30:00 | Michal Sadowski | Enterprise Database Administration Deployment | Encryption in SQL Server |
Event Date: 20-05-2017 - Session time: 10:00:00 - Track: Advanced Analysis Techniques
Microsoft R Server (MRS) mitigate R limitations, and run multi-threaded analysis on a large dataset. The new release, MRS 9, goes even further. First off, it contains a Microsoft ML (machine learning) package - a collection of best-of-breed ML algorithms that have been battle-tested by Microsoft on a variety of its products. It includes improved logistic regression, fast boosted decision tree, fast random forest, GPU-accelerated Deep Neural Networks and One-Class Support Vector Machine (for outlisiers detections). Secondly, MRS 9 allows R models to be exposed as Web services. Furthermore with MRS 9 models that are trained in one environment can even be moved to, and scored in, ot
Event Date: 20-05-2017 - Session time: 10:00:00 - Track: Analytics and Visualization
The preferred method of doing so is Stream Analytics, a subset of the T-SQL language. Join me to take a closer look at the language, the possibilities and limitations of it and how to make it work for you. We will look at inputs and outputs - and see some working samples.
Event Date: 20-05-2017 - Session time: 10:00:00 - Track: Application Database Development
Event Date: 20-05-2017 - Session time: 10:00:00 - Track: BI Information Delivery
Event Date: 20-05-2017 - Session time: 10:00:00 - Track: Application Database Development
This presentation will start 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. We will learn how we should use TRY-CATCH and why we should use SET XACT_ABORT ON, and why it pays off to be simple-minded to survive in this maze.
Event Date: 20-05-2017 - Session time: 11:10:00 - Track: BI Platform Architecture, Development Administration
For example, you need to generate set of new measures every year or end users want to add measures themselves and so on. Using TOM and meta-data table you can automate this process and save tons of time. Join this session for learning how to implement this.
Event Date: 20-05-2017 - Session time: 11:10:00 - Track: BI Platform Architecture, Development Administration
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 fools-with-tools or should we embrace the democratization of data science as the golden age of data?
Using a combination of theory and demo’s, we explore Microsoft’s solutions to ensure democratization of data science and the possible dangers that lurk below the surface.
Event Date: 20-05-2017 - Session time: 11:10:00 - Track: Advanced Analysis Techniques
During the session we will dive into different aspects of building real-time streaming analytics, will review approaches of a kappa architecture implementation on Azure and will discuss experience of massive event processing and monitoring projects. All examples are taken from a real project for on-line monitoring of drones.
Event Date: 20-05-2017 - Session time: 11:10:00 - Track: Application Database Development
Come and learn the differences of space allocation/deallocation between Clustered Indexes and Heaps in this demo oriented session. It will answer these questions:
What is the difference of data page allocation for heaps and clustered indexes? What is the amount of transaction log when you update data in a heap and/or in a clustered index? What are the differences when data are delete from a heap and clustered index? Can ETL processes be improved by usage of the right strategy for INSERTS and DELETES? What performance drawbacks have Page Splits and Forwarded Records for my application design?
Event Date: 20-05-2017 - Session time: 11:10:00 - Track: Application Database Development
This session deep dives into all the concepts behind Anchor Modelling (and indeed databases generally!) and then takes you through how Anchor Modelling uses these concepts to move away from the traditional data warehouse paradigm to deliver a purely additive, agile database.
Event Date: 20-05-2017 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment
HA/DR options with SQL Server are easy to design and deploy. With the changing arena in Azure and hybrid we need to be decisive to choose:
What are all the high availability (HA) and disaster recovery (DR) options for SQL Server in a Azure VM (IaaS)?
Which of these options can be used in a hybrid combination (Azure VM and on-prem)?
This session will overview features such as Always On AG, Failover cluster, Azure SQL Data Sync, Log Shipping, SQL Server data files in Azure, Mirroring, Azure Site Recovery, and Azure Backup.
Event Date: 20-05-2017 - Session time: 14:00:00 - Track: Application Database Development
Event Date: 20-05-2017 - Session time: 14:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 20-05-2017 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment
In this session we'll see a few 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), 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 (Jedi level). Disclaimer: No actual state secrets will be revealed. Please do not send agents to my house again.
Event Date: 20-05-2017 - Session time: 14:00:00 - Track: BI Platform Architecture, Development Administration
Microsoft Power BI Embedded helps Independent Software Vendors to use Power BI data experiences within their applications. Customers, who use applications with Power BI Embedded don’t need to have a Power BI account or to know anything about this Azure service. This talk is a practical session on Microsoft Power BI Embedded concept with many examples how to create custom BI solutions using this technology.
Event Date: 20-05-2017 - Session time: 14:00:00 - Track: Strategy and Architecture
Event Date: 20-05-2017 - Session time: 14:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 20-05-2017 - Session time: 14:00:00 - Track: Strategy and Architecture
Event Date: 20-05-2017 - Session time: 15:10:00 - Track: Cloud Application Development Deployment
We will cover:
Event Date: 20-05-2017 - Session time: 15:10:00 - Track: Application Database Development
In this session you will learn why it is so and techniques how you can use to overcome this. You will also learn that the same techniques can be to permit users to perform specific actions they need to do without granting them general high-level permissions on database or server level by packaging these actions into a stored procedure. You will also learn why should should be careful with setting a database TRUSTWORTHY.
The session should be of interest both to DBAs and application developers that need to consider advanced permissions in their stored procedures.
Event Date: 20-05-2017 - Session time: 15:10:00 - Track: Application Database Development
This way BI is not a canonical development team and no pure development methodology works "out of the box" . In my talk I would like to share my experience choosing and adjusting one.
Event Date: 20-05-2017 - Session time: 15:10:00 - Track: Application Database Development
It would be a good idea? What will be the use of it? How to make it work and make the most of it? How does all fit with the field gateway concept? During the presentation, we will take a real word scenario, real hardware, and together we will try to answer these questions
Event Date: 20-05-2017 - Session time: 15:10:00 - Track: Cloud Application Development Deployment
Event Date: 20-05-2017 - Session time: 16:30:00 - Track: Application Database Development
Let's back to the basis then in order to better understand transaction isolation levels available in SQL Server. On this session we will learn about a concurrency issue, (not)expected behaviours, lost modifications and consider how to cope with them. I will tell what the optimistic and pessimistic concurrency models are, when use it and what tempdb has in common with them. Also, we will see in practice how dangerous (NOLOCK) might be which has being used so passionately by developers.
Event Date: 20-05-2017 - Session time: 16:30:00 - Track: Application Database Development
Tag cloud: connection, multi-threading, cmdlets, scenarios and tasks, demo, Azure, new in 2016, script of the objects, etc.
Event Date: 20-05-2017 - Session time: 16:30:00 - Track: Enterprise Database Administration Deployment
On my session I'll show details of solution that allowed this idea to come true. We'll see how to install, use and administer Linux version of SQL Server. We'll see it working as a service and in Docker containers. I'll give you details of why the second option is really interesting, or to say it more clearly - groundbreaking. In addition to slides you're going to see lots of terminal windows, tools that are familiar to you and new stuff as well.
Event Date: 20-05-2017 - Session time: 16:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 20-05-2017 - Session time: 16:30:00 - Track: Enterprise Database Administration Deployment