Articles

External Article

SQL Server Change Tracking to Optimize Data Refreshes for Reporting

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

SQLServerCentral Article

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

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,543 reads

Blogs

The Agent Era: When “How do I…?” Replaces “Where do I click?”

By

After a year away getting to grips with AI and its application across the...

Beware of Generic SQL Server License Keys (What to Use Instead)

By

Beware of Generic SQL Server License Keys (What to Use Instead) ...

On Speaking Well

By

Professor Patrick Winston of MIT used to give a one-hour talk about how to...

Read the latest Blogs

Forums

Creating a JSON Document II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating a JSON Document II

Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6

By VishnuGupthanSQLPowershellDBA

Comments posted to this topic are about the item Backing Up Azure Key Vault...

Every Database Has Problems

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Every Database Has Problems

Visit the forum

Question of the Day

Creating a JSON Document II

I want to create a JSON document that contains data from this table: 

TeamID TeamNameCity         YearEstablished
1      Cowboys  Dallas       1960
2      Eagles   Philadelphia 1933
3      Packers  Green Bay    1919
4      Chiefs   Kansas City  1960
If I run this code, what document(s) is/are returned? 
SELECT json_objectagg( n.city : n.TeamName)
FROM dbo.NFLTeams;

See possible answers