Articles

You’re a developer responsible for maintaining a SQL Server database used to feed data to Power BI. You realize that some tables don’t have a modifiedDate column and some do. Also, you know the data is updated by the application as well as other processes which makes the modifiedDate unreliable. This is because it may not always be updated when data changes. You need a way to track data changes to ensure only changed rows are updated on reports in Power BI.

2025-12-24

My experience using the GitHub Copilot in SSMS 22

by Daniel Calbimonte

SQLServerCentral

Get a quick look at Github Copilot in SSMS.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2025-12-22

9,493 reads

Discuss

Get ChatGPT’s Advice On Your Queries with sp_BlitzCache.

by Additional Articles

Brent Ozar Blog

First off, I understand if you read the headline and you have a knee-jerk reaction. I totally understand that there are a lot of people out there who hate AI, and believe me, I hate most uses of it. Lots of its advice can be misleading at best, and absolute garbage at worst.

2025-12-22

T-SQL in SQL Server 2025: The || Operator

by Steve Jones

SQLServerCentral

I have been working in various computer languages for a long time. When I saw that the || operator was coming, I was a bit confused as to why we needed this, and how it would work. After all, this is a part of other languages. I decided to dig in a bit. This is […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2025-12-19

8,418 reads

Discuss

SQL Server 2025 Product() Function Examples

by Additional Articles

MSSQLTips.com

SQL Server 2025 includes new features and enhancements. In the previous SQL Server 2025 tips, we have explored many new features. Have you explored the new Product() function? If not, this will walk you through the Product() function with several examples.

2025-12-19

15 Practical Tips for Securing SQL Server

by Additional Articles

SimpleTalk

SQL Server security

Securing SQL Server isn’t complicated, but it does require consistent attention to the areas where real risks arise, such as privileges, configuration, encryption, patching, and monitoring. This article outlines 15 practical, high-impact steps you can take to harden your SQL Server environment.

2025-12-17

Think LSNs Are Unique? Think Again - Preventing Data Loss in CDC ETL

by Utsav Verma

SQLServerCentral

When using only an LSN to track which changes you have processed, you can lose data. This article shows how to avoid this problem.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2025-12-15

2,574 reads

Discuss

Query Exercise Answer: Generating Big TempDB Spills

by Additional Articles

Brent Ozar Blog

T-SQL

In last week’s Query Exercise, I challenged you to play some code golf to generate big spills with tiny T-SQL.

2025-12-15

Working with JSON/JSONB Data in PostgreSQL using Python

by sabyda

SQLServerCentral

PostgreSQL

This article discusses how to work with JSON data in PostgreSQL using Python.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2025-12-12

602 reads

Discuss

How to Monitor and Optimize Batched Deletion Processes in SQL Server

by Additional Articles

SimpleTalk

Performance and Tuning

Batched deletions are a common strategy in SQL Server to manage large datasets without overloading the system, but poorly tuned deletes can cause blocking, long-running transactions, and heavy log usage. Learn how to monitor and optimize these processes for smooth, efficient database performance.

2025-12-12

Articles

SQL Server Change Tracking to Optimize Data Refreshes for Reporting

My experience using the GitHub Copilot in SSMS 22

Get ChatGPT’s Advice On Your Queries with sp_BlitzCache.

T-SQL in SQL Server 2025: The || Operator

SQL Server 2025 Product() Function Examples

15 Practical Tips for Securing SQL Server

Think LSNs Are Unique? Think Again - Preventing Data Loss in CDC ETL

Query Exercise Answer: Generating Big TempDB Spills

Working with JSON/JSONB Data in PostgreSQL using Python

How to Monitor and Optimize Batched Deletion Processes in SQL Server

Blogs

Ramblings about data communities and your contributions, no excuses

SQL Server Journey till 2025 (brief)

Building Power BI Reports: Desktop vs Fabric

Forums

Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE

Having a Little Fun at SQL Server Central

Designing SQL Server Pipelines That Are Ready for AI Before You Actually Need AI

Question of the Day

String Similarity I