346 reputation
217
bio website norehtech.blogspot.com
location Connecticut
age 43
visits member for 1 year, 8 months
seen Aug 13 at 20:27

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


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.
Oct
17
accepted How do I resolve issue with deleted table in SQL Server Database Diagrams?
Oct
16
comment How do I resolve issue with deleted table in SQL Server Database Diagrams?
@aaronbertrand I agree completely, but have only Visio 2012 (which has basically removed this functionality) and I am working in an environment which can't / won't pay for ERwin and can't use open source tools. Have you any suggestions for a design tool?
Oct
16
revised Mathematical method for spotting irregularity in numbers flow
added relevant tags
Oct
16
comment When is it appropriate database design to use a separate schema?
For anyone else interested in this topic, I found this post dba.stackexchange.com/questions/14478/… which has some good information despite being a conversation among abandoned user ids ;-)
Oct
16
revised How do I resolve issue with deleted table in SQL Server Database Diagrams?
changed nature of question as original was a duplicate and true question was different
Oct
16
comment How do I resolve issue with deleted table in SQL Server Database Diagrams?
@JonSeigel - thanks, this resolved my issue! My question is possibly a duplicate of your link, despite the difference in details. I will edit so this can be answer...
Oct
16
comment Is it viable to attribute permissions to SQL Server virtual accounts (NT Service\SQLSERVERAgent, etc)?
Isn't this what MSA (Managed Service Accounts) are perfect for - weblogs.asp.net/owscott/archive/2010/04/21/…
Oct
16
asked How do I resolve issue with deleted table in SQL Server Database Diagrams?