430 reputation
314
bio website
location
age
visits member for 2 years, 10 months
seen 9 hours ago

11h
asked Why do maintenance plans exist as a feature?
Mar
26
awarded  Notable Question
Mar
25
awarded  Disciplined
Mar
20
comment How to make a flexible service broker receive in a stored sql procedure, how to pass “FROM” parameter into receive
@RemusRusanu - do you mean to say multiple instances of activation procedures or multiple, different activation procedures? I was under the impression that a queue could only have one activation procedure.
Mar
8
awarded  Yearling
Mar
8
asked Can I split lines into Elements with For XML?
Feb
26
comment How to architect Service Broker with three or more systems?
More specifically, can an activation stored procedure be the initiator of of secondary conversations in a conversation group? That sounds a bit like recursive triggers.
Feb
26
asked How to architect Service Broker with three or more systems?
Feb
17
comment Is there a Document based nosql with deep json update?
No. Xindice fits the equivalent niche for xml. I suppose you could lay some sort of mapping layer there. Without a broadly implemented query language for json, I don't see it happening.
Feb
12
comment How to use HTTP Connection Manager in Script Component? (Not Script Task)
What's irritating me is that It seems so straightforward in the vb example.
Feb
12
comment How to use HTTP Connection Manager in Script Component? (Not Script Task)
The JSON src component on Codeplex doesn't install correctly, so until I get that working I thought I'd just use a script component and a http connection manager.
Feb
12
comment How to use HTTP Connection Manager in Script Component? (Not Script Task)
I got nothing. Apparently I'm the first person to ever do this.
Feb
12
answered SSIS package starts and stops immediately with a DTS_W_MAXIMUMERRORCOUNTREACHED, but there's no error to read
Feb
11
accepted Limit connection rights on SQL Server
Feb
11
awarded  Nice Question
Feb
10
comment Connect to remote EC2 Postgresql database
And you did a telnet 5432? If so you have an issue on the host- either os-level(firewalling) or app-level(postgres hba conf). Netstat -an on the host should show if the postgres service is listening on that port.
Feb
10
answered Connect to remote EC2 Postgresql database
Feb
9
comment How to use HTTP Connection Manager in Script Component? (Not Script Task)
I've seen plenty of examples with DB connections- HTTP Connection Managers are apparently the odd man out.
Feb
9
comment SSIS Multicast performance question
I think you can turn down the batch size to control how many records ssis runs through the pipeline at a time. That would reduce the memory usage, but would take longer to run.
Feb
9
comment SSIS Multicast performance question
It may actually be better to write a Script Transform with multiple outputs instead of a multicast, since you can filter the columns as you shard the data. You'd have to test that to see which was better.