Today I lost way too much time trying to understand why I couldn’t see data in a PostgreSQL database running inside a Docker container. I was connected via DBeaver, everything looked fine: Read more»
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. Read more»
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. Read more»
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. Read more»
Once again experiments and tests. I added a new column to the existing table and needed to fill it with different values. Read more»
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. Read more»
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’. Read more»
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”. Read more»
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. Read more»
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. Read more»
