Sessions & Content

Search
Content Type
Conference
Tags
10 Do's and 10 Dont's for the SQL Server CLR Matt Whitfield
A guide to the things that you should be doing if you use the CLR, as well as those that you shouldn't. Find out what you need to be aware of, with a cause-and-effect approach.
The video is not available to view online.
28 Weeks later - How to scale-out your MS Business Intelligence environment Sascha Lorenz
The SQL Server provides much functionality that increases the scalability and flexibility of your solution by distributing data and jobs among low-priced commodity servers.
Advanced Dimensional Modelling Vincent Rainardi
Many of us know what dimensions and fact tables are. But dimensional modelling is more than just dimensions and fact tables. This session is about advanced dimensional modelling topics, which are useful for anybody involved in the design of a DW.
Analysis Services Advanced Best Practices Marco Russo
This dense hour of presentation will cover design techniques to leverage cube features that also consider possible maintenance of the database structure over time.
Automating SSAS cube documentation using SSRS, DMV and Spatial Data Alex Whittles
This session will show how to use DMVs (data management views) to query the OLAP cube structure, and then use SSRS to create a set of interactive reports including the BUS matrix, and using spatial data to generate automated star schemas.
Back From the Dead: How to Restore a SQL Server in 60 Minutes or Less Brad McGehee
In this session, I will demonstrate, step-by-step, the entire process of restoring all of the system and user databases from a damaged instance to a new instance.
Back to the SSIS Future Jamie Thomson
A look at the new SSIS features in SQL Server code-named Denali
BI Development using SQL Developer Tools Red Gate
In this session Noemi Moreno, BI Developer and Tom Austin, SQL Tools representative, will show you how to use SQL Developer tools to simplify and enhance your Business Intelligence application.
BISM Introduction Marco Russo
Introduce the features of BISM (BI Semantic Model), the new engine that will be available in Analysis Services "Denali".
Building a dynamic OLAP environment Dr John Tunnicliffe
This session will present the tools and techniques used to create OLAP cubes and supporting data marts on-the-fly from a mere set of data files and configuration metadata.
Business Rules and SharePoint Workflow with Master Data Services Jeremy Kashel
This session will be an in-depth look at what the MDS business rules are and how they work, including a series of demos and guidance on how the rules are built. SharePoint Workflow will also be covered, as MDS can initiate a SharePoint workflow.
Change Data Capture for real-time BI Attunity
Attunity's Ian Archibald will discuss how CDC solutions can solve problems in BI and ETL/DW projects, co-hosted with two of the industry’s highly-respected SQL Server gurus BI expert Jennifer Stirrup and ETL expert and SQL Server MVP Allan Mitchell
Common mistakes developer make in SQL Server Peter Larsson
All developers and DBAs make mistakes when programming in SQL Server. Learn to avoid the most common mistakes.
The video is not available to view online.
Consolidation and Virtualization Strategies-Microsoft Technology Center Ross Mistry
This session will teach you how to successfully plan, implement and manage SQL Server consolidation and virtualization within your organization
Data Modelling for a flexible cube Jessica Stevens-Taylor
Learn how to leverage the data model to create flexible behaviour in a cube without the overhead of calculated members
Data Vault, An introduction to the new datawarehouse supermodel Martijn Evers
A new and fresh approach to datwarehousing that is agile, performant and easy to do. Data Vault is a new methodology that tries to overcome traditional problems that plagued traditional datawarehousing in the past.
Data Visualisation using SSRS: Euclid's Royal Road to the numbers Jennifer Stirrup
Using technical demonstrations in Microsoft SQL Server Reporting Services, this presentation will focus on the practical implementation of data visualisation, along with cognitive science principles supporting data visualisations.
Database Testing-Minimizing "If it can break, it will." Mladen Prajdic
A look into the world of database testing, how to go about it, why do we really need it and how to work well with your peers and managers for greater project success.
DBAs vs Developers-The FINAL SHOWDOWN Phil Winstanley
We all know how much love DBA's have for Developers and visa versa. You can measure it in milligrams. This fun session discusses the issues we have with one another and presents some solutions to save knives in backs and blood stained carpets.
Disruptive Storage Fusion-io
Fusion-io's Mat Young will look at how radical change is often achieved through distillation and simplicity of design in conjunction with passionate people and great software.
Executing SSIS Packages Peter Doyle
Executing SSIS Packages and handling the errors
Fun with Scoped Assignments in MDX Chris Webb
This session will introduce the concept of scoped assignments in MDX and show how they can be used to solve various calculation problems.
Geting data from here to there using replication Anthony Brown
This will show the replication options available in sql server and in which situations each type can be used. I will also show how to set it up and some diagnostic techniques for when it doesnt work
Google Maps? Build your own Mapping, Geocoding, and Routing service Alastair Aitchison
SQL Server spatial features have not yet made it into mainstream usage and many developers still ask "But *why* would I use them?". In this session, I hope to answer that question by replicating the functionality of Google Maps using only SQL Server.
High Scale OLTP - LL From SQLCAT Performance Labs Ewan Fairweather
In this session, I will talk about the lessons we have learned and the methodology we follow when diagnosing and resolving issues with real customer workloads running on 64 and 128 logical cores
How DBAs can use PowerPivot for Performance Tuning / Troubleshooting Andre Kamman
PowerPivot can be a great troubleshooting / performance tuning tool for a dba besides just loading all the data in a database and start querying. I'll show the pro's and cons of PowerPivot while trying work with waitstats, profiler data etc.
Introduction to Powershell James Boother
Back (hopefully) by popular demand I'll be sharing the secrets to getting started with Powershell in a SQL Server Environment.
Introduction to SQL Server 2008 R2 Parallel Data Warehouse Richard Tkachuk
This session provides an overview of the new Data Warehousing capabilities in SQL Server 2008 R2 Parallel Data Warehouse Edition
Investigating parallelism and the CXPACKET wait type Christian Bolton
In this session you'll learn how SQL Server chooses parallel operations, how to investigate what's going on when you see the CXPACKET wait type, and whether your parallel query is running as efficiently as it could be.
Keynote SQLCAT Team
Mark Souza (General Manager in the SQL Server product team) will spend an hour of presentation and discussion of Microsoft's next generation database platform followed by a discussion on cloud technology.
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.
LINQ for DBAs and SQL Developers Atul Thakor
An introduction to LINQ covering what it is, why people choose to use it, and how you can help your developers when troubleshooting and performance tuning as you previously did through stored procedures.
Microsoft BI-More than Just SQL Jess Meats
A look at the Microsoft Business Intelligence stack and how other products can enhance a SQL BI project.
Mixing virtualisation with SQL Server - a checklist for success Gavin Payne
Here I share a checklist I created from my experience and theory designed to make sure we’re ready to put our business critical SQL Servers on a virtualised platform and are prepared for the next time we get a database performance issue.
The video is not available to view online.
Monitoring SQL Server Central’s Server Performance Red Gate
Brad McGehee, Red Gate's Director of DBA Education, will share his experience of monitoring SQLServerCentral's DB performance what he found, how he did it using SQL Monitor, and how they were fixed. Following that Brian Harris will demo SQL Monitor.
The video is not available to view online.
Multi-Site Failover Cluster With SQL 2008 and Denali Allan Hirt
Planning a failover clustering implementation in a single data center is fairly straightforward, but what happens when you want to span data centers? Come and find out how to plan a multi-site failover cluster.
Notes from the field: Cross-team Performance Troubleshooting Justin Langford
This session will be presented jointly by Justin Langford and Gavin Payne . The focus of the session is the approach to a cross-team Performance Troubleshooting engagement where multiple stakeholders were involved.
Parallel Plans Lubor Kollar
The talk will go back to SQL Server 7.0 when we have introduced “parallel query” in SQL Server for the first time. Lubor will share our initial “parallelism” challenges and how this feature has been developing through the subsequent releases
Parameter Sniffing Problem with Stored Procedures Milos Radivojevic
In this presentation it will be clarified when and why parameter sniffing is a problem in SQL Server stored procedures. Of course we will offer several solutions for this problem and discuss which solution is applicable in which scenario.
Performance Tuning Large Analysis Services Cubes Duncan Sutcliffe
Cube tuning is a key part of any BI project and it gets more so as cubes get bigger. Here are a series of tuning procedures to follow for cubes large and small.
PowerPivot Advanced Data Modeling Alberto Ferrari
During this session we are going to analyze common business problems that require and advanced usage of DAX functions and data modeling with PowerPivot.
Real Time and Historical Performance Troubleshooting SentryOne
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.
Relational Modeling for Extreme DW scale Thomas Kejser
This session is taken from lessons learned in the field on being able to scale data models to handle multi-terabytes of data. Come to this session and understand the difficulties before you encounter them.
Service Broker: Message in a bottle Klaus Aschenbrenner
Service Broker provides several new key features for building SOA applications directly with SQL Server 2008.
The video is not available to view online.
So Many High Availability Options, So Little Time Allan Hirt
This session will compare and contrast the various SQL Server high availability options and discuss the things you need to do - both SQL Server and non-SQL Server - that you need to do to achieve availability.
SQL Consolidation Planning Bob Duffy
SQL Virtualisation using the Microsoft Assessment Planning tool and the SQL Consolidation Toolkit
SQL Product Team Panel session SQLCAT Team
Bring your SQL Server Issues large and small.
The video is not available to view online.
SQL Server 2008 Database Internals Klaus Aschenbrenner
Do you already wanted to know how SQL Server 2008 stores a database file physically on the hard drive? In this session you will learn the internal structure of a SQL Server 2008 database file.
SQL Server and Solid State Storage - SQL/SSD Jon Reade
Jon Reade examines the performance benefits of SSDs in a SQL Server environment.
SQL Server Clustering for Dummies Mark Broadbent
Are you uncomfortable with the idea of SQL Server Clustering? Do you currently use it and are scared to go near your Clustered Instances and their physical hosts? Stop worrying and learn the "Dark Art" of SQL Server Cluster administration.
<<12>>