If you attended Microsoft Ignite in Chicago this week, you’re probably barely keeping your eyes open at this point. There’s been so many after-hours get-togethers, and it’s been tough to get any spare time between sessions. (Jeez, these things are spread out all over McCormick.)
One of the things I love about Ignite is that the videos and presentations are available during the conference itself. That makes it easy to catch up on the sessions I wasn’t able to attend, and then I can go talk to the presenters with my questions the next day.
I realized I should turn my session notes into a slide deck, and give it away. I’ll update it a couple more times this week as more sessions finish.
Attendees – you can go back to the office, and run through this deck as a lunch-and-learn with your coworkers who couldn’t go. This way, your boss will be more likely to send you back next year because you were such a good note-taker.
User group leaders – you can use this as a quick intro for your chapter, before your next meeting, to get ’em up to speed fast on SQL Server 2016.
This deck is licensed in the public domain, meaning you can do anything you want with it. Enjoy!
15 Comments. Leave new
Blocked at my workplace. Brilliant.
Wait! I wanted to watch Brent tune some servers! That’s not public domain? Shoot!
Michael – indeed, it will be online on http://ignite.microsoft.com tomorrow morning!
Thank you! So many easily accessible new features make 2016 a really attractive product.
Howard – yeah, I have to say Microsoft’s putting a lot of work into this release.
Thank you very much for sharing, Brent. Many more exciting features ahead!
You give arguably the best session, that it was the funniest is unarguable.
Now this.
Thanks for helping us DBA’s to look good.
Rade – awwww, thanks! My pleasure.
Dynamic Data Masking and Always Encrypted are two features my current employer will be very interested in. Great summary!
What?! Still no talk of…?
1. Passing handles to tables in/out of functions and sprocs? (such that the data is read/write)
2. Performant functions (UDFs have some bad side-effects)
3. Declare variable types by referencing a table column (like Oracle has had for years)
4. Lock-order hints (or just force Sql to always acquire index-locks in the same order during updates, even though it means it may have to release/downgrade locks it already holds in order to re-aquire in a non-deadlocking order)
(Yes, I know, add your fave to the list… 🙂
Granger – interesting ideas! Can you point me to your requests at http://connect.microsoft.com and I’ll go vote those up?
I thought so too. 🙂 Though I’m not in a spot to enter and evangelize my own “Connect” tickets. Here’s the ones I found that appear to be “the ones”:
1. https://connect.microsoft.com/SQLServer/feedback/details/299296/relax-restriction-that-table-parameters-must-be-readonly-when-sps-call-each-other
2. https://connect.microsoft.com/SQLServer/feedback/details/524983/user-defined-function-performance-is-unacceptable
3. https://connect.microsoft.com/SQLServer/feedback/details/520497/implement-equivalent-of-oracles-rowtype-attribute
4. https://connect.microsoft.com/SQLServer/feedback/details/436409/avoid-unexpected-deadlocks-when-using-server-side-scroll-locks-cursors
OK, #4 actually doesn’t have anything exactly. I expect it would be a “wontfix” because the new way forward is Snapshot Isolation. And I don’t have time to invent a good example and adequate instructions for reproduction of the situation I see under high load.
I would be remiss to again omit my opinion that the Sql Server team is doing good work to improve the product. Too bad for me that the new features aren’t compelling for my use-cases and Enterprise Edition is beyond my reach.
Great! I upvoted those (except for #4, because like you noted, it isn’t really a high priority and doesn’t make sense for most shops.) Good luck!
Awesome presentation! I can already see a use for the column store indexes on our 2012 data warehouse machine. Thanks for always sharing the wealth!
Tomorrow will do a presentation at the office about tsql tunning and SQL2014 new features, this comes handy to add some more information to my slides. Thankfully, as I’m avid follower, I was already using all the tools you recommend 😉 and I also get the superpowers I always wanted… Thanks as usual Brent