亲爱的日记- SQL通过峰会第二天2009

另一个在2009年西雅图在通过峰会上伟大的一天。强调对我来说变得23 SQL Server MVP签署一份SQL Server MVP深潜水书刚刚发布了。所有版税http://www.WarChild.org捐赠给慈善机构。书店在会上出售所有的150张。这是一个伟大的书和一个伟大的事业。一天开始使用SQL激情奖不知疲倦的志愿者,如艾伦Kinsel(北美)和查理Hanania(国际)。整个通过组织是建立在志愿者模型和通过首脑会议是一个见证这些志愿者的工作从章董事会。很荣幸成为传递的一部分作为一个独立的用户群SQL Server。如果你不是会员,现在加入和参与,它是免费的http://www.sqlpass.org。凯西的主旨是,SQL Server的总经理在微软商业智能解决方案。 He outlined the new Self-Service BI solution in Office 2010, Sharepoint 2010 and SQL Server 2008 R2. Amir Netz gave a demo of Excel 2010 with PowerPivot, the new Add-In and showed the 100 million rows demo that is now famous. The secret is in the column compression ("Vertipaq") that limits the local file to 133 MB in this case and allows sub-second sorting and filtering. The output is impressive especially using SharePoint 2010, SilverLight 3.0 and a touch-screen on the Business Analysts machine. Excellent visualization especially with the new Carousel view that looks like a 3D Rolodex online. Very cool. Next session was "DBA's behaving badly...Worst Practices" by Rod Colledge. Instead of walking through best practices, Rod gave us the other side of the coin which we have all experienced and hopefully, have learned to avoid. Rod volunteered to proof-read the MVP Deep Dives book mentioned above, so he deserves a lot of credit for that thankless job. After lunch and the book signing, I attended Louis Davidson's session on Database Design. As always, Louis made it entertaining and funny, as well as informative. Normalization and Denormalization. I liked the slide in the middle entitled "Brief Laugh Break...". Everyone did laugh. I will have to use that idea. I then took a break and experimented with the PowerPivot feature of SQL Server 2008 R2 and Excel 2010 in the Microsoft lab room. It was a nice way to escape the hubub of the conference while still focusing on technology. The best was saved for last with Buck Woody from Microsoft on the Data Collector and Policy Based Management for monitoring SQL Servers. Not only technically detailed but also hilarious. If you have ever attended a presentation by Buck, you will know what I mean. If you haven't, make sure you do in the future. After answering a question on Facets and why you would use the @ID property instead of the @Name property, Buck just turned around and said "Look, if we didn't have it, you'd want it so we put it in!". You had to be there. His irreverent style encourages some ribbing from the audience too - "How long did it take to come up with that awful shade of green for your screen background?" was one question. "That's your last question" was Buck's reply. I am looking forward to the Microsoft party tonight at GameWorks in downtown Seattle where we can hang out with 2000 new friends. Should be fun. cheers Brian