I would like to use the COPY INTO statement to copy a table with it's column names from an external storage. Would like to achieve it using a generic procedure which can use for different tables. Here below you find…
I am trying to set up a connection between Azure MySQL flexible server and Azure SQL database mainly to read data from MySQL and store it in the SQL Server periodically (multiple times a day). I was thinking of creating…
I'm working on a Docker related application, written in C#, based on Entity Framework. One of the Docker containers, is the ms-sql-server, which is used for database access. In order to access the SQL-server, following connectionString is created: Server=ms-sql-server;Initial Catalog=Ownobjects;User…
When I run Invoke-Sqlcmd with a -Query that contains a password retrieved via Read-Host with the -AsSecureString parameter, and the value entered is too simple, it will fail without returning an exception. When I run Invoke-Sqlcmd with a -Query that…
I am trying to give a service principal SELECT access on my Azure Synapse SQL data. CREATE USER [MY_SERVICE_PRINCIPAL] FROM EXTERNAL PROVIDER WITH DEFAFULT_SCHEMA=[dbo] GO GRANT SELECT ON DATABASE :: MyDB TO [MY_SERVICE_PRINCIPAL]; This works fine, but it requires me…
We have a user facing web app powered by a SQL Server that allows users top update a table in our SQL Server that also needs to update a document record in our dynamo database table. How could I reliably…
Short Summary I am running multiple sql queries (each committed separately) within one session via pyodbc. In a few queries we call SET TRANSACTION ISOLATION LEVEL SNAPSHOT;, begin a transaction, do some work, commit the transaction and then call SET…
I have created an ASP.NET Core Web API app that connects to a SQL Server database. I have a table in which I need to use SQL Server always encryption. I'm creating a column master key with the following T-SQL:…
In SQL Server, I have an existing Document_Add stored procedure that works and returns a good DocID value (in Visual Studio vb code) and cannot change. Calling it like this in SQL: EXEC @DocID = PADS2.dbo.Document_Add @SystemCode... This runs the…
I have a Stored Procedure activity in my Azure Data Factory pipeline that recalls the following stored procedure on Azure Synapse: CREATE PROCEDURE schema.procedure_name @portafoglio INT [...] The activity in configured in order to use a variable (portafoglioElab), previously set…