Context: Linux SQL Docker containers don't support FileStreams, so this is a no-go the Database I wish to restore (which uses Varbinaries) we're trying to remove them, but short term, we need to keep them and can't lose the data…
I'm working with C# and ASP.NET Core 7. I'm triying to get the hashed password from my database to verify a login request. The problem is that the value "storedPasswordHash" is always the same no matter the userId is passed.…
I've been learning about the aforementioned things in a university course all about database management, but I'm a bit confused by the details of what all these things actually mean, so I was hoping to just write down my interpretation…
I would like to format the json file shown below into a table. I get the json file from an REST-API. I already tried to resolve it with OPENJSON and CROSS APPLYS but without success. There I get only zero…
I have a .NET application that’s trying to connect to a SQL Server instance running in a Docker container. I’m using Docker Compose to manage my services, which include my .NET application and SQL Server. Here’s the relevant part of…
How do I sum the count of populated fields. An example of the data. The desired output would be. This is what I have managed so far. select m.project_ref, ( select count(*) from (values (m.[EWI/IWI]), (m.Glazing), (m.Solar), (m.CWI), (m.Boiler), (m.TRV),…
I'm trying to manually update a SQL Server column of type nvarchar(max) with a huge JSON parsed as text. It's a simple, straightforward query: UPDATE Books SET Story = '' WHERE Id = 23 The problem happens when the JSON…
I have a table named Report_Table in Azure SQL. It has more than one hundred columns. I will give an example with 3 columns like: +--------+----------+------+ | job_id | rep_pm | done | +--------+----------+------+ | 46 | a002 | a…
I'm trying to configure an application deployed to Wildfly 23 to connect to Azure SQL using managed identity and struggle to visualise how it is supposed to work in principle. There are tons of articles and how-to in the internet…
I have to develop a Laravel application based on Microsoft Sql Server, so I started configuring a Docker ambient with an Sql Server on Linux container. Actually I'm working on my windows 10 laptop where I installed Docker Desktop. Here…