132 reputation
10
bio website
location Connecticut
age 42
visits member for 5 months
seen May 16 at 13:11
stats profile views 3

Developer (c/c++/c#, Perl, VBS, PLSQL, Oracle), Proof of Concept work as a software technologist and technical researcher.


May
16
accepted How to output query to file using SQLite3
May
16
asked How to output query to file using SQLite3
Apr
19
comment In regards to GS1 barcode - what size DB field are used?
Planning on storing the ASCII characters unless someone with experience recommends parsing and storing. Trying to find x.
Apr
19
asked In regards to GS1 barcode - what size DB field are used?
Apr
16
awarded  Popular Question
Apr
10
awarded  Custodian
Apr
10
reviewed No Action Needed INFORMATION_SCHEMA Selection Error
Apr
10
comment AWS performance of RDS with provisioned IOPS vs EC2
And beware that RDS has a hard limit of 1 TB. If there is slightest possibility you may outgrow it, be sure to plan for migration (or just stick with the EC2 and provisioned IOPS). Also, if you will use for anything more than one month per year of instance being utilized, the reserved instance will save you money.
Apr
2
comment Please Review my Schema
@ypercube - +1 on the comment for SQL-Fiddle. Useful stuff!
Mar
31
revised Database design - do I need another table?
added 138 characters in body
Mar
30
answered Database design - do I need another table?
Mar
30
comment Database design - do I need another table?
It would be helpful to include a diagram of the current schema... and is only the information of the current employer which needs to be retained ?
Mar
23
revised Please Review my Schema
added link to previous related question
Mar
23
suggested suggested edit on Please Review my Schema
Mar
23
comment Please Review my Schema
Your addresses table is US centric. Will likely need more columns to accommodate global address formats. However, this may be no issue depending on the purpose of this schema. Can you elaborate?
Mar
21
awarded  Analytical
Mar
20
revised In what data type should I store an email address in database?
Looking for non-SQL Server specific answer and having a sql server example only caused the discussion to revolve around MSSQL
Mar
19
awarded  Nice Question
Mar
19
accepted In what data type should I store an email address in database?
Mar
19
comment In what data type should I store an email address in database?
the data tier needs to be sized to accommodate email addresses from other applications. The business requirement is to support integration with other web api's.