Today I've encountered a vertical table in an SQL Database and I wanted to transform it to an horizontal one. A vertical table is described as an EAV model.
Imagine you have this table
CREATE TABLE VerticalTable
INSERT INTO VerticalTable
SELECT 1, 'FirstName', 'John' UNION ALL
SELECT 1, 'LastName', 'Smith' UNION ALL
SELECT 1, 'Email', 'firstname.lastname@example.org' UNION ALL
I'm proud to announce that I was selected to present a session at Collab 365 Global Conference 2016. This is a global online conference delivering sessions about SharePoint, Office 365 and Azure on the 19th-20th October. And it's free. Register here.
In my session I will talk about event driven applications with Azure Functions, it will cover triggers and webhooks ...more
After 10 years at Create IT, I have decided to take on a new challenge at a different company.
Since this blog is hosted in Create IT's blog platform, I have created a new personal blog where I will be posting from now on. This is my final post in this blog address but the existing ...more
Today I'll help you add some bling to your UWP apps (and maybe something useful) with scheduled live tiles using the built-in features on the W10 SDK and some Azure help - although any cloud storage provider should do fine. I'll divide this into the "backend stuff", where we'll generate our tile templates, and the "client ...more
I have the following scenario:
I'm using Unity dependency injection container and interception techniques to log some WCF operation calls. I need to log the input parameters and also the result of these operations so I've implemented a CallHandler that I can apply to whatever methods that I need to intercept.
In this CallHandler I've defined a ...more
Donut Output Caching is a type of output caching where certain parts of a web page are not cached. It's a simple way of boosting your site performance!
ASP.NET doesn't provide a native way of donut output caching, so we must resort to a great NuGet package called MVCDonutCaching. You can read all about it here: http://www.devtrends.co.uk/blog/donut-output-caching-in-asp.net-mvc-3.
Since Umbraco ...more
Past March, Microsoft launched the preview of Azure Functions, often referred as an Amazon Lambda competitor.
This being my first post about this topic, I will briefly introduce Azure Functions and show how to create a simple bot for Slack with Azure Functions.
In the following posts, I will dive into more advanced features.
Azure Functions is ...more
If you need to find which part of your Umbraco application is slowing the site down, follow these steps:
Set the debug property of the compilation section of your Web.config to true: <compilation defaultLanguage="c#" debug="true" batch="false" targetFramework="4.5">
If you're using an older version of Umbraco, you also probably need to set the umbracoDebugMode app setting to true ...more
Today I've discovered a problem with CodeSmith nettiers templates because it was possible to generate two SPs with the same name, for different entities.
This happens when there are two indexes for two different tables that have the same column names and the column names reach the maximum lenght (128 for SQL). In this case the generated SP ...more
A while ago, some have predicted the death of SharePoint, stating that the SharePoint brand was not even present in Office 365 and that Microsoft would not release any new versions of the on-premises SharePoint Server. Today, on Star Wars day, Microsoft renewed its vows in a SharePoint-focused event appropriately called The Future of SharePoint ...more