173 reputation
110
bio website techgineer.blogspot.com
location Amsterdam, Netherlands
age 26
visits member for 1 year, 6 months
seen May 27 at 18:51
stats profile views 4

Data Warehouse developer at Info Support B.V., with a background in Computer Science. Love to discover new things in code, platforms and more.

When I'm not working, I like playing the piano (& hammond organs - I LOVE those), spending time with friends (going out, having some beers, discussing Deep Thoughts about Life And The Universe) and travelling.


May
27
awarded  Caucus
Apr
29
awarded  Popular Question
Oct
17
awarded  Notable Question
Sep
14
revised Running an SSIS package owned by a domain user from SQL Server running on a local service account
Update in response to several proposed answers
Sep
14
comment Running an SSIS package owned by a domain user from SQL Server running on a local service account
@Justicator: Maybe, as a last resort. But whenever domain logins are possible, I prefer not to use SQL Authentication.
Jul
23
awarded  Popular Question
Jul
16
revised SQL Server Decimal(9, 0) vs INT
Further clarified the title
Jul
16
awarded  Editor
Jul
16
revised SQL Server Decimal(9, 0) vs INT
edited title
Jul
16
asked SQL Server Decimal(9, 0) vs INT
Jun
25
awarded  Critic
Apr
4
comment Running an SSIS package owned by a domain user from SQL Server running on a local service account
Yes, but I don't know which reason (I guess something with the DTAP cycle and the domain being not everywhere available). Anyway, it's a given environment which I'm not allowed to alter.
Apr
2
awarded  Announcer
Apr
2
asked Running an SSIS package owned by a domain user from SQL Server running on a local service account
Jan
23
awarded  Scholar
Jan
23
accepted SQL Server Linked Server performance: Why are remote queries so expensive?
Jan
18
awarded  Supporter
Jan
18
awarded  Student
Jan
18
comment SQL Server Linked Server performance: Why are remote queries so expensive?
Using a temporary table works right with 54 rows; but in cases with large tables on both sides it isn't feasible anymore. What would your solution be for two equally-sized "huge" tables? Creating a UserTable, in another database?
Jan
18
comment SQL Server Linked Server performance: Why are remote queries so expensive?
Ok, so it has high startup costs to set up the connection. The query needs to be sent, processed remotely (no network needed for that one), and finally the results sent back and processed. But it won't take minutes to send data over a network connection, will it?