How to parse the nested Json into a MS SQL Table? – Asp.net
I would like to parse this Json response file coming from a rest api to a MS SQL table in C# as I don't want to loop multiple times as the files could be big. I only need the nested…
How to create a rotational secret for SQL Server credentials in AWS? – Amazon web services
To Devs, How can I create rotational credentials for SQL Server in AWS? Any ideas? Thanks, Marc
Insert a line break in a SQL Server not working – Asp.net
example 1 declare @text VARCHAR(100) SET @text = 'this is the frist line' + CHAR(10)+CHAR(13) + 'Second line' select @text example 2 select 'This is line 1.' + CHAR(13)+CHAR(10) + 'This is line 2.' why is not it working? Not…
ImagePullBack pod status in Kubernetes when pulling public image (MS SQL Server Express) – Docker
I'm following Les Jackson's tutorial to microservices and got stuck at 05:30:00 while creating a deployment for a ms sql server. I've written the deployment file just as shown on the yt video: apiVersion: apps/v1 kind: Deployment metadata: name: mssql-depl…
Connect TO Online SQL Azure DB FROM On-Premise SQL Server SSRS
I try to connect FROM my ON-PREMISE SQL Server SSRS 2019 TO an Online Microsoft Azure SQL DB. It works fine, when I connect locally from my DBMS to the online DB. Yet everything is secured with MFA though. Unfortunately…
How to download sql server driver using azure dev ops/ pipelines
I am connecting to SQL server using the library pyodbc. I downloaded the driver locally using the following https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16. All my code now works and I want to run it on azure. Is there an azure pipeline task to download…
Do I mirror, replicate, copy, copy with sync, etc. my prod db in Azure to create another db to develop new features?
I've set up my website (app service) and database (Sql Server) in Azure. Right now it works like this: prod website -> prod database The prod website has connection strings to the prod database and all is good! What I…
MSSQL in Docker – Cannot bulk load. The file "@file" does not exist or you don't have file access rights
I am using Docker's MSSQL because I'm on Ubuntu 22.04. In the terminal, cat @filepath where @filepath is the absolute file path, works. So the file path exists, and I have file rights (don't need to sudo) How can I…
Why form dropdown items are sorted alphabetically? – Asp.net
Why do both SSMS and ASP.NET MVC dropdowns show the data I filled in a different order sorted alphabetically? I've added the "Other" option as the last and when I ask SSMS to show the table content I get it…
Azure – Group by and merge to a JSON record in SQL Server
I have rows in a table like this: ORG Tenant Dimension Count A T1 MAU 100 A T1 WAU 70 B T2 MAU 50 B T2 Retention 30 Now I need to group based on ORG, Tenant and remaining columns…