Easy CDC in 5 hours (less for you!) using automatic code generation.
Updates:
Update #3:
Another reformat, thanks to andreas for giving me the heads up. The pre tags aren't behaving across browsers so...
2010-12-21
1,240 reads
Relational Types.
As I try to drag my team (sometimes with resistance, sometimes with pleasure) into the world of relational principles, I...
2010-12-15
602 reads
SQL Standards
Three posts, three critical rants. It's time to be constructive.
I was given the responsibility to decide on the SQL development...
2010-12-12
1,593 reads
SSIS: great idea, but buggy as heck.
Oh SSIS, how I love and hate you.
As DBA at my company, I don't actually develop much in SSIS. But...
2010-12-11
1,772 reads
The best laid plans....
I had big plans for this blog, a place to rant, a place to put cool things I discovered, a...
2010-09-17
1,772 reads
Separation of interface from implementation
One of the supposed advantages of the EF is that it abstracts you from
your database implementation. This is considered to...
2010-07-11
1,307 reads
Blogs
Unlocking Real-Time Financial Insights: The Power of Microsoft Fabric
By Chris Yates
Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data...
Understanding Lakehouse Permissions in Microsoft Fabric
Understanding how permissions work in Microsoft Fabric can be essential for anyone managing access...
The Cost of Not Having a DBA
By Kevin3NF
Does skipping a DBA save money? Wait until your system grinds to a halt,...
Forums
what etl tool are folks moving toward?
Hi as we replace on prem machines , sometimes not with vm's, what should...
Union where it matches against only one shared column
Hi folks I have two tables, both with a NAME, START and END fields...
How to update using data from three tables?
I am in the process of migrating from MySQL to SQL Server. I have...
Question of the Day
Replacing a NULL II
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL , @value2 VARCHAR(20) = NULL; SELECT COALESCE (@value, @value2, 100.5) AS Result; GOSee possible answers