988 reputation
415
bio website yrushka.com
location Bucharest, Romania
age 31
visits member for 3 years, 7 months
seen Aug 28 at 11:43

Work as SQL DBA for 5 years and search to improve my skills everyday. I am also interested in SQL programming and developing personal scripts for administration purpose.


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
Apr
6
awarded  Notable Question
Jan
26
awarded  Yearling