-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Server Rocks!

SQL Database Administrator/Developer. Background in developing OLTP/document based databases, SQLXML and performance tuning with an unhealthy fascination for the SQL query optimiser!

VirtualBox SQL FCI - Given Network Name Is Unusable

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… Read more

0 comments, 304 reads

Posted in SQL Server Rocks! on 19 April 2017

Moved blog to Ghost

Another year, another blog update lol!... Last year I remember doing a significant version upgrade for my self-hosted Orchard CMS software on the DiscountASP hosting platform and it all seemed to work fine.. However I just happened to look at my site recently and it appears that something was broke… Read more

0 comments, 49 reads

Posted in SQL Server Rocks! on 12 April 2017

Apologies in advance

This is a quick post to apologise in advance if all my historical blog posts get republished.

Recently it appears that my existing self-maintained Orchard CMS installation has stopped delivering content properly and as I really don't have the energy to fix it, I'm moving to a new blogging platform,… Read more

0 comments, 171 reads

Posted in SQL Server Rocks! on 6 April 2017

Pluralsight = Essential Training

Edit (11-Sep-2016) See comment that pricing tiers have been adjusted since this blog post

I've been aware of Pluralsight for a couple of years and as I'm always looking for very cheap or free ways to learn I made a resolution to check out Pluralsight this year to see what… Read more

0 comments, 38 reads

Posted in SQL Server Rocks! on 11 September 2016

Update duplicate xml attribute values to unique value

I was going through some really old blogging ideas and I stumbled over this one and seeing as I love finding creative solutions in XQuery, I'm not sure why I hadn't got this down into a blog post earlier!

Imagine the following contrived xml snippet which is essentially just a… Read more

0 comments, 39 reads

Posted in SQL Server Rocks! on 23 June 2016

Update duplicate xml attribute values to unique value

I was going through some really old blogging ideas and I stumbled over this one and seeing as I love finding creative solutions in XQuery, I’m not sure why I hadn’t got this down into a blog post earlier!

Imagine the following contrived xml snippet which is essentially just a… Read more

0 comments, 323 reads

Posted in SQL Server Rocks! on 23 June 2016

Recertification, too easy?

3 years I was awarded the MCSE: Data Platform certification and as per the recertification rules, I needed to recertify this year to keep it active. So shortly after Christmas I set about looking into what exams I needed to take and brushing up on all those new features in… Read more

0 comments, 1,631 reads

Posted in SQL Server Rocks! on 21 March 2016

Recertification, too easy?

3 years I was awarded the MCSE: Data Platform certification and as per the recertification rules, I needed to recertify this year to keep it active. So shortly after Christmas I set about looking into what exams I needed to take and brushing up on all those new features in… Read more

0 comments, 37 reads

Posted in SQL Server Rocks! on 21 March 2016

UK Contractors - As you were, for now at least

I think there were are few sighs of relief around the country yesterday after the chancellor finished giving his autumn financial statement to parliament. For the past few weeks there has been plenty of reports of doom and gloom from the various media channels suggesting that the end was nigh… Read more

0 comments, 108 reads

Posted in SQL Server Rocks! on 26 November 2015

UK Contractors - As you were, for now at least

I think there were are few sighs of relief around the country yesterday after the chancellor finished giving his autumn financial statement to parliament. For the past few weeks there has been plenty of reports of doom and gloom from the various media channels suggesting that the end was nigh… Read more

0 comments, 535 reads

Posted in SQL Server Rocks! on 26 November 2015

Indexed views on any core SQL server edition–The video

A few months back I created a blog post showing that you can indeed create and use indexed views on any core SQL server edition. It has proved to be one of my most read blog posts. Since then Webucator, provider of SQL Server training, got in contact… Read more

0 comments, 310 reads

Posted in SQL Server Rocks! on 10 October 2015

Indexed views on any core SQL server edition-The video

A few months back I created a blog post showing that you can indeed create and use indexed views on any core SQL server edition. It has proved to be one of my most read blog posts. Since then Webucator, provider of SQL Server training, got in contact… Read more

0 comments, 62 reads

Posted in SQL Server Rocks! on 10 October 2015

SQL Server Contracting - The first 14 months (or so)

Crikey, where did that time go! I have been so busy adjusting to my new work life style I have completely neglected my blog.. Well now that I seem to be adjusted to the world of contracting (or rather adjusted to working more than a mile away from where I… Read more

0 comments, 33 reads

Posted in SQL Server Rocks! on 9 October 2015

SQL Server Contracting – The first 14 months (or so)

Crikey, where did that time go! I have been so busy adjusting to my new work life style I have completely neglected my blog.. Well now that I seem to be adjusted to the world of contracting (or rather adjusted to working more than a mile away from where I… Read more

0 comments, 1,663 reads

Posted in SQL Server Rocks! on 7 October 2015

XQuery – Accessing the Attributes Axis

Working with a sequence of attributes in XQuery is fairly straight forward with the “attribute” axis even if you don’t know or need to know the attribute names. By using this axis you can access all of the attributes within the given context node. The specific scenario I had was… Read more

0 comments, 1,327 reads

Posted in SQL Server Rocks! on 19 December 2014

XQuery - Accessing the Attributes Axis

Working with a sequence of attributes in XQuery is fairly straight forward with the 'attribute' axis even if you don't know or need to know the attribute names. By using this axis you can access all of the attributes within the given context node. The specific scenario I had was… Read more

0 comments, 38 reads

Posted in SQL Server Rocks! on 19 December 2014

Updated blog Site

This post is mainly to test the syndication still works correctly from my heavily updated web/blog site so apologies for the non-SQL nature of it.

Finally after promising myself to do so since late 2013, I've actually got around to updating my blog site to the latest version of Orchard.… Read more

0 comments, 31 reads

Posted in SQL Server Rocks! on 12 November 2014

Updated blog Site

This post is mainly to test the syndication still works correctly from my heavily updated web/blog site so apologies for the non-SQL nature of it.

Finally after promising myself to do so since late 2013, I've actually got around to updating my blog site to the latest version of Orchard.… Read more

0 comments, 315 reads

Posted in SQL Server Rocks! on 12 November 2014

Creating cards in Trello via the REST API and parsing the returned JSON all in a SQL CLR

I recently blogged about how good I thought Trello was and shortly afterwards I found out that they did provide a full read/write RESTful API. Awesome! After a bit of thought I realised that I should be able to use the API to create new cards in Trello from within… Read more

0 comments, 46 reads

Posted in SQL Server Rocks! on 12 November 2014

Drop and Recreate all Synonyms

Had a quick job the other day restoring a pair of databases under different names which is all straight forward enough, but each database in the pair uses quite a few synonyms to access objects in the other database. So with the pair of databases restored under new names, a… Read more

0 comments, 31 reads

Posted in SQL Server Rocks! on 27 October 2014

Older posts