Browse by Tags

Tagged Content List
  • Blog Post: Switching context with using EXECUTE AS ... not always switch it in fact as you wish.

    In this demo i will try to explain why SET TRUSTWORTHY ON on some databases may make the sysadmin job unsafe. In previous posts i explained how db owner (or any developer) can try to implemet simplest luring attack against server sysadmin. According to BOL to avoid this problem sysadmin should switch...

    As all of you know Microsoft has made a small problem for all SQL DBA and developers. If you have a database with any of SQL_xxxxx collations (for more details please have a look at the TERTIARY_WEIGHTS() function here ), you will defenetily have a significant problem with index search and ordering performance...
Page 1 of 1 (2 items)