November 7, 2001 at 7:20 am
My role is defined as Data Architect. What that means and what it is are two different things. I perform server monitoring and maintenance on SQL 7.0 and 2000 servers. I spend quite a bit of time managing replication between an AS/400 DB2 environment and MS SQL. When things are calm , I actually do my job which is design database architectures. I use ERWin for my modelling tasks.
My biggest regret is: I rarely get to code anymore.
My biggest joy is: I rarely have to debug production code.
Thom Pantazi
November 9, 2001 at 9:43 am
I handle 4 MSSQL 2000 servers, 1 Sybase 12.0 Adaptive server, 1 Oracle 9i server, and some old dodgy Access and Fox Pro applications some monkey knocked out as a temporary measure 7 yrs ago. guess which one takes the most time . I also do Database design with Erwin and ER studio and handle change management for all of the above.
Matt
November 9, 2001 at 10:02 am
November 9, 2001 at 2:12 pm
You and Leon must the only ones left!
Andy
November 9, 2001 at 2:29 pm
Get the F##$ Out of Here.
Visual Fox was much better than VB, up to and including v6. It was object oriented, support inheretence of objects and was great to develop in.
Of course, you had to know more than the average VB monkey does to work with it effectively.
I think with VB.NET, VB will take the lead.
Steve Jones
November 22, 2001 at 11:30 am
I am a DBA for SQL Server 7 and 2000. I also do programming and admin for Oracle 8i.
I code stored procedures, and do front-end programming in VB, ASP, Java, JavaScript, VBScript, unix scripting, windows scripting, and Visual C++. And I also do security administration in Win NT 4.0 and 2k.
Lastly, I do mentoring and training on DB modeling/architecture, performance tuning and programming.
That's about it. 🙂
November 22, 2001 at 3:40 pm
Steve, I must have missed your response about Foxpro...too funny! I honestly haven't used FP, so I throw rocks at it mainly to annoy Leon. Still, I'm pragmatic about such things. If you know VB, you get VBScript for free, all the MS apps use VB for macro's, giving you the ability to "record" source code and then tweak it. More importantly to me, I believe (I can hear the feedback starting already) that there are many more jobs doing VB work than FP.
Inheritance is interesting. I've survived for a while without it, will take some retraining to get used to having it available. My guess it we'll see it either over used or under used, just like everything else (XML!).
Ever use QuickBasic? Now THERE is a language! You could not only step forward through your code in the 'IDE', but step backwards!
Andy
November 22, 2001 at 5:13 pm
Anyone else frightened by vb.net?
EDL now there was a language (and machine); kept me off the streets for several years.
Cursors never.
DTS - only when needed and never to control.
December 5, 2001 at 7:31 am
I'm a DBA for a large Org..I 'm responsible for around 15-20 SQL servers 7/2000 @ multiple sites (Globally).{with some others sometimes doing that work - when I'm busy}..
I love the variety (Tunning, DTS, Stored Proc..and of course SQL Coding !! as well as some VB and excel Dev & loads of ASP)
I hate it when I know what I want to do.. but have to work around (with Code) some of the (MS)SQL limitations..
Ohh.. and be carefull with MDAC 2.7..
it does not like NotesSQL (I had real fun sorting that one out !.. please ask if you want more info.)
Neil Hambly
December 5, 2001 at 12:35 pm
I'm looking forward to VB.NET. Too many "little" issues with VB.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
December 5, 2001 at 12:53 pm
I think VB.NET is a good step forward, but personally I'll lean more towards C#. Always loved C.
Steve Jones
December 5, 2001 at 4:31 pm
Im looking forward to .Net, the VB variety as well. Got some very nice features.
Andy
December 28, 2001 at 3:49 pm
We currently use Oracle 806, SQL2k, DB2, sysbase, and of course everybody's favorite.....Access.
Rob DeMotsis
Sr. SQL Server DBA
Pier 1 Imports, Inc.
Rob DeMotsis
Sr. SQL Server DBA
January 3, 2002 at 8:06 am
I sometimes help our network department and give minimal support for our researchers with the VB app. Usually the VB support is when none of our VB programmers are available (which occured this past week since they were all on vacation and I was not).
Because I have some experience with networking I often setup my own NT accounts and do minor configurations that I need for my SQL projects. I have helped our network people trouble shoot networking problems on occasion.
Robert Marda
SQL Programmer
bigdough.com
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
Viewing 14 posts - 16 through 28 (of 28 total)
You must be logged in to reply to this topic. Login to reply