To restore a backup of Azure backup database, that was created with sqlpackage utility, to your local instance of MS SQL (local instance, executed in docker) you should import this data to a database.

When you use Azure SQL Database, then you should understand, that it has something different from on-prem version. And you will find it only when you start to work with it.

I needed to check if the tables are in the database or not. Here is an example of the SQL query - it returns 1 if one of the tables exists and 0 if they do not exist.

Once again experiments and tests. I added a new column to the existing table and needed to fill it with different values.

I had to update the date values in the MSSQL database table for tests and demo. I needed to set random Dates from the specific range.

There's a data type 'uniqueidentifier' in SQL. If you need to feed this field with random value, you can use NEWID(). The 'uniqueidentifier' value in SQL looks like this: '234779E5-996F-45AC-90C3-21631AF4A08D'.

In the developer database (MS SQL Server) I had a field, in which all the values were the same. The value was "OldDoc.txt". I wanted to make values unique and for this I wanted to add "ID" before ".txt".

If you need to select the records between 2 dates in MS SQL, where the DateTime column contains both Date and Time, you can use SQL functions for WHERE clause and avoid of adding the time information like '23:59:59.000'. Though you can do it and this way.

I work with a WebApi project in Net.Core and MS SQL Database. MS SQL server is executed in Docker container. Suddenly I found out, that ID field value with autoincrement has increased from 2 to 1001.

Short manual how to execute MSSQL server in Docker in Windows 11. For linux there are the same steps but instead of PowerShell you should use terminal and don’t forget about sudo.