With Windows Azure we can use Windows Azure SQL Database service (formerly known as SQL Azure) when we need a Relational Database. Microsoft offers a 99.9% monthly SLA for this service. But Microsoft doesn't provide you with the service to restore your data to a moment back in time when you (accidentally) delete of corrupt data.
To have a backup in time I wrote some code to allow a Worker Role to backup my Windows Azure SQL Database every hour. Most solutions you find online are relying on the REST Endpoints but the address of the endpoint is different depending on which datacenter your database is hosted. I found a different solution where you only need the connection string to your database using the DacServices.
With Windows Azure we can use Azure SQL Database service (formerly known as SQL Azure) when we need a Relational Database.
Microsoft offers a 99.9% monthly SLA for this service.
But Microsoft does not provide you with the service to restore your data to a moment back in time when you (accidentally) delete of corrupt data.
I am invited to speak at the Techdays 2013 in the Netherlands.
The event is held on the 7th & 8th of March at the World Forum in Den Haag.
My session, in Dutch, is called “Serious Request met Windows Azure” and I will be talking about my experiences using Windows Azure to build a high available and scaling platform for the various applications used during “3FM Serious Request”,
the annual charity event organized by the Dutch radio station 3FM for the Dutch Red Cross.
If the schedule does not change, I will be speaking in the Africa Room on Friday between 13:15 - 14:30.
Update
I have uploaded my slides for this session (PowerPoint PPTX, 6,83MB).
You can also view my presentation on SlideShare (but the fonts get messed up):
dotNed is the Dutch .NET user group and organizes several meetings each year for the .NET community. Maurice de Beijer interviewed me about my experiences using Windows Azure to build a high available and scaling platform for 3FM Serious Request.
DotNed is the Dutch .NET user group and organizes several meetings each year for the .NET community.
They also run a regular podcast covering several .NET development related topics like Visual Studio, Mono, ASP.NET MVC, Windows Phone and Windows Azure.
Triggered by my scheduled TechDays 2013 presentation,
I was interviewed a few weeks ago by Maurice de Beijer about my experiences using Windows Azure to build a high available and scaling platform for the various applications used during “3FM Serious Request”.
When writing .NET code to access a SQL database we often rely on the Entity Framework (EF). The EF makes it very easy to retrieve data from the database by generating a SQL Query for us. But we should not trust it blindly, as the EF can also generate a bad query.
It will return the correct data yes, but at what performance cost?
When writing .NET code to access a SQL database we often rely on the Entity Framework (EF).
The EF makes it very easy to retrieve data from the database by generating a SQL Query for us.
But we should not trust it blindly, as the EF can also generate a bad query.
It will return the correct data yes, but at what performance cost?
Recently I was challenged with the task to set the layout and content of a wiki page when a new page is added to a team site. As I'm used to work with SharePoint publishing the task sounded easy, but I was wrong.
Recently I was challenged with the task to set the layout and content of a wiki page when a new page is added to a team site.
As I am used to work with SharePoint publishing, the task sounded easy, but I was wrong.
Text Layout
My first path was to figure out where SharePoint puts the wiki “text layouts”.
I discovered this is not how it works. The layouts available for wiki’s are not configurable anywhere.
But using some PowerShell it was easy to get and set the layout as it is the HTML content of the “Wiki Field” column in the list.
Terminal window
$web=Get-SPWeb http://server/teamsite
$list=$web.Lists["Site Pages"]
$listItem=$list.Items[2] # My test page
$listItem["Wiki Content"] # Returns HTML
The HTML content consists of two parts.
The layout table and the layout data.
The layout data describes visibility of the header and footer and the number of columns.
Event receiver
To set the content the first thing in my mind was to add an
ItemAdding event receiver,
associated with ListTemplateId 119 (WebPageLibrary).
I deployed the solution and added a page and 🎉: no content!
Using the debugger to verify my event receiver was triggered, I went to the next option:
adding an ItemAdded event receiver.
This time I got an exception the page was already modified by another user.
Refreshing the page gave me the default content.
So, this told me 2 things:
It is possible to set default content
I forgot to set the Synchronize property
So, after fixing the second thing, I deployed once again and got: no content!
As I used ListItem.Update method in my receiver,
I got a version history where it showed the content was set, but the final version still ended up empty.
When faced with utter desperation, working with SharePoint has taught me you always have an escape:
launch Reflector.
There I found this gem of code in the SubmitBtn_Click method of the CreateWebPage Class:
So, no matter what I do in ItemAdding or ItemAdded, the content always ends up empty!
After this discovery, the fix was removing the code from the ItemAdding and ItemAdded events and moving it to the
ItemUpdated method
(synchronous) and added a check if the WikiField content is an empty string.