Esta semana quiero ir un paso más allá en el camino de mover nuestras bases de datos a la nube y empezar a usar alguna de la funcionalidades avanzadas que ofrece Azure En…
Etiqueta: SQL Server 2016
In-Memory logging, much cooler than disk based
This week I want to look at one of the most important parts, in my opinion, that allow In-Memory to outperform and scale better than the traditional engine, and this is the…
Multi-column statistics are back in SQL Server 2016
The new cardinality estimator in SQL Server 2014 brought new and improved query performance but as always there are caveats. Let’s check a specific case to see the different behaviors for the…
SQL Server 2016, Double or Nothing, Always Encrypted with temporal tables
This week’s post I’ll talk about two new features that don’t seem to get on well. Let’s make them behave and work together as a team Among the overwhelming amount of new…
T-SQL Tuesday #80 – SQL Server 2016, using the Query Store for READ-ONLY databases
The new Query Store is one of the most exciting features coming with SQL Server 2016, but unfortunately comes with some limitations. Learn how we can overcome one of those This…
SQL Server 2016 Query Store, User Data or Metadata?
One of the newest features for SQL Server is the Query Store, let’s explore it to know a bit more about it It’s been a month since the SQL Server community has their…
SQL Server 2016 COMPRESS and DECOMPRESS performance
More new functionalities coming along with SQL Server 2016, this time I’ve been playing with COMPRESS and DECOMPRESS One of the most exciting things for me in this new version of SQL Server…
SQL Server 2016, playing with DATABASE SCOPED CONFIGURATIONS
It’s been a few days since SQL Server 2016 RC0 was released and one of things people have blogged about is the new DATABASE SCOPED CONFIGURATIONS, where you can do modify certain…
SQL Server 2016CTP3 fist impressions, Installation
My first impressions using SQL Server 2016, installation It’s been very exciting time waiting to get the new release installed, in my case SQL Server 2016CTP3, a bit late because I was building…