Tag: Admin

VirtualBox SQL FCI – Given Network Name Is Unusable
By Art on April 19, 2017

The other day I needed to test some HADR requirements on my local machine so using VirtualBox, I created a 2 server Windows 2012 R2 failover cluster with shared storage provided by FreeNAS and a domain controller. All was good at the windows level so I proceeded to install a SQL cluster next but part way through the setup of […]

Read More
Script to find orphaned/unreachable job steps within your SQL jobs
By Art on August 24, 2012

SQL jobs are great as the SQL agent job engine allows for very granular control over jobs that are created by allowing great flexibility with the scheduling, execution, flow actions and notifications. Invariably, when jobs are setup, they just run and run without many problems, but the other day I was called in to look at a problem where a […]

Read More
Unable to activate a Windows 2003 VM on Hyper-V behind a proxy
By Art on June 25, 2012

Ok, so this is not strictly a post about SQL itself (and it’s about a fairly old OS), but I did run into this problem myself a couple of weeks ago whilst creating a very specific build to test some functionality and seeing as it took me a little bit of googling, I wanted to jot the fix down as […]

Read More
Script to analyse space usage by your Service Broker
By Art on April 16, 2012

I believe that service broker is one of the best features from SQL server 2005, well along with the xml data type, and I use service broker a lot for messaging between solutions. Over the years it has proven to be extremely reliable; only really stopping because of a poison message or other environment type issue outside the control of […]

Read More
Finding orphaned database users
By Art on October 19, 2011

Database users can become orphaned for a few reasons. For example, a database restore to another instance or deleting the corresponding SQL login would have the effect of leaving a database user orphaned. Development/testing SQL servers may also experience this due to the number of ad-hoc updates that may occur over the years. If you are unlucky enough your production […]

Read More