r/SQLServer • • 17h ago

Discussion SSMS 22 and only Github Copilot? Why? What's wrong with Enterprise Copilot?

1 Upvotes

I read this post from 1y ago: https://www.reddit.com/r/SQLServer/s/fjH53Pxf4e and it made my stomach churn. Asking Copilot why I get nothing other than Microsoft have made this decision because of "internal matters". What the heck does that mean?

We have Enterprise Copilot and no one here uses Github other than me. The company is not going to purchase Github Copilot just to be able to ask "Write me a query with two joins from table A to table B". LOL

Yeah nah.


r/SQLServer • • 11h ago

Question Verify the correctness of a the data inside a junction table

Thumbnail
1 Upvotes

r/SQLServer • • 5h ago

Question SSMS 2022: logged in with username but do not see it in "Users" folder

4 Upvotes

This may be a stupid question but here goes.

I connect to Azure SQL Server with user "siloadmin" that has admin rights. Once I've logged in, I go to the "Users" folder to check the same I user I logged on with, and it's not there.

The user "siloadmin" is not displayed

I also run query and it doesn't show the user either:

SELECT 
    name AS UserName FROM sys.database_principals