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 […]

How Much Can You Learn?

by Steve Jones

SQLServerCentral.com

Editorial

This Friday Steve Jones wonders about the upper limits for what you may learn in a year.

Picking the ON or WHERE Clause for the SQL Predicate

by Additional Articles

MSSQLTips.com

T-SQL

Helping people solve T-SQL problems is one of my favorite hobbies. Someone messaged me the other day with a complex query that was almost complete except for one issue. He needed to perform a LEFT OUTER JOIN but had to filter based on a value from the right table. However, when he added the filter, SQL removed rows from the left table. The task was to decide where to place the SQL predicate: in the ON or WHERE clause.