Andrew Villazon
BlogAboutContact

Articles

Tags

DatabricksDiscussionGatsbyGithubMachine LearningPythonSQL ServerSiteSnippets

2023

  • Replacing multiple UNION ALLs with a Temporary Table

    28 May
  • Connect SQLAlchemy and Databricks

    12 Mar
  • 2022 Year in review

    16 Feb

2022

  • Recursive CTEs in SQL Server

    9 Aug
  • 6 lessons from a Machine Learning project

    28 May
  • Creating custom scikit-learn Transformers

    17 Jan
  • 2021 Year in review

    10 Jan

2021

  • 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)

    1 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

  • 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

    9 Nov
  • Azure Data Studio tips and tricks

    25 Oct
  • Validate YAML in Python with Schema

    8 Oct
  • Parse delimited values in SQL Server with STRING_SPLIT

    24 Sep
  • Useful SQL Server functions: TRY_CAST & TRY_CONVERT

    9 Sep
  • Move data to a Database with Python: Pandas

    1 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

    5 Aug
  • Automatically deploying a Gatsby site with Github Actions

    17 Jul
  • Building my personal site in Gatsby

    1 Jul
BlogAboutContactGithub
© 2023 Andrew Villazon. All rights reserved.