PLEASE, Please, please Stop Using Impersonation, TRUSTWORTHY, and Cross-DB Ownership Chaining December 30th, 2017November 12th, 2021 Solomon Rutzky11 Comments Module Signing was introduced in SQL Server 2005, and yet people are still using Impersonation, TRUSTWORTHY, and Cross-DB Ownership Chaining. This needs to stop.Share this awesome post:Click to share on Twitter (Opens in new window)Click to share on Facebook (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to email a link to a friend (Opens in new window)Click to print (Opens in new window)Click to share on Reddit (Opens in new window)MoreClick to share on Tumblr (Opens in new window)Like this:Like Loading...
Which Collation is Used to Convert NVARCHAR to VARCHAR in a WHERE Condition? (Part B of 2: “Rabbit”) December 11th, 2017January 9th, 2020 Solomon Rutzky3 Comments Who will win "Who's Collation is it Anyway?" Database Collation is ahead, but Column Collation isn't about to give up.Share this awesome post:Click to share on Twitter (Opens in new window)Click to share on Facebook (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to email a link to a friend (Opens in new window)Click to print (Opens in new window)Click to share on Reddit (Opens in new window)MoreClick to share on Tumblr (Opens in new window)Like this:Like Loading...
Which Collation is Used to Convert NVARCHAR to VARCHAR in a WHERE Condition? (Part A of 2: “Duck”) December 8th, 2017January 9th, 2020 Solomon Rutzky3 Comments Microsoft says string literals not prefixed with "N" are converted to the Code Page of the Database OR referenced column. Is that true?Share this awesome post:Click to share on Twitter (Opens in new window)Click to share on Facebook (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to email a link to a friend (Opens in new window)Click to print (Opens in new window)Click to share on Reddit (Opens in new window)MoreClick to share on Tumblr (Opens in new window)Like this:Like Loading...