47,327 reputation
468122
bio website
location Malta
age 45
visits member for 3 years, 7 months
seen Aug 25 at 12:45

aka Shawn

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

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
Apr
30
awarded  Custodian
Apr
30
reviewed Close Should this be a foreign key?
Apr
30
reviewed Close Maintaining mongodb for a huge list of message “documents”?
Apr
30
reviewed Close SQL Server 2012 Database Engine Configuration Storage type Raid