From Zero to Pull Request with Git on Windows

I wrote a guide about using Git and GitHub for "Windows people".

This is the guide I wish was available when I got started with Git last year.

The guide takes you through everything you need to know to get started with Git and GitHub, and only requires a Windows PC where you have admin rights to complete.  You can probably get through the whole thing in an evening or two.

This guide is unique because:

• It is specifically for developers who use Windows
• It only describes how to contribute to an existing project
• It prioritizes the GitHub for Windows UI when the command-line is not required
• It is not embarrassed to give step-by-step directions or definitions of basic terms
• It prioritizes "the simple way for the common circumstance" over "every possible way for every possible circumstance"

Check out the guide here:

https://github.com/nycdotnet/FromZeroToPullRequestWindows/blob/master/FromZeroToPullRequestWindows.md

If you like it, please hit me up on Twitter and let me know: @nycdotnet

Rounding versus truncating

Be careful when implicitly converting data types in T-SQL.  Directly assigning 1.5 (either as a FLOAT or a NUMERIC) to an INT value in SQL Server may truncate the value to 1 rather than rounding it up as you might expect.  Explicitly calling ROUND( ,0) as part of the assignment will round 1.5 up to 2.

Here's an example:

DECLARE @Value INT;

DECLARE @NumericValue NUMERIC(10,1) = 1.5;

DECLARE @FloatValue FLOAT(53) = 1.5;

SET @Value = @NumericValue;  --Not calling ROUND()

SELECT @Value; --Returns 1

SET @Value = @FloatValue; --Not calling ROUND()

SELECT @Value; --Returns 1

SET @Value = ROUND(@NumericValue,0);

SELECT @Value; --Returns 2

SET @Value = ROUND(@FloatValue,0);

SELECT @Value; --Returns 2