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…
Categoría: SQL Server 2016
Jugando con Azure, Extendiendo Bases de Datos a la nube
Nos guste o no, la nube está cada vez mas presente en nuestras vidas como DBAs, así que creo que es buen momento para comprender algunas posibilidades que nos puede ofrecer. Ha pasado…
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…
In-Memory NonClustered Indexes, much cooler than disk based
The new In-Memory engine is now available on every edition of SQL Server, including Express, so there is no excuse to start exploring this amazing feature Last week Microsoft has done it. 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…
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…