SELECT *
FROM Posts
WHERE Category = 'SQL Server 2016'

feb
1
2017

Jugando con Azure, backups de archivos instantáneos

En la última publicación, exploramos cómo mover parte de nuestras bases de datos a la nube creando un nuevo archivo en el servicio de…

Continue Reading »

ene
3
2017

Jugando con Azure, Extendiendo Bases de Datos a la nube

Ha pasado un tiempo desde mi última publicación, y quería seguir explorando algunas de las nuevas características que ofrece SQL Server 2016. Esto técnicamente no…

Continue Reading »

nov
30
2016

In-Memory logging, much cooler than disk based

Last week we started exploring some of the cool features that the new In-Memory engine (code name Hekaton) has brought into…

Continue Reading »

nov
23
2016

In-Memory NonClustered Indexes, much cooler than disk based

Last week Microsoft has done it. The release of SQL Server 2016 SP1 is a game changer, most of the desired but sometimes prohibitive features from Enterprise Edition are now…

Continue Reading »

sep
30
2016

Multi-column statistics are back in SQL Server 2016

Don’t get me wrong, they’ve always been there, but somehow someone forgot about them and weren’t used. Since last…

Continue Reading »

jul
12
2016

T-SQL Tuesday #80 – SQL Server 2016, using the Query Store for READ-ONLY databases

  This post is part of the T-SQL Tuesday, which is a monthly blog party on the second Tuesday of each month. Everyone is welcome…

Continue Reading »

jul
6
2016

SQL Server 2016 Query Store, User Data or Metadata?

It’s been a month since the SQL Server community has their new toy, SQL Server 2016, which to my surprise and considering not everyone has yet adopted SQL 2014, it’s absolutely packed with new…

Continue Reading »

mar
24
2016

SQL Server 2016 COMPRESS and DECOMPRESS performance

One of the most exciting things for me in this new version of SQL Server is inclusion of native gzip compression into the, I guess, storage engine functionalities. I know you can implement your own CLR version of…

Continue Reading »