In this post I want to share a script that I use quite often because its flexility This post is part of the T-SQL Tuesday, which is a monthly blog party on…
Tag: Database Design
T-SQL Tuesday #99 – Great Debates : Unicode
In this post I want to share my opinion about using UNICODE data types by default for strings stored in SQL Server This post is part of the T-SQL Tuesday, which is…
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…
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…
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…
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…
Database design matters, seriously
All those rules and best practices about database design exist for a reason. Today I want to show you something very simple for you to see how a good design might improve…