47,652 reputation
470124
bio website
location Malta
age 45
visits member for 3 years, 8 months
seen 20 hours ago

aka Shawn

  • SQL Server Developer/DBA
  • MySQL Developer
  • British expat
  • Code monkey

Sep
16
awarded  Enlightened
Sep
16
awarded  Nice Answer
Sep
5
awarded  Enlightened
Sep
5
awarded  Nice Answer
Aug
14
awarded  Nice Answer
Aug
8
comment SQL Server 2000 Backup fails with Status = 33
Given the age of this server, are you using FAT32? That is, hitting filesize limits?
Aug
8
comment Microsoft SQL Server Connection Coloring
Perhaps this can be sorted via security to restrict production access?
Aug
8
comment SQL cache hit ratio
Personally, I'd want a higher value if possible...
Aug
7
reviewed Close mysql server is not starting
Aug
7
answered Does it make sense to order condition in where query?
Jul
2
awarded  Curious
Jun
17
awarded  Generalist
May
21
comment Why is the speed of executing statements dependent on the network connection?
Se this answer on my question too please stackoverflow.com/a/1547539/27535
May
2
comment Is there a common approach to encrypting data at the database level?
Following on from Jon's comment, are you suggesting that each user has a different encryption key? Are you actually asking about row level security a.k.a filtering to the rows a user can see.
Apr
30
awarded  Nice Answer
Apr
30
reviewed Leave Open Generic script for stored procedure rollback
Apr
30
reviewed Close How to interpret undo statistics in Oracle AWR report?
Apr
30
reviewed Close cons of linked server providers not running in “allow in process”
Apr
30
reviewed Close Recovering Oracle Database using RMAN
Apr
30
reviewed Close Oracle becomes too slow after system crash