Sessions & Content

Search
Content Type
Conference
Tags
(Way Too Much) Fun with Reporting Services Stacia Varga
Come spend a session with us while we play games with Reporting Services…literally! Come watch Stacia Misner and Erika Bakse push the limits with what can be built in SSRS.
The video is not available to view online.
2 AM-A Disaster just began... Tobiasz Janusz Koprowski
It's 2AM and Disaster just began... In this session I want to discuss about best practices for surviving disaster, based on my experience in few years in data center. I presented this session as Lightning Talks in Liverpool. Now is the time for full
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 better SSIS? Migrating a datawarehouse to SQL Server 2012 Andre Kamman
SSIS in SQL Server 2012 has a lot of new features to help control larger projects. I'm doing a trial migration of our datawarehouse (100+ packages, 1TB+ db size) This session will be a will be a walkthrough of this process and a lessons learned
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
A lap around the SSIS Catalog Jamie Thomson
SQL Server Integration Services (SSIS) 2012 includes a new database referred to as the SSIS Catalog. Come to this session to learn what it does and how its going to change how you do SSIS development.
A Preview of High Availability in SQL Server 2012 Allan Hirt
Mission critical is a major focus of SQL Server 2012. There are quite a few changes in this release to ensure that you maximize your uptime and reliability when it comes to SQL Server. This session will start preparing you for what is coming.
Accelerating BI Projects with Varigence Varigence
Learn how Varigence tools accelerate BI development, enhance reusability, and improve agility through the use of customizable patterns and automation scripts and transform your metadata into comprehensive BI solutions.
Advanced Security with Analysis Services Multidimensional Chris Webb
This session will cover advanced security topics in the Analysis Services Multidimensional model.
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.
Architectural Patterns and practices SQL Azure Ewan Fairweather
As a shared database infrastructure in the cloud, SQL Azure provides the opportunity for creating large workloads in a scalable and reliable environment.
The video is not available to view online.
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.
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 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 & Data Visualisation: SQL Server 2012 Jennifer Stirrup
Business Intelligence and Data Visualisation features and functionality are key to the strategic and technical changes in SQL Server 2012.
The video is not available to view online.
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.
Compression - Define your Strategy Neil Hambly
The Enterprise only feature "Compression" can make a HUGE difference to your storage requirements and we will examine this feature in detail, integrate this into your strategies, finding objects which your should use this one
The video is not available to view online.
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.
Declarative Database Development with SSDT Gert Drapers
Declare how you want your schema to look like, not how you want to implement it. Using the SQL Server Data Tools, you define your database schema in a declarative form and deploy it as such!
Deep Dive on Database Private Cloud Britt Johnston
Come see what a Database Private Cloud is all about. If you have many SQL Server instances already or need to grow use of on-premises SQL Server and other demanding workloads you may need a database private cloud.
The video is not available to view online.
Designing a Private Cloud Infrastructure for SQL Server Ross Mistry
Do you want to learn how Microsoft helped one of the largest Financial Services organizations in the world design a Private Cloud infrastructure using Windows Hyper-V and System Center 2012 to standardize and consolidate hundreds of SQL Servers?
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.
Enter the Dragon: SQL 2012 on Server Core Mark Broadbent
In this session we shall demonstrate configuration, installation and administration of SQL Server 2012 on Server 2008R2 Core. We shall discuss Command line and PowerShell configuration, Installation of SQL, Remote Administration and Clustering.
Everything You Wanted to Know about ProClarity’s RoadMap... Pyramid Analytics
But were afraid to ask. Pyramid Analytics burst onto the Microsoft BI scene with not only a full roadmap for ProClarity users, but also with cube driven dashboards that offer rich functionality – yet are easy to design and deploy by business users.
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.
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.
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.
IT Horror Stories: Tales of the Weird, Grotesque & Deformed Quest
Join Quest Software’s Kevin Kline as he takes you on a guided tour of some of the worst and most horrible IT experiences. Some of them were intentional and some were accidental, but all of them will make you wince. Most are great for a laugh!
Lego Sets: Relational Building Blocks Rob Volk
Introductory Relational Theory Using Lego Bricks to Model Data and Set Operations
Lightning Talks Various Speakers
A chance for speakers new and seasoned to take the stage for 5 minutes and effuse about something/anything in SQL Server they love.
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
Luke I’m your father - Hierarchies in SQL Server Markus Ehrenmüller-Jensen
Hierarchies are the bread and butter of most business applications (departmental diagram, product categories, sales territories, calendar, …). See typical business problems and how they are solved in SQL Server.
Maximizing hardware utilization for performance & lower TCO R Meyyappan
In this session we will discuss ways to maximize existing hardware utilization to speed up queries. We will analyze cases of performance issue and tune them for better CPU, Storage and Memory utilization resulting in higher performance and lower TCO.
The video is not available to view online.
Memory Management for Analysis Services with SQL Sentry SentryOne
Learn how to monitor Analysis Services with SQL Sentry Performance Advisor. Get tips on best practices, monitoring counters and options plus improve your understanding of how Analysis Services uses memory and where it differs from SQL Server.
Native File Streaming with SQL Server 2012 Leonard Lobel
This dynamic session will teach you how to use FILESTREAM and FileTable using T-SQL and the OpenSqlFileStream API. We’ll also cover the hierarchyid data type, full-text search improvements and the new Statistical Semantic Search.
Performance investigations with Analysis Services 2012 Akshai Mirchandani
This session will do a brief overview of Analysis Services 2012 performance topics, and drill into some common methods for investigating performance issues. The talk will be adjusted based on the audience interests.
Perk up your performance! X-IO Storage
Join X-IO to learn how customers like Redknee and Temenos are combining SQL Server 2012 with X-IO intelligent storage to generate higher performance at significantly less cost. Learn why storage is on the verge of a revolution.
Presenting Like Jagger Buck Woody
Presenting your ideas is essential – from a simple team meeting to a hall of thousands of listeners, it’s vital that you have this skill. But how do you make your presentations effective, useful and interesting for everyone.
Query Plan Operators Deep Dive David Morrison
In this session we will deep an in-depth look at some of the most common query plan operators. We'll look at what they do, how they do it and the circumstances in which they are chosen. We'll also take a look into the ups and downs of each
Query Tuning Mastery: The Art of Manhandling Parallelism Adam Machanic
Are your big queries using every available clock tick, or are they lagging behind? And if your queries are already going parallel, can they be rewritten for even greater speed? In this session you will learn how to take full advantage of parallelism.
Query Tuning Mastery: Workspace Memory Internals Adam Machanic
Large, complex queries need memory in which to work--workspace memory--and understanding the how's, when's, and why's of this memory can help you create queries that run in seconds rather than minutes.
<<12>>