Articles by Tag #sqlserver
Browse our collection of articles on various topics related to IT technologies. Dive in and explore something new!
Geographic in Zync: PostGIS-Inspired Spatial Utilities for SQL Server
Geographic in Zync: PostGIS-Inspired Spatial Utilities for SQL Server Zync is a...
🚀 Building Truly Resilient SQL Server Applications in .NET
Introduction Modern enterprise systems rarely fail because of code — they fail because of...
🧱 Lesson 4 - Adding SQL Server Support (Multi-Database Setup)
Series: From Code to Cloud: Building a Production-Ready .NET Application By: Farrukh Rehman - Senior...
Cómo solucioné el error “The property 'ParameterName' contains invalid characters” en SSIS
Introducción Mientras trabajaba con proyectos de Integration Services (SSIS) en SQL Server...
The Ultimate SQL Server Cron Expression Validator — Fast, Accurate, Battle-Tested
🚀 The Ultimate SQL Server Cron Expression Validator — Fast, Accurate,...
How AI Helped a Developer Master SQL Server Performance Optimization Without DBA Training
Learn how AI assistance transformed a backend developer into someone capable of handling complex SQL...
Getting Started with Database Migrations using FluentMigrator
Why Your Database Schema Deserves Version Control Your code is tracked, reviewed, and...
Pasos para Crear una Nueva Instancia de SQL Server
Crear una instancia en SQL Server 2022 se realiza a través del Asistente para la instalación (SQL...
HierarchyId in SQL Server and EF Core 8 - Modeling Hierarchical Data
Hierarchical data is everywhere—from product categories and organizational charts to nested comments...
SQL Server 2025 is Here!
SQL Server 2025 has been officially announced at Microsoft Ignite 2025 and is now generally...
Desplegando una Base de Datos de Fontanería con SQL Server: Tablas, Vistas y Lógica de Negocio
Aquí podéis encontrar los SQL de la base de...
Understanding Database Normalization
In the world of data management, database normalization is one of the most crucial yet misunderstood...
Solving a DBMS Assignment on Oracle Live SQL: Transactions, Deadlocks & Log-Based Recovery
For a recent database management systems (DBMS) assignment, I had to demonstrate key concepts like...
SSIS - Send HTML Email from SSIS Job using DTSX package
When you are working in automating the reports you often require sending the result sets as part of...
Working with the SQL STUFF Function in SQL Server
Manipulating strings in SQL Server often involves cleaning data or formatting results. The STUFF...
Find the difference
1)SELECT COUNT(*) FROM Employee; 2)SELECT COUNT(ManagerId) FROM Employee; First statement counts all...
Optimistic vs. Pessimistic Concurrency in EF Core (with Table Hints)
Many experienced developers are familiar with database transactions but often overlook the key...
From 14TB to 700GB: Optimizing Database Storage for Real-Time Monitoring
🔍 TL;DR Learn how WaterBridge's 3-person engineering team uses TimescaleDB to ingest, monitor, and...
Message Queue in MS SQL
SQL Server Service Broker (SSB) is a powerful messaging framework built directly into Microsoft SQL...
🧠 SQL for Beginners: The 10 Most Common Queries Explained
If you’re just getting started with SQL (Structured Query Language), you’re learning one of the most...
SQL Server 2025 - What’s New and How to Visualize the Schema
What's New in SQL Server 2025 SQL Server 2025 brings several important updates that make...
Recovery of Microsoft Dynamics NAV 2002 R2 and SQL Server
Recovery of Microsoft Dynamics NAV 2009 R2 and SQL Server 🇪🇸 Leer este post en...
How to Document SQL Server Schemas Visually in 2025
Working with SQL Server, you usually get great performance and solid tools, but documenting the...
SQL in CouchDB: Get SQS for FREE and Celebrate Our Birthday
Working with CouchDB is a joy for many developers, something we’re reading again and again in this...
Recuperación de Microsoft Dynamics NAV 2009 R2 y SQL Server en Windows Server 2022
📝 Recuperación de Microsoft Dynamics NAV 2009 R2 y SQL Server 🇬🇧 Also read this post in...
Mastering Dynamic SQL Operations with the Strategy Pattern: Generate and Execute Commands Across Databases in C#
Introduction In this exercise, we build upon the previous implementation by adding the...
SQL parameterization
1) Plain-language definition & core idea A parameterized query is a SQL statement...
Why I Ditched SSMS for VS Code's MSSQL Extension (And Never Looked Back)
Three months ago, I discovered a tool that completely transformed my SQL workflow. Here's my brutally...
Optimisation SQL Server : Vues, Procédures Stockées et Index
En entreprise, une requête lente peut coûter cher !!🔴 🔑 Les 3 Clés de l'Optimisation ...
🧐 What is Write Ahead Logging 📝🗂️ (WAL)
Write-Ahead Logging (WAL) is a standard technique in databases to ensure data integrity and...