Tag Archive: tulsatechfest

What I learned at Tulsa Tech Fest 2008

Tulsa Tech Fest is a ginormous cross-discipline tech event that drew over 800 people to two days of fun sessions at OSU-Tulsa.  I learned so much from so many different people that I can’t even begin to lay it all out, but I’m going to throw in the highlights here.

Tulsa developers “get” social media. During one of the keynotes, the speaker asked for a show of hands from everybody on Twitter, and something like 1 in 5 hands went up.  That’s way, way higher of a participation rate than I see when I ask that same question in other cities.  Then, add in the fact that Twitpic and Ping.fm are both born and raised in Tulsa.  Wow.

Ping.fm consists of two guys in Tulsa. Ping.fm is a service that broadcasts your status updates to all of the social networking sites you use – Facebook, Twitter, LinkedIn, MySpace, and so on.  Post your update in one place, and boom, it goes out everywhere.  You can do updates via the web or via email, and if you attach a picture to your email, it handles that too.  Without Ping.fm, I wouldn’t be able to keep up with my friends on so many different social networks.  It works so well and stays up so much more than Twitter that it’s hard to believe it’s done by only two guys.  I met @seamoss and he’s totally down-to-earth.  If I ever started a site that cool, I’d be full of myself.  Heck, I’m full of myself now, and all I have is a blog!  Caught you reading it, though.  Heh.

People still believe virtual servers are smoke and mirrors. I gave a session on VMware and Hyper-V to an audience of people who hadn’t done any work with either platform yet.  About halfway through, I could tell that it wasn’t resonating with the audience, so I stopped and asked, “Okay, wait, how many of you actually believe me that this stuff works?  That say, VMotion works?”  The only raised hands were from the two guys in the audience who’d already done large (200+ host) VMware deployments.  I had to drop out of the slide deck, remote desktop into my lab, and show it in action.  Even then, they still didn’t seem to believe it.  Folks, this stuff is for real, and it’s coming fast.

Mint.com is a free web-based replacement for Quicken. I used to love Quicken, but it’s such a manual pain in the rear.  Mint screen-scrapes your bank’s web site, automatically categorizes your expenses based on the business name, and saves you money by suggesting things like cheaper insurance.  I’m sold.

Chris Bernard is a hell of a presenter. He’s a user experience evangelist for Microsoft, and his design experience carries over to his presentations.  He doesn’t keep turning around and pointing at the slide deck.  He doesn’t go “Uhhh, well, kinda, like, you know.”  He just bangs out his points, and the slides serve to illustrate what he’s talking about in amazing ways.  You can’t get the experience by watching Chris’s keynote on Slideshare, because like a good presenter, he’s not reading bullet points off a screen.  He’s talking about concepts, and supporting images or quotes will pop up behind him, but if you just watch the screen you’re missing the point.  I have a new benchmark to aim for in my presentations.

People love Perfmon. I gave a session on performance tuning, ran right up against my time limit, and people wanted more.  There’s a strong desire to learn more about what specific Perfmon counters mean, and what actions you should take when those counters are high.

Profiler groupings & aggregates can be enabled on the fly. If you get the chance to see Red Gate’s Brad McGehee speak on Profiler, attend, because everybody can learn something.  I eat, breathe and sleep Profiler, and I still didn’t know that you could enable groupings while a profile was running.  He got a lot of oohs and aahs when he showed deadlock graphs too.

Telligent is building cool stuff with social networking inside companies. I use a lot of social networking tools like Twitter to communicate quickly with other SQL Server professionals, and it helps me get my job done faster and have more fun doing it.  Rob Howard of Telligent gave a great keynote on social networking in the enterprise, and everybody was nodding their heads.  The products just made sense.  I’m sure they’re hard to sell to older executives who don’t get the power of things like Twitter, Facebook and LinkedIn yet, but integrated social portals like Telligent’s will help the younger generation get their job done better.

I’m still not seeing an interest in SQL 2008. The vast majority of DBAs I talked to just weren’t interested in putting in the time and effort to do upgrades because the business didn’t see an ROI in it.  They like some of the new features, but they can’t justify the manpower cost.  They also liked a lot of the Enterprise-only features in 2008, and they weren’t sure that management would spring for Enterprise.  Interesting.

Jeremy Marx and David Walker are really nice guys. One of the side effects of using Twitter is that you end up with friends all over the globe who you’ve never actually seen before. I finally got the chance to shake hands with Jeremy & David and talk with ‘em for a while, and they’re both great people.  I’ve met more cool people through Twitter in the last few months than I’ve probably met in real life the last 5 years!

I’ll be back next year. I had a great time, and I’m only scratching the surface of everything that happened.  If you’re anywhere near Tulsa, I highly recommend attending Tulsa Tech Fest.  At $2 or 2 cans of food, it’s the best IT conference bargain around.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

How To Write a SQL Server Performance Review

Sometimes I think the difference between consultants and employees boils down to one thing: documentation.

