Updating sql 2016
Bad Procedure;2 AS BEGIN SET FMTONLY ON; UPDATE b SET x = 1 FROM dbo.Bad Table AS b WITH (NOLOCK); EXEC sp_configure 'allow updates', 1; END GO CREATE PROCEDURE dbo.Advanced settings allows you to specify the port, whether to encrypt the connection (off by default)and any additional connection string parameters: I like that it shows a breakdown for all compatibility levels above the database's current level.Surprisingly, though, it only found one issue in my intentionally problematic database; the use of the NTEXT data type: These are all things that are deprecated and that should be setting off alarms for an upgrade to SQL Server 2016 and beyond.The new Upgrade Advisor certainly looks promising, but I do hope that it is enhanced to catch more than just the usage of TEXT/NTEXT, which still doesn't even actually break in SQL Server 2016.
This means organizations that want to try out new features cannot do this until the FBL is raised.
In a future tip, I'll take a look at the new feature found in this preview, the Stretch Database Advisor.
Aaron Bertrand (@Aaron Bertrand) is a Product Manager at Sentry One, with industry experience dating back to Classic ASP and SQL Server 6.5.
However, this version is completely different from its predecessors, and is available in preview from today - long before the release of SQL Server 2016!
In addition, there is a new feature available here, called the Stretch Database Advisor, which will help provide guidance about tables that might be good candidates for this new SQL Server 2016 feature.