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…
Visual Studio 2013 installer?
How to create an msi installer package using VS 2013…
Using a global (##) temporary SQL table to prevent a stored procedure from running more than once at the same time
Sometimes it is necessary to ensure that a stored procedure that you are about to execute is not already running. This might be necessary if, for example, your stored procedure is writing to a physical table.…
Custom domain names and multiple Azure web apps
Re-point your custom domain to a second azure web app…
Format T-SQL code in your blog
Which service is the best?…
Using T-SQL RAISERROR with NOWAIT to provide information on long running stored procedures
If you are trying to determine how long the various statements in a stored procedure are taking, then you really need to see output in real time (i.e. not wait till the end).…
TSQL Common Table Expression (CTE) Recursion
Recursion does my head in if I haven’t used it for a while. The following SQL is a typical employee/manager scenario, but I have used meaningful names to try and make it clear what is going on.……