Tag Archive: teched

The Top 10 Developer Mistakes That Won’t Scale

Microsoft records TechEd sessions, and you can watch the recording of mine.  Here’s the abstract:

You’ve heard it before: “It worked fine on my machine, but the users say it’s too slow.” Don’t blame the developers: they’re using SQL Server features that look great on paper, but in reality, they won’t scale up to production loads. Learn to recognize these common mistakes before they go into production and be armed with alternatives.

If you like it (or hate it), let me know by rating it at SpeakerRate.

Feedback From The Attendees

Here’s some of the comments I got from presenting it at TechEd:

“All developers should be forced to see this.”

“One of the interesting session attended. Quite humorous too. Well done.”

“Wonderful. Good info wrapped up into a nice package that was easy to understand.”

“The speaker made this one very enjoyable.”

So far so good – but then here’s a rough one:

“I would suggest that Brent not make blatant political references during his presentation. He compared the intellect of Albert Einstein to President George Bush. Also, other pictures included a person with clown makeup on holding a gun to his head. Maybe he thinks these are funny, but I really don’t… Inappropriate for a professional environment.”

Handling this kind of feedback is part of being a presenter.  It would be easy for me to call this person a stick in the mud and disregard their opinion, but that’s not the right thing to do here. I want to reach as many people as possible, teaching things while having fun.  My slides made this person so angry that they stewed in their chair throughout my session, then promptly went over to the feedback computers and banged out an eval.  I don’t care about the evaluation scores – but I do care about reaching more people.

To do the right thing, I have to stop and ask myself, “How did the audience react when I showed those slides?”  Nobody really reacted to the clown, so I need to pull that image out and swap it with something funnier or more appropriate.  No sense in aggravating audience members if I’m not gaining anything.  (I examine most of my photos that way – for example, the duct tape on the airplane window on the TempDB slide didn’t elicit so much as a chuckle, so that one comes out and either gets replaced with another photo or none at all.)

Jar Jar at Work

Too Subtle?

The Einstein vs Bush slides, on the other hand, made the audience erupt in raucous laughter.  Most of the audience doesn’t know that I’m a Republican, so I could ease the pain for the hard-core guys by saying something like, “I’m allowed to make fun of Dubya because I’m a Republican myself.”  That statement would generate negative comments for another reason, so that doesn’t work either.  I need to find someone that is universally recognized as less-than-brilliant – preferably someone who isn’t well-loved, so that when I show their picture, nobody gets pissed off.

  • Paris Hilton – might get interpreted as sexist, so no go.
  • Me – pictured doing something really stupid.  Usually I’m quick to jump in as a self-deprecating punch line, but because this is so early in the slide deck and I just got done touting my credentials, I don’t think it’d flow very well.
  • Fictional character – ahh, now, here we go.  I thought about the Three Stooges, but that might not play everywhere.  Maybe Vanilla Ice.  The only tough part about using fictional characters is that it’s sometimes harder to find Creative Commons-licensed pictures to use, but I’ll figure this out.

Feedback From Other Presenters

I was lucky enough to have a few other presenters in the audience, and I asked for their feedback individually.  People like Buck Woody, Tim Ford, and Tom LaRock do a lot of presentations, and it’s interesting to see my work through their eyes.  They gave me feedback on how to craft my message better and how to interact more smoothly with the audience.

I still have to work on repeating questions from the audience, and I need to avoid belittling someone with a controversial opinion.  I cringe when I listen to the way I handled the Heap Heckler at about 50 minutes in:

  • HH: “I get great performance from heaps, and *I* speak from experience.”
  • BGO: “You’re experienced and I’m not?  What?  Call me when you’re up here.” (referring to him being in the audience and me being on the podium)

Ouch.  Not good enough.  It felt good at the time to zing somebody, but that’s not how I want to treat audience members.  Thankfully he came up to me after the presentation and we hugged it out.  He admitted he only used it for staging tables (which makes perfect sense) and I paid him off with Starbucks gift cards.

