SELECT *
FROM Posts
WHERE Tags IN ('Database Design')

Jul
10
2018

T-SQL Tuesday #104 – Finding tables and columns in SQL Server

 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 SQL Server. This month’s host is Bert…

Continue Reading »

Feb
13
2018

T-SQL Tuesday #99 – Great Debates : Unicode

 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 SQL Server….

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 »

Oct
28
2016

Database Design Matters, RTO and Filegroups

Usually it’s said the most important duty of DBA’s is to be able to guarantee the integrity of the data of the business we…

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 »

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 »