16th April 2010

Church House Conference Centre, London

Platinum Sponsors
Microsoft
Gold sponsors
Silver sponsors
Bronze sponsors

Let’s make SQL fly – a technical session for developers and administrators who believe in magic!

In this session we will analyze and resolve a real world SQL Server Performance issue. We will first identify a customer’s query performance issue and understand the reason for the non optimal performance of their application. After understanding the limitations it will of course be natural to invent and perform non TCO increasing magic to make SQL Server really fly. We will also provide few words of caution for those who might abuse the newly acquired magical powers.

This deep dive, no fancy power point show is equally designed for developers and administrators. If you are one of those who would rather perform the magic on your own laptop than just observe it being demonstrated, send me an email so I can send you the demo scripts to prepare yourself for the adventure.

Speaker focus

R Meyyappan

 

R Meyyappan is a SQL Server specialist with expertise in Performance Tuning. Ramesh worked at Microsoft Corporation from 1994 to 2004. Nearly half of that time he worked in Redmond in the development teams - specifically as Program Manager in the SQL Server Development Team responsible for optimizing SQL Server product for SAP. Ramesh now offers onsite and offsite consulting and workshops independently as well as by partnering with various Microsoft Subsidiaries.

"3 Day Level 400 Microsoft SQL Server 2008 / 2005 Performance Monitoring & Tuning” Workshop delivered by Ramesh has been organized by various European Microsoft Subsidiaries including Microsoft Austria / Microsoft Developer Network (MSDN), Microsoft Belgium, Microsoft Czech Republic, Microsoft Denmark, Microsoft Germany, Microsoft Netherlands, Microsoft Norway, Microsoft Poland, Microsoft Russia, Microsoft Slovakia, Microsoft Slovenia, Microsoft Sweden and Microsoft Switzerland.

You can contact Ramesh at rmeyyappan@sqlworkshops.com

You can find webcasts from Ramesh at http://webcasts.sqlworkshops.com

 


R Meyyappan's blog http://www.sqlworkshops.com



Downloads

File Type Ext ContentName
Presentation .ppt Slides
<< 1 >> 

Other sessions from this conference

A whistlestop tour of SSIS add-ins
Achieve SQL Server 2008 High Availability and Disaster Recovery - technical case study
An introduction to Master Data Services
Building cubes from ODS or Operational Systems
Cache-warming strategies for Analysis Services 2008
Common Integration Services Problems
Creating High Performance Spatial Databases
Data & Backup Compression in SQL Server 2008
Data Visualisation with Bing Maps for Enterprise
Data Warehouse on a Fast Track forwards
Data warehousing features in SQL 2008
Designing for simplification
Designing I/O systems for SQL Server
Excel - An Excellent Data Mining Tool
Getting Dimensional with Data
I need my reports..........Yesterday!
Introducing Project Madison
Introducing SQL Server Master Data Services
Introduction of MS StreamInsight.
Introduction to the Microsoft BI Technology Stack
Lets go more functional - F# WHAT , WHY and BI
Microsoft SQL Server 2008 R2: What’s New in Reporting Services
Optimistic Concurrency Internals
Powershell – old tricks for a new dog?
Put Your Feet Up : Simplified Management using the Enterprise Policy Management Framework
Real World SQL Server High Availability
Report Builder 3
Self Service Business Intelligence- Project Gemini
Server consolidation with SQL Server
SQL 2008 Development Features
SQL Injection Attacks (and how to prevent them)
SQL Server 2008 - Unstructured Data Storage Solutions and Best practices
SQL Server optimization stuff you won’t find on Google (yet)
SQL, NoSQL, SomeSQL - A look at non-relational databases
SQLDataSources, LINQDataSources and EntityDatasources in Database Design
SSIS in SQL Server 2008
Strapped for cache? - Troubleshooting memory problems in SQL Server 2008
The R2 Duo: Running SQL Server 2008 R2 on Windows Server 2008 R2 Core
T-SQL Tuning with Colin Chapman, Enzo Ferrari, and The Stig
Using Perfmon and Profiler
Virtualising SQL Server
Vital Statistics
What's new in R2 for the DBA
When a query plan goes wrong