SQL Audit
There are a number of ways to audit data in SQL Server, but none of them seem to do exactly what I needed, so I rolled my own.…
Blog
Code snippets etc
Aggregate concatenation in TSQL
When rolling up data using Group By one of the things that has been missing in TSQL is the ability to concatenate. You can SUM, MAX, MIN etc...but no concatenation. There are various methods that…