第1天在传递峰会2010 - CTP中的SQL Server“Denali”

来自48个不同国家的近4000人在西雅图聚集，标志着有史以来最受欢迎的传球峰会的开始。通过第一个主题演讲的第一个活跃的媒体更多地参加了数千人。英国通过章节为那些无法旅行的人进行了一场直播的会议。主题克斯特标志着年度会议的开始，将有191个发言者和44 MVP的开头。我们是第一个听到关于明天可用的新版SQL Server代码的“Denali”的新版本。很多一天。蒂娜特纳告诉我们，我们“简直是最好的”，其次是Raphabh Mehta，通过总裁，并标记Souza的Sqlcat，告诉我们。到Microsoft的高级副总裁泰德Kummert，我们开始相信它。在两者之间，我们出现了关于SQL 7.0“远离Sybase”的怀旧视频，这突出显示了Microsoft的大规模架构更改，为未来做准备。幸运的是，他们没有提醒我们6.5的升级。 Mr Kummert reminded us of the goals of SQL 7.0 and how they still apply to the current product. Ease of use, lower total cost of ownership and more than a database - an information platform. He covered three major areas: Mission Critical, the Cloud and the next release. Mission Critical: A quick demo of SQL Server 2008 R2 Parallel Data Warehouse edition by Jesse Fountain, Program Manager of PDW at Microsoft (formerly of DATAllegro ) using the box on stage with 40 appliance nodes, a 10TB Database and 800 billion rows of data returned in seconds. Customer Paulo Resende, Chief Architect at Bank of America, reiterated the power of the product. Dave Mariani, Yahoo VP of Development talked about their 12TB Cube and how it “ingests” 1.2TB of data per day giving less than 10 second query response times. The Cloud: New product code-named “Atlanta” built using Windows Azure and SQL Azure was announced as a “configuration assessment tool” in the cloud available now in CTP. The idea is that your SQL Server 2008 configuration information is uploaded securely to the cloud on a daily basis allowing Atlanta to pass back potential diagnosis information. Bob Ward, Principal Engineer at Microsoft CSS, showed us how to solve the common SSPI Security Context error using Atlanta’s change history feature. The culprit was shown as a service account change made three days earlier. Adam Wilson, Program Manager of SQL Azure showed us working with data in the cloud by developing reports as we normally do, using Report Builder, but with a provider and connection string pointing to a database in the cloud. He also showed us how to use an OData URL to consume any data in the cloud. The Next Release: Finally, what we were waiting for was the announcement of the next release of SQL Server. Code-named “Denali”, the first CTP will be handed out after tomorrow’s keynote speech. Its three areas of focus are: mission critical, IT/developer productivity and pervasive insight. Amir Netz, Distinguished Engineer at Microsoft stole the show with a great demo of Project Crescent which will extend the very popular user interface of PowerPivot in Office 2010, into Denali’s Business Intelligence Development Studio. The column store compression engine used with PowerPivot, named VertiPaq, will also be included in Denali’s Relational Engine and Analysis Services. This is great news as PowerPivot shows great potential but relies on client-side computing. Now we can have the same UI and performance features on the server-side. Excellent news. Amir showed us the PowerPivot “100 million rows” spreadsheet demo as “wicked fast” followed by the new Denali version of BIDS with 2 billion rows accessed instantly as the “engine of the devil!”. With everyone wondering if Microsoft was really going to embrace this line of Halloween marketing, Amir’s next demo showed Denali’s new Report Designer, accessing several billions of rows again in seconds. “That’s trillions of rows per minute, true to God, not the devil!”. Nice save. So it looks like we will be getting SQL Server 2011 after all. Or will it be known simply as SQL 11.0? Just Denali for now. Watch this space. Cheers Brian