How do you become SSIS/SSRS/SSAS Administrator or Developer?

Question

Post reply

How do you become SSIS/SSRS/SSAS Administrator or Developer?

YankeesSQL

SSC-Addicted

Points: 420
More actions
December 7, 2010 at 12:24 pm

#229488

How do you become SSIS/SSRS/SSAS Administrator or Developer?
Thanks

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

foxjazzG SSCrazy Points: 2221 More actions · Answer 1

foxjazzG

SSCrazy

Points: 2221

December 7, 2010 at 1:56 pm

#1259789

get a masters degree in Information systems

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 2

Wow, seriously Fox? Man, my High School degree is fading fast.

Short form: Pick up a developer's copy of SQL Server, in specific you want to get your hands on SSRS and SSAS with a SQL engine (can most likely get away with SQL Express) as the backend.

Next, grab yourself a copy of a beginner's guide to cubes and star schemas. Add to that do some research on data marts. Use the keyword: Kimball, as well, when searching on these. Those articles will discuss design theory.

SSRS isn't as difficult as understanding dimensions vs. facts and then the MDX language used in cube building. You'll want to look into SSAS very heavily and understand all the different things you can do in a cube, and keep practicing until you can think multi-dimensionally.

That'll be the starting point to becoming a junior/mid to find a mentor to get you *really* good at it over the long term.

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

foxjazzG SSCrazy Points: 2221 More actions · Answer 3

foxjazzG

SSCrazy

Points: 2221

December 7, 2010 at 2:49 pm

#1259828

Well of course, unless your Craig Farrell

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 4

foxjazzG (12/7/2010)
Well of course, unless your Craig Farrell

Heh, no. I became an administrator and fuddled my way through it mostly because noone around me at the time wanted anything to do with it. 🙂

Of course, I graduated High School a while back so the whole go get my masters to do SSAS before it was built would probably have been premature.

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

foxjazzG (12/7/2010)
get a masters degree in Information systems

Sorry to say but a Masters Degree isn't enough to become an Administrator. You need to actually can experience with these tools. Start as a developer then work toward administration.

By the way, I have a Masters and it really hasn't had much to do with what I have done with SQL Server.

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 6

foxjazzG (12/7/2010)
get a masters degree in Information systems

Pah. That would waste the best part of four years which could be spent gaining full-time hands-on experience.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 7

Chris Morris-439714 (12/8/2010)
foxjazzG (12/7/2010)
get a masters degree in Information systems
Pah. That would waste the best part of four years which could be spent gaining full-time hands-on experience.

Four years? I got my Masters in a year and a half while working full time. Two birds with one stone you might say.

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 8

Lynn Pettis (12/8/2010)
Chris Morris-439714 (12/8/2010)
foxjazzG (12/7/2010)
get a masters degree in Information systems
Pah. That would waste the best part of four years which could be spent gaining full-time hands-on experience.
Four years? I got my Masters in a year and a half while working full time. Two birds with one stone you might say.

- not many Masters' courses allow you to start with no experience of the subject. Usually a degree is prerequisite.

A year and a half while working full-time is darned good, Lynn. Jules will (shortly) have taken the same time to complete her masters in HR, but she took six months off full-time work earlier in the year when the homework became excessive.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 9

Chris Morris-439714 (12/8/2010)
Lynn Pettis (12/8/2010)
Chris Morris-439714 (12/8/2010)
foxjazzG (12/7/2010)
get a masters degree in Information systems
Pah. That would waste the best part of four years which could be spent gaining full-time hands-on experience.
Four years? I got my Masters in a year and a half while working full time. Two birds with one stone you might say.
- not many Masters' courses allow you to start with no experience of the subject. Usually a degree is prerequisite.
A year and a half while working full-time is darned good, Lynn. Jules will (shortly) have taken the same time to complete her masters in HR, but she took six months off full-time work earlier in the year when the homework became excessive.

True, you usually have to have a four year degree first. It took me twelve years to finally get my Bachelors degree, worked full time most of that time also. Had some breaks in there also due to a lack of funds at times.

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 10

Lynn Pettis (12/8/2010)
Chris Morris-439714 (12/8/2010)
Lynn Pettis (12/8/2010)
Chris Morris-439714 (12/8/2010)
foxjazzG (12/7/2010)
get a masters degree in Information systems
Pah. That would waste the best part of four years which could be spent gaining full-time hands-on experience.
Four years? I got my Masters in a year and a half while working full time. Two birds with one stone you might say.
- not many Masters' courses allow you to start with no experience of the subject. Usually a degree is prerequisite.
A year and a half while working full-time is darned good, Lynn. Jules will (shortly) have taken the same time to complete her masters in HR, but she took six months off full-time work earlier in the year when the homework became excessive.
True, you usually have to have a four year degree first. It took me twelve years to finally get my Bachelors degree, worked full time most of that time also. Had some breaks in there also due to a lack of funds at times.

12 years! BIG celebration when you finished, I'm sure. Apart from the Open University, this wouldn't happen in the UK because of the way our funding works.

I have a friend in Argentina who completed his PhD last year through Columbia University in NY - he started roughly when I finished mine, about 1986!

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 11

Chris Morris-439714 (12/8/2010)
Lynn Pettis (12/8/2010)
Chris Morris-439714 (12/8/2010)
Lynn Pettis (12/8/2010)
Chris Morris-439714 (12/8/2010)
foxjazzG (12/7/2010)
get a masters degree in Information systems
Pah. That would waste the best part of four years which could be spent gaining full-time hands-on experience.
Four years? I got my Masters in a year and a half while working full time. Two birds with one stone you might say.
- not many Masters' courses allow you to start with no experience of the subject. Usually a degree is prerequisite.
A year and a half while working full-time is darned good, Lynn. Jules will (shortly) have taken the same time to complete her masters in HR, but she took six months off full-time work earlier in the year when the homework became excessive.
True, you usually have to have a four year degree first. It took me twelve years to finally get my Bachelors degree, worked full time most of that time also. Had some breaks in there also due to a lack of funds at times.
12 years! BIG celebration when you finished, I'm sure. Apart from the Open University, this wouldn't happen in the UK because of the way our funding works.
I have a friend in Argentina who completed his PhD last year through Columbia University in NY - he started roughly when I finished mine, about 1986!

I'd like to go back for my Doctorate, but that would be 20K a year for 3 years. Can't really afford it right now.