How to determine your SQL Azure database compatibility level?

This morning, one developer of my team asked me what was the SQL version of one of our production databases to see if he could use newer SQL syntax in a query. If you use SQL Management Studio you can get the SQL server version in the object explorer of Management Studio. In this example,…

State of the AI

Yesterday was my first experience as a speaker.  The Azure Montréal user group invited me to talk about AI and its stakes. The key takeaways of my conferences were : 2018 will definitely show a burst in AI investment and especially for Montréal. The future is promising for developers. Integrating AI in your application today…

Managed Service Identity (MSI) for Azure resources

Just found out about this cool little thing.  Managed Service Identity (MSI) for Azure resources. When enabled, it  creates an identity for your service instance in your subscription Azure AD tenant.  Your code can then make a local request to get access tokens for services that support Azure AD authentication.  This removes the need for storing…

Azure Cosmos DB evolution

Few months ago, Microsoft introduced Azure Cosmos DB, the next big leap in the evolution of DocumentDB.  As a part of this release of Azure Cosmos DB, DocumentDB customers (with their data) were automatically Azure Cosmos DB customers. The transition was seamless and they now have access to a broader range of new capabilities offered…

Time to learn

Being knowledgeable is a journey that requires time and a lot of effort. Finding the balance between getting things done and take the time to learn what’s next is a constant battle. I felt lately that I always ran out of time and when this happens the first thing that gets cut is my precious…

How to create a self-signed certificate using powershell

Didn’t know, but it seems that you can create a self-signed certificate using Powershell! The commands you need are New-SelfSignedCertificate and Export-PfxCertificate Set-ExecutionPolicy RemoteSigned $certificateFriendlyName = “MyCertificate” $certificateDns = “localhost” $certificatePassword = ConvertTo-SecureString -String “MyPassword” -Force –AsPlainText $exportDirectory = “C:\Certs” $exportFileName = “localhost.pfx” $exportLocation = “$exportDirectory\$exportFileName” New-Item -ItemType Directory -Force -Path $exportDirectory $certificate=(dir cert:\localmachine\My -recurse…

What makes them unique?

Azure Web, Mobile and API apps are all under Azure App service umbrella. But when you create an instance of each of them using the portal, they don’t seem to be different. Can you point out what makes them unique beside the visual studio template?  

Visual Studio Emulator for Android – Project does not Deploy

I don’t know how it happened, but my Xamarin Android project stop to deploy on my emulator. The compilation was  completed successfully and the emulator started as usual, but the project didn’t get deployed. Thanks to stackoverflow.com again, the solution was really simple : You can go to the emulator, click the “>>” arrow at the bottom…

What is the difference between OAUTH, OpenID and OPENID Connect?

OpenID is a protocol for authentication while OAuth is for authorization. Authentication is about making sure that the guy you are talking to is indeed who he claims to be. Authorization is about deciding what that guy should be allowed to do. Simple Terms OpenID is about verifying a person’s identity. OAuth is about accessing…