446 reputation
610
bio website samsaffron.com
location Sydney, Australia
age 38
visits member for 3 years, 3 months
seen Feb 26 at 1:42

Co-founder: http://www.discourse.org

email: sam.saffron@gmail.com
blog: http://samsaffron.com
twitter: @samsaffron

Ex Stack Overflow Valued Associate #00008, creator of Stack Exchange Data Explorer

Other projects:

  • Community Tracker, a system inspired by Stack Overflow to manage your bugs, feature requests and customer support.
  • Media Browser, an open source plugin for Windows Media Center. I makes browsing through your media awesome.

All original source snippets I post on Stack Overflow are dedicated to the public domain. Do with them as you see fit.


Mar
31
awarded  Good Question
Jan
16
awarded  Yearling
Oct
19
awarded  Popular Question
Sep
24
awarded  Notable Question
Sep
10
awarded  Good Question
Apr
15
awarded  Popular Question
Mar
5
awarded  Necromancer
Jan
16
awarded  Yearling
Dec
28
comment Is there a tool like Microsoft's “SQL Server Profiler” for MySQL?
wow, very detailed answer, thanks! how do you compare this to jetprofiler?
Dec
28
awarded  Teacher
Dec
28
awarded  Self-Learner
Dec
28
awarded  Scholar
Dec
28
awarded  Nice Question
Oct
20
comment Passing array parameters to a stored procedure
fyi, for Dapper I avoided TVPs cause manually passing in lots of parameters was faster, if in general you use the same size of list and it is not too big.
Jul
8
comment The smallest backup possible … with SQL Server
@gbn ... still deciding on what to do, I think the "regular" - back stuff up to Oregon job is feasible with the solution you suggested. However, the "Sam needs to download SO db once a month problem is still very very painful cause I need to move 22gigs to Australia - when the reality is that the "real" information could easily fit in 10 gigs."
Jun
6
awarded  Nice Question
Jun
2
comment The smallest backup possible … with SQL Server
@gbn, we need to optimise for daily full, we use enterprise, the DR is all local with people taking the stuff offsite. The small backups are required for devs and a second offsite we have. note ... devs are offsite, in other countries with limited bandwidth, we need the minimal transfer size from the servers in NY to (for example) Australia. We sync up once every few months.
Jun
2
awarded  Student
Jun
2
asked The smallest backup possible … with SQL Server
Apr
7
awarded  Supporter