The sp_Blitz procedure from Brent Ozar's First Responder Kit checks the configuration and state of Microsoft SQL Servers and presents problems found in a tabular format. We like to use this procedure during the first contact with new customers to get a quick overview of their SQL Servers.
In 2022 I learned about the possibility to output the results in Markdown format. I would like to introduce this here, because it offers advantages - but unfortunately it also has disadvantages.
The advantages
In most cases, the customer runs the procedure in SQL Server Management Studio and copies the result to an Excel spreadsheet. However, the @OutputType parameter can also be used to generate the output in other formats, including an enumerated list in Markdown. This way the result can be quickly copied into a mail, because even without a markdown editor, such a bulleted list is very easy to read.
We can then very easily add further information to this list and prepare the list for the customer in this way, to then jointly tackle the problems relevant to the customer. In many cases, an enumerated list is also better suited for documentation purposes than a table.
The functionality
But beware: Unfortunately, only a look into the source code reveals the exact functionality since only a short documentation is available in the source code. Because with @OutputType = 'markdown' the following happens:
The parameter @CheckProcedureCache is set to 0, but this is also the default value for this parameter (source code).
The @CheckServerInfo parameter is set to 1, which outputs additional information such as the version used or the hardware equipment (source code).
However, the output does not contain any information about security aspects. It was introduced because this functionality was originally intended for quickly sharing information over a public channel on Slack, and such sensitive information should obviously not show up there (source code).
The disadvantages
Unfortunately, this means that this functionality is no longer suitable for a comprehensive look at the system. However, if only the most important problems are concerned, the parameter @IgnorePrioritiesAbove with the value 50 is used in most cases. This setting then also suppresses all security aspects anyway, so an output in Markdown no longer changes the content and can thus be used for a quick overview:
sp_Blitz @IgnorePrioritiesAbove = 50, @OutputType = 'markdown'
Note (November 2026): This is no longer true as written. When the article was published, every finding in the FindingsGroup "Security" had priority 230 and was therefore also suppressed by @IgnorePrioritiesAbove = 50. Meanwhile CheckIDs 258 to 261 ("Dangerous Service Account") are security findings with priority 1. The Markdown output does not filter on the priority but on FindingsGroup <> 'Security', so it still leaves those findings out even with @IgnorePrioritiesAbove = 50. Anyone relying on the Markdown output in this combination misses the hint about a service account being a member of the local administrators group.
My solution
There is of course the possibility to make the conversion from the classic table output to the Markdown format yourself, for example with PowerShell. How to install and run the First Responder Kit with the PowerShell module dbatools is described in my article Using the First Responder Kit with dbatools. I have programmed this and thereby added a few configuration options. You can find the script in my GitHub repository.
If you are interested, we can also adapt the script to your needs, feel free to contact us.