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,248 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
608 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,632 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,778 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,777 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,314 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Cross-DB Ownership Chaining problem
We want to setup a gateway db to host stored procedures which use tables...
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers