What i like about stored procedures is that the code is closest to the database. This is especially important if you have more than one way of accessing the database....

Even though you could just hold the Zip code (and house number) in ther UK on the customer record that then means that every time you would need to use...

• This reply was modified 4 years, 8 months ago by  adelio.stevanato 21159.

As much as i like the idea of auto generated data it can get very complicated.

We use a depersonalised copy of the customer data.

we have something like 600 tables in...

And i do most of those but it is just hard to see everything about even a single SSIS item is one go.
You have properties, input/output columns, columns...

Do not get me wrong, I like the idea of code reviews.
But it is not always easy to "code review". An example is SSIS, drag and drop "arghhhh". (I...

Please note. Where you have a multi part foreign key that this script will NOT Work correctly.
it will try and drop and re-create the FK once for each element....

I am using SQL server 2014 and I have a number of tables with foreign keys where they are set as untrusted. NONE of these FK as set as "NOT...

You have missed out specifying/using the table schema as well as the table name.

I am trying to understand how Microsoft could introduct something so limited.
ALL our packages are highly parameterised, this includes the database connection details plus a ton of other...

Having had to use oracle for a large number of years we always used "TOAD" instead of the oracle management studio. Far better and more functionality.
The disappointment with the...

After having used SSIS exclusively for over a year I vote for it to be scrapped and re-written.
the interface is inconsistent and buggy.
It crashes randomly
hard to get...

I think any third party DLL's need to be in the GAC for SSIS