Category Archives: Debugging


Azure Subscription Selection

Azure Subscription Selection

When the Azure PowerShell commands aren’t returning any data well then you might have to select a default Azure subscription. I tend to forget the Azure Subscription Selection step and therefore created this post. Just to remind myself and perhaps a couple of others.

The following page will guide you to the process of setting up on how to install and configure Windows Azure PowerShell http://www.windowsazure.com/en-us/documentation/articles/install-configure-powershell/ however you will need to make sure to select the correct subscription.

Read More →

Management Studio Custom Shortcuts

Management Studio Custom Shortcuts

A DBA recently attended me on the “Query Shortcuts” option within Management Studio. Now, I have to admit that I’m lazy from time to time and a horrible typist on Monday mornings and therefore using the option a lot, especially while debugging.

Read More →

Tridion DB – Poor performance after upgrade

Tridion DB

Probably one of the most common issues customers run into after completing the upgrade is performance degradation. This post covers how you can identify and solve SQL Server related issues after upgrading to a newer version.

Read More →

sp_what: Seek and ye shall find

SQL Server SP_what

On-site performance tuning analysis can be as rewarding as it is frustrating. There are some aspects you just can’t control; Ranting managers or dealing with a passive DBA, which often stands behind you with popcorn and drinks. Fortunately, you can prepare your scripts in advance based as i did based on prior leanings.

Read More →