Most DBAs are familiar with full and differential ...

Model Context Protocol (MCP): A Developer’s Guide to Long-Context LLM Integration

by ndulam

SQLServerCentral

Uncategorized

Large Language Models (LLMs) like Anthropic’s Cl...

MongoDB and NodeJS in action

by sabyda

SQLServerCentral

Uncategorized

Overview MongoDB is a popular NoSQL database used for building modern, scalable applications. In this article, we’ll cover how to set up MongoDB on Windows and connect to it using Node.js. We will also perform some basic Create, Read, Update, and Delete (CRUD) operations to ensure we understand fully on how Node.js can be made […]

SQL Server Threats

by J P Mehta

SQLServerCentral

Uncategorized

Is your SQL Server truly secure? Here are the top cyber threats targeting it. Learn how you can stop them before it strikes.

Using psycopg2 to Connect Python to PostgreSQL

by sabyda

SQLServerCentral

Learn how to connect to a PostgreSQL database from Python with this popular library.

Why CQRS and Event Sourcing Are Gaining Ground in High-Concurrency Web Systems

by MichaelHilliard

SQLServerCentral

Uncategorized

In web app development company boardrooms, architects and engineers are debating old assumptions. Scaling up isn’t just about faster servers or better caching anymore. It’s about reshaping how systems think. CQRS (Command Query Responsibility Segregation) and Event Sourcing are no longer fringe ideas. They’re becoming default choices in high-concurrency systems where consistency, auditability, and performance […]

Working with Indexes on SSMS

by sabyda

SQLServerCentral

Management Studio (SSMS)

Overview In SQL Server, indexing is a technique used to improve the performance of queries by reducing the amount of data that SQL Server needs to scan. You can think of it like a table of contents in a book—it helps SQL Server find data more quickly. In this article, we will cover the following […]

Yet another Date Dimension

by Pete Revell

SQLServerCentral

Uncategorized

Evolution of code The thing with any bit of code that has been around for a while, is that when change comes along, the tendency is to cater for the change by adding new stuff, while nothing gets taken away. Some stuff has definitely been taken away from this Date Dimension, but some historical artefacts […]

Add a Second NIC for an Availability Group to Separate Network Traffic

by Vincent92

SQLServerCentral

Introduction Sometimes we face the scenario in an enterprise environment that the database in SQL Server Always On Availability Group (AOAG) has high concurrency read and write access from application servers. If we keep using the one network interface card for both network traffic of database connections from application servers and database mirroring between AOAG […]