Tag: SQL Server

• The TRUSTWORTHY Database Property Explained – Part 2

  

  2013-06-18 - General, Security, Trustworthy

  Why is the TRUSTWORTHY db option so dangerous? This second post on that topic shows how that “trust” can be misused to elevate a login to be a sysadmin.

  [more…]

• The Deceiving Seek Operator [TSQL Tuesday #043 – Hello, Operator?]

  

  2013-06-11 - General, Performance, Plan Operators, T-SQL Tuesday

  Do you, like most people, think that a clustered index seek is always better than a clustered index scan? If so, you need to read this post. You might just be in for a big surprise.

  [more…]

• The TRUSTWORTHY Database Property Explained – Part 1

  

  2013-02-19 - General, Security, Trustworthy

  Do you know what the TRUSTWORTHY database property does to your stored procedure security? Read on to learn more about the behavior of this commonly misunderstood database property.

  [more…]

• How to rollback in procedures

  

  2012-01-23 - General

  Transaction Management The question where in the call stack a transaction should be managed, is similar to the one where errors should be handled. There are several strong reasons to push the transaction management as high up the stack as [more…]

• Selecting the entire Database as XML String

  

  2012-01-13 - General, XML

  I just ran into this question on StackOverflow: Dump data into single XML file from MS SQL Server 2008 R2. In there Daniel is looking for a solution to export his database as an XML file. I thought that request [more…]