SELECT *
FROM Posts
WHERE Tags IN ('SQL Server')

Apr
26
2017

Successful Anti-Patterns, Using Deprecated Data types

From time to time it’s good to remind people about the…

Continue Reading »

Mar
14
2017

T-SQL Tuesday #88 – The security audit WTF

  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 and have the chance to write about…

Continue Reading »

Feb
9
2017

Statistics and Data types, What can go wrong?

One of the most interesting things in SQL Server from my point of view are Statistics and how the optimizer interprets them to produce optimal query plans. But today I want to write about something…

Continue Reading »

Jan
3
2017

Playing with Azure, Stretching Databases

It’s been a while since my last post, and I wanted to keep exploring some of the new features that SQL Server 2016…

Continue Reading »

Nov
3
2016

Database Design Matters, Real World Scenario

Disclaimer: This is how I solved a particular problem after analyzing and understanding my data….

Continue Reading »

Sep
21
2016

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…

Continue Reading »

Sep
6
2016

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…

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 »

Jun
22
2016

Update Statistics Misconception

On the 15th of June I made my first presentation at my local user group, and I have to say that was a nice experience. The presentation is about SQL Server statistics and at certain…

Continue Reading »

Jun
16
2016

Database design matters, seriously

This might sound pretty obvious, but really, database design matters. And all those rules and best practices about database…

Continue Reading »