© 2023 Hashnode
#sql-server
Introduction GUID, or globally unique identifier, is a 128-bit value that is used to identify resources in a unique and consistent way. In Entity Framework Core (EF Core), a GUID can be used as the pr…
Or how I learned Spatial SQL in Microsoft SQL Server by teaching it to my team. Studies have shown time and time again that one of the most effective ways to learn a subject quickly is to study it wit…
INTRO In MySql database, data is stored within tables and there are many tables as per requirement. Within a table, with any data, we can do basic four operations. Like we can insert new data into a t…
in very simple words, it is nothing but a language to interact with data present in databases. Databases are spaces where we keep our data virtually. A database can be of several types depending on th…
I have a little sample app, that uses my generic repository library. I've recently upgraded both to DotNet7 [.Net7] and immediately hit an issue. I was getting the error: A connection was successfull…
SQL is the relational database management system (RDBMS) developed by Microsoft. This SQL certification program is to learn SQL Server to manage databases and various database operations, relocate databases to the Cloud, and scale-up databa…
ACID (Atomicity, Consistency, Isolation, Durability) is a set of properties that define the behavior of a SQL database. These properties ensure that database transactions are processed reliably and co…
I’m very excited to let you know that I have the distinct honour of having been asked to speak a SQL Bits in March 2023 in Wales. I will be talking about how you can integrate changes in your database…
En este articulo detallaré los pasos para tener respaldos automáticos de un servidor MS SQL 2017 y almacenarlos en un bucket de Backblaze. Plan de Mantenimiento Con esta funcionalidad disponible desde el Management Studio se puede configura…
Entity Framework Core or EFCore has an interceptor for various behavior and one such interceptor is DbTransactionInterceptor. This is a abstract class and to add custom functionality it can be inherited and extended as per application need.…