In this post, we will see how to use a Common Table Expression (CTE) in Sql Server.But first of all, what is a Common Table Expression?From Microsoft web site:“Specifies a temporary named result set, known as a common table expression (CTE). This is derived from a simple query and defined within the execution scope of… Read More »
In this post, we will see how to run SQL Server in a Docker container using a docker-compose file. We start opening VS Code and we create a file docker-compose.yaml where, we will add this code: [DOCKER-COMPOSE.YAML] I want to explain some rows:line 5 => we get latest version of mssqlline 7 => we define… Read More »
In this post, we will see how to create a Sql Server Db backup and save it into a Storage container, using Powershell. We will run a backup of the Db called dockertest and then, we will save it into a container called dbbackup. In order to create a complete backup, we will use a… Read More »
In this post, we will see how to connect a Docker Web API Solution with a SQL Server Database on premises and on Cloud. DB ON PREMISES From our system, we open SSMS, we create a DB called TestDocker1 and then we run some sql scripts, in order to create a table called TabUser and… Read More »