SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to break into data warehouse management


How to break into data warehouse management

Author
Message
daniness
daniness
SSC-Enthusiastic
SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)

Group: General Forum Members
Points: 172 Visits: 173
Hi All,

I'm hoping I can get some valuable input from people in the field. My current and past jobs have been junior developer roles, working with MS SQL Server some .Net (although I wouldn't say I'm a programmer by any means), and SSIS/SSAS under the supervision of senior developers.I've been interested in working more with databases and am wondering how I can break into a data warehouse management position? Any advice would be appreciated. Thanks!
dan-572483
dan-572483
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3625 Visits: 2000
If your current position has you supporting data warehouses and gives you opportunity to develop SSIS jobs, do as many as you can, dotting the i's and crossing the t's (by adding features like error handling/reporting that might be skipped by novices or in rush jobs).

You might also study for Microsoft Exam 70-463. Passing it would be a powerful reason for someone to hire you for this job.
RonKyle
RonKyle
SSCertifiable
SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)

Group: General Forum Members
Points: 7074 Visits: 3622
You could also do work for yourself on the side to learn the tools. I've had several candidates for an open position tell me they are interested in BI, but they haven't done anything with the tools. I broke into programming and database work by doing things on my own time to learn how the tools work. I started data warehousing as a work requirement, but I'd expect someone who told me they wanted to break in what they have been doing on their own and why they find it so intereting.



daniness
daniness
SSC-Enthusiastic
SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)

Group: General Forum Members
Points: 172 Visits: 173
Thanks, Dan. Unfortunately my current position doesn't afford me the opportunity to do the things you've mentioned, but my previous position did. I will definitely look into the exam you referenced. Thanks!
daniness
daniness
SSC-Enthusiastic
SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)

Group: General Forum Members
Points: 172 Visits: 173
Thanks, Ron. Are there any data warehousing tools you can suggest I can look into? I agree with what you're saying and I'd like to familiarize myself with such tools on my own time, if that's what it takes.
RonKyle
RonKyle
SSCertifiable
SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)

Group: General Forum Members
Points: 7074 Visits: 3622
The MS stack is available in the developer's edition. It's very inexpensive as an investment in your career. Read Ralph's Kimballs data warehouse books and start learning.



daniness
daniness
SSC-Enthusiastic
SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)

Group: General Forum Members
Points: 172 Visits: 173
Hi Ron,

Thanks again for the input. By the MS stack, are you referring to the MS SSIS/SSAS/SSRS tools? If so, would the Express Edition suffice for learning?
RonKyle
RonKyle
SSCertifiable
SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)

Group: General Forum Members
Points: 7074 Visits: 3622
Yes, that's what I'm refering to, and no, the Express edition will not suffice. That is a very scaled down version of SQL Server.



dan-572483
dan-572483
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3625 Visits: 2000
Express will not work. In fact, if you install SQL Server Express 2012 on a workstation, you WILL NOT be able to properly install SQL Server Data Tools, which are required to develop SSIS jobs!

Fortunately, you can get the developer edition for a modest price. It looks like DVDs for 2012 Developer are no longer available from Microsoft, but you can get the 2014 Developer Edition
http://www.amazon.com/Server-Developer-2014-English-Only/dp/B00JKMY8KC/ref=sr_1_2?s=software&ie=UTF8&qid=1405459309&sr=1-2&keywords=microsoft+sql+server+developer+edition

daniness
daniness
SSC-Enthusiastic
SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)

Group: General Forum Members
Points: 172 Visits: 173
Thanks, Ron and Dan. I happen to have th SQL Server Management Studio R2 2008 installed which I obtained via the MS Alliance with Universities, as I'm in school. I'm wondering how different 2008 is from 2012 and if it'll be adequate for practice/study purposes.

Also, what are your thoughts on obtaining certifications? I was looking at the MCSE line of certs, but am not sure if I should go the Data Platform or BI route. Do any of you have or plan on earning these?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search