Fellow SQL Server professionals, I wanted to share some insights and start a discussion about the database design challenges we face when implementing Content Moderation Services in enterprise applications. As more organizations build user-generated content platforms, the backend data architecture becomes critical for efficient moderation workflows. Database Design Challenges for Content Moderation Services Performance at […]

Migrate from Linux to Windows with Availability Groups

by Pablo Echeverria

SQLServerCentral

This article describes the process to create a read-scale cross-platform SQL Server Availability Group where the primary is Linux and the secondary is Windows.

Monitor SQL Server using Zabbix

by Pablo Echeverria

SQLServerCentral

Monitoring

This article explains the process to install the a...

Transactional DDL in SQL Server: In Oracle, It Does Not Compute

by dbakevlar@gmail.com

SQLServerCentral

Uncategorized

Oracle treats most DDL as auto-committing, meaning once it executes, it's done. SQL Server, however, blurs that line in fascinating ways, allowing some DDL operations to be part of an explicit transaction.

How Microsoft Fabric Is Reshaping Data Value

by dbakevlar@gmail.com

SQLServerCentral

Microsoft Fabric (Azure Synapse, Data Engineering, etc.)

The data professional’s world is changing and I know you hear this from me in editorials, blogs posts and social media, but it’s the truth. With the rise of Microsoft Fabric, we’re not just seeing another platform shift; we’re witnessing a redefinition of how data is valued, governed, and protected across the enterprise. Fabric isn’t […]

We Gave Memory-Optimized Tables a Hash Lookup — Then Tried Pattern Matching Instead

by Chandan Shukla

SQLServerCentral

Uncategorized

Introduction It was the week before Black Friday — the biggest online ad rush of the year. Our US-based ad-tech platform was gearing up for an insane traffic spike. Hundreds of real-time campaigns were about to go live across multiple brands, each with thousands of user sessions flowing through our system. Every incoming user impression […]

An Introduction To Database Diagrams

by Ben Richardson

SQLServerCentral

database diagram

Take a basic look at database diagrams, what they are, and how to create one.

Unlocking Interoperability: A Guide to Foreign Data Wrappers in PostgreSQL and Aurora PostgreSQL AWS RDS

by Arvind Toorpu

SQLServerCentral

Uncategorized

Unlocking Interoperability: A Guide to Foreign Data Wrappers in PostgreSQL and Aurora PostgreSQL AWS RDS As a database professional, I often encounter scenarios where data is fragmented across various systems. In today's distributed IT landscape, it's not uncommon for critical business information to reside in different databases, perhaps an on-premise PostgreSQL instance for legacy applications, […]

Life's Little Frustrations

by Grant Fritchey

SQLServerCentral

Uncategorized

As with others, I've had to deal with death in the family recently. Some other family members are dealing with cancer (a few friends too). Happily none of us has recently been a disaster zone, but that's happened too. So yeah, big, nasty scary stuff happens in life. However, for most of us, most of […]

Automating SQL Server Access Review

by Deepam Ghosh

SQLServerCentral

Learn how you can automate checks and reports to l...

Database Architecture Considerations for Implementing Content Moderation Services

Migrate from Linux to Windows with Availability Groups

Monitor SQL Server using Zabbix

Transactional DDL in SQL Server: In Oracle, It Does Not Compute

How Microsoft Fabric Is Reshaping Data Value

We Gave Memory-Optimized Tables a Hash Lookup — Then Tried Pattern Matching Instead

An Introduction To Database Diagrams

Unlocking Interoperability: A Guide to Foreign Data Wrappers in PostgreSQL and Aurora PostgreSQL AWS RDS

Life's Little Frustrations

Automating SQL Server Access Review

Blogs

Blog a Day – Day 1: History of AI

A New Word: on tenderhooks

Ramblings about data communities and your contributions, no excuses

Forums

Ola Hallengren Index Optimize Maintenance can we have data compression = page

how do i map the "current" object entry in for each to one variable

Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)

Question of the Day

String Similarity I