A presenter’s work is never done.  This is why it’s so important to do your presentations at progressively larger sessions – I’d done this particular presentation at local user groups, the SSWUG Virtual Conference, and finally in front of 204 live meatbags at TechEd.  Even now, I’m still honing this presentation and working on my delivery.

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

Quest #QTweetup at TechEd – SOLD OUT!

Think fast!  The first 75 people who sign up at http://QuestTweetup.eventbrite.com can join me, Kevin Kline, Joel Oleson, and the rest of the Quest experts for an evening of fun on Bourbon Street.

Bourbon Street Blues Company

Bourbon Street Blues Company

We’re getting together on Wednesday night at 9pm at the Bourbon Street Blues Company smack in the middle of the action.  (If you can call a gathering of thousands of geeks “action.”)

Register for the #QTweetup quick, because I’m sure this will fill up due to the limited space.  You can also check out my TechEd schedule.

See you in New Orleans!

Update – Sold Out! Well, that was quick.  It sold out!  See you there.

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

Free Quest TechEd 2010 T-Shirts

Not going to TechEd, but you wish you could pick up some of those cool vendor freebies?  I got your hookup right here.

Register for a free Quest t-shirt and you’re also entered into a drawing for a $200 AmEx gift card.  Rules and restrictions apply.  Drawing not open to my family members, people who live in other countries, or people who dilly-dally – time limited….

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

TechEd 2010 Schedule and Info

Here’s the sessions I’m planning on attending at TechEd 2010 (my first TechEd!):

Sunday:

Monday:

  • 7:30AM – at Cafe Dumonde (800 Decatur St) with Buck Woody and anybody else who likes chicory coffee and addictive beignets.
  • 9:00AM – Keynote by Bob Muglia
  • 10:30-2:45PM – Quest booth #1800 in the expo hall
  • 2:30PM – Media briefing with Brendan Cournoyer (TechTarget)
  • 2:45PM – MGT203 System Center Roadmap by Garth Forth – auditorium B
  • 4:30PM – DAT307 SQL Server Private Clouds by Rob Reinauer – room 283
  • 5:45PM – Partner Expo – Quest Booth. Tell your friends, “I’m at the bar with Ozar.”

Tuesday:

  • 7:30AM – at Cafe Dumonde (800 Decatur St) with Buck Woody and anybody else who likes chicory coffee and addictive beignets.
  • Morning – Quest booth in the expo hall
  • 10:30AM-12:30PM – Microsoft SQL Server Mission Critical Booth
  • 1:30PM – VIR304 Hyper-V and Dynamic Memory by Benjamin Armstrong – room 295
  • 3:15PM – DAT313 Planning Large-Scale SharePoint/SQL Deployments by Joel Oleson – room 283
  • 4:30PM – Interview with Kevin Kline and Karen Forster (PlatformVision)
  • 5:00PM – DAT210 Database Design Methodologies by Buck Woody – room 293
  • 7:00PM – Microsoft Community Influencer Party (wasn’t sure if I was supposed to blog this, but it’s listed here)
  • 8:00PM – Double-Take Cluster Funk Party (I’ll be at the Influencer party, but I’m listing this one here in case you’re looking for something to do)

Wednesday:

  • 7:30AM – at Cafe Dumonde (800 Decatur St) with Buck Woody and anybody else who likes chicory coffee and addictive beignets.
  • 8:00AM – VIR315 Windows Hyper-V Performance Analysis by Clint Huffman and Kenon Owens – room 391
  • 9:45AM – OPS310 Fine Tuning Your SharePoint Environment by Mike Watson – room 388
  • 11:45AM – DAT316 – My session!  Top 10 Developer Mistakes That Won’t Scale – room 391
  • 1:30PM – BOF23-IT – Going To The Cloud: Are We Crazy? room 354
  • 2:30PM – Media briefing with Ian Murphy (Data Centre Times, ComputerWeekly.com)
  • 3:15PM – DAT317 -The OVER Clause: Your Key to No-Sweat Problem Solving by Adam Machanic – room 293
  • 4:30PM – Media briefing with Megan Keller and Sheila Molnar (SQL Server Magazine)
  • 5:00PM – WCL404 – Windows 7 & Server 2008 Kernel by Mark Russinovich – auditorium B
  • 7:00PM – Best of TechEd Awards Ceremony – Hard Rock Cafe
  • 9:00PM – Quest Tweetup at Bourbon Street Blues Company (RSVP only, sold out)

