Skip to content
SQLDoubleG
Menu
  • Home
  • Articles
  • SQL-G Hacks
  • Language: English
    • English English
    • Español Español
Menu

Tag: Database Design

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

Posted on Tuesday July 10th, 2018

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…

T-SQL Tuesday #99 – Great Debates : Unicode

Posted on Tuesday February 13th, 2018

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

Posted on Tuesday January 3rd, 2017

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

Posted on Thursday November 3rd, 2016

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

Posted on Friday October 28th, 2016

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

Posted on Wednesday September 21st, 2016

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

Posted on Tuesday September 6th, 2016

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

Posted on Thursday June 16th, 2016

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…

  • About this blog
  • Articles
  • Development
  • Free Training
  • Security
  • SQL Server 2016
  • SQL-G Hacks
  • T-SQL Tuesday

Latest Posts

  • T-SQL Tuesday #158, Implementing Worst Practices
  • T-SQL Tuesday #155 –The Dynamic Code Invitation
  • FillFactor, the Untold Story
  • How I Compared 1000’s of database’s schemas at once
  • How to Update SQL Server Stats The Right Way
©2023 SQLDoubleG | Design: Newspaperly WordPress Theme