| Session Date/Time (dd-MM-YYYY 24h) | Speaker | Category | Track | Title |
|---|---|---|---|---|
| 06-11-2013 09:00 | Adam Machanic | Pre-Conference Session (full day) | Database and Application Development | No More Guessing! An Enlightened Approach to Performance Troubleshooting |
| 06-11-2013 09:00 | Brent Ozar | Pre-Conference Session (full day) | BI Platform Architecture, Development and Administration | This Year's SQL Server Setup Best Practices |
| 06-11-2013 09:00 | Denny Cherry | Pre-Conference Session (full day) | Database and Application Development | Storage and Virtualization for DBAs |
| 06-11-2013 09:00 | Dejan Sarka | Pre-Conference Session (full day) | BI Platform Architecture, Development and Administration | Enterprise Information Management with SQL Server 2012 |
| 06-11-2013 09:00 | Marco Russo, Alberto Ferrari | Pre-Conference Session (full day) | BI Platform Architecture, Development and Administration | 0 to DAX |
| 07-11-2013 09:00 | Steve Simon | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | Master Data Services Best Practices |
| 07-11-2013 09:00 | Brent Ozar | Regular Session (60 minutes) | Enterprise Database Administration and Deployment | Why is SQL Server Slow Right Now? |
| 07-11-2013 09:00 | Dejan Sarka | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | Advanced Analytics in Excel 2013 |
| 07-11-2013 09:00 | Matija Lah | Regular Session (60 minutes) | Database and Application Development | SQL Server and XML Query |
| 07-11-2013 12:00 | Kennie Pontoppidan | Regular Session (60 minutes) | Database and Application Development | SQL anti patterns |
| 07-11-2013 12:00 | Jacky van Hogen | Regular Session (60 minutes) | Database and Application Development | SQL Server Availability Groups |
| 07-11-2013 12:00 | Hans Geurtsen | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | Choosing between Tabular and Multidimensional |
| 07-11-2013 12:00 | Denny Cherry | Regular Session (60 minutes) | Enterprise Database Administration and Deployment | Flash vs. Disk vs. SSD |
| 07-11-2013 14:15 | Francesco Cogno | Regular Session (60 minutes) | Database and Application Development | How to call Windows Azure REST API from CLR |
| 07-11-2013 14:15 | Uwe Ricken | Regular Session (60 minutes) | Database and Application Development | FILLFACTOR - pro and con |
| 07-11-2013 14:15 | Scott Klein | Regular Session (60 minutes) | Database and Application Development | Microsoft SQL Server In-Memory OLTP Deep Dive |
| 07-11-2013 14:15 | Alberto Ferrari | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | Optimizing Data Models in Tabular & PowerPivot |
| 07-11-2013 15:45 | Matija Lah | Regular Session (60 minutes) | Database and Application Development | FILETABLEs: What They Are and How to Use Them |
| 07-11-2013 15:45 | Niko Neugebauer | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | Clustered Columnstore - Deep Dive |
| 07-11-2013 15:45 | Henk Van der Valk, Jan Pieter Posthuma | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | Hadoop |
| 07-11-2013 15:45 | Andreas Wolter | Regular Session (60 minutes) | Enterprise Database Administration and Deployment | “SQL Attack…ed” – SQL Server under attack. |
| 07-11-2013 17:00 | Adam Machanic | Regular Session (60 minutes) | Database and Application Development | Data, Faster: SQL Server Performance Techniques with SQLCLR |
| 07-11-2013 17:00 | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | 10 Tips and Tricks for better SSIS Performance | |
| 07-11-2013 17:00 | Neil Hambly | Regular Session (60 minutes) | Enterprise Database Administration and Deployment | Load Testing with SQL Server Tools |
| 07-11-2013 17:00 | Rafal Lukawiecki | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | Predictive Analytics with SQL Server Data Mining and R |
| 08-11-2013 09:00 | Jen Stirrup | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | Analysing Data with Power View |
| 08-11-2013 09:00 | Klaus Aschenbrenner | Regular Session (60 minutes) | Enterprise Database Administration and Deployment | Index Impact Workload Analysis |
| 08-11-2013 09:00 | Hugo Kornelis | Regular Session (60 minutes) | Database and Application Development | T-SQL User-defined Functions |
| 08-11-2013 09:00 | Oliver Engels, Julian Breunung | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | M versus P versus R |
| 08-11-2013 10:30 | Davide Mauri | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | Automating DWH Patterns through Metadata |
| 08-11-2013 10:30 | Dave Ballantyne | Regular Session (60 minutes) | Database and Application Development | Estimation and Statistics : The basis of query optimization |
| 08-11-2013 10:30 | Constantin Klein | Regular Session (60 minutes) | Database and Application Development | StreamInsight: Complex Event Processing by MS |
| 08-11-2013 10:30 | Adam Machanic, Thomas Kejser | Regular Session (60 minutes) | Database and Application Development | Using Your Brain to Beat SQL Server |
| 08-11-2013 13:15 | Alessandro Recino | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | Business Intelligence Stack and the Kerberos Authentication Jungle |
| 08-11-2013 13:15 | Lord Richard Douglas | Regular Session (60 minutes) | Enterprise Database Administration and Deployment | The Day After Tomorrow: Why you need to baseline |
| 08-11-2013 13:15 | Peter Larsson | Regular Session (60 minutes) | Database and Application Development | Fix your EAV data model with a new EAV design |
| 08-11-2013 13:15 | Alberto Ferrari | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | Inside xVelocity Engine |
| 08-11-2013 14:45 | Christina Leo | Regular Session (60 minutes) | Database and Application Development | The Secret Life of APPLY: Helping Us Work Smarter, Not Harder |
| 08-11-2013 14:45 | Menzo Steinhorst | Regular Session (60 minutes) | Database and Application Development | Reading Query Plans |
| 08-11-2013 14:45 | Marcel Westra | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | Big Data |
| 08-11-2013 14:45 | Jenny Rjinbeek | Regular Session (60 minutes) | Database and Application Development | Next Generation Databases with SQLServer 2012 & FusionIO |
| 08-11-2013 16:00 | Emanuele Zanchettin | Regular Session (60 minutes) | Database and Application Development | rewrite query with SQLServer2012 |
| 08-11-2013 16:00 | Paul te Braak | Regular Session (60 minutes) | BI Platform Architecture, Development and Administration | Data Mining - the Art of Unkonwn Business Intelligence |
| 08-11-2013 16:00 | Marcel Fernee | Regular Session (60 minutes) | Database and Application Development | SQL IaaS/Private Cloud |
| 08-11-2013 16:00 | Brent Ozar | Regular Session (60 minutes) | Database and Application Development | How the SQL Server Engine Thinks |
Event Date: 06-11-2013 09:00 - Category: Pre-Conference Session (full day) - Track: Database and Application Development
In this full-day seminar, you will learn a proven methodology that can be used to approach virtually any performance problem. Created and refined by Adam Machanic over several years, this strategy leverages core SQL Server performance tools (including dynamic management views, Extended Events, and WMI counters), applying them to various performance troubleshooting techniques (such as waits and queues analysis, baselining, and real-time activity monitoring). Each of these tools and techniques has a unique role, and you will learn to use them cooperatively to quickly and adaptively find the actual cause of performance issues. All of this will be illustrated through demonstrations that will teach you how to drill from high-level problem detection all the way to a specific spot in a query plan or deeper?pinpointing the exact problem and helping you quickly solve it. Attend this seminar to take full control of your databases—and never again stumble blindly through the dimly lit world of performance troubleshooting.
Event Date: 06-11-2013 09:00 - Category: Pre-Conference Session (full day) - Track: BI Platform Architecture, Development and Administration
Event Date: 06-11-2013 09:00 - Category: Pre-Conference Session (full day) - Track: Database and Application Development
We will begin by focusing on the storage array. Storage can be one of the biggest bottlenecks when it comes to database performance. It ís also one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often do not speak the same language. In the first half of this seminar, we will look at storage from both the database and storage perspectives. We will dig into LUNs, HBAs, and the fabric. Then we will examine advanced storage configurations, including RAID groups, multi-pathing software, and proper redundant storage network design. We will also cover some advanced storage array backup techniques, including taking storage level clones and snapshots, then see best practices for using them to back up the SQL Server environment to provide maximum redundancy with no recurring tape costs. In addition to theory, we will look at an actual SAN so we can translate what we see in the Storage Array with what we see on the actual server.
In the second half of the day, we will explore the pros and cons of moving SQL Servers into a virtual server environment, when it is not be a good idea, and when virtualizing a SQL Server is a good idea and can save you some money. We will see how to gather the metrics you need to make the appropriate decision for your environment. We will also look at how to tie the virtual platforms to the storage array so that you can maximize the storage performance for your SQL Servers and the virtual environment.
Event Date: 06-11-2013 09:00 - Category: Pre-Conference Session (full day) - Track: BI Platform Architecture, Development and Administration
Every company has "master data" - certain data that is used everywhere, in every transaction, such as customers data and products data. The people who manage master data are often called data stewards. Processes and activities for maintaining master data are known as master data management (MDM). In this workshop, we will discuss ETL, DQ, and MDM challenges and look at Microsoft SQL Server technologies and tools that can help you with solutions, including SQL Server Integration Services (SSIS), Data Quality Services (DQS), and Master Data Services (MDS), and other tools for data profiling and matching. Workshop modules include:
Event Date: 06-11-2013 09:00 - Category: Pre-Conference Session (full day) - Track: BI Platform Architecture, Development and Administration
During this full-day workshop, the authors of the bestselling books Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model and Microsoft PowerPivot for Excel 2010: Give Your Data Meaning will guide you through the process of learning the DAX language, using many examples and scenarios that will help you understand important DAX concepts and how to leverage them in your everyday work. This workshop is for data professionals in many different roles, including Information Workers interested in exploiting the many interesting features of PowerPivot for Excel 2013 and BI developers who want to learn the DAX language.
Event Date: 07-11-2013 09:00 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
Event Date: 07-11-2013 09:00 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment
Event Date: 07-11-2013 09:00 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
Event Date: 07-11-2013 09:00 - Category: Regular Session (60 minutes) - Track: Database and Application Development
Event Date: 07-11-2013 12:00 - Category: Regular Session (60 minutes) - Track: Database and Application Development
The session is relevant for developers and DBAs.
Event Date: 07-11-2013 12:00 - Category: Regular Session (60 minutes) - Track: Database and Application Development
Event Date: 07-11-2013 12:00 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
Event Date: 07-11-2013 12:00 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment
Event Date: 07-11-2013 14:15 - Category: Regular Session (60 minutes) - Track: Database and Application Development
In this session we'll show you how to cross the gap separating SQL Server from the Windows Azure Platform using the CLR and the Windows Azure REST API. We'll talk about Windows Azure queues, Windows Azure table storage and Windows Azure blob storage and how to exploit them from your T-SQL code. We'll explain in detail how to construct a Windows Azure REST request and how to secure it using both shared key and certificate authentication. Finally, to give you a complete insight of the topic, we'll also talk about debugging tools and techniques useful in the cloud world.
Event Date: 07-11-2013 14:15 - Category: Regular Session (60 minutes) - Track: Database and Application Development
Learn how to determin the right choice for FILLFACTOR by using index statistics and it's evaluation
Event Date: 07-11-2013 14:15 - Category: Regular Session (60 minutes) - Track: Database and Application Development
Event Date: 07-11-2013 14:15 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
Event Date: 07-11-2013 15:45 - Category: Regular Session (60 minutes) - Track: Database and Application Development
Event Date: 07-11-2013 15:45 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
Event Date: 07-11-2013 15:45 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
Event Date: 07-11-2013 15:45 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment
Event Date: 07-11-2013 17:00 - Category: Regular Session (60 minutes) - Track: Database and Application Development
Event Date: 07-11-2013 17:00 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
Event Date: 07-11-2013 17:00 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment
Come learn about the native tools at our disposal for performing these important load tests and how we can identify when performance levels begin to drop. Using demos of these native tools – including Distributed Replay Utility (DRU), Database Tuning Adviser (DTA), Perfmon, Extended Events, and Profiler – we’ll see how to plan and perform a load test project, gain an understanding of SQL Server’s performance under varying load scenarios, and discover which tell-tale indicators can help alert us to performance degradation.
Event Date: 07-11-2013 17:00 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
Event Date: 08-11-2013 09:00 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
Event Date: 08-11-2013 09:00 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment
============================== Should we add this additional index, should we modify existing ones, or does it make sense to drop unused (?) indexes to improve workload performance? A lot of different questions, but finding correct, profound answers is very hard and difficult. In this session you will learn a proven approach how you can identify if an index change was a good or bad one. We will take a real SQL Server OLTP workload, establish a baseline against it, and use that baseline together with some tools to determine if index changes should be applied to our production databases, or not. After attending this session, it is very easy for you to apply the same techniques to your production environment.
Event Date: 08-11-2013 09:00 - Category: Regular Session (60 minutes) - Track: Database and Application Development
The reason is performance. In this session, you will learn how user-defined functions feed the optimizer with misleading and insufficient information, how the optimizer fails to use even what little information it has, and how this can lead to shocking query performance. However, you will also see that there is a way to avoid the problems. With just a little extra effort, you can reap the benefits of code encapsulation and reuse, and still get good performance.
Event Date: 08-11-2013 09:00 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
like Power Pivot, Power View and Power Map. This session will take a deep dive into the language behind the Data Explorer: "M". We will take the language concepts and possibilities and compare them with other cool kids in town: "P" (for Python) an "R" THE language for statistical computing and data mining. What possibilities do these languages offer, where can you use them best and how good is the integration to the Microsoft stack. The session is driven by demos and you will take away a good starting point how to work with these three languages.
Event Date: 08-11-2013 10:30 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
Event Date: 08-11-2013 10:30 - Category: Regular Session (60 minutes) - Track: Database and Application Development
Event Date: 08-11-2013 10:30 - Category: Regular Session (60 minutes) - Track: Database and Application Development
Event Date: 08-11-2013 10:30 - Category: Regular Session (60 minutes) - Track: Database and Application Development
SQL Server's query optimizer, often very good at coming up with decently-performing plans, also regularly goes down the wrong path. The problem domain is simply too large and complex for it to adequately cover all cases. When the going gets tough, you mind is a better machine for the job. So don't trust optimisation to a mere piece of code! In this session we will teach you how to recognise various real world cases where the optimiser fails. We will show you why these queries aren't performing as well as they should and how to work around the optimiser's lack of insight. You will learn to turn your brain into a better query optimiser and make your queries faster than you thought possible.
Event Date: 08-11-2013 13:15 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
If you work with Business intelligence solutions either native or integrated with SharePoint, sooner or later you will come across some decision to make around authentication. In this session you will learn do's and don’ts, how and when to configure the appropriate authentication method for Microsoft BI services.
Event Date: 08-11-2013 13:15 - Category: Regular Session (60 minutes) - Track: Enterprise Database Administration and Deployment
Event Date: 08-11-2013 13:15 - Category: Regular Session (60 minutes) - Track: Database and Application Development
Event Date: 08-11-2013 13:15 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
Event Date: 08-11-2013 14:45 - Category: Regular Session (60 minutes) - Track: Database and Application Development
Event Date: 08-11-2013 14:45 - Category: Regular Session (60 minutes) - Track: Database and Application Development
Event Date: 08-11-2013 14:45 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
Event Date: 08-11-2013 14:45 - Category: Regular Session (60 minutes) - Track: Database and Application Development
Event Date: 08-11-2013 16:00 - Category: Regular Session (60 minutes) - Track: Database and Application Development
Event Date: 08-11-2013 16:00 - Category: Regular Session (60 minutes) - Track: BI Platform Architecture, Development and Administration
Analysis Services (OLAP) includes a data mining engine which can be used at various levels within the organisation, from Analyst to Developer. This presentation looks at all facets of data mining within Analysis Services by explaining what data mining is and how it can be used across the organisation. We look at simple and complex implementations of data mining so that new information can be extracted from data and used in novel ways.
Event Date: 08-11-2013 16:00 - Category: Regular Session (60 minutes) - Track: Database and Application Development
This session is relevant for you, if you plan to work on SQL Server in the private cloud. This includes re-usable ‘VM deployments of SQL Server’.
Event Date: 08-11-2013 16:00 - Category: Regular Session (60 minutes) - Track: Database and Application Development