Leon Yue questions

Leon Yue answers

• Can I use special characters in column name in SQL Server and C# data table
• MERGE data in a Dataflow of Azure Data Factory into an existing table
• How to create an Azure SQL Database user who can CREATE/ALTER/DROP views but not tables, can read data but not INSERT/UPDATE/DELETE/TRUNCATE data?
• Reference to database and/or server name is not supported in this version of SQL Server
• Azure Data Studio - Setting SQL variables to be used as globals
• Need to know the number of concurrent connections allowed in Azure SQL Database
• CXSYNC_PORT wait type in Azure Sql Database
• Connect to Azure SQL in Python with MFA Active Directory Interactive Authentication without using Microsoft.IdentityModel.Clients.ActiveDirectory dll
• Why does Azure Data Factory seemingly insist on inserting DateTimes as string?
• Can we import SQL bacpac file in existing DB