Find fields & stores near you!
Find fields and stores
Zipcode
PbNation News
PbNation News
Community Focus
Community Focus

Reply
 
Thread Tools
Old 06-20-2015, 12:24 AM #1
zkorAVALS
4T3HLULZ
 
zkorAVALS's Avatar
 
Join Date: Jan 2008
Location: Reno, NV
SQL Server

Anyone experienced in it? I've started the process of self-learning to get a few Microsoft certs before I graduate school. Wondering if anyone has any tips to point me in the right direction of resources.
I've acquired a few books that i've been working through which seems to be working, but i'm curious if anyone has any work experience in it.
__________________
XBL: SlavaRussky
zkorAVALS is offline   Reply With Quote
Old Sponsored Links Remove Advertisement
Advertisement
Old 06-20-2015, 09:22 AM #2
Oedipus
god save captain slow
 
Oedipus's Avatar
 
Join Date: Dec 2005
Location: Butts
Oedipus supports DLX Technology
I deal with it periodically; it's a harsh mistress. I presume you're dealing with 2014?
__________________
ST:Tech -- Three solid failures away from emptying large quantities of ammunition into a daycare.

Last edited by Oedipus : 06-20-2015 at 10:28 AM.
Oedipus is offline   Reply With Quote
Old 06-20-2015, 10:43 AM #3
durrell
 
 
Join Date: May 2004
Location: NC
durrell is a Supporting Member
 has been a member for 10 years
I too deal with it, though I deal with MySQL a lot more often. SQL can be temperamental.

Any reason you picked SQL to self-learn? Do you just really want to be a DBA?
durrell is offline   Reply With Quote
Old 06-20-2015, 12:31 PM #4
zkorAVALS
4T3HLULZ
 
zkorAVALS's Avatar
 
Join Date: Jan 2008
Location: Reno, NV
I'm going to school for Geophysics and there are a lot of jobs available for database development in geology. Big gold mines need to keep track of stuff.

It's also the career path my dad took and he's doing pretty well.

It also opens up my career paths. My girlfriend is a geology major so it would be nice for me to be more open to living anywhere, that way she could get a job and then I could either look for a job as an geophysicist or a database admin/engineer/developer depending on where we move.

I'm actually dealing with 2012. My dad told me that there haven't been a lot of companies that have fully switched to 2014 yet, although its coming. Also the resources that i've been able to acquire are all for 2012.
__________________
XBL: SlavaRussky
zkorAVALS is offline   Reply With Quote
Old 06-20-2015, 08:46 PM #5
durrell
 
 
Join Date: May 2004
Location: NC
durrell is a Supporting Member
 has been a member for 10 years
Most of the SQL technology (syntax, design, etc.) is pretty ubiquitous. The major version differences are usually related to management I think - backups, integrations with other systems, etc.
durrell is offline   Reply With Quote
Old 07-01-2015, 11:11 AM #6
bdsmith08
 
 
bdsmith08's Avatar
 
Join Date: Apr 2012
Location: Myrtle Beach, SC
bdsmith08 plays in the PSP
bdsmith08 is an NCPA player
If you're just building the tables then the syntax should be nothing you just have to understand normalization and how tables should relate. It's once you get into big stored procedures that I feel the logic may be tricky depending on what you want to do.
__________________


SPG
Gi Sportz
bdsmith08 is offline   Reply With Quote
Old 07-02-2015, 11:00 AM #7
Ford
☻♦♣b
 
Ford's Avatar
 
Join Date: Nov 2001
Location: Austin 49
Ford is a founding member
 has been a member for 10 years
I agree with those saying SQL tech is pretty similar from mysql, MS sql and something like postgres.

I lightly deal with a postgres DB that was designed before normalization was a thing...

the important thing is understanding normalization. getting something to 3rd normalized form seemed to be what my professors drilled into us the most.

Once you've got design down you can worry about what SQL version supports Integer arrays vs arrays at all vs whatever, and how to build complex queries for your data...
__________________
"Originally posted by Bronk0
Everyone put something in your sig about it...

like PORN THREAD 10/24/04: I was there.
"
Ford is offline   Reply With Quote
Old 07-08-2015, 09:23 AM #8
Gopher49
Torn acl's suck
 
Gopher49's Avatar
 
Join Date: Nov 2005
Location: Minnesota
Gopher49 plays in the APPA D5 division
I would not be much help in Server set up, but if you are looking for a good script resource, stackoverflow.com has been pretty helpful
Gopher49 is offline   Reply With Quote
Old 07-10-2015, 08:37 AM #9
Dontcallmepete
BALLSOHARD
 
Dontcallmepete's Avatar
 
Join Date: Oct 2007
Location: 6zero9 nj
Dontcallmepete is one of the top 1000 posters on PbNation
I used to work for a software company, I did a lot of sql debugging. At my new job I setup/manage systems which use ms sql, handful use postgresql and ora. With that said, outside of erp, take some time to learn Nosql. Mongodb is where a lot of new technologies are going.
__________________
ST:tech-Troll the gdt they said...
Its only after we've lost everything
that we're free to do anything
"Originally posted by Sp0rk: Pete's endorsed by over 20 liquor companies, he gets free **** all the time.
"Originally posted by SUR3 S}{oT: Southern Comfort:
Only thing that goes in and out of pete."
Dontcallmepete is offline   Reply With Quote
Old 07-10-2015, 01:34 PM #10
Burninator
Punisher of fleshlights
 
Burninator's Avatar
 
Join Date: Apr 2004
Location: Texas
Annual Supporting Member
Burninator is a Mega Moderator
Burninator is a Supporting Member
 has been a member for 10 years
Burninator is reppin' sidebar 4 life
Burninator has achieved Level 5 in PbNation Pursuit
Burninator is Legendary
We used Nosql and mongoDB in grad school for cloud applications. Ive also heard many people are moving that way. My current employer has 1 DB of information for like the last 10 years and its an old sql database. I havent had a chance to mess with it much though.
Burninator is offline   Reply With Quote
Reply


Thread Tools

Posting Rules
Forum Jump