Snowflake vs. Microsoft SQL Server

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Snowflake
Score 9.0 out of 10
N/A
The Snowflake Cloud Data Platform is the eponymous data warehouse with, from the company in San Mateo, a cloud and SQL based DW that aims to allow users to unify, integrate, analyze, and share previously siloed data in secure, governed, and compliant ways. With it, users can securely access the Data Cloud to share live data with customers and business partners, and connect with other organizations doing business as data consumers, data providers, and data service providers.N/A
Microsoft SQL Server
Score 8.7 out of 10
N/A
Microsoft SQL Server is a relational database.
$1,418
Per License
Pricing
SnowflakeMicrosoft SQL Server
Editions & Modules
No answers on this topic
Subscription
$1,418.00
Per License
Enterprise
$13,748.00
Per License
Offerings
Pricing Offerings
SnowflakeMicrosoft SQL Server
Free Trial
YesNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
SnowflakeMicrosoft SQL Server
Considered Both Products
Snowflake
Chose Snowflake
We particularly liked Snowflake's security model as well as its unique storage (whereby everything is essentially a pointer to immutable micro-partitions, which is the key behind its zero-copy cloning, its secure sharing, its time travel, etc.). and also how it separates …
Chose Snowflake
We had a MS SQL server with over 2 TB of ram & 51 processors that we were using, that could no longer handle our workload. Snowflake can handle 3 times that workload with ease and efficiency.
Chose Snowflake
Azure and Snowflake compared very similarly, but Snowflake provided more options to integrate and connect with tools/companies that were not partners. It seemed to be a more flexible environment. The barrier for entry on Oracle and Google we just too complicated. In particular, …
Chose Snowflake
I have had the experience of using one more database management system at my previous workplace. What Snowflake provides is better user-friendly consoles, suggestions while writing a query, ease of access to connect to various BI platforms to analyze, [and a] more robust system …
Chose Snowflake
- Cost was the main aspect on the decision.
- Performance was in par or better compared to other tools in the market.
- Snowflake in my opinion stacks better than other tools I have used in the past.
Chose Snowflake
Accommodates future data types such as JSON and XML. Scalability is another advantage. Pay per use is beneficial for organizations like yours. Direct connectors with AWS help us to go with it. No limit on user creation and clone data not eating up extra disk space are a few …
Chose Snowflake
  • Delivered as an easy-to-use data warehouse service, Snowflake enables you to process and analyze all your diverse data, build multiple databases, query with a common robust ANSI SQL environment, and execute ACID transnational capabilities.
  • No need to create indexes and optimize …
Microsoft SQL Server
Chose Microsoft SQL Server
Microsoft SQL Server is a comprehensive solution as transactional database, data warehouse, analytics, reporting, and ETL. It also integrates with the cloud well (Azure). The ease of use and setup makes this better than Oracle Database because the query syntax is also different …
Chose Microsoft SQL Server
[Microsoft SQL Server] offers a full solution, Inhouse Applications and hosted application continue to use SQL as backend database. Allows easy creation of development environments and continuous feature release.
Chose Microsoft SQL Server
Amazon Redshift is a cloud-based data warehouse. It does what it says it will do, but my experience is that for a cloud data warehouse, it is a little slow and I'd hope for performance to be insanely fast. Plus, it is also very costly. Same performance for much less cost in …
Top Pros
Top Cons
Best Alternatives
SnowflakeMicrosoft SQL Server
Small Businesses
Google BigQuery
Google BigQuery
Score 8.6 out of 10
SingleStore
SingleStore
Score 9.7 out of 10
Medium-sized Companies
Db2
Db2
Score 8.7 out of 10
SingleStore
SingleStore
Score 9.7 out of 10
Enterprises
Db2
Db2
Score 8.7 out of 10
SingleStore
SingleStore
Score 9.7 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
SnowflakeMicrosoft SQL Server
Likelihood to Recommend
9.3
(37 ratings)
9.6
(96 ratings)
Likelihood to Renew
10.0
(2 ratings)
9.0
(6 ratings)
Usability
8.7
(13 ratings)
9.9
(10 ratings)
Availability
-
(0 ratings)
10.0
(1 ratings)
Performance
-
(0 ratings)
9.0
(1 ratings)
Support Rating
9.8
(8 ratings)
7.9
(25 ratings)
In-Person Training
-
(0 ratings)
9.0
(1 ratings)
Online Training
-
(0 ratings)
9.0
(1 ratings)
Implementation Rating
-
(0 ratings)
9.0
(5 ratings)
Configurability
-
(0 ratings)
10.0
(1 ratings)
Contract Terms and Pricing Model
8.0
(1 ratings)
-
(0 ratings)
Ease of integration
-
(0 ratings)
9.0
(1 ratings)
Product Scalability
-
(0 ratings)
9.0
(1 ratings)
Vendor post-sale
-
(0 ratings)
9.0
(1 ratings)
Vendor pre-sale
-
(0 ratings)
9.0
(1 ratings)
User Testimonials
SnowflakeMicrosoft SQL Server
Likelihood to Recommend
Snowflake Computing
I am over our HR data, and we use Workday for our HR management system. I have a script in place that runs reports on Workday and saves the results as CSVs. I can then use stages in Snowflake to insert these CSVs into Snowflake, then I can insert or truncate and replace these staged tables into a final schema. Then once these are in a schema I can reference them and build out my data models. In addition to ingesting CSVs, Snowflake has the ability to write a CSV file to our Amazon S3 bucket. Ingesting these CSVs, transforming the data, then delivering it to a destination would've involved so much more coding than my current process if we were on any other platform.
Read full review
Microsoft
Microsoft SQL Server is a great RDBMS and meets all of our requirements. If you need a stable DB platform to support your line of a business application you'll be well served. Licensing costs are far cheaper, more portable and a lot more user friendly than Oracle. Product support and security patches from Microsoft are strong.
Read full review
Pros
Snowflake Computing
  • Snowflake scales appropriately allowing you to manage expense for peak and off peak times for pulling and data retrieval and data centric processing jobs
  • Snowflake offers a marketplace solution that allows you to sell and subscribe to different data sources
  • Snowflake manages concurrency better in our trials than other premium competitors
  • Snowflake has little to no setup and ramp up time
  • Snowflake offers online training for various employee types
