How many years

Of database experience do you have?
And what are they?approximately 30

IDMS, DB2, SQL Server, Access, Oracle, MySQL|||approximately 8

Oracle, Sybase, Sql Server, Access, MySql|||I've lost count, but I think it is 8.

Informix SE - 1 year,
Oracle - 4 years
Sybase - 2 years
SQL Server from 6.5 - SQL 2005 - Since 1997

I still read half these posts and say, "I am such a danged noob."|||5+ Years ...Excel ... Access ... Oracle ... SQL Server|||5+ Years ...Excel ... Access ... Oracle ... SQL Server I didn't realize Excel counted ;-)|||It doesn't.

10+ years. SQL Server/Access/Oracle/Sybase.|||I've been working with databases since the late 1970s.

Everything from CMS to SQL Server 2000, with bunches of MUMPS, Clipper, HP IMAGE 3000, Jet (the engine behing Microsoft Access), Paradox, different C and UCSD systems, etc, etc, and so forth. I've used almost every microcomputer database engine that I've ever heard of, and many of them on a professional basis.

-PatP|||Do you mean to say Excel isn't a database ;). I have had many managers who thought so :)|||I guess I should have said Database Management Systems

http://www.webopedia.com/TERM/D/database.html

I guess a database could be anything.

I left Relational outm because then that would invalidate IDMS as well...

