161 reputation
3
bio website townsends.ca
location PEI, Canada
age 35
visits member for 3 years, 1 month
seen Sep 16 at 17:28

Primarily a SQL Server developer, I have more than 10 years experience in Enterprise-level IT projects.

  • I started in Fortan 77 on a VAX VMS (DEC Alpha);
  • worked up through Pascal, VB6 and Coldfusion;
  • led a couple of Java development teams;
  • was senior team leader for a dotNet team for a couple of years;
  • spent some time doing PHP on MySQL for a startup;
  • for more than a year was in charge of managing and developing the database systems and applications for L'Oreal NZ;
  • spent the next year doing SSIS and stored proc development for Spendvision.com;
  • followed up with some time back at the Government of Canada;
  • and now do Java development in the Healthcare sector for Accreon.com

Mar
19
comment Help understanding database design logic for a secondhand bookstore project in MySQL
Yes, you could use the order_details as sales_history.
Mar
18
comment Help understanding database design logic for a secondhand bookstore project in MySQL
I would think that if this is an online system (registration by email suggests that), all buyers must be users. Even Amazon used to create anon user accounts if buying without logging in. As for the other types of users, that's what refactoring is for (eg: add a user_type column.) No point designing for what you might never use, you're bound to miss a future use case and end up having to refactor regardless.
Mar
18
answered Help understanding database design logic for a secondhand bookstore project in MySQL
Mar
18
comment Help understanding database design logic for a secondhand bookstore project in MySQL
What's the relationship between an Order and a Sale? If an Order is just the sale of a single book, then you could just add seller_user_id, sale_value_total and sale_value_tax. Or do you mean Sale as in "a list of items for sale but not yet sold"?
Mar
18
awarded  Supporter
Oct
26
comment Single DELETE statement deadlocking in Sybase ASE
The default, it should be Read Committed for this server. I can double-check it later, if you think that makes a difference. There's only the implicit transaction though, so I would have thought all transaction levels above Read Uncommitted would behave the same way.
Oct
25
asked Single DELETE statement deadlocking in Sybase ASE
Oct
30
awarded  Teacher
Oct
30
awarded  Autobiographer
Oct
20
answered SQL Server symmetric key & certificates games by Hacker?