En este post quiero compartir un script que utilizo bastante a menudo por su versatilidad Esta publicación forma parte de T-SQL Tuesday, que es una fiesta de blog mensual el segundo martes…
Etiqueta: Database Design
T-SQL Tuesday #99 – Grandes Debates : Unicode
En esta publicación, quiero compartir mi opinión sobre el uso de tipos de datos UNICODE de forma predeterminada para cadenas almacenadas en SQL Server Esta publicación forma parte de T-SQL Tuesday, que…
Jugando con Azure, Extendiendo Bases de Datos a la nube
Nos guste o no, la nube está cada vez mas presente en nuestras vidas como DBAs, así que creo que es buen momento para comprender algunas posibilidades que nos puede ofrecer. Ha pasado…
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…