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...
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...
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...
How to Document SQL Server Schemas Visually in 2025
Working with SQL Server, you usually get great performance and solid tools, but documenting the...
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...
🧐 What is Write Ahead Logging 📝🗂️ (WAL)
Write-Ahead Logging (WAL) is a standard technique in databases to ensure data integrity and...
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...
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...
Understanding Database Normalization
In the world of data management, database normalization is one of the most crucial yet misunderstood...
The Power of OUTER APPLY: A SQL Weapon to Expand Legacy Database
Introduction In the world of SQL Server, maintaining and enhancing legacy stored...
Auditing SQL Server Database Users, Logins, and Activity: A Comprehensive Guide
Auditing SQL Server Database Users, Logins, and Activity: A Comprehensive Guide In today’s...
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...
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:...
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...
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...)...
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...
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:...
How to Manage Your SQL Server Database Effectively
Managing an SQL Server database effectively is crucial for ensuring data integrity, security, and...
Stop Killing Your Database with Multiple Calls
We’ve all seen it. A single API endpoint makes three, four, sometimes ten separate queries to load...
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...
Amazon Aurora DSQL: The New Era of Distributed SQL
Amazon Aurora DSQL (dee-sequel) is a groundbreaking serverless, distributed SQL database that...
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...
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 ...
I am Learning SQL(mysql) in 2025.
Database & DBMS Type of DB, SQL & non-sql / (RDBMS vs NRDBMS) SQL Tables, Columns(schema),...
SQL Server vs PostgreSQL: From Architecture to Cost
When comparing SQL Server and PostgreSQL, two of the most widely used relational database...
⚔️ The Mighty MERGE: Using SQL Merge Statements Safely with EF Core
When you’re working with bulk data operations, upserts, or syncing external sources, MERGE is one of...
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...
How to Optimize SQL Queries for Speed and Efficiency
Efficient SQL performance is essential for fast data retrieval and reducing system load. The...
Understanding SQL Subqueries and Common Table Expressions (CTEs)
Welcome! In this article, we’ll explore two powerful SQL tools—subqueries and Common Table...