SQL Server Community Technology Preview 3 has been released some days ago.
The SQL Server team added a lot of features related to:
- SQL Server Engine (Query Store, Temporal Tables and In-Memory improvements)
- Cloud-ready stuff (Transactional replication from and to Azure SQL Databases, Stretched database enhancements)
- New releases of Management Studio
- Analysis Services
- Reporting Services (great, let’s say, “new entry”)
- Integration Services
Additionally, we can deal with new programmability features:
I’m a fan of the SQL Server 2016 native JSON support right now. This is one of the newest features, and, due to this, it’s a “frequent changing” topic. The CTP3 has been released before our SQL Saturday in Parma, fortunately. Thus, I have to update my slides and demo in three weeks. This is great!
This is the “what’s new” on CTP3 for JSON support:
I’ll write a blog post for each one of those function in the next days. So we will be ready for #sqlsat462!