Reputation
1,038
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
5 16
Newest
 Nice Answer
Impact
~115k people reached

1d
awarded  Nice Answer
Jan
26
awarded  Yearling
Aug
8
answered best possible index on this situation
Aug
8
answered List all tables that a specific login has permissions
Jul
30
awarded  Nice Answer
Jul
21
awarded  Citizen Patrol
Jul
18
comment Rapidly increasing TempDB write latency
Any system that causes a PLE less than 300 for me it would say there is a memory pressure. On nowadays systems, PLE can be as high as 12000 but the question came from someone that didn't give specific hardware configuration. Instead of giving no answer, I would rather give some guidance.
Jul
18
comment Preventing SQL Injection
of course it will be used, the idea was to prevent the sql injection of malicious queries inputed for @tVariable, but I got confused, because the second query as I wrote it can still be missused. In order to not be able to execute scripts like select * from sysusers; drop table SOMETABLE AN ORDER BY or GROUP BY or WHERE clauses should be added.
Jul
18
revised Preventing SQL Injection
added 15 characters in body
Jul
16
answered Rapidly increasing TempDB write latency
Jul
16
comment Preventing SQL Injection
thanks I updated correctly.
Jul
16
revised Preventing SQL Injection
deleted 91 characters in body
Jul
16
awarded  Critic
Jul
16
answered Security implications of restoring a backup from an unknown source?
Jul
16
answered Preventing SQL Injection
Jul
2
awarded  Curious
Jan
26
awarded  Yearling
Feb
21
awarded  Popular Question
Jan
26
awarded  Yearling
Aug
8
awarded  Popular Question