The Recording
The Panelists
- Kevin Feasel
- Mike Chrestensen
Notes: Questions and Topics
ggsql: The Grammar of Graphics for SQL
Our first topic of the night came from Mala, who couldn’t make it this evening. The people behind ggplot2 (implementing the Grammar of Graphics for R) have come out with a SQL variant called ggsql. It’s still pretty early on in development, but it does look promising.
DROP USER and EXTERNAL MODEL Permissions in SQL Server
Our next topic comes from Andreas Wolter and deals with a permissions bug in SQL Server. To me, it looks like certain permissions get cached (or maybe not cleaned up correctly) and can lead to people having a bit more access to specific external models than you’d think.
Group Managed Service Accounts
The third topic was a blog post from Randy Knight on Group Managed Service Accounts (gMSAs). These have been around for quite a while, but they’re definitely worth pointing out to DBAs working on-premises or outside of Azure.
SQL MCP Server
The final topic also came from Mala and covers SQL Server’s MCP offering. Jerry Nixon describes using the Data API Builder (DAB) to serve as a database intermediary, so that you don’t offer up direct database access to a language model.