Leon Yue questions

Leon Yue answers

• SSMS "Windows logins are not supported in this version of SQL Server"
• 'dbo' user should not be used for normal service operation
• Does Azure Data Factory (ADF) support linked service Azure Cosmos DB (Table API)?
• How to use SQL Server Profiler with an Azure SQL Server with AAD integrated security where AAD user is different from logged in desktop account?
• Azure SQL Server cannot create database
• Concatenate values from 2 or more columns in a csv to single column in Azure Data Factory
• Cross Database Queries in Azure Synapse, Azure SQL Database, Azure Managed Instance and On Premise SQL Server
• Bringing incremental data in from REST APIs into SQL azure
• Unable to specify parameters to parameterized source data set in ADF data flow
• Azure SQL Single DB (Serverless) Autopause vs SSMS (SQL Server Management Studio)