| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Dejan Pervulov | Other | Welcome Note - Room 1 |
| 09:00:00 | Goran Milanov | Other | Welcome Note - Room 2 |
| 09:15:00 | Dr. Subramani Paramasivam | Cloud Application Development Deployment | Tired of connecting on-prem cloud data? Take a DB stretch |
| 09:15:00 | Zoltán Horváth | BI Platform Architecture, Development Administration | Top 10 SSAS Solution Design Best Practices |
| 10:30:00 | Janos Berke | Enterprise Database Administration Deployment | High Availability - Partial Database Availabilty |
| 10:30:00 | Dragoslav Ogar | Application Database Development | SQL Server 2016: Operational Analytics |
| 11:45:00 | Mikael Wedham | Enterprise Database Administration Deployment | When good pages go bad / The rise and fall of db corruption. |
| 11:45:00 | Vladimir Markovic | BI Platform Architecture, Development Administration | Optimizacija DWH rešenja u praksi |
| 13:45:00 | Miloš Radivojević | Application Database Development | Temporal Tables in SQL Server 2016 |
| 15:00:00 | Ivan Donev | Application Database Development | SQL Server Advanced indexing techniques |
| 15:00:00 | Miroslav Dimitrov | Enterprise Database Administration Deployment | Performance Tuning for the Transaction Log |
| 16:15:00 | Dejan Sarka | Advanced Analysis Techniques | Analyzing Text with SQL Server, R, and Azure ML |
| 16:15:00 | Mladen Prajdić | BI Information Delivery | Visualizing streaming data in real time |
| 17:30:00 | Catalin Gheorghiu | Application Database Development | IoT and SQL (Server) |
| 17:30:00 | Mihail Mateev | Analytics and Visualization | Complex Event Processing with Azure Stream Analytics |
Event Date: 28-11-2015 - Session time: 09:00:00 - Track: Other
Event Date: 28-11-2015 - Session time: 09:00:00 - Track: Other
Event Date: 28-11-2015 - Session time: 09:15:00 - Track: Cloud Application Development Deployment
Event Date: 28-11-2015 - Session time: 09:15:00 - Track: BI Platform Architecture, Development Administration
I've collected a number of best practices during the years I've spent on building and maintaining OLAP cubes. In this session, we will go through the most important ten of these, so you can consider them in your everyday work when you build analytical back-end solutions with SSAS. Join this session, and see how these tips and best practices can save your precious time.
Event Date: 28-11-2015 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment
Session agenda is the follwoing:
Event Date: 28-11-2015 - Session time: 10:30:00 - Track: Application Database Development
Event Date: 28-11-2015 - Session time: 11:45:00 - Track: Enterprise Database Administration Deployment
The DBCC command is the most important part and its output will be covered. The different methods to repair the pages gives different amounts of data loss, so we'll go through some of your options such as page level restore, DBCC repair options and some other options. Finally you'll learn to estimate how much data loss you can expect. We'll even going to see how to look at the corrupt page with DBCC PAGE to try to see approximately what data we are going to loose.
Event Date: 28-11-2015 - Session time: 11:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 28-11-2015 - Session time: 13:45:00 - Track: Application Database Development
In this session we'll explain why we need them, how system-time tables work and demonstraint how to design and implement solutions for common use cases that involve temporal tables...
Event Date: 28-11-2015 - Session time: 15:00:00 - Track: Application Database Development
Event Date: 28-11-2015 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 28-11-2015 - Session time: 16:15:00 - Track: Advanced Analysis Techniques
Event Date: 28-11-2015 - Session time: 16:15:00 - Track: BI Information Delivery
that has to be refreshed on an interval. And those are very important visualizations. But sometimes you just have to have a real time view of your data streams and snapshots aren't enough. What if you could monitor multiple servers with SQL Trace or Extended Events or had some other source of streaming data and be able to see it all happening live on a central monitoring website? This is a scenario we'll take a detailed look at and build a system for such monitoring. We'll do this by using Extended Events .Net provider to get the live data stream, SignalR to get the live stream from the server to the website and the D3 javaScript library for actual real time visualizations on any device. After seeing all this in action, you'll definitely get a few ideas on where you could use this in your company.
Event Date: 28-11-2015 - Session time: 17:30:00 - Track: Application Database Development
And we are not talking about Oracle Index Organized Tables, we are talking about Internet of Things. This buzzword you hear almost everywhere, and for sure needs databases. So let’s take the Microsoft vision of IoT and see the database side of it. We will talk about the vision of IoT and the real world practicalities of it. The presentation goal is to provide a DBA all he/she needs to know to support an IoT application. And to make you curious we will cover topics such SQL 2014 for Embedded Systems or the Azure offerings (and their SQL connections), and I will try full demos with IoT hardware.
Event Date: 28-11-2015 - Session time: 17:30:00 - Track: Analytics and Visualization
This technology uses a T-SQL like syntax to express its intents. A language that most data-power users will be familiar with.
The biggest advantage of Stream Analytics is when events are being published to the Stream Analytics, the only thing that event publishers needs to know is which Event Bus or Blob storage to place the data. Stream Analytics will then fetch the data.
This talk is about the main concepts and solution architecture when using Azure Stream Analytics, and also how to use this technology together with MS SQL Server, Azure SQL Database and Power BI.