Sessions & Content

Tags
Content Type
Search
Conference
Advanced Data Visualisation in Reporting Services 2012
Come to this session to pick up some tips and tricks for advanced reporting writing, that is also in accordance with thinking by Data Visualisation gurus such as Stephen Few and Edward Tufte.
Advanced SQL Server 2012 HA and DR Architectures
In this session I'll cover advanced HA and DR architectures for SQL Server 2012 that also enable you to scale-out certain workloads.
Always ON Overview & Field Experience
The introduction of Availability Groups in SQL Server 2012 and the flexibility this gives administrators is truly awesome. In these session we will cover what Availability Groups bring to the table
An introduction to the wonderful world of OData
Join me as I guide you through the architecture and capabilities of the OData protocol. Data has been locked inside applications for too long, allow me to show you how to implement OData and open up the data silos inside your company today!
Analysis Services for the DBA
Mark will explain the use cases for Analysis Services, illustrate how it improves performance for large data sets and eases report writing, and will go through a practical example of building a first Analysis Services solution
Cleaning Up Dirty Data with SSIS
In this session, we'll review methods for cleaning up dirty data using SQL Server Integration Services. We will review the various cleansing tools accessible from within SSIS including native components, T-SQL, SSIS scripting, and DQS.
Data loading at warp speeds
Do you struggle to reduce those frustrating long hours it takes to load data? Are your time windows for loading becoming too short for comfort? If so – you simply can’t afford to miss this session…
Data Modeling for Analysis Services Cubes
In this session we’ll look at a number of different data scenarios and explore ways of remodelling the data to optimise it for cubes and MDX. Sometimes a small ETL change can have a dramatic impact on the cube's functionality and simplicity.
Database Design: Size Does Matter!
Great database performance starts with great database design. During the design process it is important to select your SQL Server datatypes wisely. Failure to do so will result in wasted disk space, additional I/O overhead, and decreased performance.
DAX Query Engine Internals
In this session, we will analyze the way DAX solves filtering. Starting from simple queries, we will follow the steps DAX does with the filter context, discovering the internals of the query engine of DAX.
DAXMD: SSAS Multidimensional meets DAX and Power View
This session looks at the most significant new functionality to be added to SSAS Multidimensional in recent years: support for the DAX language and Power View.
Dynamic MSBI content generation
In the ideal world, all information and structures are static, but in the real world almost everything is dynamic, and changes are constant. This session reviews different methods for generating MSBI content (SSIS, SSRS) dynamically.
Enabling Flash to Support Mission-Critical Applications
In this session we will discuss how using flash with intelligent caching can allow an economical mix of flash and HDDs to be used to provide huge performance gains
Estimation, Statistics and “Oh My!”
At the heart of SQL Server is the cost based optimizer. This is driven by estimates and they in turn are driven by statistics. This will be a deep dive into how the optimizer makes its decisions to give you a plan, the things that can go wrong.
ETL shootout-SSIS vs Powershell
I know what you're thinking, Powershell is not an ETL tool. And you're probably right. But I keep running into weird requests that were just easier to fix with Powershell. I'll show you why some things are not easy in SSIS.
ETL with Hadoop and MapReduce
Big Data is hot! And the magic word is Hadoop. But what is it? And more important: what can I do with it? In this session we will cover some basics of Hadoop, MapReduce, Pig and Hive.
Everything you always wanted to know about MERGE
In this demo-rich session, Hugo Kornelis shows how the full syntax of MERGE enables more than just synchronizing data. You'll get an overview of all the available options, plus a few surprising pitfalls you may not be aware of.
Excel 2013 - Whats new beside PowerPivot and Power View?
You probably already heard a lot of the wonders of PowerPivot and Power View, but will you have any other cool new BI features with Excel 2013. The answer is a big YES! This session will demo a lot of those.
Excel 2013 Analytics
Excel is “The” analytical tool in Microsoft suite for advanced analysts. This session introduces Excel 2013 and 2010 business intelligence capabilities.
From SQL Traces to Extended Events. The next big switch
This session will give you insight into both of the current tracing technologies in SQL Server. Old SQL Trace has served us well but new times call for new technology. The new Extended Events are a new lightweight tracing mechanism built into SQLOS.
<<1234>>