Dec 23, 2025 · 4 min read · Calling stored procedures in Entity Framework Core (EF Core) varies slightly depending on whether you are reading data (querying) or modifying data (executing a command) and which version of EF Core you are using. Here is a comprehensive guide coveri...
Join discussionOct 18, 2025 · 35 min read · SQL Basics What is SQL? SQL (Structured Query Language) is the standard language used to interact with relational databases. It allows you to create, read, update, and delete data (CRUD operations) efficiently. Key points: SQL is declarative, mean...
Join discussion
Oct 2, 2025 · 3 min read · Introdução Alterar a estrutura de uma tabela (renomear coluna, mudar tipo de dado, remover/adição de colunas, trocar schema, etc.) pode gerar problemas silenciosamente em views, stored procedures e funções. O problema costuma aparecer só em produção,...
Join discussion
Sep 6, 2025 · 3 min read · Creación de tabla, procedimientos almacenados y casos de prueba en SQL Server Fecha: 4 de septiembre Hora de inicio: 6:55 p.m. Hora de finalización: 11:45 p.m. 1. Creación de la tabla Empleado Durante esta sesión inicié creando la tabla Empleado...
Join discussionSep 1, 2025 · 20 min read · In this blog, we will understand distributed systems and the challenges that come while building them. Approaching Distributed Systems At its core, a distributed system takes multiple components running across multiple machines and orchestrates them ...
Join discussion
May 20, 2025 · 3 min read · The Alarming Metrics That Forced Our Hand We were facing a content engagement crisis:📉 68% bounce rate (visitors fleeing instantly)⏱️ 47-second average time on page (barely scanning headlines)😤 0.3% conversion rate (embarrassingly low) Then we swit...
Join discussionMay 8, 2025 · 2 min read · In the noisy world of ecommerce, where ad budgets and influencer partnerships usually dominate growth strategies, we took a different route — and it worked. We stopped running ads. We didn’t chase influencers. Instead, we trusted one tool: xBlog AI. ...
Join discussionMar 19, 2025 · 4 min read · Thrown into the Deep End I had just started my journey as an intern, excited but nervous. One of my initial tasks? Work on a project using Sequelize ORM with MySQL. Sounds simple, right? But then my senior told me: "Write all the business logic insi...
Join discussionFeb 26, 2025 · 2 min read · In traditional SQL-based systems like MySQL or SQL Server, stored procedures can return multiple table views in a single call. However, PostgreSQL does not support returning multiple result sets directly in the same way. Instead, PostgreSQL provides ...
Join discussion
Feb 6, 2025 · 5 min read · For years, stored procedures have been a go-to solution for handling business logic inside databases. They help automate tasks, improve performance, and ensure security. But as data systems grow more complex, stored procedures have started showing th...
Join discussion
