Sessions & Content

Search
Content Type
Conference
Tags
Design patterns for SSIS Performance Darren Green
Do you wonder about SSIS performance? Well I do, and I've compiled my research into this session. We'll cover various design patterns for solving common problems like inserts vs. updates, is it faster to use a lookup, or can you just catch the errors and process them afterwards? As well as the richer patterns we'll look at some straight comparisons between two components that can be used to do perform the same task and ask which one is quicker?
Designing and Tuning high speed data loading Thomas Kejser
If you want to understand how to load data into Sql Server very quickly then this is the session for you.
Event Driven Cube Performance and Security Monitoring David Elliott
This session will investigate using Stream Insight, SQL Server and Analysis Services to provide an example framework to monitor cube usage as well as suggest a mechanism for highlighting areas for performance and security enhancements.
High performance functions Simon Sabin
Encapsulating common code in fucntions is one of the first things you learn as a programmer. However with SQL Server functions can be very bad for performance. In this session we will examine scalar functions in both TSQL and in .Net. You will come away from this session understanding the pitfalls of TSQL functions and how you can make them run 100 times faster.
Improving Database Performance by Removing the Database Simon Munro
A challenge to traditional patterns of processing, storing and retrieving the precious data that we are responsible for
Inside the SQL Server Query Optimizer Conor Cunningham
Understand the Query Optimiser from the man who knows!
Introduction to Performance Tuning Analysis Services 2008 Chris Webb
Learn to tune Analysis Services 2008 query performance
Lessons Learned from 128 Core OLTP Testing Thomas Kejser
See the lessons learned from stressing 128 cores
Monitoring and Tuning Parallel Query Execution R Meyyappan
In this session with examples we will cover how to identify inefficiencies in parallel query execution. We will also investigate some invisible symptoms! Keywords: MAXDOP, CXPACKET, SLEEP_TASK & SOS_SCHEDULER_YIELD. I don’t have a quad core laptop yet, so I will do the best with my dual core!
Non-Functional Dependencies - A talktorial on getting performance and scalability right through proper Database Design and understanding Set and Relational theory Tony Rogerson
Bad performance is often systemic of poor queries which are systemic of bad schema design which is systemic of non-relational thinking which is systemic of project time constraints and lack of understanding of Database Design. In this talk/tutorial I'll work my way through Normalisation, we'll look at the Relation Model and how to think in sets - it's very important; throughout I'll be referring to Codd and Date's teachings. Theory aside I'll do all my demonstrations in SQL Server - concurrency, indexing, good T-SQL practices and advice.
Performance Management for SQL Server with SCOM 2007 Bob Duffy
Learn to love SCOM! Out of the box the SCOM Management Pack for SQL Server is not popular with DBA's. This demo based session will take you through the process of how you can extend SCOM to properly monitor and analyse SQL performance. Ultimately providing performance management scorecards and dashboards for your CIO.
Performance Monitoring & Tuning - Documented Tips & Tricks R Meyyappan
With examples we will discuss tips and tricks that will be useful for Developers, DBAs and Consultants.
Photograph: SQL Server Crash Dump Analysis Pablo Doval
This session will reveal the basics of analyzing crash-dumps in order to troubleshoot SQL Server crashes or abnormal situations. We will also review the postmortem analysis of common (but tricky) development problems, such as connection leaks, using WinDbg and Adplus.
SQL Server 2008 Reporting Services Scalability and Performance Rob Carrol
This session covers the new scalability features of SQL Server Reporting Services 2008 and demonstrates how to build a high performance reporting platform to deal with your enterprise reporting needs.
Supercharge MDX performance using MDX Studio Ashwani Roy
MDX Studio can be used to analyze complex MDX expressions, monitor performance characteristics of MDX queries and get insight into how MDX interacts with other UDM features such as attribute relationships.
Transaction Log Performance Tuning, Stop shouting Timber! Chirag Roy
This session aims to enlighten the audience on improving Log file design, implementation and management for extracting maximum performance from SQL Server using real world examples and strategy. The session will focus on SQL Server 2005, SQL Server 2008 and SQL 2008 R2.
<<1>>