第二天2010 -德纳里峰通过峰会上宣布和可用…

是的,这是有史以来最大的通过峰会。你可以告诉的人试图让自动扶梯上得到楼下后主旨演讲。我们一直在谈论关于我们的数据库锁定和阻塞一周,这是一个人类白斑在我们眼前。主旨是出席会议并没有让人失望的更多细节在下一个版本的SQL Server代号为“德纳里峰”。后来,CTP1分发在CD。也许这创造了死锁。昆汀·克拉克,微软SQL Server的总经理指出,这是第一次宣布新产品版本和分布式会议。酷…微软已经强调了三个主要的主题德纳里峰功能:关键任务,开发人员的生产力和普遍的见解。Gopal Ashok,技术产品经理在微软,证明德纳里峰的主要新的关键任务功能命名为SQL Server“总是”,看起来像一个整洁的整合数据库镜像和日志传送。他展示了如何创建一个可用性组组成的多个数据库SQL Server,您希望保护。每个数据库可以有多达4二级数据库与每一个被指定的其他实例自动故障转移,手动故障转移或异步处理。 Any secondary database can now be marked to “Allow all connections” which allows up-to-date read-only access for load-balancing. There is also provided an “Always On Dashboard” for real-time monitoring. Much applause as the major limitations of Database Mirroring seem to be removed in the new release with an intuitive user interface to boot. Rohan Kumar, Principal Group Program Manager at Microsoft then demonstrated a new Denali feature called FileTable which extends the Filestream data feature in SQL Server 2008. Instead of defining individual columns for BLOB data to be stored external to the database now you can define a whole table as a FileTable which references a folder on the file system. The advantage here is that any application that stores files in NTFS can now populate that data in a table in SQL Server without any code changes needed. Rohan loaded document files through the command-line into a folder referenced by a FileTable and showed how the data could be immediately accessed through T-SQL using, for example, Full-Text Indexes. Being part of the database, FileTable supports normal transaction processing, backup, restore and security as you would expect. Don Box, Distinguished Engineer at Microsoft, showed us more about the new unified tool codenamed “Juneau” that will combine SSMS and BIDS through the VS 2010 Shell in the name of developer productivity. Having spent the last 5 years plus getting used to SSMS, Don assured us that the all the features of SSMS will be present in Juneau. We’ve heard that before, but he did show us some extra functionality that will be there. For instance, the Table Designer in SSMS is clunky at best and has been redesigned in Juneau. Now, as you make changes to the table graphically, a script window automatically shows the T-SQL changes. If you make changes to the script it will also show those updates in the graphic. It will also show any potential referential errors before you commit your work or, better, will allow you to save a change script for further testing. The new Import Database Wizard will generate all the object scripts for a database and conveniently bring them into a Visual Studio Project for version control. When opening a table script, the UI jumps straight into the Table Designer, showing graphic and code. Microsoft has listened that, yes, the User Interface can provide productivity but as techies we always want to see the actual code. Finally, Jeff Bernhart, Principal Product Unit Manager at Microsoft showed us some Pervasive Insight features (aka BI). We were shown already how the PowerPivot and VertiPaq technologies are being rolled into Denali. Excel will also have a direct link to Master Data Services for enterprise data consistency and “Single Source of Truth”. The new version of SSIS is more forgiving, we are told. The SSIS Dashboard will show deployed packages and their dependencies. The new Data Cleaning transform will make standardizing data easier. And yes, SSIS now has a fully functional Undo feature. Sometimes it’s surprising what gets the biggest applause! Cheers Brian