Client App Calling An Azure Function With AAD

I recently needed to create a client app that used an AAD application to authenticate with an Azure Function that was configured with the AAD Easy Auth flow. Documenting it here seemed like it might add value to the interwebz. Create a new Azure Function App. Once it is created, create a simple function that…

0

Kusto Code Hygiene and Performance Tips

Now that you’ve started authoring your first Kusto queries in Azure Data Explorer, there are a few things you can do to make your life a lot easier going forward. In terms of performance, there are three things that I recommend to new users: Use a where clause as soon as you can and always…

0

Getting Started with the Kusto Query Language (KQL)

Azure Data Explorer is in public preview and their documentation is an excellent place to educate yourself on the Kusto Query Language that is used to interact with Azure Data Explorer. There’s also a 4-hour Pluralsight course which will really jump start you. The Azure Data Explorer white paper also covers the basics of the…

0

Ingesting Your First CSV Into Azure Data Explorer

We’ve been using the Kusto query language internally for quite a while and over that time, and while I’m not a member of the Data Explorer team, I’ve helped a number of people get started with the language. Now that Azure Data Explorer is public, there are a lot of resources to get you off…

2

Azure Data Explorer Public Preview

There is lots of great stuff flowing out of Microsoft Ignite this week, but my favorite so far is the announcement about the public preview of Azure Data Explorer. We’ve been using this tool internally for a while now and it has revolutionized how we do big data analysis. What used to take us hours…

0

Encrypt Secrets With A Certificate In Azure Websites

Here’s the scenario: you have a secret that needs to be used in your website but you know it’s insecure to put the password in your code in plain text. One easy solution is to manually enter the secret into the web config using the Application Settings page in the portal, but that doesn’t give a…

0

IP Security in IIS Express

If you’re building an Azure website and you want to add IP security, there are quite a few blog posts about how to make that happen. I’m just going to summarize them here for you. In your web.config, add a new element under configuration/system.webServer. The new element is security and underneath is ipSecurity. You can read up on…

0

Getting Started with Power Query for Excel

Power Query v1 launched a few months ago. Power Query is part of the Microsoft Power BI suite. If you’re interested in getting started with Power Query, here are some helpful resources: Help page – This includes helpful topics such as the Introduction to Microsoft Power Query for Excel Download v1  – This is our…

0

Ode to Data Explorer

To the tune of The Candy Man by Sammy Davis Jr. Who can talk to SQL, sprinkle with Hadoop Cover it with Sharepoint and a miracle or two Data Explorer, oh Data Explorer can Data Explorer can causes it mixes it with love and makes your data taste good. Who can take a table, merge…

0

TFS Work In Progress Shelvesets

By now you all know that you should save your progress often. This batch file will quickly create a TFS shelveset with all your current changes. The shelveset will be named with the current date and time. You can specify an optional parameter which will be used as the comment for the shelveset. Be sure…

0