Dear Diary - Pre-Conference Day at SQL PASS Summit 2009
SQL Server
By Brian Egler on Tue, 11/03/09 - 10:30am.
It's great to be back in Seattle for the SQL PASS Summit 2009. This year it has a different structure with one pre-conference day for extra seminars and one post-conference day instead of 2 pre-conference days. This is a good idea and should prevent people disapearing early on the last day of the conference. We'll see...
I attended Kalen Delaney's session on "Care and Feeding of the Transaction Log". She started with "how can you talk for a whole day on just the Transcation Log?" but she did it and we could have gone on longer. Kalen made it interesting and technically useful enough on the internals of the transaction log without going crazy deep. There are other sessions in the conference for that.
As always, Kalen showed us some "undocumented" features like DBCC LOGINFO and fn_dblog so we can see for ourselves what was happening to the transaction log. The special trick was to create a table that had the exact structure of the output of those utilities. Then we could do an INSERT EXEC statement to populate the table and then perform our own analysis with filtering and sorting using standard SELECT statements. Naming the table with the special prefix of "sp_" and storing it in the master DB means it's available to all databases. Very clever.
After the session, we attended the Welcome party and Quiz Bowl. It was good to network with folks over a beer and appetizers. Louis Davidson created a cool Jeopardy game with some pretty tricky questions including a category of SQL Movies. For instance, "Batman and SQL PASS Leader" was "Bruce Wayne Snyder". It was a bit like a trip through Louis's brain (yikes!) but the star panel did well and made it funny all the way through. The famous partnership of Kimberly Tripp and Paul Randall won the day hands-down. They even answered some of the questions in unison. Scary!
Looking forward to the rest of the conference!
cheers
Brian
- About Brian Egler's SQL Server Strategies
Brian D. Egler, MCITP/MCSE/MCT 2009, is currently an instructor with Global Knowledge, teaching various Microsoft training courses. He is a SQL specialist with a focus on SQL Server, Windows, .Net and XML. Egler has been a technical instructor for over 20 years and has more than 10 years experience with SQL Server, data modeling, database design, application development including IMS, DB2, Sybase. Every year he runs the Boston Marathon for cancer research.
Sponsored Links
- Efficiency goes up. Costs come down.- Microsoft
- SQL Server Experts: Virtually unstoppable- Microsoft
- Stay informed with custom newsletters from Tech Dispenser- Tech Dispenser
- FREE LCD Console and 16 node central management tool with purchase of any KN4 series IP KVM- ATEN
- Drive down operating expenses and mitigate risk with app centralization - Live May 12.- Juniper Networks
- The Next Generation of Content Security Has Arrived! Learn More!- Websense, Inc.
- Reduce costs by 49%, Increase capacity utilization by 33%. Make the HP LeftHand SAN work for you.- HP LeftHand SAN
- Connexion saves costs with Microsoft & Novell- Novell Microsoft
- Masters of Virtualization and Cloud Computing- Trend Micro
- Hitachi IT Operations Analyzer—30-day free trial- Hitachi Data Systems
-
Network World, Inc
The Leader in Network Knowledge
comment
I also want to visit the Seattle,but after my hosting paper which is going to held after a couple of days. No doubt the Seattle is one of the best picnic place in the whole world.
hosting
Fantastic information and good job. I hope you will guide me regarding domain name registration and its procedure, because its my thesis topic and i want to get more knowledge about it.
Post new comment