Sessions & Content

Tags
Content Type
Search
Conference
2 AM-A Disaster just began...
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 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
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
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
An in-depth dive into physical table structures
A lap around the SSIS Catalog
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
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
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
This session will cover advanced security topics in the Analysis Services Multidimensional model.
Analysis Services 2012 Tabular Mode Best Practices
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
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
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.
BigData vs. Data Warehousing
: 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
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
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
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
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
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
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!
Designing a Private Cloud Infrastructure for SQL Server
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?
<<1234>>