I have an API in AWS that cannot connect to SQL Server (different EC2 instances) I am able to connect to the database using SSMS on my laptop, and the API is using the same connection string Both EC2 instances…
I have two different AWS servers for RDS instances. I want to restore db from one server to another, but can't since the backup is created on another server(which it belongs to). What is the best way to do this?…
I have a requirement, where I need to create a new data base in a azure SQL data base by opening a master connection. So for that I need to check if that user have the permission t create new…
This is my first CRUD app, and I am trying to determine the best way to implement a clean architecture to access the more than 20 tables I currently have in my database. I am using Dapper as I want…
I am playing around with Python in VS Code and I can't seem to connect my code to my SQL Server database. Any suggestions? Below is the code and the error message I get when I run the code. Code…
private void btnSubmit_Click(object sender, EventArgs e) { try { if (EmpIdTB.Text == "" || Empname.Text == "" || EmpPhone.Text == "") { MessageBox.Show("Missing Information"); } else { conn.Open(); string query = "UPDATE EMPTB SET EmpId='" + EmpIdTB.Text + "', EmpName='"…
I have AWS Lambda function that connects over a VPC into a privately hosted SQL Server database. I intermittently get this exception: Microsoft.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was…
This is my query: SELECT a.Id, a.Title, (SELECT m.Id, m.Name, m.MobileNo FROM [msm].[MsmMember] AS m WHERE m.Id = a.MemberId AND m.OrganizationId = @OrganizationId FOR JSON PATH, WITHOUT_ARRAY_WRAPPER) AS Member FROM msm.MsmArticleSubmission a WHERE a.OrganizationId = @OrganizationId AND a.Id = @Id…
My business requirement is to store lists of issues & responses as JSON data within a SQL Server 2019 table. Each list corresponds to a page within a document. At minimum, I'd like to be able to retrieve the GUID…
I am using Visual Studio 2022. I have 9 million XML files and need to transfer the data into SQL Server. I am reading in the XML through XmlDocument, Xmlnode list. It's working fine, but taking so much time to…