Hector Sanchez

Git Quick Reference Guide

This is a quick reference guide about Git so I can have it at hand. I took the data from the official documentation located at: https://git-scm.com/docs Command Description Common Variants Example git init Initializes a new Git repository in the current directory. git init git clone Copies a repository from...

Continue reading...

Advanced SQL Server Guide

This is a short quick guide on advanced SQL Server topics, that I recently learned in this course from Udemy. The examples run in this post, use the AdventureWorks2019 sample database provided by Microsoft. Window Functions OVER() Function OVER() is a function used after an aggregate function like SUM() to...

Continue reading...