‫انتشار SQL Server 2016 CTP 3.1

New In-Memory OLTP improvements in CTP3.1 include:

• Unique indexes in memory-optimized tables, to complement the support for unique constraints that was released in CTP3
• LOB data types varchar(max), nvarchar(max), and varbinary(max) in memory-optimized tables and natively compiled modules
• Indexes with NULLable key columns in memory-optimized tables

Syntax inputdate AT TIME ZONE timezone.

• Inputdate: An expression that can be resolved to a smalldatetime, datetime, datetime2, or datetimeoffset value.
• Timezone: Name of the destination time zone in standard format as enumerated by Windows. Available time zones can be found by querying sys.time_zone_info.
  

SQL Server Analysis Services (SSAS) updates allow upgrading your existing models to 1200 compatibility level and a JSON editor for SSDT;