359 reputation
26
bio website
location
age
visits member for 3 years, 1 month
seen Apr 4 at 14:51

Retired. Once a programmer, then a DBA.


Mar
25
comment Why is Database Administration so hard?
Good writeup. It might be worth being more explicit about being a DBA that serves developers in a devlopment project, and being a DBA that serves database stakeholders in a production environment. These two kinds of DBA deal with the same subject matter, but require completely different psychologies.
Feb
12
awarded  Necromancer
Jan
2
answered Deciding when to extend to child tables
Dec
6
answered Database partitioning - Horizontal and Vertical sharding - Difference between Normalization and Row Splitting?
Nov
4
comment Data modelling concepts
Are you using ER modeiling to capture analysis or design? If you are analyzing the subject matter, and you discover circular relationships in the real world, by all means you should model them. If you are designing a database, then you need to consider whether all of these relationships are going to be reflected in the design.
Oct
24
answered Are 2+ Foreign Keys a Bad Idea in any Association / Junction table?
Sep
24
answered How could DBAs be more 'programmer friendly'?
Sep
15
comment What do you call a relationship between two entities without a foreign key?
A foreign key may or may not be a feature of the data as given, before it's manipulated by the application prior to entry in the database. Foreign keys are a feature of the relational model of data, but not a feature of the entity-relationship model of data. If the ERD is being used to represent a relational schema, then foreign keys are germane. Otherwise, not.
Aug
7
awarded  Yearling
Aug
7
answered Why set up static data in views vs. using tables in mysql?
Aug
5
comment Oracle DB Recovery
There are lot of people who become de facto DBAs because there is no one else to do the job. Some of them are in this area.
Jul
28
comment Sybase SQL Anywhere 12 - Get all indexes which are unique -> ambigious sysindexes error
What do you mean by "shouldn't be unique"? Do you mean that the data is overconstrained relative to the business rules of the subject matter?
Jul
14
comment School database design
So far so good. Do you know how to design a junction table with two foreign keys so as to implement a many-to-many relationship such as between students and courses?
Jul
14
comment School database design
What do you know about foreign keys? This will determine what the best way to answer your question is.
Jul
12
comment Order table Database design
Your question is really a combination of two kinds of questions. The first kind is about the quality of the design, namely whether your table design is going to facilitate your operations. The second kind is analysis questions, namely whether the business really works the way your design assumes it does. You need to consider the second kind first, and we can't really help you. Your restaurants could work differently than the ones we have encountered.
Jun
10
answered adding ORDER BY decreases speed by 15x
Jun
10
comment adding ORDER BY decreases speed by 15x
How long does it take if you omit the qualifier DESC?
Jun
6
comment Proper Use of Lookup Tables
@Mike, good comment!
Jun
5
comment Is it worth to separate columns into multiple tables for one-to-one relational table
Yikes. Thanks. Will edit.
Jun
5
revised Is it worth to separate columns into multiple tables for one-to-one relational table
fixed problem about tags not defined in dba