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.
This can be necessary as there seems to be an issue loading files more than 2GB in size via the Azure Storage UI in Chrome - attempting it results in a “The requested file could not be read, typica...