This week I want to go another step into moving databases to the cloud and start using some advanced features that Azure offers Last post, we explored how to move part of our…
Category: SQL Server 2016
Playing with Azure, Stretching Databases
Whether we like it or not, the cloud is more and more present in our life as DBAs, so it is a good time to try understand some of the possibilities it…
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…