


Where I have made claims about MS SQL Server I have done my best to check that they apply to version 2014 by consulting Microsoft's own documentation – although, for reasons I will get to, I have also had to rely largely on Google, Stack Overflow and the users of the internet. Unless otherwise stated I am referring to PostgreSQL 9.3 and MS SQL Server 2014, even though my experience with MS SQL Server is with versions 2008 R – for the sake of fairness and relevance I want to compare the latest version of PostgreSQL to the latest version of MS SQL Server.

This document is my way of automating that conversation. A well-known principle in IT says: if you're going to do it more than once, automate it. Over the years I have discussed the issue of PostgreSQL vs. I frequently come into contact with people who know very little about these things – although some of them don't realise it. I have spent that decade dealing with data, database software, database hardware, database users, database programmers and data analysis methods, so I know a fair bit about these things. I have been doing this for about a decade.
#SQLPRO FOR MSSQL SERIAL PROFESSIONAL#
I work as a data analyst in a global professional services firm (one you have certainly heard of). A comparison of two relational databases from the point of view of a data analyst 0.
