Connecting from Azure Databricks to Azure SQL with AAD auth (with and without service principal)

If you need to load data from Azure SQL server to Azure Databricks you have several options. Using JDBC Using JDBC you can simple paste username/password, however this only works with sql authentication i.e. NOT with Azure Active Directory (AAD) Auth. A guide is available here: https://docs.microsoft.com/en-us/azure/databricks/data/data-sources/sql-databases However, I recommend using the Spark Connector as… Continue reading Connecting from Azure Databricks to Azure SQL with AAD auth (with and without service principal)

RuntimeError: module compiled against API version 0xf but this version of numpy is 0xd

If you ever get this error when using numpy e.g. with Azure ML: RuntimeError: module compiled against API version 0xf but this version of numpy is 0xd You probably have mismatched versions of Numpy.Check the version and API version of your Numpy like this: You can check the mapping from Numpy version to C_API_VERSION here:… Continue reading RuntimeError: module compiled against API version 0xf but this version of numpy is 0xd

My Ethereum address

If you want to send Ethereum or other compatible tokens to me this is my main wallet address: 0x3Ae138A03F77dfC65fc6e27063C3E65f6668359c

Curriculum Vitae

My Curriculum vitae is available  here: CV-HansHarhoffAndersen2015. See also my LinkedIn profile.

Installing qutip on Windows

I had some problems installing Qutip on Windows. I solved them by adding the MinGW32-xy path to the Windows path environment. See details here.

Getting started with Python

I’ve written a short introduction to getting started with Python including IPython and how to set a default search path. It is mostly targeted Ubuntu users. Link to guide on Google Docs.