Thursday:

  • 7:30AM – at Cafe Dumonde (800 Decatur St) with Buck Woody and anybody else who likes chicory coffee and addictive beignets.
  • 8:00AM – SIA334 – Secrets of Effective Tech Talks by Mark Russinovich – auditorium C
  • 9:45AM – DAT405 – T-SQL Tips and Tricks by Itzik Ben-Gan and Tobias Ternstrom – room 272
  • 3:15PM – DEV301 – Oracle Development Using Visual Studio by Daniel Norwood – room 281
  • 5:00PM – DAT305 – Largest Mission Critical Deployment of SQL in the World by Kevin Cox – room 272
  • 6:30PM – TechEd Party

TechEd Twitter Accounts:

  • @TechEd_NA – the official feed.  Retweets planners and vendors, runs contests now and then.
  • @RobNic_TechEd – Twitter feed for a TechEd planner.  You can check his photos to see the swag like the water bottle and backpack.
  • @TheKrewe – hard-partying TechEd attendees with a private Facebook page that denied me entry.  See, you guys think I have all kinds of inside connections, and I can’t even get into a damn Facebook page.  Famous my rear.

Did I miss anything?  Is there anywhere I should be?  I might have missed some cool sessions – there’s just so many with conflicting times.  So many sessions, so little time…

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

I ___ with Brent

I need creative help with my name.

At TechEd, Quest is promoting their MVPs and experts like Joel Oleson and Kevin Kline with a really cool series of buttons, t-shirts, and banners.  Joel and Kevin have awesome buttons:

Joel and Kevin - Awesome Buttons

Joel and Kevin - Awesome Buttons

Really cool, right?  But what on earth do we do with a guy named “Brent Ozar”?  The marketing department will never approve a button that says, “I Got Spent with Brent.”

Lacie Iamakey USB Drive

Lacie Iamakey USB Drive

So that’s where you, dear reader, come in.  Leave your best button slogan with Brent or Ozar in it, and next Monday, May 10th, I’ll pick my three favorites and announce the winners here.  I can’t promise that the marketing team will let me use my favorite one, but it’s worth a shot!

The winners will each get an 8GB Iamakey drive.  Open to US and Canada only, unfortunately – the shipping kills me.

C’mon, smart people – show me that creativity.  Don’t make me wear a button that says, “I Rent Brent.”

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

Microsoft TechEd 2009 Keynote Liveblog

At today’s Microsoft TechEd 2009 conference in LA, Senior VP Bill Veghte started by talking about big-picture needs.  He discussed focusing Microsoft’s R&D on the ability to deliver anywhere access with end-user centricity: the ability for mobile users on laptops and PDAs to access applications securely and with IT control.

Office 2010 and SQL Server 2008 R2 Release Date for CTP

Technical previews of both products are coming this year.  The SQL Server 2008 R2 CTP will be coming in the second half of 2009.  (PASS Summit, hopefully?)  From the TechEd press release:

“Finally, Microsoft announced that a Community Technology Preview of Microsoft SQL Server 2008 R2 (formerly SQL Server code-named “Kilimanjaro”) will be available in the second half of 2009. SQL Server 2008 R2 will empower end users to make better decisions through self-service business intelligence, and help IT drive greater efficiency and reduce costs through new capabilities such as multi-server management and Master Data Services. In 2010, Microsoft will also introduce complex event processing for real-time insight into streaming information.”

