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…
Database Design Matters, Real World Scenario
Sooner or later the more you know how SQL Server works will help you come up with more and more ideas to solve your daily problems, let me show you what one…
Database Design Matters, RTO and Filegroups
RTO and RPO are two terms that must sound familiar for database professionals, but not everybody know that a good database design can dramatically improve our recovery time in case of disaster Usually…
Successful Anti-Patterns, Storage Requirements
One of the things you realize with experience is that there is not one absolute truth when speaking about SQL Server… that comes along with the magical answer for most of 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…
Database Design Matters, choosing the Clustering Key
There has been a permanent debate about which is the right clustering key for our tables since the beginning of the time, this time I’ll get a bit deeper to show you…
T-SQL Tuesday #82 – My first steps on Azure Database
This week I want to walk my first steps into SQL Azure database, create a new database and run a query, totally for novices like me This post is part of…
Database design Matters, choosing the right data type
This is not the first time I write about best practices or how a good design can help even from a performance point of view, but today I’ll go to an earlier…