I would go directly to Sql Server 2016, it is IMHO by far the best ever and so far I haven't heard of any serious bugs.
😎

Question, are you trying to find all the entries containing an underscore character?
😎

Note that replacing the underscore character in brackets will only work with the LIKE operator,...

This update operation is elementary using the XML modify operation, here is a quick example
😎

USE TEEST;
GO
SET NOCOUNT ON;

-- Sample XML
DECLARE...

Looks like there is a bug in the subscription/notification part, after the upgrade I'm getting lots of notifications from threads I haven't subscribed to.
😎

This should get you started
😎

SELECT
 SPART.object_id
,OBJECT_SCHEMA_NAME(SPART.object_id) AS SCHEMANAME
,OBJECT_NAME(SPART.object_id)   AS TABLENAME
,SPART.partition_number     AS PARTITION_NO
,SDSPC.name        ...

You will have to Configure Windows Service Accounts and Permissions

😎

Looks like a problem with the data where the group by clauses in the sub-queries of the second query suppress the problem.

😎

Try running these three queries with and without the...

Suggest you read up on the CONVERT function!

😎

Example

DECLARE @DSTR VARCHAR(50) = '20151025'; -- ISO FORMAT

SELECT CONVERT(VARCHAR(30),CONVERT(DATE,@DSTR,112),101) -- US OUTPUT

As Tom pointed out, there is no JSON parsing support on...