It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

Sessions & Content

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

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

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.

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.

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.

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.

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.

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

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.

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.

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?

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.

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.

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 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.

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.

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!

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

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.

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.

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.

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.

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 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.

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

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.

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.

In this deep(!) dive session. I will walk you through the internal storage format of MDF files. I'll cover how SQL Server stores its own internal metadata, how it knows where to find your data, and how to read it once found.

The Column Store Index is an
exciting new technology in SQL Server 2012. Using column stores, you can
unlock new levels of performance for data warehouses – often gaining an order
of magnitude speedup on queries.

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.

In this presentation, we provide an introduction to SQL Azure Federations and also show
some interesting patterns that provide additional capabilities such as
scale-out query processing, cross-shard schema management and multi-key sharding.

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.

In this session, Noemi and Tom explain how they developed a system to import information from Twitter into a SQL Server data warehouse, and to export their analysis into Google Docs using Red Gate tools to help them on their way.

The addition of spatial data to SQL Server 2008 is one of the most important in terms of integration in line-of-business applications. This talk will discuss the new features and performance enhancements in SQL Server 2012.

Data is the most important asset in every business. SQL 2012 introduces the new innovative Knowledge Driven Data Quality Services that allows IT and Data Users to define and use Knowledge effectively for data cleansing and validation.