Sessions & Content

Search
Content Type
Conference
Tags
5+ Database Design Blunders and How to Avoid Them Karen Lopez
Karen discusses five (plus a few more) database design blunders with tips on how to avoid them. Audience members will also be able to contribute their war stories of design fails, WTHs and D'ohs.
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.
A heap of clusters Ami Levin
An in-depth dive into physical table structures
Analysis Services 2012 Tabular Mode Best Practices Itay Braun
In this session we'll understand the best practices of using this new technology. What exactly is it good for? When to use it and when NOT to? Migration, Security, Administration and other tips and tricks.
Awesome new T-SQL candy in SQL Server 2012 Mladen Prajdic
We'll focus on the awesome new SQL Server 2012 stuff that will make your T-SQL development a breeze. We'll look at new stuff like OFFSET, WINDOWING FUNCTIONS, SEQUENCES, ERROR HANDLING, FORMAT & CONVERT functions and METADATA DISCOVERY.
BI from space: PowerPivot with NASA data Mark Stacey
In this session, you will learn how to combine data from web services, tables and cubes to build a powerful model, and visualise it in Excel.
Big Data, Cloud, and other Marketing Buzzwords De-mystified Buck Woody
When your boss sends you to a conference, she expects you to learn something useful. Like all of the buzzwords she has to explain to her boss. Make it worth her while (and budget) and bring back the info she craves.
The video is not available to view online.
Building a BI Portal for Tabular Models Cathy Dumas
The Microsoft BI stack has a number of tools for data visualization - Excel, Power View, native Reporting Services, and Performance Point. Come see each visualization applied to the new tabular model in Analysis Services.
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
Business Intelligence with Excel 2010 Stephan Stoltze
Most of us use Excel in our Daily work, but are you familiar with the Business Intelligence features in Excel? In this session we'll look at some of the most common and useful BI features in Excel 2010 and discuss limitations and best practices.
Create a Data Model in BISM Tabular Marco Russo
In this session you will see how to create a BISM Tabular data model from scratch, providing the required metadata in order to improve user experience navigating the data model by using client tools like Excel PivotTable and Power View.
Deciding if Virtualization is a good choice for your servers Denny Cherry
We’ll be looking into the pros and cons of moving SQL Servers into a virtual server environment. Specifically we’ll be looking into when it’s a good idea and when it’s probably not a good idea.
Distributed Query Deep Dive Conor Cunningham
This talk will cover how the distributed query feature in SQL Server works, end-to-end. Topics include the query model, metadata, query optimization, execution, distributed transactions, and scale-out scenarios via Distributed Partitioned Views(DPV)
DW Design With The Product Team Conor Cunningham
This talk will explain the patterns that we recommend to customers when designing data warehouses. This talk will help people learning about DW for the first time and also give insight for those who wish to learn more.
Extended Events and the new Profiler in SQL Server 2012 Bob Beauchemin
Extended Events made its appearance in SQL Server 2008, but in SQL Server 2012, the number of lightweight events have been expanded. After a quick review of how Extended Events work, I’ll cover the enhancements in detail.
Extended Events-Not so tricky as you might think Jonathan Allen
A beginners guide to using Extended Events Sessions to monitor your servers.
Incremental Loading of Data using CDC in SQL Server 2012 Allan Mitchell
More data, less time, storing everything. These ingredients mean it is becoming imperative we do not move the kitchen sink everytime we do our ETL Come to this session to find out how.
Introduction to Microsoft Codename "Data Explorer" Miguel Llopis
Microsoft Codename "Data Explorer" provides a new way to organize, manage, enrich, share and gain new insights from your data.
The video is not available to view online.
Load Testing Analysis Services Bob Duffy
Ever deployed an Analysis Services cube that worked perfectly well with one user on the development server, only to find that it doesn’t meet the required volumes of user concurrency?
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
<<123>>