596 reputation
23
bio website
location Central Victoria Australia (between Melbourne and Bendigo)
age
visits member for 2 years, 9 months
seen Oct 23 '12 at 3:08
  • c# and .net websites (and knows a bit of Java and C).
  • Database design, build, tune and maintain.
  • Builder of batch processing systems.
  • Writes scripts in bash and wsh.
  • Change and release management.

Sep
24
awarded  Autobiographer
Dec
27
awarded  Yearling
Dec
27
awarded  Yearling
Oct
23
answered Partitioning in SQL Server 2008
Oct
19
comment Partitioning in SQL Server 2008
Why do you need to partition? is it to archive off seldom used data or for performance or space reasons?
Oct
16
answered Recommendations for PostgreSQL training
Oct
14
answered How to determine which SQL Server user or database overuses server resources
Oct
4
answered How to get SQL Profiler record the user which login to your web application but the SQL username and password is specify in the web.config file?
Sep
20
answered What are the pros and cons of this schema for flashcards app?
Sep
10
comment Can operations in a loop cause table locks?
Some insights may be gained here stackoverflow.com/questions/2248011/…
Sep
10
answered MySQL database backup every day using java code
Sep
10
answered Maximum number of databases for single instance of PostgreSQL 9
Sep
10
comment Db design for a quiz with variable number of answer choices, and each worth different score in a different category?
Duplicate? dba.stackexchange.com/questions/11933/…
Sep
4
answered Is it possible to synchronize two ms access db?
Sep
4
comment Database Design for Questions and Answers
You probably need one more table to hold the list of responders (maybe with name, contact details, dates, etc), and then a extra field in the RESPONSES table to act as a foreign key to this table. This way you can get the responses per responder.
Aug
29
answered How to shard 14 gb of data for archival database?
Aug
27
answered Single query sending and retreiving duplicate data on MS SQL Server?
Aug
27
answered How to simplify schema for multi database / hundreds of millions of rows data set
Aug
23
answered PostgreSQL import CSV File causes Syntax Error
Aug
22
answered How do I perform a UNION query on a dynamic list of tables?