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...
  • Blog Post: ALTER DATABASE ... ALTER COLLATION (FORCED).

    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)