Proper Storage and Handling of Personal Names
As database developers, we may need to rethink the way we store and handle personal names
2016-08-04
6,334 reads
As database developers, we may need to rethink the way we store and handle personal names
2016-08-04
6,334 reads
Find Tables with identity, which should have PK with 1 column but have a PK with multiple columns or where the unique identity is contained in other indexes.
2015-11-25 (first published: 2015-11-04)
133 reads
Find Tables with identity, which should have PK with 1 column but have a PK which is clustered but has multiple columns.
2015-11-24 (first published: 2015-11-04)
932 reads
Creating SQL Server databases is easier than the internet may lead us to believe.
2017-08-11 (first published: 2015-10-29)
8,247 reads
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
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
2014-08-04
2,187 reads
2014-07-16
2,728 reads
2014-01-06
1,844 reads
2013-01-24
2,295 reads
By Steve Jones
A customer had a question recently on masking Chinese characters. I thought that was...
By Steve Jones
looseleft – the feeling of loss upon finishing a good book, sensing the weight...
By Steve Jones
I have been experimenting more and more with ChatGPT on a regular basis. I’m...
Hi, I am looking for some help with two queries using the following table/data....
Comments posted to this topic are about the item Happy Memorial Day 2023
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Install SQL Server using Powershell...