Sessions & Content

Search
Content Type
Conference
Tags
Advanced SQL Server 2008 Troubleshooting Klaus Aschenbrenner
It's Friday, 05:00pm. You are just receiving an email that informs you that your SQL Server has enormous performance problems! What can you do? How can you identify the problem and resolve it fast?
Advanced SSRS. Find out what you have been missing Emil Glownia
Would you like to see examples of advanced SSRS reports that you do not see every day and which are not very easy to build (if you don’t know how) but are very useful for business users?
Around the world (of query plan operators) in 50 minutes David Morrison
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
The video is not available to view online.
Basic BISM Chris Webb
This session explains what the BI Semantic Model in SQL Server Denali is, how it is related to Analysis Services, and provides a brief introduction to the new Tabular model.
Building Great Models for Crescent Kasper de Jonge
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.
Creating a Meta Data Driven SSIS Solution with Biml Marco Schreuder
In this session you'll get a good introduction of the concepts and advantages of Biml as we walk to the creation of Meta Data Driven SSIS Solution.
Data Quality Services-Making Data Suitable for Business Allan Mitchell
Data Quality Services is a new product coming in the SQL Server Denali release of Microsoft SQL Server. Come to this session to understand how it can take your data cleansing to the next level.
Database unit testing with visual studio 2010 Anthony Brown
This session will cover why you should run database unit tests (and when you should not). It will show how to set them up and run them in visual studio 2010
Deep Dive - HP EDW, Massive Scale, Low Cost Steve Tramack
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.
Designing an SSIS Framework Andy Leonard
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.
Gather SQL Server Performance Data with PowerShell Allen White
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.
Handling Advanced Data Warehouse Scenarios in SSIS John Welch
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.
Hey PowerShell Eventing, can you notify me ? Laerte Junior
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 ?
Implementing Real-Time Data Warehouse Sutha Thiru
Steps involved in implementing a near-real-time data warehousing solution.
Inside Ola Hallengrens Maintenance Solution Ola Hallengren
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.
Keynote - Appliance Roadmap Steve Tramack
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
Knowing the Internals, Who Needs SQL Server Anyway? Mark S. Rasmussen
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.
Let Service Broker Help You Scale Your Application Allen White
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.
LogParser-quicker than SSIS, easier than BCP Jonathan Allen
LogParser is a free data application that anyone working with SQL Server should know about, come along and see how you could use it.
Many-to-Many Relationships in DAX Alberto Ferrari
Deep dive into the handling of many to many relationships in DAX. How to make them work and how to optimize their speed thorugh many patterns and live examples of M2M usage.
<<123>>