SQL Server 2016

SQL Server 2016 RC3: .NET Framework 3.5 is no longer required during installation

As you may certainly know, the last release candidate of SQL Server 2016 (RC3) has been released by Microsoft a couple of days ago. You may find the announcement here.  As usual, after downloading the binaries(…)

SQL Server 2016: CREATE TABLE for Stretch Database is available

This month, the Release Candidate 1 (RC1) for SQL Server is available. With this new version, you can now use the “CREATE TABLE” command for Stretch Databases. If you read the msdn page(…)

SQL Server 2016: new database-scoped configuration parameters part 2

In this blog post, let’s continue with other database-scoped options shipped with the SQL Server 2016 RC0. We will first begin with the first one and my preferred option: setting the MAXDOP value for(…)

SQL Server 2016: new database-scoped configuration parameters

Do you remember new capabilities shipped with SQL Server 2016 CTP2 about tempdb? In this blog post, I talked about well-known trace flags 1117 and 1118 that become useless for tempdb because their related effects are(…)

SQL Server 2016 : nonclustered columnstore index and aggregate pushdown

Did you miss aggregate pushdown capability shipped with columnstore index? Well, I remember the first time I heard about it is was when I read the very interesting blog post of Niko Neugebauer here with a(…)

SQL Server 2016: new upgrade advisor

I write this article because it is very interesting to see that the upgrade advisor has evolved… Recently (February 11, 2016), a new version is available: Microsoft® SQL Server 2016® Upgrade Advisor Preview 1.4 The msi package(…)

SQL Server 2016: temporal table with In-Memory

In SQL Server 2016 CTP 3.0, temporal tables with In-Memory OLTP is supported. 🙂 At the JSS2015 (Journée SQL Server 2015), I have presented a little demo about temporal table with a table(…)

SQL Server 2016 – availability groups and gMSAs

This blog post will probably not concern customers where either password policy change rules are not defined for service accounts or Kerberos authentication is not used. But I’m sure that the number of these customers has decreased over at least(…)

Journées SQL Server 2015: Retrouvez nos sessions sur SlideShare et Youtube!

Avant de partir pour des vacances bien méritées et une année pleine d’aventures sur SQL Server, je fais un dernier petit article pour vous informer que nos sessions des Journées SQL Server 2015 sont disponible sur SlideShare et(…)

SQL Server 2016: new T-SQL commands COMPRESS and DECOMPRESS

In live from the JSS2015 (Journée SQL Server 2015) in Paris, we saw that the CTP3.1 has been available in the night of these 2 days. One new feature available for this release in the T-SQL(…)