sql for mackbook

Question

Answer 1

Azure data studio uses the lastest SQL driver. The new default is to use ssl to encrypt the connection. Unless you bought a trusted cert for the sql server it is using a self signed cert that you must trust in the connection string.

you can just click on the trust button, or toggle the connection setting.

you can not alter a database if it in use. Just kill any connections, it might be the tool.

note: if you are not using sql authentication, than you will use Mac’s ticketviewer app to login and get a Kerberos token. Azure data studio or your code will use this ticket. Linux and Mac only support one user session per domain. thats why the login is global.

Answer 2

Answer 3

depends on if your MacBook is a M1/M2 or Intel. In both cases you use a docker image

if intel, use the linux docker image:

https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-ver16&pivots=cs1-bash

if M1/M2 then use azure sql edge arm64:

https://hub.docker.com/_/microsoft-azure-sql-edge

to access sql use azure data studio:

https://azure.microsoft.com/en-us/products/data-studio