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.

This session will take a look at query plan operators, what they are, what they each do, why they get chosen and also how to avoid using them when they perform badly. This will be held mainly in management studio with lots of examples

This session will drill into some of the details on the shipping HP BDA and BDW appliances and how they can work well together to deliver a comprehensive BI and DW solution for customers using the Microsoft Application Platform.

SQL Server Code Name Denali Reporting Services will include Project Crescent for visualizing, interacting with and presenting data. Project Crescent. Come to this session to see how to make the most of this new tool.

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!

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.

In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging.

Tuning disk subsystems for optimal SQL Server performance is typically the domain of very experienced, enterprise DBAs. This session will short-cut you past years of hard-won experience straight to the essentials of IO tuning for SQL Server.

It's important to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. This session will show you how to use PowerShell to gather your baseline and how to report it.

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.

How many times have you needed to automate a restore process Asynchronous to N databases and be notified when each finalized? ...Or the SQL Server service stopped in your Server X and a notification in W task bar showing immediately what happened ?

How do you do database maintenance in an enterprise environment? In this session I will go through how you can do backup, integrity check, index and statistics maintenance using Ola Hallengren's Maintenance Solution.

The Apple iPad's cutting edge usability, along with PowerPivot’s accessibility, can be combined to enhance productivity for mobile business users. Come to this session, and learn about mobilising BI for the iPad generation of end users.

This keynote will provide deeper insight into the currently available appliances (Business Decision Appliance, Business Data Warehouse, Enterprise Data Warehouse) and solution blocks (Database Consolidation Solution), as well as looking to the future

Based on my experience in creating OrcaMDF, an open source MDF file parser, I'll go through the primary storage structures, how to parse pages, headers, internal base tables, b-tree structures as well as the supporting IAM, GAM, SGAM and PFS pages.

Service Broker was introduced in SQL Server 2005 to provide asyncronous messaging in your database applications. In this session we'll walk you through the basics of Service Broker and show how you can use it to build highly scalable applications.

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.

This talk looks at MDX and DAX, examining their similarities and differences. It won’t turn you into an expert in either but it will help you to decide, given your particular career plans, if either or both are worth learning.

This exciting session will be delivered by PowerShell expert James Boother and Clustering expert Mark Broadbent where we will demonstrate how to use PowerShell to perform SQL Failover Cluster administration and automate simple and complex operations.

How to get started with PowerPivot and QlikView. Covering how to combine data sources, common pitfalls, adding some calculation logic and building a basic dashboard.
We’ll walk through the same example on both systems and compare the results.

Sooner or later some sort of disaster occur on your SQL Server instance. It might be the destruction of a server, the corruption of a page inside the database, or just the unexpected deletion of some data. When disaster does strike, will you be prepa

In this session Aaron Bertrand and Steve Wright of SQL Sentry, will illustrate how SQL Sentry provides unparalleled insight, awareness and control over the true source of performance issues in SQL Server.

I'll explain how to manage a large environment of 400+ instances in such a way that it's also useful if you have only 5 instances. Expect 50% processes and war stories and 50% demos and scripts (lots of PowerShell of course, but not everything)

The leaders from every SQL user group across England, Scotland & Wales have got together and created the definitive dictionary of essential SQL know-how, and crammed all of this into a single fast paced romp through the SQL alphabet.

With a myriad of options available, choosing the most appropriate storage solution for your company can be challenging. This session will give you a brief introduction to the technologies available, and what to focus on when making the decision.

So your customer's dot.net application is ready to ship and it is dog slow. This session focuses on the tools and methology that SQL consultants use to test and improve performance with dot.net applications.

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!

Well, I'm a DBA and one of my duties is to check that all SQL Server stuff are in the right place. It's a routine job, but, probably, the most important duty as DBA because it can help me to predict many important problems.