Ever have to fix pointers?|||Do you mean to say Excel isn't a database ;). I have had many managers who thought so :)
I've had managers who thought they were managers, but weren't any more managerial than a spreadsheet is relational.|||Ever have to fix pointers?nope, i would always delegate scutwork (http://www.answers.com/topic/scutwork) to the DBA ;)|||6+ with SQL server, Access, Oracle, Foxpro, DBase, Flat Files, MySQL|||6+ with SQL server, Access, Oracle, Foxpro, DBase, Flat Files, MySQL

Hey, thanks for playing along.

And you blind dude, from the def I posted, a "data base" seems to be just about anything...like flat files...

So I should include QSAM, VSAM, and BDAM...no kidding

IDMS for example is non relational...it's hierarchacal, but it is a Database Management System.

I guess Notepad would be considered a DBMS for a text file.|||6 years SQL Server (6.5, 7, 2000)
1 year Oracle (8, 9, 10)
6 months DBase (III, IV?)
Access here and there (2.0, 97, 2000, 2003)|||I can remember standing outside the classroom where I first studied Boyce, Codd & Date saying :-

"I don't think this Microsoft Windows GUI thingy will be popular"

So I'd say 9+ Years but - I used 2 have 2 look after everything else at the same time, so say 30 percent of that hands on being paid for it ;-)

GW|||Hey, thanks for playing along.

And you blind dude, from the def I posted, a "data base" seems to be just about anything...like flat files...

So I should include QSAM, VSAM, and BDAM...no kidding

IDMS for example is non relational...it's hierarchacal, but it is a Database Management System.

I guess Notepad would be considered a DBMS for a text file.
Ah. Ok then. In that case I have about 35 years experience, dating from the first time I "backed up" my teacher's vocabulary database from the blackboard to my trapper-keeper. As I recall, I had to use one of the old Crayon '72 processors to get the job done. -sigh- Those were the days...|||Yes, and a SELECT Would be a transfer of an item to another piece of paper.

So I guess Guttenberg was the first DBA|||Just hit my two year mark on SQL Server 2000. Been introduced to MySQL and Oracle, but haven't used them much. I guess I'm the youngin' of the bunch.|||20 years - IMS, Adabas, DB2 (mainframe), Oracle, RDB, SQL Server, Access, Unidata|||5+ But during that time mostly C++ programming, nowadays since 2 years I'm mostly db instead of C++.

Oracle, Access, Informix, SQL Server|||I gotta learn c#|||I've got about 3 years of Oracle (basics) and now I'm diving head first into MSSQL. Not totally a huge difference I know, but we did alot with Oracle through our frontend as far as tuning and performance along with some backdoor fixes and data manipulation. My new job is all behind the scenes, no out of the box software - it's all custom. I've got to learn tuning and analysis ASAP - boy-o-boy, it sure would have been nice to have some overlap with the previous person, but I guess I'll just sink or swim! For my sake, I hope I at least float until I can swim with the sharks!
Tiffanie|||Hey welcome!

And remember you're not alone.

You got US!

And yes Tiff, there are some major differences

Like, forget about using any cursors...|||I gotta learn c#

Why?

Not to open up a hot topic (off topic too), but I don't like the .NET offerings. Nothing wrong with the languages, I don't like having to use the .NET framework.

Bill|||Thanks for the welcome Brett! So far you all have helped me twice and so I guess I'm still floating thanks to this group! Any recommendations on EXCELLENT resources for starters then? I've been reading the BOL and a few other books we happen to have in the office (SQL Server2000 Resource Kit and Administrator's Companion) plus a DTS manual. I really like where I'm at and would love to be here beyond my 90 day probation! Half way there! They had enough guts to hire me and take a chance that I'd catch on quickly (MSSQL was nowhere on my resume) and now I need to hold up my end of the deal and learn this! I'm putting in 50 hours of regular work days plus another 25 hours of home study time per week. So if anybody has any quick tips that are good to know for the here and now - I'd love to see/read/hear about them! (Especially perf tuning and analysis)
Tiffanie|||Thanks for the welcome Brett! So far you all have helped me twice and so I guess I'm still floating thanks to this group! Any recommendations on EXCELLENT resources for starters then? I've been reading the BOL and a few other books we happen to have in the office (SQL Server2000 Resource Kit and Administrator's Companion) plus a DTS manual. I really like where I'm at and would love to be here beyond my 90 day probation! Half way there! They had enough guts to hire me and take a chance that I'd catch on quickly (MSSQL was nowhere on my resume) and now I need to hold up my end of the deal and learn this! I'm putting in 50 hours of regular work days plus another 25 hours of home study time per week. So if anybody has any quick tips that are good to know for the here and now - I'd love to see/read/hear about them! (Especially perf tuning and analysis)
Tiffanie

I would pick anyone of these

http://www.sqlteam.com/store.asp

Plus Kalen Delaneys inside sql server, is actuallly pretty intense|||Why?

Not to open up a hot topic (off topic too), but I don't like the .NET offerings. Nothing wrong with the languages, I don't like having to use the .NET framework.

Bill

Because of this

http://www.sqlteam.com/item.asp?ItemID=21927

And this

http://www.sqlteam.com/item.asp?ItemID=22074|||you know, just the other day I was thinking the same thing. C#, here I come (after I read through the stack of books sitting in my basement office).|||Because of this

http://www.sqlteam.com/item.asp?ItemID=21927

And this

http://www.sqlteam.com/item.asp?ItemID=22074

It was my understanding that this amounted to a much better way to code and implement extended stored procedures. You can write TransactSQL all day long without needing to know C#. How often do you need to write extended stored procedures? Me ... almost never. I'm not sold on the CLR integration. I'll stick with T-SQL to get my work done.

Bill|||It was my understanding that this amounted to a much better way to code and implement extended stored procedures. You can write TransactSQL all day long without needing to know C#. How often do you need to write extended stored procedures? Me ... almost never. I'm not sold on the CLR integration. I'll stick with T-SQL to get my work done.

Bill

True, Bill, True.

There has not been one thing that I haven't been able to accomplish with TSQL and a couple of *.bat files|||Speaking out of ignorance, admittedly, but it seems to me that CLR is yet another inefficient crutch for developers who can't be bothered to learn SQL.
Sad.|||Speaking out of ignorance, admittedly,
Sad.

Well, at least you feel at home

:D|||DataEase - 2 years
Lotus Approach - 3 years
MS Access - 4 years
SQL Server - 6 months|||Dude, I thought you would've bit on that one....|||Why, its not a willy-waving thread is it? Anyway, 2 years of DataEase isn't that bad is it :p

Besides, it took me quite a while to get a job with full-time SQL Server experiece. I'm proud of my 6 months!|||five years overall db experience. has felt like 25 and the the last 3 works days on the new job felt like 15 of that.

my chair was not warm yet before it started coming fast and furious. no honeymoon here. feels weird to actually work for a living again. got a get back to writing this query that needs to be in production tomorrow.|||Well, I guess I should chime in on this never-ending story.

http://www.sql-server-performance.com/profile_derrick_leggett.asp

Yep, that about does it. :)

I've been doing the database gig for about 12 years now on all kinds of hierarchial and relational database engines. That's if you don't include DBase IV, SmartSuite (don't ask), and other stupid things like notepad. Nobody mentioned edlin??

Products I work on include CA Datacom, SQL Server, Oracle, some DB2 (too much), mySQL, Access (should this really count), Progress (piece of sh*$), postGre (now Enterprise DB I think?), and the good old VAX. Gotta love those.|||http://www.sql-server-performance.com/profile_derrick_leggett.aspi liked this question: "What Microsoft (and other) certifications do you have?"

i have MCSE - minesweeper expert and solitaire consultant

:)|||i have MCSE - minesweeper expert and solitaire consultantAre you certifiably dislexic too? :p

-PatP|||no, pat, i'm not -- it's part of the joke (possibly above you?)|||no, pat, i'm not -- it's part of the joke (possibly above you?)Obviously... It missed me completely on the first pass, and still eludes me.

-PatP|||Seeing as you are in Canada, of course you are above him. Duh.|||15+ years database ... IDMS, PACE (Wang Labs), ORACLE, SQL Server, ACCESS|||Enable (does anybody even remember that?)
Access - 12 years
Informix - 1 year
Sql Server - 4 years, but still mastering the basics|||Access, 12 years?

Is that 1.2 or 2.0?

I remember a gig I did for $200 in Access 1.2...boy was I a moron...|||I started with Access 2.0. It was the only thing my company would make available to me at the time.|||I started with Access 2.0. It was the only thing my company would make available to me at the time.

So...you're that dangerous

:D