If you are a longtime reader of this newsletter you probably know that I have no financial connection with Microsoft, nor do I have any connections to third party vendors for SQL Server add-ins. It is the only way I can assure readers that I am giving them my unbiased opinion. I do not want to be a shill for Microsoft.
That is also why you never see advertising in this newsletter. I Every once in a while I plug myself and my business but that is usually around the holiday season. You have to give me a break on that.
While I have often criticized decisions made in upgrading SQL Server I have little to complain about in SQL 2017. There are so many new things that I don’t have the space here to list them.
I have been working with SQL Server since it parted company with Sybase SQL Server. I have to watch my superlatives but I think SQL 2017 is the most important upgrade since SQL Server 2000.
There are so many new features that I can’t address them all here. I suppose that SQL Server on Linux should be near the top of the list but I don’t quite believe it yet.
In my humble opinion the improvements in speed should be the most helpful for struggling databases but there are so many improvements almost everywhere in this product.
My advice is that you should download the Developer Edition and give it to your DBA to play with it.
Here is a link to a more detailed look at SQL Server 2017.