Both when developing locally and when an app is deployed on a non-Azure service (e.g. on Streamlit), authenticating an app using an application service principal is an option. In fact, this is the ...

Run the code snippet from this page in a bash terminal. NB: GitHub Codespaces using Ubuntu by default NB: In VS Code this should be pasted in as 24 lines of code, rather than a single line

Installing pre-commit: pip install pre-commit Initialising pre-commit (needs to be run within a directory containing a .git folder): pre-commit install Running pre-commit hooks on a specific file...

select obj.name, sum(reserved_page_count) * 8.0 as "size in KB" from sys.dm_db_partition_stats part, sys.objects obj where part.object_id = obj.object_id group by obj.name ...

Run: bundler exec jekyll serve

df.loc[ df ["col_name"].dropna().astype(str).str.contains(r'[a-z]') ]["col_name "].unique() dropna() is needed where the column contains NaNs, to fend off an error. astype() is needed to for...

The current pyodbc version - 5.1.0 - can’t be installed on Python using the standard cmd commands - it fails with an error relating to building wheels. A workaround is to install the latest versio...

As of version 1.49.1 at least, Azure Data Studio settings need to be synced manually - ADS doesn’t include a built-in feature to sync settings across multiple devices. Steps that need to be taken:...

Use: git config --global user.name "Philip Nye" git config --global user.email "philipnye@users.noreply.github.com" Note that the email address should be the privacy-defending email address asso...

The Storage Blob Data Owner role is needed to upload data - even when the Owner role is held. It can take up to five minutes for role assignments to propagate.