Leon Yue questions

Leon Yue answers

• Best way to copy an Azure SQL Server database with encrypted columns from one subscription to another
• Transforming data type in Azure Data Factory
• pyodbc will support connecting to an Azure SQL DB using the AD access token instead of user/password?
• The length of execution ouput is over limit (around 1M currently) in azure adf webactivity rest api
• How to create a contained database and user in azure sql
• How to copy all files and folders in specific directory using azure data factory
• 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