SELECT *
FROM Posts
WHERE Tags IN ('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 »

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 »

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
27
2016

SQL Server 2016, Double or Nothing, Always Encrypted with temporal tables

Among the overwhelming amount of new features available for SQL Server 2016, there was one I really wanted to try, maybe because I have never worked with encryption further…

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 »

mar
10
2016

SQL Server 2016, playing with DATABASE SCOPED CONFIGURATIONS

It’s been a few days since SQL Server…

Continue Reading »

ene
15
2016

SQL Server 2016CTP3 fist impressions, 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 my new test system I’ll tell you about in a post hopefully soon. The user interface to install SQL Server is pretty much…

Continue Reading »