Andrew Villazon
Articles
Contact
Articles
Discussion
Gatsby
Github
Python
SQL Server
Site
Snippets
Recursive CTEs in SQL Server
09 Aug
6 lessons from a Machine Learning project
28 May
Creating custom scikit-learn Transformers
17 Jan
2021 Year in review
10 Jan
Logistic Regression in Python with statsmodels
14 Nov
Multi-file LaTeX Documents with Pylatex
16 Sep
Four ways to forward-fill values in T-SQL (the last non NULL problem)
01 Sep
The Table Value Constructor (aka the VALUES keyword)
19 Jun
Clinical Natural Language Processing in Python
30 Apr
Identify consecutive values in SQL Server
17 Mar
Identify non-consecutive values in SQL Server
24 Feb
Placeholder Text (String Interpolation) in T-SQL
23 Jan
2020 Year in review
31 Dec
Maximize user snippets in Azure Data Studio
20 Dec
Site update: November 2020
30 Nov
Use Python to quickly load lots of data to a Database
09 Nov
Azure Data Studio tips and tricks
25 Oct
Validate YAML in Python with Schema
08 Oct
Parse delimited values in SQL Server with STRING_SPLIT
24 Sep
Useful SQL Server functions: TRY_CAST & TRY_CONVERT
09 Sep
Move data to a Database with Python: Pandas
01 Sep
Move data to a Database with Python: SQLAlchemy
26 Aug
Move data to a Database with Python: Pure Python
10 Aug
How to use SQL Server's OPENJSON function
05 Aug
Automatically deploying a Gatsby site with Github Actions
17 Jul
Building my personal site in Gatsby
01 Jul