My last post was about the
new adaptive query processing family of features coming to SQL Server. It’s
first introduction is the Memory Grant Feedback functionality now added to our
execution plans…all good stuff I promise you.
You can enable this functionality now if you have the CTP1 ofSQL Server vNext. You read that right, this new technology is there for you to
play with right now over at the evaluation centre!
That isn’t all there is to it either; amongst other
things you can now scale out Integration Services
meaning you can execute packages over multiple machines using a master/worker(s) scenario. I really like this
having been in situations previously where this kind of functionality would
have been really useful!
SQL Server is changing (would evolving be OTT?) and
getting on your hands on the CTP (and its future editions) is a must. Personally, I'm getting other teams involved (we are in DevOps era right?) and getting heads together on how we can use the new technology and take advantage of it. Seriously! It's a really innovative time for SQL Server and personally I don't think there is a better time to be working with the product.
No comments:
Post a Comment