Tracking table changes seamlessly with Change Data Capture (CDC)
I am going to describe quite forgotten feature in SQL Server 2008. It is Change Data Capture (CDC) – powerful feature...
2011-07-15
2,421 reads
I am going to describe quite forgotten feature in SQL Server 2008. It is Change Data Capture (CDC) – powerful feature...
2011-07-15
2,421 reads
T-SQL debugging is not 100% in SQL Server. It has few bad drawbacks starting from difficulties when setting it up...
2011-07-13
1,208 reads
I was facing quite well-known issue today – I had to develop logic of duplicating (versioning) parent-child records. Because I was...
2011-07-12
1,974 reads
I continued to check SQL Server 2011 “Denali” for few things I dislike on 2008 R2 and tried to find...
2011-07-11
605 reads
While I was reading Martin Catherall’s post about Selecting from a table with no rows returned I remembered TABLESAMPLE function...
2011-07-11
1,379 reads
On my current project, I am dealing with date intervals in T-SQL very heavily. I’ve hit interesting issue recently – how...
2011-07-08
2,107 reads
I’ve received interesting question/requirement few days ago:
“… When viewing a query plan graphically, we usually have to hunt for the...
2011-07-08
1,656 reads
My wife and kids are leaving for holiday (without me). Bad thing is that I will miss them, good thing...
2011-07-07
1,283 reads
I’ve started to play little bit with SQL Server 2011 CTP Denali to find out whether some open wounds were...
2011-07-06
457 reads
I wrote about some skeletons in the Denali’s closet here. Let’s also put some good on the table. Very handy...
2011-07-06
1,190 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers