In this post, we will see how to search for objects in our SQL server databases, using a simple Stored Procedure called SearchInAll.In the world of database management, searching through various database objects for specific text can be a tough task, especially in large and complex databases. Whether it’s for debugging, auditing, or just general… Read More: SQL Server – How to Search for Objects in a… »
In this post, we will see the ACID properties and how we can implement it using C#.But first of all: what is ACID?ACID is an acronym that stands for Atomicity, Consistency, Isolation, and Durability. It’s a set of properties that databases strive to achieve to guarantee that database transactions are reliable, even in the face… Read More: C# – ACID properties in Database Management »
In this post, we will see how to save a Stored Procedure result into a temporary table.We remember that Temporary tables are tables that exist temporarily on SQL Server and, they are used to store result that need to be elaborate. We start creating a database called TestBlog where, we will add two tables called… Read More: SQL Server – How to save Stored Procedure result into… »
In this post, we will see how to fix a possible error of connection that we could have trying to connect at SQL Server using TCP/IP.For this post, I have installed SQL Server 2019 Express edition and SQL Server Management Studio.I have created a password for the sa user and I can connect using all… Read More: SQL Server – TCP/IP error connection »
In this post, we will see how to create and manage a Temporal Table in Sql Server.But first of all, what is a Temporal Table?From Microsoft web site:“Temporal tables (also known as system-versioned temporal tables) are a database feature that brings built-in support for providing information about data stored in the table at any point… Read More: SQL Server – Temporal Table »
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: SQL Server – Common Table Expression »
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: Docker – How to run SQL Server in a Docker… »
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: Docker – Web API and Sql Server »
In this post, we will see how to create an Azure SQL Database using the Azure portal. We open a browser, go to https://portal.azure.com, select “Create a resource” and we choose “SQL Database”: The first things we have to set are:Resource GroupDatabase NameServer Then, we have to set some Networking parameters: Finally, we review everything… Read More: Azure – How to create an Azure SQL Database »