Hi folks. It’s been a long time, but Databases Never Die (this could be a movie name, don’t you think?). Below are a few performance articles to think about performance.
First one is SQL on Windows vs. SQL on Linux. Some interesting numbers here: http://www.sqlservercentral.com/articles/vnext/152671/?utm_source=SSC&utm_medium=pubemail
Then some tips about compression, this is really worth checking: https://sqlperformance.com/2017/01/sql-performance/compression-effect-on-performance
And finally some index goodness. Indexes are Always a good thing to learn more about: http://www.sqlservercentral.com/blogs/confessions-of-a-microsoft-addict/2017/02/08/dba-101-what-you-may-be-missing-with-missing-indexes/?utm_source=SSC&utm_medium=pubemail
cya!