| Session Date/Time (dd-MM-YYYY 24h) | Speaker | Category | Track | Title |
|---|---|---|---|---|
| 08-11-2011 09:30 | To be Announced | Keynote (75 minutes) | General | Welcome & Keynotes |
| 08-11-2011 11:00 | Tibor Karaszi | Regular Session (60 minutes) | DBA | Making the GUI work for you |
| 08-11-2011 11:00 | Johan Åhlén, Tim Peterson | Regular Session (60 minutes) | BI | The New Possibilities in Microsoft Business Intelligence |
| 08-11-2011 11:00 | Peter Larsson | Regular Session (60 minutes) | Developer | Relational Division |
| 08-11-2011 13:00 | Thomas Kejser | Regular Session (60 minutes) | DBA | The Grade of the Steel |
| 08-11-2011 13:00 | Marco Russo | Regular Session (60 minutes) | BI | BISM Introduction |
| 08-11-2011 13:00 | Kevin Kline | Regular Session (60 minutes) | Developer | Ten Crucial Dev Skills That Will Keep Your DBA Happy |
| 08-11-2011 14:15 | Mark Mortimore, D. Britton Johnston | Regular Session (60 minutes) | DBA | Learn about the Database Consolidation Appliance |
| 08-11-2011 14:15 | Cihan Biyikoglu | Regular Session (60 minutes) | Developer | Building Large Scale Applications on SQL Azure |
| 08-11-2011 14:15 | Alberto Ferrari | Regular Session (60 minutes) | BI | Programming Patterns with BISM Tabular |
| 08-11-2011 15:45 | Chris Webb | Regular Session (60 minutes) | BI | Security in Analysis Services 2008R2 and BISM |
| 08-11-2011 15:45 | Raoul Illyes, Erling Skaale | Regular Session (60 minutes) | DBA | Make my day, Distributed Replay |
| 08-11-2011 15:45 | Lubor Kollar | Regular Session (60 minutes) | Developer | Performance and Scalability improvements in SQL Server Denali engine |
| 08-11-2011 17:00 | Simon Lidberg | Regular Session (60 minutes) | BI | Planning and forecasting with SQL Server, Excel 2010 and SharePoint 2010 |
| 08-11-2011 17:00 | Aaron Bertrand | Regular Session (60 minutes) | Developer | T-SQL : Bad Habits to Kick |
| 08-11-2011 17:00 | Thomas Grohser | Regular Session (60 minutes) | DBA | How to establish a Service Level Agreement (SLA) |
| 09-11-2011 09:00 | Thomas Ivarsson | Regular Session (60 minutes) | BI | Top five features in Crescent, Microsoft's new Denali Reporting Tool |
| 09-11-2011 09:00 | Bjorn Eriksen | Regular Session (60 minutes) | Developer | Database Development with SQL Server Developer Tools Code-Named “Project Juneau |
| 09-11-2011 09:00 | Mark S. Rasmussen | Regular Session (60 minutes) | DBA | Knowing the Internals, Who Needs SQL Server Anyway? |
| 09-11-2011 10:15 | Itzik Ben-Gan | Regular Session (60 minutes) | Developer | T-SQL Window Functions in SQL Server Denali |
| 09-11-2011 10:15 | Marcel Franke, Alexei Khalyako | Regular Session (60 minutes) | BI | Designing High Performance ETL for Data Warehouse, Best Practices and Approaches |
| 09-11-2011 10:15 | Jerome Halmans | Regular Session (60 minutes) | DBA | Using Correlated Tracing to Diagnose Query Level Performance |
| 09-11-2011 12:30 | Tobias Ternstrom | Regular Session (60 minutes) | Developer | What is New for T-SQL in SQL Server Code Name "Denali" & SQL Azure |
| 09-11-2011 12:45 | Regular Session (60 minutes) | DBA | ColumnStore Index in action | |
| 09-11-2011 12:45 | Peter Myers | Regular Session (60 minutes) | BI | Delivering KPIs with Analysis Services |
| 09-11-2011 13:45 | Roman Schindlauer | Regular Session (60 minutes) | Developer | Event-Driven Stream Processing with Microsoft StreamInsight |
| 09-11-2011 14:00 | Feodor Georgiev | Regular Session (60 minutes) | DBA | Database hidden disasters and planning against them |
| 09-11-2011 14:00 | Jen Stirrup | Regular Session (60 minutes) | BI | Data Visualisation: Are You Winning the Red Queen's Race? |
| 09-11-2011 15:15 | André Kamman | Regular Session (60 minutes) | DBA | RoboDBA |
| 09-11-2011 15:15 | Dave Ballantyne | Regular Session (60 minutes) | Developer | "Cursors are Evil" |
| 09-11-2011 15:15 | Benjamin Sigursteinsson | Regular Session (60 minutes) | BI | Slowly Changing Dimensions – Features vs. Performance |
Event Date: 08-11-2011 09:30 - Category: Keynote (75 minutes) - Track: General
Event Date: 08-11-2011 11:00 - Category: Regular Session (60 minutes) - Track: DBA
Event Date: 08-11-2011 11:00 - Category: Regular Session (60 minutes) - Track: BI
Event Date: 08-11-2011 11:00 - Category: Regular Session (60 minutes) - Track: Developer
Relational Division is the easiest way to pull out rows from a table which matches a subset of other rows. Even if you don't know it, you are actually using Relation Division every day. I'll prove it.
Event Date: 08-11-2011 13:00 - Category: Regular Session (60 minutes) - Track: DBA
In this session, I will take simple SQL statements, the stuff you write every day, and bump up the scale until things start breaking. I will attempt to answer questions like
Event Date: 08-11-2011 13:00 - Category: Regular Session (60 minutes) - Track: BI
Event Date: 08-11-2011 13:00 - Category: Regular Session (60 minutes) - Track: Developer
This session will answer questions like:
There are a short list of mistakes that, if you know of them in advance, will make your life much easier. These mistakes are the “low hanging fruit” of application design, development, and administration. Once you apply the lessons learned from this session, you’ll find yourself performing at a higher level of efficiency and effectiveness than before.
Event Date: 08-11-2011 14:15 - Category: Regular Session (60 minutes) - Track: DBA
Event Date: 08-11-2011 14:15 - Category: Regular Session (60 minutes) - Track: Developer
Event Date: 08-11-2011 14:15 - Category: Regular Session (60 minutes) - Track: BI
In this session the speaker is going to analyze some common data modeling scenarios, take a quick view at the Multidimensional implementation and then perform a deep dive into the Tabular/DAX solution of the same data model, paying attention to the main differences in the approach of the two methodologies. Using examples of various complexity, the goal is to show how to leverage the DAX programming language and the Tabular data model to solve common scenarios.
Event Date: 08-11-2011 15:45 - Category: Regular Session (60 minutes) - Track: BI
Event Date: 08-11-2011 15:45 - Category: Regular Session (60 minutes) - Track: DBA
Event Date: 08-11-2011 15:45 - Category: Regular Session (60 minutes) - Track: Developer
Event Date: 08-11-2011 17:00 - Category: Regular Session (60 minutes) - Track: BI
Event Date: 08-11-2011 17:00 - Category: Regular Session (60 minutes) - Track: Developer
Event Date: 08-11-2011 17:00 - Category: Regular Session (60 minutes) - Track: DBA
Learn how to define a real SLA, get a grip on what's possible and what is impossible to do and guarantee in a SLA. A Realistic SLA will protect you and your company from unpleasant surprises. See how including non SQL Server topics in the SLA will help you to negotiate more realistic terms
Event Date: 09-11-2011 09:00 - Category: Regular Session (60 minutes) - Track: BI
The first part will describe the role of Crescent in the Microsoft BI stack of reporting tools and compare it to Excel 2010, Reporting Services and Report Builder. Topics are supported data sources, Crescent and Sharepoint 2010 and Crescent's reporting language DAX.
The second part will demo the five most important features in Crescent like how to design the report, the abstraction of the data model, support for pictures and the possibility to show data changes over time in charts.
Finally a few shortcomings in the first release will be mentioned.
Event Date: 09-11-2011 09:00 - Category: Regular Session (60 minutes) - Track: Developer
Event Date: 09-11-2011 09:00 - Category: Regular Session (60 minutes) - Track: DBA
In this level 500 deep dive session we will go into the intimate details of the MDF file format. Think using DBCC Page is pushing it? Think again! As a learning experiment, I've created an open source parser for MDF files, called OrcaMDF. Using the OrcaMDF parser I'll go through the primary storage mechanisms, how to parse page headers, boot pages, internal system tables, data & index records, b-tree structures as well as the supporting IAM, GAM, SGAM & PFS pages.
Has your database suffered an unrecoverable disk corruption? This session might just be your way out! Using a corrupt & unattachable MDF file, I'll demo how to recover as much data as possible. This session is not for the faint of heart, there will be bytes!
Event Date: 09-11-2011 10:15 - Category: Regular Session (60 minutes) - Track: Developer
Event Date: 09-11-2011 10:15 - Category: Regular Session (60 minutes) - Track: BI
Achieving the right performance for Data Loads becomes a very crucial steps for the success of a Data Warehouse solution. This sessions gives an overview of design principles and best practices how to best load a Data Warehouse with SQL Server Integration Services in case of performance.
Event Date: 09-11-2011 10:15 - Category: Regular Session (60 minutes) - Track: DBA
This talk will focus on using the diagnostic capabilities of Extended Events, which provides visibility into the internal operations of SQL Server and how these capabilities can be combined with client traces to pinpoint the source of production issues.
Event Date: 09-11-2011 12:30 - Category: Regular Session (60 minutes) - Track: Developer
Event Date: 09-11-2011 12:45 - Category: Regular Session (60 minutes) - Track: DBA
Event Date: 09-11-2011 12:45 - Category: Regular Session (60 minutes) - Track: BI
Next, consideration will be given to where the KPI sources its target data from. The session will explore additional capabilities of the UDM to collect planning data, specifically by using cube write-back, and Data Mining to seed planning values.
Finally, the session will introduce how the Excel 2010 What-If Analysis feature can be used to support the collection of planning data from users.
Event Date: 09-11-2011 13:45 - Category: Regular Session (60 minutes) - Track: Developer
Event Date: 09-11-2011 14:00 - Category: Regular Session (60 minutes) - Track: DBA
While understanding your databases and knowing what to expect 3-5 years down the road may seem like a low priority and staggering effort, the concepts and techniques presented in this session aim at making it easier and more accessible to both seasoned DBAs and a broad range of IT professionals. By the end of this session the audience, regardless of its expertise, will have grasped the concepts of proactive disaster prevention concerning databases.
Event Date: 09-11-2011 14:00 - Category: Regular Session (60 minutes) - Track: BI
Demonstrations will be carried out using SQL Server 2008 R2. This presentation will assume a basic familiarity of Reporting Services. This session is aimed at Business Intelligence specialists with some familiarity with Reporting Services. Ultimately, it is intended for those who would like to produce effective reports by working smarter rather than harder. Come and learn how to win the Red Queen's Race by moving your reporting forwards, not running on the spot!
Event Date: 09-11-2011 15:15 - Category: Regular Session (60 minutes) - Track: DBA
I was a DBA for more than 400 instances.
•Did I do all that by myself? •Was the whole environment standardised ? •Did nothing ever go wrong? •Did I look through all the error logs on a daily basis by hand?
Of course the answer to all these questions is a big fat NO.
I'll explain how managing a large environment like this works, and I'll do it in such a way that even if you have 5 instances, this should still be useful.
Expect 50% processes and war stories and 50% scripts and demos (lots of PowerShell of course, but not everything)
Event Date: 09-11-2011 15:15 - Category: Regular Session (60 minutes) - Track: Developer
Thats frequent advice given on forums when asking about performance problems. Its correct advice, but how do you go about removing cursors and what do you replace them with ? Thats the tricky part!
By deconstructing a cursor based routine, Dave will demonstrate a number of TSQL techniques and how they can be applied to generate a new routine with significantly less overhead.
Event Date: 09-11-2011 15:15 - Category: Regular Session (60 minutes) - Track: BI