I saw a note from Microsoft recently that they are trying to improve some of the support experiences for customers that are going through their docs. The idea is to make it easier for a customer to get a rich code experience for troubleshooting or learning.
This is a preview feature, but here’s a quick look.
Full Transaction Logs
For some people, the transaction log gets full. Not for me, but it has happened in the past, and I’ve learned how to be proactive here. However, this topic might be the number one topic at SQLServerCentral over the years.
Microsoft has a docs article on troubleshooting a full transaction log. In the article, at the top, is a new button. You can see here, this will open a notebook in ADS.
When I click this, I get a security warning and do I want to open this with an app.
Then I get the app chooser:
Then ADS opens.
Well, kind of. I have to approve something else.
I appreciate secure computing and good practices, but this type of clicking again and again is going to get people to do the “run everything as sa” security mindset and start to always allow things to open.
In any case, I do get a notebook. The text is the text of the KB article, which is comprehensive.
The code is included, but I can run this case. Not cut/paste, not mess with, just connect to an instance and run it.
There are instructions for fixing things.
And there are options for how to solve different issues, some of which also have code.
To me, this is a great way to help customers quickly solve issues. I look forward to seeing how this goes, and how people use it. For now, I know there are two articles in preview, if you want to give this a try.