Category: General

• 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…]

• Merge Wonders – Insert or Use

  

  2013-02-05 - General, Hints, MERGE, Performance, T-SQL Statements

  One of the most often encountered concurrency problems in T-SQL code happens in the Insert or Use scenario in which a new row is inserted if it does not exist yet and afterwards the primary key of the existing or the new row is returned. One of the easiest and safest ways to get this right is provided by the MERGE statement.

  [more…]

• Philly GiveCamp 3

  

  2013-01-22 - General, Off Topic

  Last weekend was Philly GiveCamp 3. I got to work on creating a Choropleth Map of Pennsylvania for the Coalition Against Hunger in Philadelphia. Get all the details about the weekend and the project here.

  [more…]