Understanding the CDC State Value
If you are using Change Data Capture (CDC) it can be very useful to look at the CDC State table...
2012-07-12
2,189 reads
If you are using Change Data Capture (CDC) it can be very useful to look at the CDC State table...
2012-07-12
2,189 reads
Change data capture was introduced in SQL Server 2008 and has been pretty popular ever since. The basic concept behind...
2012-07-10
4,112 reads
I’ll be honest, I contemplated a lot about whether to write this blog or not for fear that it may...
2012-06-26
267 reads
It’s about that time again, PASS Summit 2012 is right around the corner in Seattle, WA. It will be held...
2012-06-25
952 reads
PowerPivot was a great new tool when it released several years ago. Now the newest version is out along side...
2012-04-05
3,738 reads
Like all systems built on top of SQL Server SharePoint 2010 needs to have a plan for availability. There are...
2012-04-02
1,218 reads
Between SharePoint 2007 and SharePoint 2010 there were many new features that were added or enhanced. There still remains a...
2012-04-02
1,480 reads
In an SSIS package you have the option to choose from a wide range of source from Flat Files to...
2012-03-29 (first published: 2012-03-23)
3,579 reads
In T-SQL there are many functions there to help do a variety of different things. SSIS is no different. In...
2012-03-23
2,012 reads
The MultiDimensional eXpressions, or MDX, language is used to query the data in a multidimensional in an OLAP database. In the...
2012-03-12
1,422 reads
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Think there's a reason why this is still in preview, but have someone manage...
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
This is a generic question. To the moderators, I wasn't sure where to place...
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers