Sessions & Content

Search
Content Type
Conference
Tags
Slowly Changing Dimensions made Easy with Durable Keys Niall Langley
In this session we look at a simple way to implement Kimball durable keys on a SCD2 dimension. This provides an easy, performant, way to support reporting on data using historical and current hierarchies.
When and how to migrate to Azure Synapse? Kamil Nowinski
The session is for everyone who knows the data warehousing concept and wants to broad theirs horizons with modern capabilities of processing the data at scale.
Biml Tips and Tricks: Not just for SSIS packages! Cathrine Wilhelmsen
Biml is not just for generating SSIS packages! Come and see how you can use Biml to save time and speed up other Data Warehouse development tasks like T-SQL development, test data creation, and dimension population.
Different types of many-to-many relationships in Power BI Marco Russo
Clarify differences between many-to-many and weak relationships in Power BI
Disposable Dev environments with Azure DevOps and AzureRM Gavin Campbell
Using Azure DevOps and Azure RM templates to created isolated environments for testing PaaS solutions.
Learn how to build a real-time analytics solution José Mendes
In this session we will learn which processes are required to build a real-time analytical model along with batch-based workloads, which are the foundation of a Lambda architecture.
Profiling Your Data Angela Henry
What data profiling is & why you should do it.
SentryOne Tools for Productivity and Performance Andy Yun
This quick vendor session demonstrates the spectrum of SentryOne's best-of-breed products for the Microsoft Data Platform, from Task Factory, to Plan Explorer, to DOC xPress, to the SentryOne monitoring platform, and beyond.
Using Change Tracking to build a Live Data Warehouse Andrea Besozzi
How to build a Live Data Warehouse using Change Tracking capabilities
Advanced Techniques for Cleaning Data using SQL Server 2017 Jennifer Stirrup
If your organisation doesn't have dirty data, it's because you are not looking hard enough. Join this session to see what you can do to clean up your data properly, using SQL Server 2017.
Azure SQL Data Warehouse Optimizing and Maintaining Robin Lester
In this talk we will discuss best practices around how to design and maintain an Azure SQL Data Warehouse for best throughput and query performance.
Deep Dive into SSIS 2017 and Beyond Jimmy Wong
We will showcase the latest feature of SSIS 2017 such as connectors for Azure Data Lake Store (ADLS), Azure SQL Data Warehouse (SQL DW), SSIS Scale-Out at package level for the box product as well as the SSIS package execution on Azure Data Factory
DevOps, CI and the Data Warehouse Dr John Tunnicliffe
DevOps and continuous integration provide huge benefits to data warehouse development. John will be showing how you can use VSTS and Octopus Deploy to build, test and deploy your data warehouse
What is the Azure SQL Datawarehouse? Vitor Fava
In this session we will discuss about the Azure SQLDW and how we can use it to help on our day to day.
‘Out of the box’ advanced analytics & data warehousing Ian Macdonald
Pyramid Analytics BI Office’s Enterprise BI Platform and PrecisionPoint’s data warehousing solution for MS Dynamics ERP systems combine to deliver simplified access to key Business and Financial data.
Get Near Realtime ETL with Service Broker Allen White
Using SQL Server Service Broker you can create near real-time data in your data warehouse for more timely analysis and reporting.
Review ColumnStore Index in SQL 2016 and Azure SQL DB Sunil Agarwal
This session describes columnstore index internals with deep insight into data compression methodology for achieving high query performance including improvements in column store investments for SQL Server 2016 and Microsoft Azure SQL Database
Columnstore Indexes in SQL 2014: Flipping the DW Faster Bit Jimmy May
This presentation includes an overview of SQL Server 2012 & a deep dive into SQL Server 2014 columnstore indexes, including a review of the architecture, as well as the challenges, workarounds, travails, & big wins at customer sites
Designing a database to best support multidimensional OLAP Dr John Tunnicliffe
Data warehouse designers often ignore the specific needs of an OLAP database. In this session, John will outline the best ways to optimise your relational database to support your multidimensional OLAP cubes
Power BI as your Business Intelligence Proof of Concept Tool Adam Aspin
Learn how to use the Power BI tools to help you analyse, specify and test the concepts and requirements of your next data Warehouse project.
SQL Server Fast Track Data Warehouse: Understand the program Niall MacLeod
This presentation discusses the process undertaken to achieve the certification of a 90TB SanDisk solution (HP DL580 Gen8 and Fusion ioMemory) whilst achieving an efficient out-of-box balance between SQL Server data processing capability and hardware
Tools and Tips: From accidental to efficient DWH developer Cathrine Wilhelmsen
As data warehouse developers we deliver data to business users... but we don't deliver data as fast as we want. There are many things you can do to increase your own productivity and become a more efficient data warehouse developer.
Advanced Modeling with Analysis Services Tabular Alberto Ferrari
This session goes beyond the classical star schema modeling, exploring new techniques to model data with Power Pivot and SSAS Tabular. You will see how brute-force power in DAX allows different data models than those used in SSAS Multidimensional
Is your data big enough for a PDW? Mark Stacey
You have tuned your SQL server to it's limits, you have maxed the RAM on your server, and still your data warehouse is too slow. Is a Parallel Data Warehouse the next step?
Making the ODS the Centre of Your Data Strategy Attunity
Big Data has triggered the need for organisations to build real-time Operational Data Store (ODS) layers to feed the ‘Data Lake’ on Hadoop. Attend this lunchtime session to learn why a real-time ODS should be at the heart of your data architecture
T4 Templating within SSDT using SQL Server 2014 Geoff Clark
T4 templating will be a first class citizen in SSDT for SQL Server 2014. This session will show why you should use this technology for SQL code generation and how you can automate the process. The session will be demo rich.
Modern Data Warehousing Strategy Marco Russo
This session will discuss what a modern strategy for data warehousing can be in this era, considering how the use of technologies like PowerPivot or Analysis Services Tabular affect the way you should model your data.
A Deep Dive in SQL Server 2012 Data Warehousing Dejan Sarka
In this session, we are going to explain and test different DW features in SQL Server 2012, including star join optimization through bitmap filters, table partitioning, window functions, columnstore indices and more.
BigData vs. Data Warehousing Thomas Kejser
: We are looking at the dawn of a new workload: BigData. In this session I will talk about what BigData is, and which BigData technologies Microsoft are working on.
Building an infrastructure to support real-time OLAP Dr John Tunnicliffe
Users love flexible analytics but hate to wait for the data to be loaded into a traditional data warehouse. John will describe how to build an infrastructure to support real-time loading of your OLAP cubes so your user's get exactly what they want
FastTrack 101: How it makes your data analysis faster Felipe Ferreira
SQL Server FastTrack References Architecture gives you the best practices and reference architectures from different hardware vendors to help you create a balanced environment for your data warehouse workload.
Loading Data Warehouse Dimensions in SSIS Alex Whittles
This session looks at some of the different methods available to load slowly changing dimension data into a data warehouse, and compares the relative performance given different data scenarios and traditional storage compared with FusionIO
Saturday Keynote: Inside SQL Server 2012’s ColumnStore Index Conor Cunningham
This talk will describe how the new ColumnStore index technology in SQL Server 2012 makes queries go faster. Covering details of the storage and execution model, how this model interacts with modern CPUs to deliver significant performance benefits.
So How Does BI Workload Impact the Database Engine? Part I Stacia Varga
In this first of two sessions, we review the architecture of SQL Server and its BI components and deployment options for optimal performance. We'll also discuss how to optimize data warehouse load operations.
Temporal Snapshot Fact Table Davide Mauri
Snapshots without snapshots...is that possible? Take a "Classic" snapshot fact table, add some temporal data theory and you'll get a new fact table than can store snapshot data without doing snapshots. A life saver when you have a lot of data.
Turbocharge your DW Queries with Columnstore Indexes Susan Price
Do you have data warehouse queries that run too long? In this session we’ll address how columnstore indexes speed up queries, best practices for creating and using columnstore indexes, and how to diagnose and treat potential issues.
Data Replication Redefined - best practices for replicating data to SQL Server Attunity
This session will provide expert advice & best practices for replicating Oracle (& other) data to SQL Server for data warehousing & BI initiatives. Also, become one of the first to see Attunity’s innovative new software in its historic unveiling!
Deep Dive - HP EDW, Massive Scale, Low Cost Steve Tramack
Organizations risk being overwhelmed by data. How can you effectively provide a “single version of the truth”, while unlocking the key trends and insights that will allow your business to succeed? Come to this session to find out how.
Handling Advanced Data Warehouse Scenarios in SSIS John Welch
Do you have complex dimensions in your data warehouse? Parent-child, late arriving, type 3 or type 6? In this session, we'll cover some SSIS patterns for handling each of these, along with tips for making them perform well.
Implementing Real-Time Data Warehouse Sutha Thiru
Steps involved in implementing a near-real-time data warehousing solution.
Master Data Services in SQL Server Denali Jeremy Kashel
Master Data Services has been given an overhaul in Denali, including a new Excel add-in and modified web front-end. Come to this session to see how MDS can be used to give greater control and process to your BI/DW dimension management.
The Art of War-Fast Track Data Warehouse & Fragmentation James Rowland-Jones
When loading a Fast Track Data Warehouse it is important to ensure that your data is optimally laid out for Sequential I/O. Fragmentation is therefore the enemy. Know your enemy. Learn what it is, how it occurs and prevent it from happening to you!
Vertipaq vs OLAP: Change Your Data Modeling Approach Marco Russo
In this session we will introduce the new modeling capabilities of Vertipaq, showing how the same scenarios can be modeled in both Multidimensional (MOLAP) and Tabular (Vertipaq), looking at how to enable your data warehouse to support both.
Advanced Dimensional Modelling Vincent Rainardi
Many of us know what dimensions and fact tables are. But dimensional modelling is more than just dimensions and fact tables. This session is about advanced dimensional modelling topics, which are useful for anybody involved in the design of a DW.
BI Development using SQL Developer Tools Red Gate
In this session Noemi Moreno, BI Developer and Tom Austin, SQL Tools representative, will show you how to use SQL Developer tools to simplify and enhance your Business Intelligence application.
Data Vault, An introduction to the new datawarehouse supermodel Martijn Evers
A new and fresh approach to datwarehousing that is agile, performant and easy to do. Data Vault is a new methodology that tries to overcome traditional problems that plagued traditional datawarehousing in the past.
Introduction to SQL Server 2008 R2 Parallel Data Warehouse Richard Tkachuk
This session provides an overview of the new Data Warehousing capabilities in SQL Server 2008 R2 Parallel Data Warehouse Edition
Relational Modeling for Extreme DW scale Thomas Kejser
This session is taken from lessons learned in the field on being able to scale data models to handle multi-terabytes of data. Come to this session and understand the difficulties before you encounter them.
Panel Discussion with the SQLCAT Team SQLCAT Team
An open forum panel discussion with members of the SQL Customer Advisory team.
Fast Track Foundations: Get Serious about Sequential I/O James Rowland-Jones
Fast Track is a new reference data warehousing architecture provided by Microsoft. More than this it represents a new way of thinking about data warehousing. A Fast Track system is measured by its raw compute power - not by a DBAs ability to tune an index. Fast Track is an appliance-like solution that delivers phenomenal performance from a pre-defined, balanced configuration of CPU, memory and storage using nothing but commodity hardware. Of particular interest in a Fast Track system is the way in which the storage and SQL Server are configured. To achieve the fantastic throughput without using SSDs requires some careful configuration. This configuration is designed to make use of Sequential I/O to dramatically improve disk I/O performance. Interested? If you have a large data warehouse that's seen better days or perhaps you are about to embark on a new warehousing project then you should be! Fast Track is a great solution with a fantastic value proposition. In this one hour session we'll aim to get under the skin of Fast Track and get some answers as to how it delivers such great throughput on commodity hardware. In the process we'll aim to answer the following questions: * When might I need Fast Track? * What is Sequential I/O? * How does Sequential I/O improve performance? * What do I need to do to get Sequential I/O? * How can I monitor for Sequential I/O ? * What may I need to change in my ETL to get the benefit of sequential I/O? Still reading? I'll save you a front row seat....
<<12>>