| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 10:00:00 | Tobias Koprowski | Enterprise Database Administration Deployment | Storage, Backup and Restore Management in the Cloud World |
| 10:00:00 | Satya Jayanty | Enterprise Database Administration Deployment | Upgrade, upgrade and more upgrade -know about SQL Server platform upgrade |
| 10:00:00 | Sergiy Lunyakin | Other | Power BI Workshop |
| 10:00:00 | Andrey Langovoy | Application Database Development | Managing Database Changes in Source Control |
| 10:00:00 | Tobias Koprowski | Strategy and Architecture | AD 2015. 2 AM. A Disaster just began... |
| 10:00:00 | Mihail Mateev | Cloud Application Development Deployment | Think Connected – Modern IoT Solutions with Microsoft Azure |
| 10:00:00 | Alexander Karl | Application Database Development | JSON XML; since SQL 2016 it is important to weigh respective advantage |
| 10:00:00 | Vitalii Bondarenko | BI Platform Architecture, Development Administration | Azure Data Lake Analytics. Dive into Big Data with Microsoft U-SQL lanuage. |
| 11:10:00 | Uwe Ricken | Professional Development | Mastering DML Operations like a master |
| 11:10:00 | Michal Sadowski | Enterprise Database Administration Deployment | SQL Server 2016 for DBA |
| 11:10:00 | Sergiy Lunyakin | BI Information Delivery | Real-Time Dashboards on PowerBI |
| 11:10:00 | Satya Jayanty | Advanced Analysis Techniques | Big Data with Azure: where to begin? Concepts and best practices |
| 11:10:00 | Sergey Syrovatchenko | Application Database Development | XML, XQuery и трюки с производительностью |
| 12:30:00 | Luan Moreno Medeiros Maciel | Enterprise Database Administration Deployment | DBA Vs. Hacker: Protecting SQL Server |
| 14:00:00 | Regis Baccaro | BI Platform Architecture, Development Administration | Advanced BIML - for the advanced ETL developer |
| 14:00:00 | Tomasz Libera | Application Database Development | Service Broker in action |
| 14:00:00 | Umit Sunar | Strategy and Architecture | What is Azure Data Lake? How to position it in Big Big Data business? |
| 14:00:00 | Enrico van de Laar | Enterprise Database Administration Deployment | Introducing the SQL Server 2016 Query Store |
| 14:00:00 | Alexey Vasiliev | Strategy and Architecture | PostgreSQL and Big Data |
| 15:10:00 | Eugene Polonichko | BI Platform Architecture, Development Administration | Tabular SSAS 2016. What's new? |
| 15:10:00 | Dejan Sarka | Advanced Analysis Techniques | Anomaly Detection |
| 15:10:00 | Erland Sommarskog | Application Database Development | Dynamic Search Conditions |
| 15:10:00 | Mariya Shirokopetleva | Application Database Development | Relation Theory - back to basics |
| 15:10:00 | Andrzej Kukula | Enterprise Database Administration Deployment | PBM and PowerShell for DBA |
| 15:30:00 | Oleg Alekseev | Professional Development | SQL 2016. Super speed with in-memory OLTP. |
| 16:30:00 | Marcin Szeliga | Advanced Analysis Techniques | Revolutionary R integration in SQL Server 2016 |
| 16:30:00 | Andrii Zrobok | Application Database Development | @Table vs #Table: шаблони використання, спільні характеристики, міфи |
| 16:30:00 | Andriy Pogorelov | Application Database Development | Индексы в SQL Server. Сборник рецептов. |
| 16:30:00 | John Tunnicliffe | BI Platform Architecture, Development Administration | Continuous Integration and the Data Warehouse |
| 16:30:00 | Anton Boyko | Cloud Application Development Deployment | DevOps'ing or how to build, release and provision environments on |
Event Date: 21-05-2016 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment
Requirements for this workshop:
Event Date: 21-05-2016 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment
Data Platform Upgrade topic has been a popular session that I've presented in major conferences like Microsoft Tech-Ed (North America, Europe India) and SQLbits since 2008.
In this session, we will overview in depth end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading SQL Server (2000 to 2012), SQL Server 2014 (with a good overview on 2016 too) by using best practices and available resources.
What to-do and what not-to-do?
A popular session that I have been presenting since the year 2008, in MS Tech-Ed, SQL Saturday SQLbits UK. We will cover the complete upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. Real-world examples from my Consulting experience expanding on why how such a solution.
Event Date: 21-05-2016 - Session time: 10:00:00 - Track: Other
В курсе так же будут рассмотрены компоненты традиционных BI решений, архитектура Power BI и их различие в подходах и применении. По окончанию курса Вы будете знать - как использовать PowerQuery для объединения и трансформации данных из нескольких источников; PowerPivot и DAX для моделирования данных, создания вычислений и KPI; как создавать информативные и интерактивные отчёты в Power BI используя различные способы визуализации, как организовать совместную работу с информацией с использованием Dashboards и Groups в Power BI Service
Event Date: 21-05-2016 - Session time: 10:00:00 - Track: Application Database Development
Event Date: 21-05-2016 - Session time: 10:00:00 - Track: Strategy and Architecture
Event Date: 21-05-2016 - Session time: 10:00:00 - Track: Cloud Application Development Deployment
This talk is about the main business cases and main architectural challenges, related to the actual and new IoT systems and particularly predictive services, based on Microsoft Azure.
Event Date: 21-05-2016 - Session time: 10:00:00 - Track: Application Database Development
Both the different operational scenarios and the technical background of JSON and XML, however, require a different range of functions and language. Therefore, initially, as far as practicable the parallels will be demonstrated. Especially the T-SQL extensions „FOR JSON“ and „OpenJSON“ are very similarly implemented in comparison to „FOR XML“ and „OpenXML“. Furthermore the new functions „IsJSON“, „JSON_VALUE“ and „JSON_QUERY“ are now contained in T-SQL. Do they also have these as T-SQL functions for XML or can these results be calculated with XML-methods? Additionally, XML has some more features which concern saving ( and indexing ) and requesting (in particular with XQuery) in relational tables. These will also be demonstrated exemplary. The goal of the session is to show, when which language is of advantage in which case.
Event Date: 21-05-2016 - Session time: 10:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 21-05-2016 - Session time: 11:10:00 - Track: Professional Development
This session will demonstrate the huge difference of allocation data in a heap and in a clustered index. If you don't know the benefits of correct record size and / or you are wondering how you could release allocated data pages in a professional way this session may give you all the answers.
Event Date: 21-05-2016 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment
Event Date: 21-05-2016 - Session time: 11:10:00 - Track: BI Information Delivery
Event Date: 21-05-2016 - Session time: 11:10:00 - Track: Advanced Analysis Techniques
Microsoft Azure has the ability to move, store and analyze data within the cloud. It is essential to evaluate multiple opportunities and options with Microsoft Azure data insights. In this session let us talk about strategies on data storage, data partitioning and availability options with Azure. A tour on how best these Azure components can help you achieve success for your Big Data platform.
Event Date: 21-05-2016 - Session time: 11:10:00 - Track: Application Database Development
Event Date: 21-05-2016 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment
A Hacker's goal is to find vulnerabilities in a system and a DBA's goal is to make the environment secure and reliable. In this session we will learn how to protect SQL Server from the various forms of attacks that a smart hacker can throw at you. Let's dig in the Hacker thought process to understand the inception of the attack and how to defeat the invasion. Join with me in this internal session using SQL Server and Kali Linux for the ultimate security showdown!
Event Date: 21-05-2016 - Session time: 14:00:00 - Track: BI Platform Architecture, Development Administration
By now you already know that BIML is a great productivity enhancement to SSIS. You also know that you can build metadata driven solution and include C# code in your BIML scripts or snippets. If you don't know what I'm talking about this session is not for you. If you - on the other hand - want to know how to build a modular BIML framework, do real C# development and include it in your BIML code so that you can pass custom objects around for optimized performance and code reuse then this session is for you. I promise you no more than 5 slides but a lot of demos and real life experience acquired from major BIML projects. We will also have a look at how to harness integration and unit tests in the setup with a twist of Continuous Integration.
Event Date: 21-05-2016 - Session time: 14:00:00 - Track: Application Database Development
Event Date: 21-05-2016 - Session time: 14:00:00 - Track: Strategy and Architecture
This session delves into Microsoft's play in the Big Data workload, and paints the end-to-end picture of effective solutions.
Session covers the importance of building a Data Lake, nurturing its potential with Hadoop and other analytics options and an important chapter in the Microsoft Data Platform story.
Event Date: 21-05-2016 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment
During this session we will take a thorough look at the Query Store, it’s architecture, the build-in reporting, DMVs and the performance impact of enabling the Query Store. No matter if you are a DBA or developer, the Query Store has information that can help you!
Event Date: 21-05-2016 - Session time: 14:00:00 - Track: Strategy and Architecture
Event Date: 21-05-2016 - Session time: 15:10:00 - Track: BI Platform Architecture, Development Administration
Event Date: 21-05-2016 - Session time: 15:10:00 - Track: Advanced Analysis Techniques
Event Date: 21-05-2016 - Session time: 15:10:00 - Track: Application Database Development
Event Date: 21-05-2016 - Session time: 15:10:00 - Track: Application Database Development
Event Date: 21-05-2016 - Session time: 15:10:00 - Track: Enterprise Database Administration Deployment
Event Date: 21-05-2016 - Session time: 15:30:00 - Track: Professional Development
Event Date: 21-05-2016 - Session time: 16:30:00 - Track: Advanced Analysis Techniques
• R can greatly simplify collection of different data.
• Data manipulation and preparation can also be way easier with R.
• You can use R to quickly explore and visualize data.
• Last but not least, R brings the whole power of modern data mining techniques to SQL Server.
As if this was not enough, you can use familiar user interface and SQL Server Enterprise R Services to work with large datasets and multi-threaded, multi-core, multi-process computations. So, even if you don’t know R at all, come and see how natural this language is for everybody who already think in rows and columns.
Event Date: 21-05-2016 - Session time: 16:30:00 - Track: Application Database Development
Event Date: 21-05-2016 - Session time: 16:30:00 - Track: Application Database Development
О чем будем говорить:
Будет мало текста - будет, в основном, демонстрация!
О чем не будем говорить:
Event Date: 21-05-2016 - Session time: 16:30:00 - Track: BI Platform Architecture, Development Administration
Setting up SQL Server Data Tools for automated deployments: DAC Publish profiles SQLPackage.exe
Automating your build and deployments with PowerShell and psake
Guide to configuring TeamCity as your build server
Automated Integration and Regression testing of your Data Warehouse using NBi test framework
Automating cube and tabular model deployment
On-going management of OLAP databases using the SSAS Partition Manager
Event Date: 21-05-2016 - Session time: 16:30:00 - Track: Cloud Application Development Deployment
I will show the demo app which consists of 3 parts - client app, server api and database. I will show how to automate builds for all parts of your project. I will show how to provide different configuration settings for different environments. I will show how you can create new environment on a fly, deploy your app there, run some integration and UI automation tests, etc. I will show how to automate all routine stuff and focused more on innovation, not maintenance.