亲爱的日记-第三天在SQL PASS峰会2009

在PASS的最后一天总是心情复杂，但正如他们所说的，“不要因为结束而哭泣，微笑吧，为你的曾经拥有。”说起来容易做起来难，当总统韦恩·斯奈德(Wayne Snyder)承认凯文·克莱恩(Kevin Kline) 10年来对PASS的领导做出了令人惊叹的贡献时，他都哽咽了。在西雅图，人们起立鼓掌。David DeWitt博士今年又回来做KeyNote演讲，深入研究了列式商店和列式商店。列存储技术是使用Office 2010和Sharepoint 2010在SQL Server 2008 R2的PowerPivot特性中启用“Vertipaq”的机制。Excel 2010中包含1亿行的次秒排序和过滤的演示非常令人印象深刻，David让我们深入了解了这项技术是如何发展的，并为SQL Server的未来提供了一些线索。巨大的东西。我与Lindsey Allen一起参加了关于整合和虚拟化的SQLCAT演示。本节主要关注SQL Server的Hyper-V虚拟化，但也强调了其他的整合方法。Windows 2008 Server R2 Hyper-V现在支持“实时迁移”功能，Lyndsey给我们展示了一个比我们在周二的KeyNote上看到的更详细的演示。 To see the Perfmon graph as one node takes over from another all while a SQL Script is running unhindered (ok, one blip of a second or so) is very cool. The Case Study used was that of Microsoft IT itself which had to consolidate 5,000 SQL Instances containing 100,000 databases. This time last year they had consolidated just 4 instances. Well, one year later, apparently all the servers have been consolidated with a 6:1 consolidation ratio using Hyper-V virtualization and an estimated savings of $12 million. Lunch was organised with local PASS chapters on separate tables so you could connect with your own local users. It was good to meet some folks from Raleigh, NC and talk about our relatively new chapter at http://www.TriPASS.org . BTW, good food all week too. After lunch, I ventured over to Brent Ozar's session on "Yes, I am actually using the Cloud". I knew very little about Cloud computing going into the presentation but Brent shared his immense experience in this area with honest and candid recommendations. "If I lose my MVP award after the conference, you'll know why..." as he discussed the recent shortcomings of SQL Azure. Brent compared the Cloud to where virtualization was 7 or 8 years ago and showed us how to use Amazon EC2, S3 and JungleDisk to host a SQL Server solution for just a few dollars per month. I was intrigued to find out that you could turn this into a revenue stream (well, at least cover your costs) if you provide links and visitors actually buy stuff from Amazon via your web site. Brent uses the cloud to host all the videos on the great web site http://sqlserverpedia.com for less than $50 per month so there's an application with real value. See http://www.brentozar.com/go/cloud for all the details. The last couple presentations flew by..."Madison Overview" with Jesse Fountain outlined the new SQL Server 2008 Parallel Data Warehouse and its support for 30TB databases and beyond. Each Microsoft product team seems to be trying to go for the Guiness book of records longest product names category. "Tweet if you prefer the name SQL * " said David DeWitt this morning... Finally, Gail Shaw gave us "Lies, Damned Lies and Statistics" which got us deep into index and column statistics, how they affect query plans and how to keep them updated. Or rather, how SQL Server sometimes does NOT always keep them updated, what to do about it and why. I am not sure if it is because of all the great information I have learnt or just the Microsoft party last night, but at the end of an awesome week I can certainly say with confidence "my brain hurts"...thanks to all that made this possible... cheers Brian