Archive for June, 2014

Road Trip: SQLSkills Immersion Event on Performance Tuning and Optimization – Part 1 @ Bellevue, WA

The following takes place between June 8th to June 14th 2014:

Journey to the West (June 8th 2014)

What a beautiful Sunday morning! It must have felt like 78 to 82 degrees Fahrenheit. I was excited about this road trip. I will be taking lessons on SQL Server performance tuning from Paul Randal and Kimberly Tripp, the top experts in the SQL Server industry. I am heading over to Bellevue, WA for the “SQLSkills Immersion Event on Performance Tuning and Optimization – Part 1.” I was about to be “Up in the Air” again. The voice of George Clooney giving Anna Kendrick advice on how to go through airport security was echoing on top of my head again as the car got closer to The LaGuardia (LGA) Airport. In case you are interested, you can search for the keyword “airport security” on this link http://www.imdb.com/title/tt1193138/quotes to see what Ryan Bingham said to Natalie Keener. Good advice. It is true. It takes me 2 minutes or less to go through the airport security.
When in Philly, enjoy a Philly Cheesesteak! It’s not as good as the Geno’s Steaks. But, it’s the airport. Let’s just comprise. Yes. Even though it’s less than 45 minutes away from the New York LaGuardia (LGA) Airport, the connecting flight is in Philadelphia. I could hear my European colleagues’ voices, “You Americans. Your banknotes are all the same sizes and you have a connecting flight in less than 95 miles!”

Sleepless in Seattle? (June 8th to June 14th 2014)

I haven’t watched the movie “Sleepless in Seattle” yet. But, if I knew Tom Hanks, I would have advised him to sleep in Bellevue, WA instead. It’s across the river from Seattle. It’s only 45 minutes away from Seattle downtown as per my experience by Sound Transit Bus Line 560 http://www.soundtransit.org/Schedules/ST-Express-Bus/560. I bet it will take much less time if you drove your own car. The most important thing is that he would have slept like a baby like I did!
It is called Subway in New York City; BART in San Francisco; Tube in London. In Seattle, they call it The Link. Here’s a photo:
The_Link

In New York, there’s the Empire State Building. In Chicago, the Sears Tower (now called the Willis Tower). In Toronto, the CN Tower. In Seattle, here’s the Space Needle:
Space_Needle

Do you fancy some fish? Here’s the world famous “The Pike Place Market”:
Farmers_Market

Believe the hype! (June 9th to 13th 2014)

Think you know SQL Server? Think again!
“Immersion Event on Performance Tuning and Optimization – Part 1” is the best professional training course that I have ever attended in the past decade based on 20+ courses evaluations. In the class, there were very knowledgeable, talented, and accomplished SQL Server DBAs from all corners of the world travelled to Bellevue, WA to take lessons on SQL Servers from the true masters of SQL Server: Paul Randal and Kimberly Tripp. In addition to the world-class SQL Server training for the week, it was great to network with these amazing and passionate SQL Server DBAs from around world.
During the week, Paul Randal and Kimberly Tripp explained database structures, data file internals and maintenance, transaction and locking, snapshot isolation, optimizing logging and recovery, index fragmentation, index internals and covering, statistics internals and updates, cardinality estimation issues, indexing strategies, and answered all questions that the attendees brought with them plus the questions that you can’t Google for possible answers. Paul Randal and Kimberly Tripp’s knowledge about SQL Server is exceptional and their clarity of explanations on SQL Server is bar none. They are simply amazing and the best in the industry.
Believe the hype! There are Senior SQL Server DBAs, Superstar SQL Server DBAs, then Real-Deal SQL Server DBAs, and then there are Paul Randal and Kimberly Tripp. They are in an elevated league of their own.

Microsoft Campus Building 35 (June 11th 2014)

Sure. I was tired after more than 8 hours of in-depth SQL Server lecture. But, it would be regrettable not to take a road trip to Redmond, WA to visit the Microsoft Campus. It would have been even more regrettable as SQL Server DBA and not visit Building 35, the building where the Microsoft SQL Server Development Team works.
Here are the photos:
To_Redmond

Shuttle_Connect

Microsoft_Campus

Microsoft_Campus

Building_35

Building_35_Front

Paul Randal’s Autograph (June 13th 2014)

Guess who’s the winner for a copy of the “Microsoft SQL Server 2012 Internals” book and asked Paul Randal to sign it? This is simply icing on the cake!
SQLSkills_IE1

Paul_Randal_Autograph