SQL and databases

Import Azure SQL Database to a local SQL instance

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»

SQL and databases

Create backup of Azure SQL 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. Read more»

SQL and databases

Check if table exists in MS SQL database

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»

SQL and databases

Feed uniqueidentifier field with Random GUID value in SQL

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»

SQL and databases

T-SQL tips: Replace function example

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»

SQL and databases

Select the rows between 2 dates in MS SQL table

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»

SQL and databases

ID numbers dramatically increased with MS SQL in Docker

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»

SQL and databases

Popular Posts