When doing memory-intensive operations in VSCode - e.g. working with large pandas dataframes - the kernel can crash with the following error: The kernel crashed while executing code in the current...

Attempting to upload large dataframes can result in the following error: PendingRollbackError: Can't reconnect until invalid transaction is rolled back. Please rollback() fully before proceeding ...

Images can be inserted using:  Ref. Spaces need to be URL-encoded in GitHub Markdown. Spaces are encoded as %20%.

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

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...