Read full review
Microsoft
  • Easy to configure and use with Visual Studio and Dot Net
  • Easy integration with MSBI to perform data analysis
  • Data Security
  • Easy to understand and use
  • Very easy to export database and tables in the form of SQL query or a script
Read full review
Cons
Snowflake Computing
  • This tool is very much technical and proper knowledge is required, so mostly you have to hire an IT team.
  • I wish if various videos could be available for basic quires like its initiation, then I think it would act as a guideline and would help the beginners a lot.
Read full review
Microsoft
  • The import/export process can be tricky to follow with lots of steps and could be better for importing flat files
  • Obtaining help from Microsoft is cumbersome and often other internet sources are better and quicker
  • The documentation is not great and again it's generally better to obtain help elsewhere if needed
Read full review
Likelihood to Renew
Snowflake Computing
SnowFlake is very cost effective and we also like the fact we can stop, start and spin up additional processing engines as we need to. We also like the fact that it's easy to connect our SQL IDEs to Snowflake and write our queries in the environment that we are used to
Read full review
Microsoft
We understand that the Microsoft SQL Server will continue to advance, offering the same robust and reliable platform while adding new features that enable us, as a software center, to create a superior product. That provides excellent performance while reducing the hardware requirements and the total cost of ownership of our solution.
Read full review
Usability
Snowflake Computing
The interface is similar to other SQL query systems I've used and is fairly easy to use. My only complaint is the syntax issues. Another thing is that the error messages are not always the easiest thing to understand, especially when you incorporate temp tables. Some of that is to be expected with any new database.
Read full review
Microsoft
SQL Server mostly 'just works' or generates error messages to help you sort out the trouble. You can usually count on the product to get the job done and keep an eye on your potential mistakes. Interaction with other Microsoft products makes operating as a Windows user pretty straight forward. Digging through the multitude of dialogs and wizards can be a pain, but the answer is usually there somewhere.
Read full review
Reliability and Availability
Snowflake Computing
No answers on this topic
Microsoft
Its does not have outages.
Read full review
Performance
Snowflake Computing
No answers on this topic
Microsoft
SSAS data cubes may some time slow down your Excel reports.
Read full review
Support Rating
Snowflake Computing
We have had terrific experiences with Snowflake support. They have drilled into queries and given us tremendous detail and helpful answers. In one case they even figured out how a particular product was interacting with Snowflake, via its queries, and gave us detail to go back to that product's vendor because the Snowflake support team identified a fault in its operation. We got it solved without lots of back-and-forth or finger-pointing because the Snowflake team gave such detailed information.
Read full review
Microsoft
We managed to handle most of our problems by looking into Microsoft's official documentation that has everything explained and almost every function has an example that illustrates in detail how a particular functionality works. Just like PowerShell has the ability to show you an example of how some cmdlet works, that is the case also here, and in my opinion, it is a very good practice and I like it.
Read full review
In-Person Training
Snowflake Computing
No answers on this topic
Microsoft
It was good
Read full review
Online Training
Snowflake Computing
No answers on this topic
Microsoft
very hands on and detailed training
Read full review
Implementation Rating
Snowflake Computing
No answers on this topic
Microsoft
Other than SQL taking quite a bit of time to actually install there are no problems with installation. Even on hardware that has good performance SQL can still take close to an hour to install a typical server with management and reporting services.
Read full review
Alternatives Considered
Snowflake Computing
I have had the experience of using one more database management system at my previous workplace. What Snowflake provides is better user-friendly consoles, suggestions while writing a query, ease of access to connect to various BI platforms to analyze, [and a] more robust system to store a large amount of data. All these functionalities give the better edge to Snowflake.
Read full review
Microsoft
[Microsoft] SQL Server has a much better community and professional support and is overall just a more reliable system with Microsoft behind it. I've used MySQL in the past and SQL Server has just become more comfortable for me and is my go to RDBMS.
Read full review
Scalability
Snowflake Computing
No answers on this topic
Microsoft
SQL server does handle growing demands of a mid sized company.
Read full review
Return on Investment
Snowflake Computing
  • Positive impact: we use Snowflake to track our subscription and payment charges, which we use for internal and investor reporting
  • Positive impact: 3 times faster query speed compared to Treasure Data means that answers to stakeholders can be delivered quicker by analysts
  • Positive impact: recommender systems now source their data from Snowflake rather than Spark clusters, improving development speed, and no longer require maintainence of Spark clusters.
Read full review
Microsoft
  • Increased accuracy - We went from multiple users having different versions of an Excel spreadsheet to a single source of truth for our reporting.
  • Increased Efficiency - We can now generate reports at any time from a single source rather than multiple users spending their time collating data and generating reports.
  • Improved Security - Enterprise level security on a dedicated server rather than financial files on multiple laptop hard drives.
Read full review
ScreenShots

Snowflake Screenshots

Screenshot of Snowflake Installation