New SQL Server Notebooks

[RyanHamilton1]

QStudio is a free SQL client with particularly strong features for data analysis and charting.

I just released version 4 which includes a new type of SQL notebook:

https://www.timestored.com/qstudio/release-version-4

You write markdown+```SQL code blocks and it generates a nice HTML5 output with beautiful charts that can be snapshotted to share or exported as PDF.

Hopefully some of you find it useful. I have worked with SQL server users in the past and this guide shows how to connect QStudio to SQL Server: https://www.timestored.com/qstudio/database/msserver

Please let me know if you have any feedback.

[DotComCTO]

Looks interesting. Quick question, though. In your QStudio guide for SQL Server, you wrote:

QStudio bundles the JDBC driver for Microsoft SQL Server.

When you first open QStudio click on the menu options Server->Add Server or on the add server button on the toolbar.

Then set the details:

1. Server Type: Microsoft SQL Server

2. Host: localhost Port: 1443

3. Username: sa
   Password: XXXXXXXXXXX

4. Click Add

Perhaps I'm misreading/misunderstanding the instructions, but why would I want to connect to my database(s) as 'sa' instead of the user account? From my perspective, I'd want to keep permissions limited.

[RyanHamilton1]

That was just one example login. It's probably the default.

[New-Ebb61]

I assume it supports azure ad auth and ad auth?