Changes to Azure SQL service tiers and pricing

Today Microsoft announced changes to Azure SQL Database service tiers. I’ll simplify it for you: You’ll get larger databases for less money and a better uptime SLA. The Web and Business editions of Azure SQL Database are going away with retirement in 12 months. New service tiers of Basic and Standard are now available. 

here is the main differences :

Full details on the new tiers are available here and pricing details are here.


News from C# 6

hi everybody,

Have you heard some news about Roslyn. Theis project is a compiler entierely recasting.  The project is now an open source project and it’s available on codeplex.

Let’s take a look around about the new functions

 Using Static

Now you can make an using on an object. That permit to import all static method without type the object name. Here is an example with String.Concat :

using System.String;
String a = « hello »;
String b = « world »;
Console.WriteLine(Concat(a, » « ,b, »! »);


Properties initialization

Now we can initialized properties to a default value at object initialization :

public class class1
public int cmpt {get;set;} = 42;

Note now you can create readonly property with the same syntax, but I prefer create a const member :

public class class1
public int cmpt {get;} = 42;


Improvement around primary constructor

This new syntax concern again the properties, you can set the property intial value when calling the method :


public class class1(int x, int y)
public int a {get;set;} =x;
public int b {get;set;} =y;

The syntax benefit is only at code line number, it’s better for understanding, but I think it will be useful.

dictionnary and indexed member initialization

Since  C# you can initialize dictionary  with a syntax not really intuitive :

var letters = new Dictionary<string, int>
{ « a », 1 },
{ « b », 2 },
{ « c », 3 },


Now there is two better way to initialize a dictionary :

var letters = new Dictionary<string, int>
[« a »] = 1,
[« b »] = 2,
[« c »] = 3,




var letters = new Dictionary<string, int>
$a = 1,
$b = 2,
$c = 3,


The second one, I think, will be very useful for json object

Thus, you can access to indexed value with the manner :


int a = letters.$a


 Declaration scope for variable

Until now, a variable only could be declared in autonom statement, not in the midlle of a function. But sometime, we only need a temporar variable result of tryparse for example. Now it’s possible :

if (Decimal.TryParse(txtPrice.Txt, out decimal price))
product.Price = price;


Filtering exception

in VB.NET it’s already possible, and now in c# 6 we can do that like in VB :

using (var stream = new FileStream(path, FileMode.OpenOrCreate, FileAccess.Write))

catch(IOException ex) if (ex.HResult == 0x80070020)
// File is in use by another process
// Handle that case…
catch(IOException ex) if (ex.HResult == 0x80070035)
// Network path was not found
// Handle that case…
catch(Exception ex)
// Something else happened
// Handle that case…

This method target to clarify code, it will be very usefull



As we can see, lot of new function has arrived, and lot of more will come. The new statement are not vital but they simpligy developper life.  If you want to show all news implementation visit this page

Source :


New Azure cloud portal

Hi everybody,

since a long time from my last post (some post will be delivered soon), Microsoft has delivered a new portal design.

This design is more graphic and more user friendly. So it’s not for developer :P. I like this design but I think it’s not very usefull. It refer to windows 8 style with tiling. When you browse a section it develop it on the right side :



When you select an artifact, it develop it on the right side :

sql view

Then when you select a database :

sql details

this version is a preview I don’t know when they want to pass it as  standart.



Azure design Pattern

Microsoft has delivered an ebook around cloud design pattern

You can download it as pdf, epub or mobi

This book contains twenty-four design patterns and ten related guidance topics, this guide articulates the benefit of applying patterns by showing how each piece can fit into the big picture of cloud application architectures. It also discusses the benefits and considerations for each pattern. Most of the patterns have code samples or snippets that show how to implement the patterns using the features of Windows Azure. However the majority of topics described in this guide are equally relevant to all kinds of distributed systems, whether hosted on Windows Azure or on other cloud platforms.

here is the content :


  • Cache-Aside Pattern
  • Circuit Breaker Pattern
  • Compensating Transaction Pattern
  • Competing Consumers Pattern
  • Compute Resource Consolidation Pattern
  • Command and Query Responsibility Segregation (CQRS) Pattern
  • Event Sourcing Pattern
  • External Configuration Store Pattern
  • Federated Identity Pattern
  • Gatekeeper Pattern
  • Health Endpoint Monitoring Pattern
  • Index Table Pattern
  • Leader Election Pattern
  • Materialized View Pattern
  • Pipes and Filters Pattern
  • Priority Queue Pattern
  • Queue-Based Load Leveling Pattern
  • Retry Pattern
  • Runtime Reconfiguration Pattern
  • Scheduler Agent Supervisor Pattern
  • Sharding Pattern
  • Static Content Hosting Pattern
  • Throttling Pattern
  • Valet Key Pattern


  • Asynchronous Messaging Primer
  • Autoscaling Guidance
  • Caching Guidance
  • Compute Partitioning Guidance
  • Data Consistency Primer
  • Data Partitioning Guidance
  • Data Replication and Synchronization Guidance
  • Instrumentation and Telemetry Guidance
  • Multiple Datacenter Deployment Guidance
  • Service Metering Guidance

Techdays sessions

Bonjour à tous, premier article en français puisqu’il concerne la communauté francophone,

J’anime une session aux techdays le jeudi 13 fevrier à 15h15 :

Réalisez le potentiel des données cross canal qui vous entourent

RP, Réseaux Sociaux, CRM, Site de e-commerce, caisses de magasin, site Web, Hadoop : comment analyser les données en provenance de sources de données si différentes ? La solution: mettre l’information à disposition dans le Cloud Windows Azure, avec des connecteurs dédiés et la puissances des outils de Business Intelligence Microsoft. Pour illustrer cette solution, venez découvrir BIjen, une solution permettant de générer des tableaux de bord agrégés et synthétiques des indicateurs de performances multi-sources de l’entreprise. Accessible sur PC et tablettes, l’interface BIjen simplifie l’édition de tableaux de bord multi-sources et cross canal. A destination de l’ensemble des managers, cette solution a pour objectif d’accélérer le partage d’information au sein de l’entreprise mais aussi de faciliter la mesure à 360° de la performance de l’entreprise.

Produits concernés :

  • SQL Azure
  • Office 365
  • SQL Server
  • SharePoint 2013
  • Sharepoint Online
  • Excel


BizTalk Server 2013 R2

News from BizTalk summit

The next version of BizTalk Server, BizTalk Server 2013 R2 will be due some time mid of next year. Some of the core capabilities will include

Support latest Platforms and Standards

  • Visual Studio 2013, Windows Server 2012 R2, SQL Server 2014, Office 2013, System Center 2012 SP1
  • SWIFT 2012 Message Pack

Health Care

  • MLLP 64 bit support
  • Dynamic MLLP adapter
  • Better troubleshooting
  • HL7 2.6
  • Support for free text data type

Adapter Improvements

  • SFTP
  • Proxy support
  • SSO support
  • REST
  • JSON support
  • Empty message support while exposing REST services
  • Service Bus adapter
  • Authentication improvements


XSD2DB a tool to help to create datatable

Who never need to create a datatable from xsd schema.

Every time, I designed it by hand but this one I have 70 fields and 5 join tables. I bing a little and find this tool : Xsd2db

It’s a c# command line tool which create the datatable.

For more informations : please visit

To download it :