SQLPASS Summit Wednesday Keynote – Part 2

Aww, the box is justa touchscreen computer.  No malarial mosquitoes. I'm switching to a selection of the live tweets, because it's what I find most interesting:

  • Me: Amir Netz comes on for a demo. The room perks up. #sqlpass
  • RT @AdamMachanic: RT @way0utwest  expecting a magic trick at #sqlpass …. Maybe he'll cut a monitor in half
  • @mrdenny: Where's his ponny tail? #sqlpass
  • sqlfool: Amir Netz just took the stage. I hope there's not another Visual Studio demo. 🙂 #sqlp
  • adammachanic: #sqlpass finally, a flashy demo. But the guy demoing has had waytoomuchcoffeeandissaying300wordsasecond
  • sqlchicken: @BrentO is that when Mr. DNA comes on screen and demoes the miracle of cloning dino DNA? #sqlpass
  • brento: Yep, @SQLChicken I think so. It's the Jurassic Database.
  • SQLServerMag: Amir Netz on PowerPivot–data from many sources into Excel."Working w/100 million rows is as easy as working with 1000 rows."
  • aspiringGeek: "Magic of s/w" allows *fast* client-side manipulation of 100M rows in Excel #sqlpass #powerpivot
  • GFritchey: It's Excel on pure rage! It'll be like the sprinting zombies in 28 Days Later. #sqlpas
  • Sqlrockstar: OH: "There is some magic here, the magic of software" #sqlpass
  • RT @AdamMachanic:100,000,000 rows in Excel? Great, now someone is going to accidentally hit print and cause an environmental crisis #sqlpass
  • SQLDBA: Where the IT worker gets invovled: When the CFO calls wondering why his Excel database didn't work on the plane (no connectivity). #sqlpass
  • SQLFool: 100m rows in Excel is impressive, but in reality, if you're showing users that much data, you're doing something wrong with BI #sqlpass
  • mladenPrajic: maybe they should use that algorithm to store data in sql server 🙂 RT @sqlbelle: 100M rows compressed to133MB excel file? wow. #sqlpass
  • sqlservermagazine: Netz–THAT GUY has a bunch of Excel spreadsheets. Put em in PowerPivot and you can see the data live & updated.
  • BrentO: Awesome! Instead of worrying about whether my SQL Server is paging to disk, now I can worry about my users' laptops too! #sqlpass
  • GFritchey: Oooh, I'll bet that generates pretty execution plans…. #sqlpass
  • BrentO: Please stop explaining joins to us. We're DBAs. We're not impressed by joins.
  • mrdenny: How come when I open my "application" my computer slows down? Because you have 1 gig of RAM and 100M rows in the sheet. #sqlpass
  • mrdenny: Sweet 35 new functions that I have to explain to my boss. Thanks guys. #sqlpass And then I have to explain why the SQL Engine doesn't have these same functions. #sqlpass
  • sqlservermag: Netz For PowerPivot you don't need to know SQL or C#, just Excel, but SQL Server is under the hood. Lots of power for end users.
  • sqldba: OK all jokes aside, I can totally see PowerPivot for Excel being useful at my company. #sqlpass
  • gfritchey: @sqldba yeah, me too. I'd love to be able to put this in a few peoples hands.
  • gfritchey: Every time he says scan I twitch. Make it stop. #sqlpass
  • mrdenny: Excellent point, users are now going to be emailing 100M Email files back and forth. Exchange database size will grow like crazy. #sqlpass
  • adamMachanic: #sqlpass the flashy demo looks really cool but I want to know what the real-world pitfalls are. How long does it REALLY take to do this?
  • Brento: Touchscreen Win 7 machine onstage at #sqlpass. Suddenly geeks everywhere are completely captivated.

 Recent blogs published, if you're interested in the conference from a non-Twitter viewpoint:

  • @joewebb: just blogged "Day 1 of PASS" – http://bit.ly/3teiCt #sqlpass
  • @BenchmarkIT: New Blog Post: Day 2 and Day 3 Recap #sqlpass http://bit.ly/rd2qu thanks @midnightDBA , @wendy_dance, and @sqlrockstar
  • @sqlrockstar: [Blog] PASS Summit Update: I remember the days when I had plenty of time to blog once or twice a day from the PASS … http://ping.fm/7tMWr
  • @sql_joker: SSC Blog – PASS Summit 2009 – Opening Remarks: Opening remarks on day 2 of the Summit come from Rusha.. http://bit.ly/3mDkQ6

-Jen McCown, MidnightDBA.com

Blogging for SQLServerPedia.com