Activity overview
Latest activity by alastairs
Thanks Robyn, that's a shame. Does SQL Prompt in either SSMS or Visual Studio support External Resource definitions? / comments
Thanks Robyn, that's a shame. Does SQL Prompt in either SSMS or Visual Studio support External Resource definitions?
Does SQL Prompt support formatting External Resource definitions?
Hi thereI am using SQL Prompt 0.12.2 for Azure Data Studio with an SSDT project for Synapse Analytics. When viewing the script for any type of External Resource, SQL Prompt collapses the statement ...
I would also like to use SQL Clone (well, SQL Provision to be honest) with Azure SQL databases. It's a really common scenario in 2022 for databases to be deployed on a PaaS database. I run SQL Server in Docker on my dev machine, so I can't even install SQL Clone locally because of the requirement for Windows Authentication. Our databases--both our application service DBs and our data warehouses--are all deployed as Azure SQL databases. We use Azure Active Directory and Managed Service Identities to provide native access control. I was really disappointed to see that the "support" for Azure SQL databases is via a Windows VM. We operate within a highly-regulated industry with twice-yearly audits, and have no capacity for high-administration "pet" resources like this. / comments
I would also like to use SQL Clone (well, SQL Provision to be honest) with Azure SQL databases. It's a really common scenario in 2022 for databases to be deployed on a PaaS database. I run SQL Serv...
Raja's correct--or best of all would be a seamless into ADS like other extensions, and not via a zip file download. / comments
Raja's correct--or best of all would be a seamless into ADS like other extensions, and not via a zip file download.