103 reputation
12
bio website
location
age
visits member for 3 years, 11 months
seen May 21 '13 at 19:59

Oct
30
awarded  Notable Question
Jun
20
awarded  Popular Question
Apr
13
comment How well does PostgreSQL perform with a large number of databases?
Parameterized stored procedures don't protect against anything but SQL injections. If one of those procedures does a SELECT * WHERE clientId = 3, you have a security leak.
Aug
17
comment ODBC (SQL Server): How do I turn on Multiple Active Result Sets(MARS) for a System DSN?
I don't understand your comment. I am using the SQL Native Client via ODBC, my app works when I change the registry key.
Aug
17
accepted ODBC (SQL Server): How do I turn on Multiple Active Result Sets(MARS) for a System DSN?
Aug
17
comment ODBC (SQL Server): How do I turn on Multiple Active Result Sets(MARS) for a System DSN?
Thank you, I could not get it working through the connection string. Is it supposed to be MultipleActiveResultSets=true? Maybe it is unsupported by my ODBC driver (pyodbc)?
Aug
17
asked ODBC (SQL Server): How do I turn on Multiple Active Result Sets(MARS) for a System DSN?
Aug
3
awarded  Scholar
Aug
3
comment SQL Server: how do I know if I have lost or corrupt data after an automatic recovery?
@gbn, thanks, I didn't know it did that at startup, answers my question. This is what happens when a programmer is force to moonlight as a DBA. Put that in an answer and I will accept it.
Aug
3
comment SQL Server: how do I know if I have lost or corrupt data after an automatic recovery?
@Mitch Wheat, you are right, I just voted to migrate my own question ;)
Aug
3
asked SQL Server: how do I know if I have lost or corrupt data after an automatic recovery?
Mar
9
comment How to run an svn server on a Mac completely fire-walled from the outside?
Why bother? If your goal a personal source repository, there are vastly better and easier to configure decentralized options. Mercurial, git, Fossil, monotone, ...