Keybindings can be set for specific languages and specific contexts. E.g.: { "key": "ctrl+e", "command": "mssql.runQuery", "when": "editorTextFocus && editorLa...

Save the template to a central location e.g. C:\Users\nyep\<username>\templates. Create a new task in tasks.json in VS Code, replacing <file path> with the actual path to your template...

Indexed views (known as materialized views in other RDBMSs) can improve query performance as they store the result set of the view physically on disk, with details updated automatically when the un...

Setting Azure App Service to ‘Always on’ Azure App Service having the ‘Always on’ setting disabled can apparently lead to the container going to sleep, with the first d/b call after wake-up often ...

nan values cannot be directly serialized to JSON. Django REST Framework uses json.dumps(), which throws an error unless allow_nan=False is passed to it. Ref.: https://chatgpt.com/share/6907c3ca-4a...

pandas’ where() function doesn’t replace nan values in float64 columns by default. Instead, it retains the original nan values unless explicitly instructed to replace them. Coupled with the fact t...

pandas converts integer columns with nan values to float64 to accommodate those values. If the results of a SQL query that contains, say, min() or max() operations, and count() operations, are rea...

Updating virtual environment settings when folder names change In env\pyvenv.cfg, update file paths. In env\Scripts\activate, update file paths. Ref. \

Two-factor fixed effects regressions These can be useful to start to dig more into causality by focusing on changes in the independent and dependent variables - as this should strip out the effect ...

NB: These all require Git to be installed. Repos that have been turned into Python packages I.e. that have a setup.py file. pip install git+https://github.com/philipnye/<package_name> Repo...