| Author |
Topic |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2007-03-15 : 10:30:34
|
| Does anyone has, a list of interview questions for SSIS? Or can somebody list possible SSIS interview questions?------------------------I think, therefore I am - Rene Descartes |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2007-03-15 : 12:43:12
|
| Here's two:1. Why the hell would anybody want to use SSIS?2. Why does SSIS suck so bad?e4 d5 xd5 Nf6 |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2007-03-15 : 15:46:56
|
quote:
Originally posted by blindman
Here's two:1. Why the hell would anybody want to use SSIS?2. Why does SSIS suck so bad?e4 d5 xd5 Nf6
Blindman, I understand the humor, since i am also preparing for the interviews , I will try my best to answer your questions. Rest of the guys can try to improve the answers.1. Why the hell would anybody want to use SSIS?SSIS – complete code rewrite SSIS has its own service Dynamic property task – you can alter the package dynamically at runtime You can put the whole package in a transaction Separate interface – no need to start SQL server while designingComes free with SQL ServerPartial logging is possible for tasks Tasks can be grouped Tasks can be loopedIn Debugging - breakpoints can be used 2. Why does SSIS suck so bad?There is a code rewrite for SSIS, hence a steep learning curve.------------------------I think, therefore I am - Rene Descartes |
|
|
|
readysetstop
Posting Yak Master
123 Posts |
Posted - 2007-03-19 : 08:15:50
|
| I think someone asked me those in an interview recently... ;-)But heck, I'll take a crack at it:1. Why use SSIS? a. You're stuck importing old DTS packages from SQL 2000 and can't be arsed to rewrite them in T-SQL. b. Your programming skills suck (like mine) and the GUI helps. c. Your files can't be loaded as is, so you have to do actual data transformation. (Like 2000 DTS)2. Why does SSIS suck? a. Too many moving parts. b. If you need SSIS features, it means your conditions for loading files are not optimal to begin with. Fix that first. |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2007-03-19 : 13:13:51
|
| Excellent answer, ReadSetStop. You're hired.And wasn't I the one who gave you a technical interview for my company a few weeks ago?e4 d5 xd5 Nf6 |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-03-19 : 16:06:42
|
quote:
Originally posted by blindman...e4 d5 xd5 Nf6
Do you find that most people respond with 3. d4 ?CODO ERGO SUM |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2007-03-19 : 16:31:11
|
| d4 is one of the strongest responses, but that does not mean most people play it. More common is for people to try to protect the pawn with Nc3, Bc4, or c4, but these allow Black to get good development, which is the whole purpose of a gambit.e4 d5 xd5 Nf6 |
|
|
|
readysetstop
Posting Yak Master
123 Posts |
Posted - 2007-03-20 : 06:49:37
|
| Blindman, Yes, you did interview me a few weeks ago. Thanks for the vote of confidence in recommending me for the position. Wish I had given answers like that a few weeks ago. :-)p.s., I'm an Nf3 man, myself... |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-03-20 : 09:36:21
|
quote:
Originally posted by blindman
d4 is one of the strongest responses, but that does not mean most people play it. More common is for people to try to protect the pawn with Nc3, Bc4, or c4, but these allow Black to get good development, which is the whole purpose of a gambit.e4 d5 xd5 Nf6
3. D4 looks good to me. It seems to leave white with a lot of freedom in the center, and easy development.I like a Center Gambit for white with:1. E4 2. E52. D4 2. ExD3. NF3 It has a lot of inviting looking bad responses for black that can be a lot of fun in a 5 minute game.CODO ERGO SUM |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2007-03-20 : 14:19:11
|
| Try:1. e4 2. e52. d4 2. exD3. f3!I can't remember the name of this opening right now, but I have a friend who employs it with great success against club players. If Black accepts the f3 pawn, he can find himself in hot water.e4 d5 xd5 Nf6 |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-03-20 : 15:33:38
|
quote:
Originally posted by blindman
Try:1. e4 2. e52. d4 2. exD3. f3!I can't remember the name of this opening right now, but I have a friend who employs it with great success against club players. If Black accepts the f3 pawn, he can find himself in hot water.e4 d5 xd5 Nf6
Do you mean 3. C3, since the black pawn is at D4?CODO ERGO SUM |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-03-21 : 00:09:54
|
quote:
Originally posted by blindman
Yes, I meant c3. And it is called the Danish Gambit.http://en.wikipedia.org/wiki/Danish_Gambite4 d5 xd5 Nf6
I never really like it for white.If you don't get an early knockout, you've given black a passed C pawn, and you're down a pawn. The Schlechter Defense from the article looks good for black.CODO ERGO SUM |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2007-03-21 : 13:49:11
|
| The Danish is not something that is frequently played at the Master level, but Black's defense requires a great deal of tactical accuracy and if White is more familiar with the positions that come up then he can often get a large advantage. That is why it is very effective against club-level players.Yes, the defense mentioned in the article is effective, but not a knock-out, and it is not a move that is so intuitive that someone unfamiliar with the opening would likely play it.e4 d5 xd5 Nf6 |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-03-28 : 04:21:16
|
| i usually completly ignore the opponents opening and open myself independatly of their moves.usually it screws with their logic and it works pretty well._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
SSIS interview question