This could be an interview question actually. How are you able change, say, only one out of an arbitrary collection of complete duplicate rows, and in a set-based manner?
Having fun preparing that PowerShell deployment script and need to run some XMLA with it? Here’s how.
There are those times where you just need those SIDs, no matter what door you knock on. For those fateful times, you can use this snippet of code to grab the SID from a given target user.
While it is usually a good idea to keep away from the injectionable fun of dynamic SQL, there are some cases where it does help you out a bit. One such example is generating code in your SSDT post deployment scripts.
Do you need to quickly add a numbers table to your SSDT Database Project? Here’s how.