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…
Categoría: Articles
Articles mostly focused on SQL Server technologies
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…
SQL Server 2016, Double or Nothing, Always Encrypted with temporal tables
This week’s post I’ll talk about two new features that don’t seem to get on well. Let’s make them behave and work together as a team Among the overwhelming amount of new…
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…