Snowflake is a cloud-based solution, whereas SQL Server is an on-premises option. This implies that, whereas Snowflake may be viewed from any location with an internet connection, SQL Server requires hardware to execute on.