Articles by Tag #sqlserver
Browse our collection of articles on various topics related to IT technologies. Dive in and explore something new!
5 Essential SQL Skills Learned from a Decade of Experience
In my ten years of working with SQL, I've honed several critical skills that significantly enhance...
CRUD operations using Blazor Web App, Entity Framework and SQL Server
In this tutorial, we’ll explore how to do simple CRUD (Create, Read, Update, and Delete) Operations...
Building a Custom Logging Provider in ASP.NET Core
Logging is one of the most important parts in .NET ecosystem and any developer should interact with...
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...
The Book Nook: A Website Security Crisis
Once upon a time in the bustling digital city of Cyberspace, there was a small, quaint website called...
Employee Management System Using SQL
Introduction The Employee Management System is an SQL-based project that streamlines...
🧐 What is Write Ahead Logging 📝🗂️ (WAL)
Write-Ahead Logging (WAL) is a standard technique in databases to ensure data integrity and...
20 Livros sobre Linguagem SQL que você deveria ler
Na série #QueroLer de hoje conheceremos 20 livros de qualidade para aprender Linguagem SQL. Eles...
5 Steps to Secure Passwordless Azure SQL Connections Using Node.js
Passwordless Authentication for Azure SQL Using Microsoft Entra ID Introduction: In today’s digital...
SQL Server Database Design and Management in 2025 with a GUI Tool
If you’re working with SQL Server, you know how robust and reliable it is for managing and storing...
SQL Admin Scripts: A Practical Toolkit for Managing Servers and Databases
Effective database management relies on having the right tools to streamline tasks and ensure optimal...
Parallel Queries in EF Core with PostgreSQL: Why It Fails and How to Fix It
You may have faced an interesting error trying to run queries in parallel with EF Core and Postgres:...
The Power of OUTER APPLY: A SQL Weapon to Expand Legacy Database
Introduction In the world of SQL Server, maintaining and enhancing legacy stored...
Step-by-Step Guide: Easy Reporting 📋 with ClosedXML (Excel) and Database Views
'ClosedXML' allows you to create Excel files without installing the Excel. Here's a step-by-step...
How to Manage Your SQL Server Database Effectively
Managing an SQL Server database effectively is crucial for ensuring data integrity, security, and...
Part 8: SQL Injection Series - Advanced Prevention Techniques and Real-World Applications
Author: Trix Cyrus Waymap Pentesting tool: Click Here TrixSec Github: Click Here TrixSec Telegram:...
SQL(Structured Query Language) Road Map for beginners
How can I learn SQL all over again if I were to start over? During your early days of learning you...
Step-by-Step Guide: Querying From Databases Via a Single Database Helper Using the Strategy Design Pattern
This exercise allows you to get data from different databases (MySQL, PostgreSQL and SQL Server...)...
Connecting Azure SQL-Database and App Service using system-assigned identity
I had built an application using an Azure SQL-Database for storage and I wanted to upload it to Azure...
18 Key Points You Must Know When Creating Tables in MySQL
For backend developers, accessing a database is crucial. Core user data is usually stored securely...
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 ...
Unlocking SQL Server Performance – Namrata Hinduja’s Guide to Optimization
SQL Server is a powerful relational database management system, but like any complex software, its...
Postgres 🐘 vs. SQL Server: a Complete Comparison ⚖️ in 2025
This post is maintained by Bytebase, an open-source database DevSecOps tool that can manage both...
An E-Commerce Web Application
This repository contains an e-commerce web application built using SQL Server, EF, ASP. NET Core MVC,...
I am Learning SQL(mysql) in 2025.
Database & DBMS Type of DB, SQL & non-sql / (RDBMS vs NRDBMS) SQL Tables, Columns(schema),...
Difference Between VARCHAR() and NARCHAR()
This is my first article 😍, and I will discuss Varchar and NVarhcar 🤔. Understanding the difference...
Amazon Aurora DSQL: The New Era of Distributed SQL
Amazon Aurora DSQL (dee-sequel) is a groundbreaking serverless, distributed SQL database that...
SQL- Commands intro
Structure Query Language(SQL) SQL is a collection of statements used to communicate with...
SQL Server vs PostgreSQL: From Architecture to Cost
When comparing SQL Server and PostgreSQL, two of the most widely used relational database...
How To Debug SQL Procedures and Queries in Microsoft Visual Studio
Stored procedures and functions can be long and tedious to debug. This article will guide you on how...