In the comments on my previous post, Erdju made the suggestion that I add StackOverflow to my analysis – suggesting that the more SQL Server questions might be found there, changing the result of the analysis. Using the data.stackexchange.com site to analyse data as suggested by Nick Craver (instead of my own, mocked up version) I can now extract recent data for both sites.
This posts contains the updated result as well as a few additions to the previous post.
I used the following query to dig out the data:
/* Count of questions */
, SUM(MySQL) AS MySQL
, SUM(MSSQL) AS MSSQL
, SUM(PostGres) AS Postgres
, SUM(Oracle) AS Oracle
CAST(YEAR(CreationDate) AS VARCHAR) + '-' + RIGHT('00'+CAST(MONTH(CreationDate) AS VARCHAR) , 2) AS CreationMonth
, CASE WHEN Tags LIKE '%mysql%' OR Tags LIKE '%my-sql%'
THEN 1 ELSE 0 END AS MySQL
, CASE WHEN Tags LIKE '%sql%server%'
OR Tags LIKE '%mssql%'
OR Tags LIKE '%SSAS%'
OR Tags LIKE '%Azure%'
THEN 1 ELSE 0 END AS MSSQL
, CASE WHEN Tags LIKE '%postgre%'
THEN 1 ELSE 0 END AS Postgres
, CASE WHEN Tags LIKE '%Oracle%'
OR Tags LIKE '%ORCL%'
OR Tags LIKE '%sqlplus%'
THEN 1 ELSE 0 END AS Oracle
WHERE YEAR(CreationDate) >= 2011
AND PostTypeId = 1 /* Question */
) AS C
GROUP BY CreationMonth
ORDER BY CreationMonth
The result is pretty impressive:
When taking StackOverflow into account, MySQL is a clear winner.
SQL Server people, any additional suggestions that might save your world view?