Tag Archives: Automation

Bitesize SSIS: Passing SSIS variables into script components

I hate SSIS. It seems to me that it is full of certain nuances and unless you are regularly developing SSIS packages, they are easy to forget or it is easy to miss specific important steps. I first started using SSIS back … Continue reading

Posted in SQLServerPedia Syndication, SSIS | Tagged , | 1 Comment

Using the SQL Server Installation Wizard on Server Core!

Ever heard the phrase “just because you can, doesn’t mean you should?”. Yep me too -many times, and what I am about to say comes with that caveat in mind although as I shall explain, I see absolutely no reason … Continue reading

Posted in SQL, SQLServerPedia Syndication, Windows | Tagged , , | 9 Comments

Categorise your agent jobs

Perhaps you are one of those people who’s house is immaculate? The lid is firmly placed back on the toothpaste, shoes left in a neat pile, coat in the cupboard. You know the sort of thing? Well I’m not quite … Continue reading

Posted in SQL, SQLServerPedia Syndication | Tagged , ,