June 13, 2017 at 6:41 am
Brandie Tarvin - Tuesday, June 13, 2017 5:01 AMAs part of my Grace Hopper SOL session, I'm committed to naming the different types of database platforms and it occurs to me that I know of a few off the top of my head: SQL Server, Oracle, NoSQL, MySQL, and DB2.
You're mixing types and examples there.
Types would be relational, document, graph, key-value, columnar, object and a couple others
SQL Server, Oracle, MySQL are all examples of relational DBs.
I can give a presentation that has some bits on this, but it's pictures only, no bullets, no notes (was from a university lecture I gave last year)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 13, 2017 at 8:14 am
Grant Fritchey - Tuesday, June 13, 2017 5:50 AMBrandie Tarvin - Tuesday, June 13, 2017 5:01 AMAs part of my Grace Hopper SOL session, I'm committed to naming the different types of database platforms and it occurs to me that I know of a few off the top of my head: SQL Server, Oracle, NoSQL, MySQL, and DB2.Any others that I'm missing?
I only have about 10 minutes to lay out what types of DB administrators there are, mention the different platforms, and explain why databases are so important to modern life before giving 10 minutes of questions and give and take on the session (each one only lasts 20 minutes), so I have to be brief. Any thoughts you'd like me to incorporate into this?
Types of platforms I'd go different:
Relational, Object, ID/Value, Unstructured, Semi-structuredWhat you have is kind of a mix between products & platforms, NoSQL being more of a platform than the products you listed, SQL Server Oracle MySQL & DB2.
Your forgetting the old Hierarchical and Network database systems that came before the relational database systems.
June 13, 2017 at 8:25 am
Lynn Pettis - Tuesday, June 13, 2017 8:14 AMGrant Fritchey - Tuesday, June 13, 2017 5:50 AMBrandie Tarvin - Tuesday, June 13, 2017 5:01 AMAs part of my Grace Hopper SOL session, I'm committed to naming the different types of database platforms and it occurs to me that I know of a few off the top of my head: SQL Server, Oracle, NoSQL, MySQL, and DB2.Any others that I'm missing?
I only have about 10 minutes to lay out what types of DB administrators there are, mention the different platforms, and explain why databases are so important to modern life before giving 10 minutes of questions and give and take on the session (each one only lasts 20 minutes), so I have to be brief. Any thoughts you'd like me to incorporate into this?
Types of platforms I'd go different:
Relational, Object, ID/Value, Unstructured, Semi-structuredWhat you have is kind of a mix between products & platforms, NoSQL being more of a platform than the products you listed, SQL Server Oracle MySQL & DB2.
Your forgetting the old Hierarchical and Network database systems that came before the relational database systems.
Don't forget the access databases that people have saved on their desktops!
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 13, 2017 at 8:55 am
Ugh, what a "fun" morning (for certain values of "fun")
Trying to clean up logins on an old server that's waiting on one customer before being decommissioned, whip up a handy little query to generate the drop logins for any login that doesn't have a corresponding database user. Thought I had it set up to exclude the right accounts (and I did, mostly,) so I copied the drops and ran it...
Then realized that *MY* account (which I'd thought I excluded) was in the list.
Then it looked like (because I'd been dropped) that all the logins except SA were dropped.
So, bounce the SQL instance to single-user, re-add myself as sysadmin, to find out that after I got dropped the rest of the drops couldn't run, so I could've just walked over to the Oracle DBA (my backup) and had her re-add me...
(thankfully, this was a QA instance, with only one customer still on it with an app that keeps working without the database)
While dealing with this, a couple devs pop up with a small code deployment to their app.
Then another customer pops up, having just gotten a backup of a database that is hosted (for now) elsewhere and is coming back into our SQL environment that needed to be copied up to the QA server for work to be done on it.
Which I can't unzip because the sender somehow split the zip file, without actually doing it through a zip utility...
THEN this afternoon another customer wants a meeting about possibly migrating their production databases (finally) on a Sunday...
And they didn't invite *my* supervisor to said meeting (but I did)
You go from no one even knowing you're there, to everyone needing your attention at once...
June 13, 2017 at 9:00 am
Lynn Pettis - Tuesday, June 13, 2017 8:14 AMGrant Fritchey - Tuesday, June 13, 2017 5:50 AMBrandie Tarvin - Tuesday, June 13, 2017 5:01 AMAs part of my Grace Hopper SOL session, I'm committed to naming the different types of database platforms and it occurs to me that I know of a few off the top of my head: SQL Server, Oracle, NoSQL, MySQL, and DB2.Any others that I'm missing?
I only have about 10 minutes to lay out what types of DB administrators there are, mention the different platforms, and explain why databases are so important to modern life before giving 10 minutes of questions and give and take on the session (each one only lasts 20 minutes), so I have to be brief. Any thoughts you'd like me to incorporate into this?
Types of platforms I'd go different:
Relational, Object, ID/Value, Unstructured, Semi-structuredWhat you have is kind of a mix between products & platforms, NoSQL being more of a platform than the products you listed, SQL Server Oracle MySQL & DB2.
Your forgetting the old Hierarchical and Network database systems that came before the relational database systems.
Correction. I am trying to forget those. So should you.
June 13, 2017 at 9:02 am
Hugo Kornelis - Tuesday, June 13, 2017 9:00 AMLynn Pettis - Tuesday, June 13, 2017 8:14 AMGrant Fritchey - Tuesday, June 13, 2017 5:50 AMBrandie Tarvin - Tuesday, June 13, 2017 5:01 AMAs part of my Grace Hopper SOL session, I'm committed to naming the different types of database platforms and it occurs to me that I know of a few off the top of my head: SQL Server, Oracle, NoSQL, MySQL, and DB2.Any others that I'm missing?
I only have about 10 minutes to lay out what types of DB administrators there are, mention the different platforms, and explain why databases are so important to modern life before giving 10 minutes of questions and give and take on the session (each one only lasts 20 minutes), so I have to be brief. Any thoughts you'd like me to incorporate into this?
Types of platforms I'd go different:
Relational, Object, ID/Value, Unstructured, Semi-structuredWhat you have is kind of a mix between products & platforms, NoSQL being more of a platform than the products you listed, SQL Server Oracle MySQL & DB2.
Your forgetting the old Hierarchical and Network database systems that came before the relational database systems.
Correction. I am trying to forget those. So should you.
Ooo, and MUMPS, can't forget MUMPS
June 13, 2017 at 9:12 am
jasona.work - Tuesday, June 13, 2017 9:02 AMOoo, and MUMPS, can't forget MUMPS
IDMS 😉
Far away is close at hand in the images of elsewhere.
Anon.
June 13, 2017 at 9:40 am
Hugo Kornelis - Tuesday, June 13, 2017 9:00 AMLynn Pettis - Tuesday, June 13, 2017 8:14 AMGrant Fritchey - Tuesday, June 13, 2017 5:50 AMBrandie Tarvin - Tuesday, June 13, 2017 5:01 AMAs part of my Grace Hopper SOL session, I'm committed to naming the different types of database platforms and it occurs to me that I know of a few off the top of my head: SQL Server, Oracle, NoSQL, MySQL, and DB2.Any others that I'm missing?
I only have about 10 minutes to lay out what types of DB administrators there are, mention the different platforms, and explain why databases are so important to modern life before giving 10 minutes of questions and give and take on the session (each one only lasts 20 minutes), so I have to be brief. Any thoughts you'd like me to incorporate into this?
Types of platforms I'd go different:
Relational, Object, ID/Value, Unstructured, Semi-structuredWhat you have is kind of a mix between products & platforms, NoSQL being more of a platform than the products you listed, SQL Server Oracle MySQL & DB2.
Your forgetting the old Hierarchical and Network database systems that came before the relational database systems.
Correction. I am trying to forget those. So should you.
Already forgotten. Mostly because I never learned that crap.
See, sometimes NOT having a formal education is a gigantic advantage.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 13, 2017 at 9:59 am
David Burrows - Tuesday, June 13, 2017 9:12 AMjasona.work - Tuesday, June 13, 2017 9:02 AMOoo, and MUMPS, can't forget MUMPSIDMS 😉
INFOS (A Data General product). 😉
June 13, 2017 at 11:09 am
Lynn Pettis - Tuesday, June 13, 2017 9:59 AMDavid Burrows - Tuesday, June 13, 2017 9:12 AMjasona.work - Tuesday, June 13, 2017 9:02 AMOoo, and MUMPS, can't forget MUMPSIDMS 😉
INFOS (A Data General product). 😉
:w00t::w00t::w00t: The old Data General. I didn't work with it for long, but I've intentionally forgotten. I think it might be one of those defense mechanisms we learned about in college psychology class years ago.
June 13, 2017 at 11:32 am
Ed Wagner - Tuesday, June 13, 2017 11:09 AMLynn Pettis - Tuesday, June 13, 2017 9:59 AMDavid Burrows - Tuesday, June 13, 2017 9:12 AMjasona.work - Tuesday, June 13, 2017 9:02 AMOoo, and MUMPS, can't forget MUMPSIDMS 😉
INFOS (A Data General product). 😉
:w00t::w00t::w00t: The old Data General. I didn't work with it for long, but I've intentionally forgotten. I think it might be one of those defense mechanisms we learned about in college psychology class years ago.
DataFlex
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
June 13, 2017 at 12:02 pm
Ed Wagner - Tuesday, June 13, 2017 11:09 AMLynn Pettis - Tuesday, June 13, 2017 9:59 AMDavid Burrows - Tuesday, June 13, 2017 9:12 AMjasona.work - Tuesday, June 13, 2017 9:02 AMOoo, and MUMPS, can't forget MUMPSIDMS 😉
INFOS (A Data General product). 😉
:w00t::w00t::w00t: The old Data General. I didn't work with it for long, but I've intentionally forgotten. I think it might be one of those defense mechanisms we learned about in college psychology class years ago.
Worked with DG hardware/software for over 10 years as a computer operator, system admin, and a programmer. Last employer using the DG hardware dropped it and moved to Solaris using ICOBOL (should have purchased a couple of Linux servers instead, the ICOBOL ISAM files could have help twice the data).
Oh, actually worked for Data General for 3.5 years as well.
June 13, 2017 at 11:48 pm
Lynn Pettis - Monday, June 12, 2017 11:43 AMAnd sarcasm must be a foreign language to you. :hehe:
It's my native.
_____________
Code for TallyGenerator
June 14, 2017 at 5:24 am
Hugo Kornelis - Tuesday, June 13, 2017 9:00 AMLynn Pettis - Tuesday, June 13, 2017 8:14 AMGrant Fritchey - Tuesday, June 13, 2017 5:50 AMBrandie Tarvin - Tuesday, June 13, 2017 5:01 AMAs part of my Grace Hopper SOL session, I'm committed to naming the different types of database platforms and it occurs to me that I know of a few off the top of my head: SQL Server, Oracle, NoSQL, MySQL, and DB2.Any others that I'm missing?
I only have about 10 minutes to lay out what types of DB administrators there are, mention the different platforms, and explain why databases are so important to modern life before giving 10 minutes of questions and give and take on the session (each one only lasts 20 minutes), so I have to be brief. Any thoughts you'd like me to incorporate into this?
Types of platforms I'd go different:
Relational, Object, ID/Value, Unstructured, Semi-structuredWhat you have is kind of a mix between products & platforms, NoSQL being more of a platform than the products you listed, SQL Server Oracle MySQL & DB2.
Your forgetting the old Hierarchical and Network database systems that came before the relational database systems.
Correction. I am trying to forget those. So should you.
Graph Databases?
Used for defining patterns such as path analysis or production lines to identify flow.
June 14, 2017 at 4:05 pm
Hugo Kornelis - Tuesday, June 13, 2017 9:00 AMLynn Pettis - Tuesday, June 13, 2017 8:14 AMGrant Fritchey - Tuesday, June 13, 2017 5:50 AMBrandie Tarvin - Tuesday, June 13, 2017 5:01 AMAs part of my Grace Hopper SOL session, I'm committed to naming the different types of database platforms and it occurs to me that I know of a few off the top of my head: SQL Server, Oracle, NoSQL, MySQL, and DB2.Any others that I'm missing?
I only have about 10 minutes to lay out what types of DB administrators there are, mention the different platforms, and explain why databases are so important to modern life before giving 10 minutes of questions and give and take on the session (each one only lasts 20 minutes), so I have to be brief. Any thoughts you'd like me to incorporate into this?
Types of platforms I'd go different:
Relational, Object, ID/Value, Unstructured, Semi-structuredWhat you have is kind of a mix between products & platforms, NoSQL being more of a platform than the products you listed, SQL Server Oracle MySQL & DB2.
Your forgetting the old Hierarchical and Network database systems that came before the relational database systems.
Correction. I am trying to forget those. So should you.
I think that's a mistake. There are still many out there being used for large scale stuff (sometimes very large scale stuff). If you are a database specialist you may find yourself having to deal with of those databases, if only to get data out of one and into a more modern database model (and already many such transitions have had nightmare problems precisely because the perople in charge of moving the data thought underatanding the old models was beneath them). Pretending that hese thing are not a significant proportion of extant databases, with a very large data content, is just plain "if I shut my eyes it doesn't exist" crazy.
Tom
Viewing 15 posts - 58,906 through 58,920 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply