| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 00:00:00 | Boris Hristov | DBA | Replay your workload as it's your actual one! |
| 00:00:00 | Dejan Sarka | DEV | Optimizing Temporal Queries |
| 00:00:00 | Kennie Pontoppidan | BI | Autogenerating a process data warehouse |
| 00:00:00 | Marcin Szeliga | DEV | Indexing for denormalization |
| 00:00:00 | Mark Stacey | BI | Analysis Services for the DBA |
| 00:00:00 | Miloš Radivojević | DEV | TSQL Performance Tips |
| 00:00:00 | Miloš Radivojević | DEV | SQL Server 2014 - New Cardinality Estimator |
| 00:00:00 | Pieter Vanhove | DBA | Harder, Better, Stronger and more secure |
| 00:00:00 | Rasmus Reinholdt | BI | Optimizing BI with SQL2014 In-Memory tables |
| 00:00:00 | Mladen Prajdić | DBA | From SQL Traces to Extended Events. The next big switch. |
| 00:00:00 | Tomaž Kaštrun | BI | Using Data Quality services on Customer related data |
| 00:00:00 | William Durkin | DBA | SQL Server Consolidation - Resistance is Futile |
| 00:00:00 | André Kamman | BI | Automate your SSIS development with BIML |
| 00:00:00 | Marco Parenzan | DEV | .NET Development for the SQL Server Developer |
Event Date: 21-12-2013 - Session time: 00:00:00 - Track: DBA
Event Date: 21-12-2013 - Session time: 00:00:00 - Track: DEV
Event Date: 21-12-2013 - Session time: 00:00:00 - Track: BI
In this talk I will show you how Rehfeld has overcome this difficult problem using an autogenerated datawarehouse based on metadata on the objects in the EDW/DM layers. In this approach you can autogenerate the process data warehouse if only you have the timestamps present in the EDW layer and are able to correlate them. The talk will consist of slides and demos.
Event Date: 21-12-2013 - Session time: 00:00:00 - Track: DEV
A third normal form is great, but sometime a database really should be denormalized to gain a performance boost. This is where indices shine. During this session you will see: how important a proper table design can be, when to use indices on computed columns and why they are way better than triggers, how to create useful indexed views and how to asses their costs and benefits.
Event Date: 21-12-2013 - Session time: 00:00:00 - Track: BI
Event Date: 21-12-2013 - Session time: 00:00:00 - Track: DEV
In this session we will advice how to avoid common developer mistakes and show how bad designed queries reduce the SQL Server optimizer's capabilities for choosing an optimal execution plan.
Event Date: 21-12-2013 - Session time: 00:00:00 - Track: DEV
This session will answers all these questions and will demonstrate new query processing capabilities and compare them with those from SQL Server2012.
Event Date: 21-12-2013 - Session time: 00:00:00 - Track: DBA
Microsoft has already implemented a lot of HA/DR solutions in previous editions of SQL Server, like AlwaysOn failover clustering, AlwaysOn Availability Groups, log shipping, ... But,when it comes to high availability, SQL Server 2014 changes the game by enhancing the availability, scalability, and flexibility of AlwaysOn. How about your HA/DR solution? Did your management decide the DR site is still too expensive? Are your backups secure? In this session, you will learn all about the new and enhanced features of AlwaysOn in SQL Server 2014 like managing backups to Azure, encrypting backups, adding
Event Date: 21-12-2013 - Session time: 00:00:00 - Track: BI
This demo intensiv session is build around a number of hypothesis that are testet and show what we can - and cannot optimize with In-Memeory tables covering both the ETL and (R)OLAP angels of the BI process. The session will use the latest CTP release and is constantly updated to include the latest news on the topic.
Event Date: 21-12-2013 - Session time: 00:00:00 - Track: DBA
The old SQL Trace which has served us well over the past 10 or so years is on its way out because the overhead and details it produces are no longer enough to deal with today's loads. The new Extended Events are a new lightweight tracing mechanism built directly into the SQLOS thus giving us information SQL Trace just couldn't. They were designed and built with performance in mind and it shows. Mastering Extended Events requires learning at least one new skill: XML querying. We'll look at how the Extended Events work with only a brief overview of old SQL Trace architecure.
Event Date: 21-12-2013 - Session time: 00:00:00 - Track: BI
Main focus of this session will be usage of data quality services with practical examples on managing quality, integrity and consistency of data for further data usage. Session will show how to build a knowledge base, manage domains and use data cleaning and matching.
Event Date: 21-12-2013 - Session time: 00:00:00 - Track: DBA
In this session we will discuss how consolidating SQL Server can reduce overall costs and increase efficiency. We will cover the reasons for consolidation along with the advantages and the disadvantages of consolidating SQL Servers. We will also take a look at some of the tools that can assist with a consolidation project and some pitfalls that I have experienced on previous consolidation projects.
Event Date: 21-12-2013 - Session time: 00:00:00 - Track: BI
Or created a bunch of SSIS packages to process a data warehouse load? Then you know how much work it is to specify the metadata correctly just to create a package that actually works. Wouldn't it be cool if you had a descriptive language which looks at your metadata and just created the packages for you? This is what BIML is all about. In this session I explain what BIML is, how it works and I'll show you how you can generate your packages and quickly respond to changes. You can expect a demo rich session with lots of notes from the field and practical examples. This is not just for BI developers, DBA's or SQL dev's who need to import or export data occasionally will learn some quick and easy tricks as well.
Event Date: 21-12-2013 - Session time: 00:00:00 - Track: DEV