It’s December and we are in a code freeze period at work, usually these period are used to invest in infrastructure upgrades, version upgrades etc. So this brings me to blog about our upgrade from Sitecore 6.5 to Sitecore 7.2 – this blog post is specifically to document my findings in regards to upgrading Sitecore’s… Continue reading Sitecore upgrade from 6.5 to 7 – Sitecore-Item-Buckets
How to configure an Asynchronous SAP webservice in VS2013 with async and await
Steps to follow: Right click on the project you would like the SAP webservice added. Select ‘Add’ –> ‘Service Reference’. From the Add Service Reference screen Enter URL to the SAP WSDL. Select the Service. Name the service reference. Click the Advanced button. From the Service Reference Settings screen Ensure the ‘Allow generation of asynchronous… Continue reading How to configure an Asynchronous SAP webservice in VS2013 with async and await
How to: Clear the cache for a stored procedure in SQL Server
OPTION 1 – Simple Approach Option 2 – The Configurable and Automated Approach
Instrumenting Web APIs for requests enlisted the sync process
To round out the synchronisation processes logging I needed to instrument each Web API called made that formed part of a sync. This was done in one of two ways. It was either triggered by the client by sending a SyncId in the header or if a SyncId value was present in the users session.… Continue reading Instrumenting Web APIs for requests enlisted the sync process
Architecting a Throttling Mechanism
Before reading through this post please first refer to this post: Architecting a data synchronisation process between SAP and multiple internal mobile applications. With some of our existing, offline capable, sales mobility systems we’ve experienced issues when a large numbers of users synchronise data at once. Typically, we would see all synchronisation activities error and… Continue reading Architecting a Throttling Mechanism
Architecting a data synchronisation process between SAP and multiple internal mobile applications
My team and I have over the last 12 months have been working through architecting the ability for internal mobile applications to synchronise data largely stored in SAP based system to local storage for offline use. The data synchronisation process has mainly been from SAP ECC SAP CRM to a sales mobility application and an… Continue reading Architecting a data synchronisation process between SAP and multiple internal mobile applications
Useful SQL Server Index Fragmentation Query
Recently I had to brush up my skills on index fragmentation and as a result pulled this query together from a number of useful resources on the net. Just replace ‘DATABASE_NAME’ and run it against the specified database to receive a list of indexes that need attention. Internal Fragmentation is represented by the ‘avg_page_space_used_in_percent’ column… Continue reading Useful SQL Server Index Fragmentation Query
Team Foundation Server 2013–Setting up effective alerts
After upgrading to TFS 2013, and starting to make use of the new agile planning features, users were reporting they were getting to many alerts. Most alerting was triggered by a lot of re-prioritisation of stories so to combat that issue the below alerting configuration was setup for each individual user in the team:
Monitoring and maintaining an int IDENTITY column
When using an int as an identity column in Microsoft SQL Server you’re bound to an upper limit of 2,147,483,647. Ordinarily, that limit would be extremely difficult to exceed e.g. if you had a ShoppingCarts table and it had an int IDENTITY field as the primary key and there were 10,000 carts created a day… Continue reading Monitoring and maintaining an int IDENTITY column
Delete localDb database after physical files have been deleted
While working on setting up a new project structure for the team and prototyping how I could get the Entity Framework ‘Update-Database’ command to work from the repository project (EF aware) to create/update the database and have the web project (not EF aware) make use of the database – I made the mistake of deleting the database… Continue reading Delete localDb database after physical files have been deleted
Kaz on Commerce! 