The self-service BI stuff ties in with the Office 2010 release, and the technical preview for that will be available in July, but it’ll be a limited preview starting with the TechEd attendees.  More information is available at the Office 2010 Technical Preview site.

Windows 7 Notes and Improvements

He asked for as many people as possible to install and live with Windows 7 so that they can get telemetry: bug reports and device installation data.  The more data they get, the better the final release is.  They’re working on video drivers especially, which got a chuckle out of some of the attendees.  (In my humble opinion, video drivers are some of the buggiest things in an operating system, and it’s not Microsoft’s fault there.)

Microsoft worked with Intel on two things in Windows 7: power management (in core management and Nehalem) and hyperthreading scheduling.  The latter is starting to matter with Apple’s focus in Snow Leopard: Apple’s delivering something called Grand Central to ease multithreaded software development.  It’s nice that Microsoft is trying to compete on that.

Veghte said he was surprised that he didn’t get more feedback on Internet Explorer v7 and v8, especially around security.  I’ll break the insightful answer right here on BrentOzar.com first for my readers: it’s because we’re using Firefox and Chrome. <rimshot>

Windows Server 2008 R2 Improvements

Windows 2008 R2 brings tools with VDI, local printer support, PowerShell, etc to make it easier to manage lots of desktops and remote offices.  60-70% of the “run rate” has become portable machines, which makes management tougher.  The Windows Server 2008 R2 RC is available now.  One of the new key features is BranchCache, which caches file server content at branch offices to speed access for branch office users.

Vighte demoed BitLocker to Go, which encrypts USB flash drives.  Mark Russinovich then came onstage and showed a little about policy management (GPO) that can enforce the requirement of BitLocker so users can’t just plug in drives and use bad passwords.

Russinovich also introduced AppLocker, an improved version of SRM, and neither of these terms mean anything to me.  He pointed out a bug in the application and said that even though the app on his screen said Sysinternals, he clearly didn’t write it because it had a bug – and his software never has bugs. Ha! Nice.

He demoed Problem Steps Recorder, a troubleshooting tool that end users can use to record a mini-screencast of problems.  When they’re experiencing a problem, they start the tool, which captures a series of screenshots of each thing they click on.  It produces a chtml file with all of the screenshots embedded, making it easy to email that file over to tech support.

Windows will be able to access and create VHDs (virtual hard drives) very similar to disks.  In Disk Manager, you can create a new VHD, partition it and format it just like a hard drive, and it uses thin provisioning.  Users can create a 10gb VHD, but it won’t immediately start at 10gb – it just uses the necessary space to accommodate the files contained inside.  Windows will also be able to boot into a VHD by editing the boot configuration file: users can download a new VHD to test a new operating system, for example, and then reboot straight into it.

PowerShell v2 will be able to script Group Policy.

Application Compatibility and Virtualization

Microsoft Enterprise Desktop Virtualization (MED-V) was demoed by Russinovich as a way for enterprises to continue to deploy and manage their older applications that aren’t Windows 7 compatible.  In addition, enterprises can specify specific URLs that will launch in older browsers via virtualization: if you have an old intranet web app that only works in IE6 or IE7, your users won’t have to know the difference.  The right browser will launch based on the site they visit.

He showed Application Virtualization (APP-V) as another piece in the lost-laptop puzzle: the way IT employees can rapidly redeploy laptops to users. Roaming profiles handles the storage of settings, folder redirection handles document storage, and APP-V handles the fast provision of applications on the fly.  All of this relies on extremely fast bandwidth, though: you can’t simply drop-ship a new laptop to someone in a remote office and expect them to pull their profile, folders and APP-V apps over the wire.  For in-office workers, it’s great though.

Windows 7 Release Date: “Before the Holiday”

Windows 7 Release Party

Windows 7 Release Party

