岩石方格呢裙

现在是PASS 2011的第二天，毫无疑问，这是峰会最精彩的一天。这不仅是我们midnightdba赞助的活动的第二天，也是正式的方格呢裙日。几年前，有些人在第二天就开始穿方格呢短裙，这很流行，所以现在我们很多人都这样做。我记得我第一次听到这个消息的时候，我真的以为他们只是想看看能不能让我穿着裙子出现。所以第一次的时候我真的很紧张，但是有很多人都穿着苏格兰短裙，所以我绝对不是在开玩笑。而现在，那些不穿方格呢裙的人被驱逐了。但这正是我喜欢这次峰会的原因之一。社区太酷了，我们是一群非常亲密的朋友，我们的圈子一直在扩大。我昨天谈到了第一个新手项目，我们已经从这个项目中得到了一些新朋友。这些家伙以前没来过这里真是太神奇了因为他们适应得很好。 I also blogged about the keynote yesterday on my DBARant blog.你可以在这里看到那篇文章。现在，他们昨天宣布了SQL Server 2012(新的官方名称)的截止日期，你可以在上面的链接读到。就像我说的，我现在在主题演讲的博主桌边我们今天应该有很多Denali的演示。所以这个版本最大的新特性可能是AlwaysOn。这是他们新的HADR策略，它允许一个可读的镜像。目前，我们看到的演示版本与之前的100次相同，但这是一种很好的技术。不过，我真的希望他们能为这些大型演讲提供一些新的、更令人印象深刻的演示。他们在AlwaysOn上做演讲，每个人都在为他们使用zoomIt鼓掌，这说明了什么呢?下一个演示是关于列存储的。不，等等，看起来他只是想提一下。也许他会在一分钟内把人拉出来，但看起来不像。 Ok, I stand corrected... we're getting our column store demo, and frankly, I've seen it demoed a couple times but never from the front end. It's an excellent feature that you won't be able to use for OLTP, but you'll be able to add it to your warehouse for your star queries. This is just v.1 so they'll be expanding the offering in the future. So anyway, column store, if done right, can speed your star queries by 10x. I don't think it'll do me much good in my current gig, but I love it and I really wish I could use it. In the demo, the report went from 45secs to .3secs. Good stuff that. I also like the new data alerts. You can set it up so that whenever you get a condition met in a table, you can get an alert via email (and other methods) that tells you about it. That's not only useful for the business, but also for IT. I can easily see a scenario where we setup data alerts on some of our DMVs that notifies us when certain performance metrics get out of whack. Now they're moving on to appliances, and frankly I'm just not that interested in appliances so I'll let someone else write about that. That's it for now.