Subscribe to this blog
Don Halloran
SQL Server, SSIS, SSAS and maybe even SSRS rants and raves (and, on occasion, useful code or designs).
Archives: December 2010
Interlude: SSMS tips
Introduction
I know I said I was going to add more information about the CDC system in this post, but I wanted to throw up a quick sideline before Christmas.SSMS is a powerful tool, and one I am very happy with. It contains a lot of really useful features…
3 comments, 467 reads
Posted in Don Halloran on 23 December 2010
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 I have had to set a fixed width of 600 pixels. I have also set the inline code text to 10 pixel consolas, which still looks pretty decent…
4 comments, 269 reads
Posted in Don Halloran on 21 December 2010
Relational Types.
As I try to drag my team (sometimes with resistance, sometimes with pleasure) into the world of relational principles, I find myself struggling for a good answer as to why type constraints were deprecated in SQL 2005. And further, why we can't derive user types from other user types.
Consider,…
0 comments, 232 reads
Posted in Don Halloran on 15 December 2010
SQL Standards
Three posts, three critical rants. It's time to be constructive.
I was given the responsibility to decide on the SQL development standards at my company. I think most people with any real interest in database development would enjoy this task. As it happens, enforcing the standard is a little difficult…
I was given the responsibility to decide on the SQL development standards at my company. I think most people with any real interest in database development would enjoy this task. As it happens, enforcing the standard is a little difficult…
3 comments, 347 reads
Posted in Don Halloran on 12 December 2010
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 I do have to get SSIS packages running through SQL Agent for our various ETL tasks.
The developers are by no means SQL BI experts, and their packages may…
As DBA at my company, I don't actually develop much in SSIS. But I do have to get SSIS packages running through SQL Agent for our various ETL tasks.
The developers are by no means SQL BI experts, and their packages may…
10 comments, 479 reads
Posted in Don Halloran on 11 December 2010