Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[jimbobmccoy]

How do

I really dont think its worth paying the money to sit the mcitp exam, but i'm not sure of the best way to find the requirements, and thusly the best things to concentrate on working on.

I know microsoft do revision guides, but if i want the knowledge, whats the best way to go about getting it.

At the moment i administer my companys it structure, which is 30 odd shops on standalone till units but users in AD using webmail, with about 20 workstatoins at head office, running off two servers, one an app server one the domain controller, using server 2003.

I feel confident doing most things on the network, and have a bit of knowledge using sql since our epos system is sql based, oh, and crappy businessmaster if anyone is familiar with it. btrieve and pervasive are the bane of my life.

anyhow, seems lots of peeps in the know on here, so any pointers that i can use to develop myself in my own time would be greatly appreciated.
no point standing still!!

[TheBoy]

LOL, I write the epos stuff for my brother's shops...

[jimbobmccoy]

we had bought ours of a company years befor i joined.
they try to convince me its complicated, but the only hardship is that most of the tables and programming is written in german which i dont read!

i'm trying to convince them it is possible to put a fingerprint scanner in that will talk to it at the moment, but they dont get that an image of a finger print can be stored as a looooong list of digits that can be read like a barcode.

still, i've been contemplating a move, bit like jamesv6 but in the current climate i thought i'd stay where i'm secure and use the time to develop myself.

come the revolution and all that stuff....

[cem_devecioglu]

How do

I really dont think its worth paying the money to sit the mcitp exam, but i'm not sure of the best way to find the requirements, and thusly the best things to concentrate on working on.

I know microsoft do revision guides, but if i want the knowledge, whats the best way to go about getting it.

At the moment i administer my companys it structure, which is 30 odd shops on standalone till units but users in AD using webmail, with about 20 workstatoins at head office, running off two servers, one an app server one the domain controller, using server 2003.

I feel confident doing most things on the network, and have a bit of knowledge using sql since our epos system is sql based, oh, and crappy businessmaster if anyone is familiar with it. btrieve and pervasive are the bane of my life.

anyhow, seems lots of peeps in the know on here, so any pointers that i can use to develop myself in my own time would be greatly appreciated.
no point standing still!!

Now comes the question ..Which one you prefer actually..

Op.Systems Management or Database Administration..

They are different tasks actually .. If you want database

administration I must admit also you must know some tuning about

op.system parameters..(which again requires you must know some

internals) And if you want to be good db administrator first of all you

must be capable of writing real production application code which talks

to db and utilize its abilities..And you need really long time to be

experienced..

As an old programmer I dont take those courses from Microsoft but

been currently using SQL server for more than 10 years and also

Oracle my experinece is that it really takes time..

[jimbobmccoy]

to be honest, i'd like to know a bit about database administration, but i really enjoy kinda maintaining a network, and all the varying challenges that offers.

i dont think the microsoft courses will ever offer an alternative to experience, and i find no shame in hitting a problem i know nothing about and going away to research and find the solution, i do think theyoffer a good starting point or prompt though.

unfortunately i think to progress career wise it may be necessary to have the bit of paper to open doors.
me myself, would be happy spending 10 years just learning off my own back (finances allowing of course)

[TheBoy]

mcse and ccna will be the ones that get you past paper sift in large corporate environments.

[cem_devecioglu]

You can learn database administration principles with small databases

also which will cost nearly nothing..Also you can download some beta

or demo versions of SQL server which will be very helpfull ..

Main tasks are Creating databases, creating tables (with fields),

creating users, user permissions, indexing tables (needs a bit reading)

then comes the transact sql (which is a bit complicated) and stored

procedures and the list goes on..

The next step is writing a code which connects to db and reading from

the tables..  if you google you can find many examples but also you

must choose a language and a compiler environment..

[jimbobmccoy]

mcse and ccna will be the ones that get you past paper sift in large corporate environments.

doyou think its worth investing in, or are their too many applicants and too few corporate positions at the moment.

i dont have enough experience i dont think to get a great position, as im only 26, so in this respect age isnt on my side.

[TheBoy]

mcse and ccna will be the ones that get you past paper sift in large corporate environments.

doyou think its worth investing in, or are their too many applicants and too few corporate positions at the moment.

i dont have enough experience i dont think to get a great position, as im only 26, so in this respect age isnt on my side.

currently, many corporates are outsourcing heavily, and the outsourcers are cutting jobs.

in our environment, no shortage of people going for the 1 or 2 jobs that come up - and we tend to only take on contractors currently, and pay them a pittence (most of them only worth that!)

Getting good app develoopers seems to be hard currently, but degree level programming to get through paper sift.  But we're offshoring a load of that as well now.

[TheBoy]

You can learn database administration principles with small databases

also which will cost nearly nothing..Also you can download some beta

or demo versions of SQL server which will be very helpfull ..

Main tasks are Creating databases, creating tables (with fields),

creating users, user permissions, indexing tables (needs a bit reading)

then comes the transact sql (which is a bit complicated) and stored

procedures and the list goes on..

The next step is writing a code which connects to db and reading from

the tables..  if you google you can find many examples but also you

must choose a language and a compiler environment..

Even Access and VBA (or better full VB6) can be a good learning for Transact SQL.  OK, no SPs or triggers, but the SQL language is similar enough to learn on.

vb.net ain't no good with Access.

or vb.net with SQL Server Express (all available free), but you need to programmatically create databases and tables (good learning)

[cem_devecioglu]

You can learn database administration principles with small databases

also which will cost nearly nothing..Also you can download some beta

or demo versions of SQL server which will be very helpfull ..

Main tasks are Creating databases, creating tables (with fields),

creating users, user permissions, indexing tables (needs a bit reading)

then comes the transact sql (which is a bit complicated) and stored

procedures and the list goes on..

The next step is writing a code which connects to db and reading from

the tables..  if you google you can find many examples but also you

must choose a language and a compiler environment..

Even Access and VBA (or better full VB6) can be a good learning for Transact SQL.  OK, no SPs or triggers, but the SQL language is similar enough to learn on.

vb.net ain't no good with Access.

or vb.net with SQL Server Express (all available free), but you need to programmatically create databases and tables (good learning)

 

[Martin_1962]

Getting good app develoopers seems to be hard currently, but degree level programming to get through paper sift.  But we're offshoring a load of that as well now.

Haven't come across many degree level programmers - the two top ones in our company just have about 20 years each experience instead. (just worked that out - very scarey really)

[cem_devecioglu]

Getting good app develoopers seems to be hard currently, but degree level programming to get through paper sift.  But we're offshoring a load of that as well now.

Haven't come across many degree level programmers - the two top ones in our company just have about 20 years each experience instead. (just worked that out - very scarey really)

yep... same here..

[TheBoy]

Getting good app develoopers seems to be hard currently, but degree level programming to get through paper sift.  But we're offshoring a load of that as well now.

Haven't come across many degree level programmers - the two top ones in our company just have about 20 years each experience instead. (just worked that out - very scarey really)

those that don't probably won't get through our papersift, which is shame, as it limits who we can have.

but then, our marketers think its important from a sales view.

[Martin_1962]

Getting good app develoopers seems to be hard currently, but degree level programming to get through paper sift.  But we're offshoring a load of that as well now.

Haven't come across many degree level programmers - the two top ones in our company just have about 20 years each experience instead. (just worked that out - very scarey really)

those that don't probably won't get through our papersift, which is shame, as it limits who we can have.

but then, our marketers think its important from a sales view.

Typical - chuck out the experienced and get the graduates who won't know how to get software out