| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | Pawel Potasinski | BI Platform Architecture, Development Administration | (PL) Think Mobile! Mobile Reporting with Microsoft Data Platform |
| 10:30:00 | Uwe Ricken | Enterprise Database Administration Deployment | (EN) Demystifying clustered indexes |
| 10:30:00 | Agnieszka Cieplak | Enterprise Database Administration Deployment | (PL) Rozwiązywanie problemów i optym. SQL Server przy użyciu Data Collect |
| 10:30:00 | André Melancia | Enterprise Database Administration Deployment | (EN) NSA Secrets - Hacking SQL Server |
| 11:45:00 | Cédric Charlier | BI Platform Architecture, Development Administration | (EN) Automating the testing of your BI solutions with NBi |
| 11:45:00 | Lord Richard Douglas | Enterprise Database Administration Deployment | (EN) Natural Born Killers, Performance Issues to Avoid |
| 11:45:00 | Michał Janiec | Enterprise Database Administration Deployment | (PL) Optymalizacja zapytań opartych o linked servery |
| 13:45:00 | Satya Jayanty | Enterprise Database Administration Deployment | (EN)Upgrade, upgrade more upgrade -know about SQL Server platform upgrade |
| 13:45:00 | Marcin Szeliga | Advanced Analysis Techniques | (EN) Microsoft R Server |
| 13:45:00 | Neil Hambly | Enterprise Database Administration Deployment | (EN) Effective Index Partitioning, Compression Strategy |
| 13:45:00 | Bartosz Ratajczyk | Application Database Development | (PL) How minimal logging can help me? |
| 15:00:00 | Regis Baccaro | Enterprise Database Administration Deployment | (EN) Continuous Integration with SSDT and Team Foundation Server |
| 15:00:00 | Sergiy Lunyakin | BI Platform Architecture, Development Administration | (EN) Azure SQL Data Warehouse: Deep Dive |
| 15:00:00 | Denis Reznik | Application Database Development | (EN) Hidden gems of SQL Server 2014 |
| 16:15:00 | Andrzej Pilacik | Enterprise Database Administration Deployment | (PL) Refresh a 1TB+ database in under 10 seconds |
| 16:15:00 | Grzegorz Stolecki | BI Platform Architecture, Development Administration | (PL) Diving into hyperspace - how to make better OLAP calculation |
| 17:30:00 | Damian Widera | Application Database Development | (PL) Travelling in time with SQL Server 2016 |
| 17:30:00 | Mikael Wedham | Enterprise Database Administration Deployment | (EN) When good pages go bad / The rise and fall of db corruption. |
| 17:30:00 | Hubert Kobierzewski | BI Information Delivery | (PL) SQL Server talks Hadoop |
Event Date: 01-10-2016 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 01-10-2016 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment
This session will run several demos which will show in a very clear way why a clustered index isn't the best choice in several workload scenarios. "There's no lunch for free"! Not using clustered indexes will have ONE heavy drawback - this drawback will be demonstrated, too.
The session goal is to make decisions easier for you to use a clustered index or not!
Event Date: 01-10-2016 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 01-10-2016 - Session time: 10:30: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: 01-10-2016 - Session time: 11:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 01-10-2016 - Session time: 11:45:00 - Track: Enterprise Database Administration Deployment
Ever thought that you were adhering to best practices but still seeing performance problems? You might well be. In this session I will be covering why the optimizer isn’t using all available processors, when the database engine fails to report all the resources a query has used and why the optimizer doesn’t always use the best plan.
You will leave this session with a list of things that you can check for in your environment to improve performance for your users.
Event Date: 01-10-2016 - Session time: 11:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 01-10-2016 - Session time: 13:45: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: 01-10-2016 - Session time: 13:45:00 - Track: Advanced Analysis Techniques
In this demo heavy session Marcin Szeliga will introduce you to the fundamentals of Microsoft R Server, it’s native file format XDF (eXternal Data Frame), data manipulation functions, and machine learning algorithms. Don’t miss the opportunity to see how MSR addresses open source R scalability and performance issues.
Event Date: 01-10-2016 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment
When Indexing also combines 2 of the Enterprise features: Partitioning Compression, we can often see substantial gains.
Learn how to identify those objects that benefit greatly from being Partitioned or Compressed, OR combining both of these features to even greater effect.
Using Demos to illustrate the performance gains with real-world examples, Take away advanced scripts for use in your own environments.
Event Date: 01-10-2016 - Session time: 13:45:00 - Track: Application Database Development
If you want to speed up data loading you should get familiar with minimal logging. In this sessiion I will show you real life examples (and - well - some not real life) how useful can it be, what downsides it has and how it changed over the SQL Server versions.
Event Date: 01-10-2016 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 01-10-2016 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 01-10-2016 - Session time: 15:00:00 - Track: Application Database Development
In this session, we will learn a lot about these features and improvements. Query Fingerprints, Cardinality Estimator, Tempdb improvements, and other overshadowed features will be covered in this session.
As a small bonus, we will talk a bit how these features are improved in SQL Server 2016.
Event Date: 01-10-2016 - Session time: 16:15:00 - Track: Enterprise Database Administration Deployment
Finally, the presentation will focus on an architecture based on SAN technologies with respect to SQL Server. I will demonstrate an architecture put in place resolving many business needs in a financial trading environment, working with large data sets and many different environments. This section will highlight the benefits of using SQL Server together with newer SAN solutions and show the potential for reliability, scalability, and the delivery of a high quality HA/DR solution. That is where things get interesting...
Event Date: 01-10-2016 - Session time: 16:15:00 - Track: BI Platform Architecture, Development Administration
Event Date: 01-10-2016 - Session time: 17:30:00 - Track: Application Database Development
Event Date: 01-10-2016 - Session time: 17:30: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#39;ll go through some of your options such as page level restore, DBCC repair options and some other options. Finally you#39;ll learn to estimate how much data loss you can expect. We#39;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: 01-10-2016 - Session time: 17:30:00 - Track: BI Information Delivery