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)
Category: Uncategorized
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
Python is not THAT strict with whitespace :)
Using AutoHotKeys to mute/unmute teams meetings
This great blog post just needs a simple change. Instead of (Meeting) you should pattern match for “Microsoft Teams”.All the MS Teams windows have this in their title, luckily and Teams window allows for the input eof the Mute command shortcut. My final script looks like this now: SetTitleMatchMode, 2 ; 2 = a partial… Continue reading Using AutoHotKeys to mute/unmute teams meetings
Websockets
WebSocket Test WebSocket Test
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.
Ubuntu 14.04: Making it useful
sudo apt-get update && sudo apt-get dist-upgrade -y && sudo apt-get autoremove sudo apt-get install ipython-notebook htop vim flashplugin-installer nautilus-open-terminal spyder tortoisehg-nautilus network-manager-openconnect ssh