Veghte came back onstage to talk more about application compatibility with Windows Vista applications, and emphasized that developers need to test their Vista apps to make sure they’ll work with the final release of Windows 7 since it’s coming fast.  He didn’t mention Windows XP applications, which rather surprised me until I realized Windows 7 Professional will come with a virtual XP – but not a virtual Vista.

He said that the release candidate work went on schedule, and it looks like it’s tracking for a wide availability before the holiday.  “The Holiday.”  No name, just “The Holiday.”  How politically correct. We know he means Hanukkah, though.

Windows Server 2008 R2

Iain McDonald, GM of Windows Server, came onstage to jokingly announce that TechEd 2009 is the coming-out party for Windows Server 2008 R2 because Windows 7 has hogged the spotlight too long.  Windows 2008 R2 is also on track for a holiday delivery, and that there won’t be a workload it can’t handle.

Several factors combine to make this release interesting for shops with a large number of servers: the ability to boot from VHD, the ability to run .NET apps on Windows Core, and PowerShell.  Between these, you could conceivably copy VHDs out to all servers in a farm, tweak their boot config files to update to the new VHD file, and reboot them.  If I managed web farms or application server farms, this would get me really excited, and down the road if SQL Server scales out, this has good implications for better server management too.

A new File Classification Infrastructure will let administrators set extended properties on files, like confidentiality.  For example, if a file is marked confidential, it will be moved to a specific area on a file server, a symlink will be left in its place, and the document will be handled the way the sysadmins want.  Even if the file isn’t marked confidential, Windows Server 2008 R2 will include OCR capabilities to recognize terms like “Microsoft Confidential” in scanned documents, and automatically add the appropriate metadata tags.

Exchange 2010

Iain called Exchange one of the most deployed applications in the world, and talked about wanting to deploy it similarly whether it was deployed locally or in the cloud. The goals for Exchange 2010 were making it:

  • Great at dealing with information overload
  • More reliable and easier to manage
  • Protecting data better for compliance needs

He demonstrated sending a piece of email from a member of the legal team to an executive – or rather, tried to, and he got two straight failures.  Whoops.  If the document had key phrases, it would recognize that the email should be confidential and would be marked as such.

Outlook Web Access in Exchange 2010 will work “beautifully” in other browsers (only Firefox and Safari were mentioned, not Chrome).

System Center Virtual Machine Manager

SCVMM’s aim is to manage both physical and virtual servers, and manage virtual servers no matter whose platform it is (Hyper-V, Xen, VMware, etc).  His demo showed a server with a high level of CPU utilization, and he migrated it to another node (host) the same way as VMware vMotion.

Interestingly, like SQL Server has done since 2005, SCVMM also has a Script button that will show the script that will be executed behind the scenes to accomplish the task.  This feature in SSMS 2005 was a boon for DBAs because it encouraged them to learn T-SQL scripts by example, and this might do the same thing for PowerShell users.

Summary Wrapup: A Good Time for DBAs to Attend Remotely

Why Yes, Those Are Yoga Books

Why Yes, Those Are Yoga Books

I’ve never attended TechEd in person, and this year’s economic climate meant that I was really happy Microsoft did such a good job of webcasting the keynote.  I was able to watch it, research in realtime, and liveblog it from the comfort of a quiet Barnes & Noble with my headphones on.

There wasn’t much news for the SQL Server community in the keynote.  The “accidental DBA” community – developers and sysadmins who spend most of their time managing applications or servers – got more out of TechEd than DBAs did.  The timing of SQL Server 2008 R2′s CTP date means that the PASS Summit will probably get the meat of the SQL Server news.

My take: this schedule makes attending the 2009 PASS Summit even more attractive for database administrators.  We’ll likely be getting our first good looks at SQL Server 2008 R2 at the summit, and since it’s in Seattle again this year, we’ll be able to talk to more Microsoft people about the release.

And now, if you’ll excuse me, it looks like those yoga books are 30% off.

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