Articles tagged “database”

• What's wrong with SQL Server's FILESTREAM? Mi­crosoft SQL Serv­er con­tains a fea­ture called FILESTREAM. For those who don't use SQL Serv­er, in short, this fea­ture al­lows to store very large chunks of data in a data­base with all the ben­e­fits and none of the draw­backs. Un­der the hood, Mi­crosoft…
  database 2 short 50
• Duplicating database constraints in code When I re­view data­base mod­els for RDBMS, I'm usu­al­ly sur­prised to find lit­tle to no con­straints. For in­stance, per­cent­age is of­ten stored in a col­umn of type int (while tinyint would be more ap­pro­pri­ate) and there is no CHECK con­straint to re­strict…
  database 2