SQL Notebooks rendering HTML output

[ervinte]

SQL Notebooks in Azure Data Studio have become invaluable to my workflow.

It took 5 hours of command line hell to figure out how to get them to work in VS Code. It turns out that you apparently have to uninstall the MSSQL extension and re-install to get the SQL Kernel to show up in Notebooks.

After all that time, the output looks like this.

Completely useless as I routinely copy data into Excel and need a tabular format to do so. Instead I get this:

<table><thead><tr><td><span>Category</span></td><td><span>State</span></td><td><span>#</span></td></tr></thead><tbody><tr><td>New</td><td>Active</td><td><div class="dni-plaintext"><pre>81</pre></div></td></tr><tr><td>Used</td><td>Active</td><td><div class="dni-plaintext"><pre>38</pre></div></td></tr><tr><td>Used</td><td>On Hold</td><td><div class="dni-plaintext"><pre>10</pre></div></td></tr><tr><td>Used</td><td>Wholesale - On Hold</td><td><div class="dni-plaintext"><pre>6</pre></div></td></tr></tbody></table><style>
.dni-code-hint {
    font-style: italic;
    overflow: hidden;
    white-space: nowrap;
}
.dni-treeview {
    white-space: nowrap;
}
.dni-treeview td {
    vertical-align: top;
    text-align: start;
}
details.dni-treeview {
    padding-left: 1em;
}
table td {
    text-align: start;
}
table tr { 
    vertical-align: top; 
    margin: 0em 0px;
}
table tr td pre 
{ 
    vertical-align: top !important; 
    margin: 0em 0px !important;
} 
table th {
    text-align: start;
}
</style>

Not to mention I benefit greatly from the ability to sort and filter the result table on the fly.

You will have to pry Azure Data Studio from my cold dead hands if this is what the end result is gonna be.

[cssuh]

https://learn.microsoft.com/en-us/azure-data-studio/whats-happening-azure-data-studio#recommended-alternatives-for-sql-server-capabilities-in-azure-data-studio
Hi @ervinte, here is a link to the recommended alternatives for ADS. Hopefully this helps!

[ervinte]

Now it simply doesn’t work at all. I didn’t change a thing.

Error: Microsoft.DotNet.Interactive.NoSuitableKernelException: No handler registered on kernel sql-Alpha for command: SubmitCode: USE Admin ... at Microsoft.DotNet.Interactive.Commands.KernelCommand.InvokeAsync(KernelInvocationContext context) in D:\a\_work\1\s\src\Microsoft.DotNet.Interactive\Commands\KernelCommand.cs:line 188 at Microsoft.DotNet.Interactive.Kernel.HandleAsync(KernelCommand command, KernelInvocationContext context) in D:\a\_work\1\s\src\Microsoft.DotNet.Interactive\Kernel.cs:line 365 at Microsoft.DotNet.Interactive.CompositeKernel.HandleAsync(KernelCommand command, KernelInvocationContext context) in D:\a\_work\1\s\src\Microsoft.DotNet.Interactive\CompositeKernel.cs:line 216 at Microsoft.DotNet.Interactive.KernelCommandPipeline.<BuildPipeline>b__6_0(KernelCommand command, KernelInvocationContext context, KernelPipelineContinuation _) in D:\a\_work\1\s\src\Microsoft.DotNet.Interactive\KernelCommandPipeline.cs:line 60 at Microsoft.DotNet.Interactive.KernelCommandPipeline.<>c__DisplayClass6_1.<<BuildPipeline>b__3>d.MoveNext() in D:\a\_work\1\s\src\Microsoft.DotNet.Interactive\KernelCommandPipeline.cs:line 75 --- End of stack trace from previous location --- at Microsoft.DotNet.Interactive.App.KernelExtensions.<>c__DisplayClass6_0.<<UseTelemetrySender>b__0>d.MoveNext() in D:\a\_work\1\s\src\dotnet-interactive\KernelExtensions.cs:line 457 --- End of stack trace from previous location --- at Microsoft.DotNet.Interactive.KernelCommandPipeline.<>c__DisplayClass6_1.<<BuildPipeline>b__3>d.MoveNext() in D:\a\_work\1\s\src\Microsoft.DotNet.Interactive\KernelCommandPipeline.cs:line 75 --- End of stack trace from previous location --- at Microsoft.DotNet.Interactive.App.KernelExtensionLoader.<>c__DisplayClass0_0.<<UseNuGetExtensions>b__0>d.MoveNext() in D:\a\_work\1\s\src\dotnet-interactive\KernelExtensionLoader.cs:line 25 --- End of stack trace from previous location --- at Microsoft.DotNet.Interactive.KernelCommandPipeline.<>c__DisplayClass6_1.<<BuildPipeline>b__3>d.MoveNext() in D:\a\_work\1\s\src\Microsoft.DotNet.Interactive\KernelCommandPipeline.cs:line 75 --- End of stack trace from previous location --- at Microsoft.DotNet.Interactive.App.KernelExtensions.<>c__DisplayClass5_0.<<UseSecretManager>b__0>d.MoveNext() in D:\a\_work\1\s\src\dotnet-interactive\KernelExtensions.cs:line 388 --- End of stack trace from previous location --- at Microsoft.DotNet.Interactive.KernelCommandPipeline.<>c__DisplayClass6_0.<<BuildPipeline>g__Combine|2>d.MoveNext() in D:\a\_work\1\s\src\Microsoft.DotNet.Interactive\KernelCommandPipeline.cs:line 73 --- End of stack trace from previous location --- at Microsoft.DotNet.Interactive.KernelCommandPipeline.<>c__DisplayClass6_0.<<BuildPipeline>g__Combine|2>d.MoveNext() in D:\a\_work\1\s\src\Microsoft.DotNet.Interactive\KernelCommandPipeline.cs:line 73 --- End of stack trace from previous location --- at Microsoft.DotNet.Interactive.KernelCommandPipeline.<>c__DisplayClass6_0.<<BuildPipeline>g__Combine|2>d.MoveNext() in D:\a\_work\1\s\src\Microsoft.DotNet.Interactive\KernelCommandPipeline.cs:line 73 --- End of stack trace from previous location --- at Microsoft.DotNet.Interactive.KernelCommandPipeline.SendAsync(KernelCommand command, KernelInvocationContext context) in D:\a\_work\1\s\src\Microsoft.DotNet.Interactive\KernelCommandPipeline.cs:line 41

[ervinte]

^^Apparently you have to waste cells to create the “cell kernel” every time you want to use a notebook. This is ugly and obnoxious for me who creates 100s of copies of a template, 1 cell for notekeeping and 1 for running a stored procedure.

I’m sure there are plenty of others like me who aren’t 1337 coders and just want something that works, like Azure Data Studio. Instead, every wrong step results in a 1,000 line stack trace.

Oh, and it’s still rendering in HTML. The text/csv “mimetype” whatever that is says not available.

At my wit’s end, VS Code as an Azure Data Studio replacement is so not ready for primetime.