a question for SQL programmers

[thatdarncat]

I've got a (sort of important - at least to me) question.

My contract is up for renewal at work. I'm being asked to migrate some access 97 databases to SQL, and will be doing the programming of said SQL server in the future.

You are an SQL programmer. Roughly how much do you make an hour?

(and I bet you thought I was going to ask how to do a select query in SQL )

 

[Mustrum_Ridcully]

Unfortunately, I am not a SQL Programmer. The last time I heard what people in the electronic business get was 120 Euro per hour for a technician that would repair my notebook. (Luckily, I still have gurantee...)`

 

[gariig]

Have you tried salary.com? It might cost you..but if you really want to know..

Gariig

 

[LightPhoenix]

Mmmm, Google...

http://www.payscale.com/salary-survey/aid-10904/raname-SALARY/fid-6886/

This site, which is for Senior Software Engineer/Developer/Programmer, lists SQL programmers as making $61,000 to $87,000, with an median of $74,000. Unfortunately getting the average requires a membership.

 

[smetzger]

Access 97 uses SQL so there is nothing to do.

Just a pet pieve of mine.

 

[thatdarncat]

Access 97 uses SQL so there is nothing to do.

Just a pet pieve of mine.

Access 97 and Access 2000 do (sort of) use SQL - it's there as an option, though they would much prefer that you use VBA and queries for everything. Access does NOT provide the stability and multi-user environment that SQL provides.

Just a pet pieve of mine My company should have switched over to SQL (or at the very least Access 2000) a few years ago.

 

[smetzger]

Access 97 and Access 2000 do (sort of) use SQL - it's there as an option, though they would much prefer that you use VBA and queries for everything. Access does NOT provide the stability and multi-user environment that SQL provides.

Just a pet pieve of mine My company should have switched over to SQL (or at the very least Access 2000) a few years ago.

Uhmm, Oracle is SQL compliant, Advantage is SQL compliant, Paradox is SQL compliant, Interbase is SQL comliant, MySQL is SQL compliant, etc. etc.

But you are talking about MS SQL Server.

 

[drothgery]

That seems like an ...odd... title.

Either it's a programmer who has to code against a database (in which case you'll be working in another programming language -- probably VB or C#, if the database is MS SQL Server -- at least as much as you're using SQL, if not more often) or it's a DBA.

Given the job description, it looks like they want you to program against a database. Access' upsize wizard should be helpful in migrating your data to SQL Server. So the difficult of the job will mostly be dependent on how complex your forms and reports are and how well you know whatever tools you're using to build the new SQL Server-based front end in.

Myself, I'm a programmer who does tons of web stuff, almost always VB.NET/ASP.NET/SQL Server. It's not as quick & easy as Access (though VS.NET 2003 is in many ways a nicer IDE to code in than the modified VB6 IDE of Access), but it does scale a lot better.

 

[thatdarncat]

Given the experience I've had with other databases the company uses, I'm expecting plenty of issues. I also have to completely recreate a couple of databases. The company has had 8 or 9 programmers previous to me - I'm just trying to do as best I can with what they've left behind.

In a given week I preform network admin tasks, hardware and software troubleshooting, training, database and misc programming, in addition to data entry, transcribing and clerical work. I'll even move furnature. *shrugs* sucks to be the new guy I guess.

 

[Sir Whiskers]

Minor hijack//

On a related note, I've noticed there are not a lot of postings for pure MS Access work, while I see SQL postings every week. How much will my Access experience help if I try to move into SQL programming? What should I study?

I've worked with MS Access since the old 2.0 days and love designing db's, everything from the structure to the GUI. I've taught myself to build queries in SQL (i.e., without the query grid in Access), and used a ton of VBA, but I haven't formally taken any programming courses beyond Basic.

Any suggestions would be welcome. Thanks.

Hijack off//