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.

My experience using the GitHub Copilot in SSMS 22

by Daniel Calbimonte

SQLServerCentral

Get a quick look at Github Copilot in SSMS.

What's Your Area of Expertise?

by Steve Jones

SQLServerCentral.com

Editorial

We might be smart in one area, but not others. That's worth remembering.

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.

The Microsoft SQL Year in Review

by Steve Jones

SQLServerCentral

Microsoft gives a year in review from the SQL Server and Azure SQL teams. Steve sees a lot of accomplishments from this past year.

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

Your Value from a Conference

by Steve Jones

SQLServerCentral

Today Steve asks what value you get from attending conferences or other events.

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.