SQL Server 2017: Unpublished Gems

SQL Server 2017

Sneaky, sneaky, sneaky

Release notes never seem to tell the full story, do they?

At some point, you have to take matters into your own hands and go hunting for, as Paul Harvey would say, “The Rest Of The Story”.

So what did I find?

New stuff! Brand. New. Stuff. For you. If you ever upgrade, lazybones.

This the full list of new stuff.


I’m not going to talk about all of them, just a few that I find interesting. Hint: you’re not going to learn anything about Linux.


What have we here?



Of particular interest are last_sql_handle, query_hash, and query_plan_hash. It appears that we’ll finally be able to easily tie missing index requests to their queries, without doing a lot of painful XML processing. I had planned on adding something like this, but couldn’t find a good fit between 1) adding XML processing to sp_BlitzIndex, or adding more DMV queries and rather unpleasant XML processing to sp_BlitzCache. This will make implementing it far easier, assuming it works the way it looks like it will work.


Up next is a new function called fn_full_dblog. This apparently makes querying fn_dump_dblog easier, and hopefully more bug-free.

I wouldn’t want to remember all that, either.


Has a bunch of new columns that tell you about ColumnStore index access. You know, if you’re into that sort of thing.

Hey sailor.

Bright and shiny

All this new stuff, and we’re only on CTP 2. I can’t wait to see what gets added between now and release day.

Thanks for reading!

Previous Post
SQL Server 2017: Quick Rundown
Next Post
SQL Server 2017: query_store_wait_stats

Leave a Reply

Your email address will not be published.

Fill out this field
Fill out this field
Please enter a valid email address.