Database Design

External Article

How to get Database Design Horribly Wrong

  • Article

Database Design is one of those tasks where you have to carefully get all the major aspects right. If you mess-up just one of these, it can all go horribly wrong. So what are these aspects that can ruin database design, and how can you get them right? Robert Sheldon explains.

2015-03-19

17,062 reads

External Article

Defusing Database Time Bombs: Avoiding the Need to Refactor Databases

  • Article

Where applications are evolved by gradually molding them to a growing understanding of the business domain, this presents great challenges to database development. If databases are designed too loosely, and initial errors are allowed to fester, the results become harder and harder to refactor until eventually they constitute a database time bomb. Thomas LeBlanc describes how to avoid a few basic, but very common, database time bombs.

2015-03-13

9,069 reads

Blogs

Using Data Masker on Chinese Surnames

By

A customer had a question recently on masking Chinese characters. I thought that was...

A New Word: Looseleft

By

looseleft – the feeling of loss upon finishing a good book, sensing the weight...

Using ChatGPT for Writing

By

I have been experimenting more and more with ChatGPT on a regular basis. I’m...

Read the latest Blogs

Forums

Advanced SQL query help

By sc-w

Hi, I am looking for some help with two queries using the following table/data....

Happy Memorial Day 2023

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Happy Memorial Day 2023

Install SQL Server using Powershell Desired State Configuration (DSC)

By VishnuGupthanSQLPowershellDBA

Comments posted to this topic are about the item Install SQL Server using Powershell...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers