Viewing 12 posts - 1 through 12 (of 12 total)
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....
March 13, 2020 at 1:32 pm
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...
March 2, 2020 at 11:47 am
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...
January 14, 2020 at 3:25 pm
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...
December 17, 2018 at 5:15 am
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...
December 17, 2018 at 3:58 am
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....
June 30, 2017 at 5:13 am
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...
June 30, 2017 at 4:18 am
You have missed out specifying/using the table schema as well as the table name.
April 26, 2017 at 2:48 am
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...
April 25, 2017 at 3:47 am
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...
February 3, 2017 at 6:26 am
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 randomlyhard to get...
February 3, 2017 at 4:26 am
I think any third party DLL's need to be in the GAC for SSIS
February 19, 2016 at 2:36 am