376 reputation
1218
bio website norehtech.blogspot.com
location Connecticut
age 44
visits member for 2 years
seen Dec 22 at 20:49

Data-warehouse / Database and Software Developer (c/c++/c#, Perl, VBS, PLSQL, Oracle, Greenplum), working primarily on the Microsoft stack.


Nov
23
awarded  Tumbleweed
Nov
16
revised SSIS Deployment: The specified parameter value string is too long
deleted 1 character in body
Nov
16
revised SSIS Deployment: The specified parameter value string is too long
added 175 characters in body
Nov
16
asked SSIS Deployment: The specified parameter value string is too long
Sep
14
awarded  Famous Question
Sep
13
accepted Attempt to add DQS Cleansing Connection Manager to SSIS results in error
Sep
3
asked Attempt to add DQS Cleansing Connection Manager to SSIS results in error
Sep
3
answered Attempt to add DQS Cleansing Connection Manager to SSIS results in error
Jul
2
awarded  Curious
Apr
23
awarded  Citizen Patrol
Apr
10
awarded  Popular Question
Feb
12
revised How do I determine if a SSIS transform is non-blocking, partially blocking, or fully blocking?
changed wording of question and added details to question
Feb
12
revised How do I determine if a SSIS transform is non-blocking, partially blocking, or fully blocking?
added ideas as to possible solution method
Feb
11
comment How do I determine if a SSIS transform is non-blocking, partially blocking, or fully blocking?
@Rob - while I agree they are not the same thing (asynchronous can partially or fully block) - The jorg_klein blog actually states that the Union All is partially blocking. I am inclined to agree as if the data is moved into the new buffer, intuition leads me to think that would partially block. If he can be proved wrong and my intuition is incorrect, all the better as that would answer the question!
Feb
10
asked How do I determine if a SSIS transform is non-blocking, partially blocking, or fully blocking?
Dec
25
comment Harden a public login to only let it retrieve a list of other logins, and do nothing else
+1 for defense in depth idea of last sentence - at least user needs to gain access to AD to get list of usernames.
Dec
25
comment Harden a public login to only let it retrieve a list of other logins, and do nothing else
This is a really bad idea - as Max said, it's a security no-no - it is more than 1/2 of the work as even if only one user has a weak password, you have provided hackers with a list to try against. If you insist on doing this, please post the site so I can be sure to not use it.
Dec
24
comment User creation and rights to import a dump
If you don't know how to do that, there is a really good website for looking up instructions or asking questions if you get stuck. Need to google it as I forget the name, but it is either exchange something or something overflow.com
Dec
20
awarded  Yearling
Dec
5
comment In what data type should I store an email address in database?
@AaronBertrand - thanks for your article - I think anyone interested in this thread would be interested to read mssqltips.com/sqlservertip/2657/… And if you happen to be applying learnings to Oracle, there are a number of good trials to perf test.