Us DBAs know exactly what we think is wrong with an application, and we’ll tell anybody who’ll listen, but what does management do?  They hire some expensive consultants to come in, ask a lot of questions, and tell us what we already knew.

The solution is to write a SQL Server performance review just as if we were consultants.  The goal is to deliver a solid document that explains:

  • The Effects – A list of objective, solid measurements of system performance
  • The Causes – An analysis of what is causing those metrics to be worse than we want
  • The Mitigations – Steps to take in order to reduce or work around the problems

Here’s two short videos explaining how to do it:

And part 2:

At TulsaTechFest 2008 this week, I’m giving a session on what goes into each section, how to word it, and how to look fantastic to your management in the process.  The cost of admission is just two cans of food or $2 – can’t beat that!

And here’s the sample report I discuss in the presentation:

Download the Sample SQL Server Performance Review

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

Upcoming SQL Server meetings & presentations

I’ve got a few upcoming presentations at user groups and meetings:

August 13 – West Michigan SQL User Group – SQL Server Consolidation: Your datacenter is overcrowded and overheated. Your manager is breathing down your neck to cut costs. The Wintel admins want to virtualize your servers. Consolidation might be the answer to a lot of different problems. Brent Ozar has gone through several consolidation projects some successful, some horrible and he’ll share his tips and tricks to make your project go successfully. I’ll cover different consolidation options, SAN storage considerations, how to write a successful consolidation plan, and what to do after the consolidation.  Looking forward to meeting up with Tim Ford.  (MSSQLTipsTwitter)

August 14 – Detroit SQL User Group – SQL Server Consolidation (same presentation as the 8/13 one.)

September 1 – PASS Camp 2008 Dusseldorf – SQL 2008 Improvements for Business Intelligence evening keynote. I’m also going to be running a Guitar Hero competition with Heather Eichman!

September 2 – LiteSpeed v5 London Launch – not quite sure where this is happening yet, or who’s invited, but as I find out more I’ll post the details here.  I’ll be talking about the new features in LiteSpeed v5.

September 4 – Quest SQL Server Club in Lausanne, Switzerland – Performance Baselining, Monitoring and Tuning. I love these subjects, because outside of disaster recovery, there’s no better way for a DBA to get fame and fortune in their organization then by doing performance improvements.  In my first couple of weeks at Southern Wine, I took a nightly job that had been running in 4-5 hours and cut it down to 4-5 minutes just by doing some indexing in less than an hour’s work.  That one performance tuning session made my reputation at the company, and people still talked about it a year later.  In these two sessions, I’ll share some of my experience doing performance diagnostics with Perfmon and staying on top of performance issues.

September 9 – New York City – The Changing Role of the DBA. We’re doing a day-long session at the Microsoft offices in NYC to talk about the new things database administrators have to learn just to do their jobs.  I’ll be focusing on consolidation, but it was a toss-up: I could have just as easily talked about virtualization or storage.  I could even make a laundry list of essential things I DON’T know, like SSIS and SSRS!  DBAs have a lot of stuff on their plate these days.  (When I get a signup link I’ll post it here.)

October 9 & 10 – Tulsa Tech Fest – Sessions listed below. I’m excited to be a part of this for my first time, because it’s got a great diverse list of sessions & speakers.  Programmers, DBAs and Wintel admins will all find interesting sessions to attend.  I’ll be doing a whopping five presentations:

  • SQL Server Consolidation: Perfect Planning Prevents Poor Performance – the same presentation I recently gave to the West Michigan and Detroit user groups.  I’ll cover different consolidation options, SAN storage considerations, how to write a successful consolidation plan, and what to do after the consolidation.
  • Hit The Ground Running with SQL 2008 – DBAs don’t have the time to dig into each new feature of SQL 2008.  I will help you get started fast by showing how to enable the features that will give you the biggest bang for the buck.  You’ll walk away with starter scripts for the Resource Governor, Policy-Based Management and more.
  • SQL Server Performance Monitoring & Budgeting with Perfmon – I’ll cover the same topics I discuss in my blog article about monitoring SQL Server with Performance Monitor and show how to do some basic budgeting & projections.
  • How to Write a SQL Server Performance Review – one of my specialties is taking an existing application, studying it transparently for a week using tools like Profiler and Perfmon, and then writing up an analysis of what needs to be done to fix scalability or performance problems.  Managers love this stuff because it helps IT budget more wisely, helps developers plan their time better, and helps justify DBA salaries.  In this session, I’ll show you how to write a performance review.
  • Virtualization 101: Hyper-V versus VMware ESX – virtualization is coming on strong in the enterprise, and I get a lot of questions from DBAs about what virtualization really means.  I’ll cover the differences between these two platforms, discuss some of their freakishly cool features, and point out what’s still smoke and mirrors.

Now, if you’ll excuse me, I have to go print out a whole bunch of airline, car, and hotel info!

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts