There is currently a lease on the blob and no lease ID was specified in the request
By Art on May 21, 2013

I’ve been using the backup to Azure feature that shipped with SQL2012 SP1 CU2 and generally it works really well, but a couple of times I have had an issue where I wasn’t able to overwrite a previous backup file and received an error: Msg 3202, Level 16, State 1, Line 1 Write on failed: Backup to URL received […]

Read More
How to backup a SQL 2012 database directly to Windows Azure
By Art on April 24, 2013

It has been a little while since I posted something and I’ve been meaning to finish off this blog for a few weeks now, but I have been a little busy with the arrival of my 2nd son (and have been distracted by my new Alienware laptop!)… Anyway I recently blogged about how cool I thought the new feature was […]

Read More
Retrieving the next or previous element node value in an Xml blob using XQuery
By Art on March 13, 2013

It’s been a little while since I wrote a blog post on my favourite subject but this is from a thread on the SSC Xml forum that I was helping out on a couple of weeks ago. I’ve been a bit busy lately with a big project at work, revising/taking exam 70-461 and getting ready for the birth of my […]

Read More
SQLBits XI Agenda Announced
By Art on February 13, 2013

The agenda for the SQLBits event in May was announced today and after a quick look earlier today, it looks like there is a great choice covering a wide range of topics both in and around SQL server. Understandably there are a number of sessions on Azure, about 5 or 6 I think, which shows one of the main themes […]

Read More
Backup SQL database directly to Azure Storage
By Art on January 25, 2013

There is a new CU update for SQL 2012 SP1 and I noticed a very interesting new feature described in the documentation blogged here. This is one of two new improvements and it is described as: You can now directly create a backup to Windows Azure Storage using SQL Server Native Backup functionality. This will allow users to back up […]

Read More
SQLBits XI – My second most eagerly awaited event of 2013…
By Art on January 17, 2013

I bet you are half wondering what is the first? Well that would be the birth of my second child which due in March so you could say that SQLBits XI is my most ‘professional’ eagerly awaited event of 2013. Last Friday I was just about to head off to get some lunch at around 12 and I just happened […]

Read More
Using XQuery to remove duplicate values or duplicate nodes from an xml instance
By Art on December 31, 2012

Sometimes we need to retrieve a list distinct values from within an xml instance or even distinct nodes and this is relatively straight forward using XQuery. It gets a bit more complicated if you have attributes in the xml, but it is still possible to retrieve unique xml nodes. On the flip side, it is also possible to only return […]

Read More
Using Facebook to extend/enhance your blogging
By Art on November 22, 2012

Edit (04-Apr-2017) I have since deactivated my Facebook account for the time being but I shall leave this blog post active as I still believe the post is fair reflection on the subject I read a blog a few months ago by Ramkumar Gopal (blog) in which he had setup a Facebook page to record and post things that he […]

Read More
SQLBits XI recently announced
By Art on November 14, 2012

When I saw an email from SQLBits announcing SQLBits XI in East Midlands in my inbox this morning, it simply made my day! Fantastic!!! I can’t wait now until the registration is open as I’ll be signing up as quickly as I can for the full event. I’m already seeking approval from my company for them to fund this as […]

Read More
Your online security is only as good as the weakest link
By Art on October 24, 2012

Over the weekend I received an email supposedly from Microsoft Live wanting me to verify my account and provided a verification code in the email to do that. It was a simple plain text email with no images or anything so I thought that this was just a spoof email attempt. I hovered the mouse over the link to where […]

Read More