Join us at PASS 2010!

Please join as at the 2010 global summit for the Professional Association for SQL Server in Seattle.  The conference is the second week in November at the Washington State Convention Center.  The PASS Global Summit is one of the best technical conferences and the absolutely best place to go to unite with the SQL Server community.

Please Attend My Session

My session on “Cooking With Reporting Services” is schedule for Wednesday, November 10th at 1:30 PM local time.  This will be the fourth time I’ve presented a conference session with this title.  Some of the material will be new and some of the demos will be drawn from our Wrox Press Book: SQL Server Reporting Services Recipes for Designing Expert Reports.

Birds of a Feather: Lunch Time with the SQL Server MVPs

The Birds of a Feather lunch time event on Tuesday, November 9th will give attendees the opportunity to sit down and chat one-on-one with Microsoft SQL Server MVPs and focus on a variety of subjects.  Mike Walsh and Jason Strate have graciously organized the BoF event this year.  View the complete event description on Mike’s blog.  “How do I attend?” you might ask.  Easy… just show up – but get there early.  For those who plan ahead, you’ll be able to choose your most pressing topic and chat with the expert.  For those who get there late, it can become a game of musical tables.  When an MVP’s table fills up and there’s no more room, you’ll have to move on.

Here are all the BoF assignments this year.

Allan

Hirt

SQL Server Manageability Tips for the DBA

Ami

Levin

Performance Management Tools

Andy

Leonard

SSIS Frameworks

Andy

Warren

Statistics

Arnie

Rowland

Community – TechNet Wiki

Brad

Schulz

Interpretting Query Plans

Bruce

Loehle-Conger

SSRS Lessons Learned

Chris

Webb

Performance Tuning SSAS

Christian

Bolton

Hyper-V with SQL Server

Christopher

Shaw

Professional Development for the Data Professional

Darren

Gosbell

SSAS Triple A – Administration, Automation and APIs

Davide

Mauri

SQL Server & NoSQL Alternatives

Dean

Vitner

Write-Ahead Logging & The Transaction Log

Denny

Cherry

SQL Service Broker

Eduardo

Castro

HA In Virtualized Environments

Edwin

Sarmiento

Why you need to distinguish yourself from the rest

Erland

Sommarskog

Practical T-SQL Programming

Geoff

Hiten

Advanced SQL Clustering

Gianluca

Hotz

Oracle to SQL Server DBA

Glenn

Berry

Database Mirroring

Grant

Fritchey

T-SQL Tuning & Optimization

Greg

Galloway

What’s the Coolest Business Problem You’ve Solved with a Cube?

Jason

Massie

Querying The Procedure Cache

Jeff

Moden

Black Arts T-SQL

Jessica

Moss

Fixing Bad Data Using SSIS

Jesus

Gil

Geo-Spatial Data on SSRS (en espanol)

Jonathan

Kehayias

VMWare With SQL Server

Justing

Langford

SQL Server Consolidation

Kevin

Boles

Performance Tuning

Kevin

Kline

Help for the involuntary DBA

Louis

Davidson

Database Design

Michael

Coles

SQL Encryption

Michael

Steineke

High Performance DBs on Shared Storage

Patrick

LeBlanc

CDC

Paul

Turley

BI Tool & Visualization Choices

Peter

Ward

SQL Server Migration and Upgrade Planning

Plamen

Ratchev

Implementing Hierarchies in SQL

Rafael

Salas

PowerPivot: Where/How Are You Using It?

Rob

Farley

Tables don’t exist, so join me at my index

Scott

Klein

Data Development in SQL Azure

Sean

McCown

PowerShell For the SQL Server DBA

Ted

Krueger

Cheapest DR/HA Options on SQL Server

Tim

Chapman

SQL Security Best Practices

Tim

Mitchell

Care and Feeding of your SSIS Infrastructure

Tim

Ford

DMVs

Todd

McDermid

Data Warehouse ETL with SSIS

Tomislav

Piasevoli

The Past, Present and Future of Microsoft BI

Presenting at 2010 European PASS – Sort Of

I was so looking forward to the trip to Germany to speak at the European PASS Summit on April 22nd.  Two of my abstracts had been selected several months ago; a spotlight session titled “Cooking with SSRS”, based on our new Reporting Services Recipe book; and “Implementing a Self-Service Reporting Solution with SSRS”.  Unfortunately the fine people of Iceland decided to share some of their country with the rest of Europe in the form of volcanic ash and all of the flights in and out of western Europe were cancelled for several days.  At the last minute, the conference organizers arranged for 15 US and non-European based speakers to deliver their sessions via LiveMeeting and webcam.  Rather than enjoying Wienerschnitzel and the scenic Rhein, I had the pleasure of presenting my sessions from the comfort of my home office in Vancouver, Washington.

I woke up just after 1 AM Pacific time to deliver my first session (10:45 AM European time) to an audience of about 50 conference attendees in Neuss, took a nap and then dialed-in again for my second session at 6:30 AM.  Since I didn’t ever make the transition to European time, needless to say, I’ve been a zombie the rest of the day.

I’ll post video and my PowerPoint decks soon.  In all, I think both session went well.  The first session started a little late because Donald Farmer’s key note went about 20 minutes long.  Donald can get away with that.  Both sessions were well received and I had a lot of questions.

Demo’ing Report Builder in Low Resolution

I had one hiccup during the first session while demonstrating new features in Report Builder 3.0.  This application was designed to run in high resolution mode and even at 1280 x 1024 pixels, the dataset dialog is too big to fit on the screen.  Running at 1024×768 to match the projector resolution with an extended desktop over LiveMeeting, it was near impossible to get to the dialog controls and click the OK button.  I had practiced earlier in the same resolution without using LiveMeeting and was able to solve the problem by maximizing the window.  During the second session, I found a work-around by moving the dialog to the second screen on my extended desktop, resizing it and moving it back or just hitting the OK button on the second display – live and learn.  Let’s hope they don’t slaughter me in the evals for one small screw up.