SSRS dynamic hyperlink

Sometimes it's quite useful to use a hyperlink in a report to drill through or drill across to more detail or to a related report. I've also found it useful to dynamically generate links to various websites where the URI is predictable. Amazon.com uses a fairly predictable set of URLs…

Showplan Query Execution Plans

SQL Server execution plans are the key to optimising queries in an empirical, scientific way. The wrong way to go about optimising SQL is to trial and error until the query appears to run more quickly. The problem with that technique is that your query might not scale efficiently. Confronting…