Filters:

  • Technologies

  • Instructors

  • Category: SQL Server

    A Primer on Joins

    The golden rule of OLTP database design is that every table should represent one, and only one, entity-type. Without this rule, databases can exhibit three data anomalies (insertion, deletion, and update anomalies) that undermine data integrity. But adherence to the rule comes at a price of greater overhead (though it is a price well worth … Continue reading A Primer on Joins

    Referential Integrity Options (Cascade, Set Null and Set Default)

    Ever wonder why there are only two options under the INSERT and UPDATE Specification of a foreign key? Why is there no Insert Rule? And to which table in the relationship do these rules apply? Let’s start at the beginning. Relationships in a database are implemented with foreign keys and primary keys. (For a primer … Continue reading Referential Integrity Options (Cascade, Set Null and Set Default)

    Object Prefixes: Friend or Foe?

    Contrary to popular belief, prefixing object names isn’t always a good idea and some professionals have dropped the practice entirely. To see why this is, let’s take a look at database object names as an example. Initially, it might seem like a good idea to prefix table names with “tbl,” views with “v,” and so … Continue reading Object Prefixes: Friend or Foe?

    The Differences Between BI for Enterprises and SMBs

    Business Intelligence (BI) systems were originally targeted primarily at large enterprises with tons of data. As BI technology improved, it started to become more accessible to small- and medium-sized businesses (SMBs), who started using BI systems to answer many of the same business questions as their larger, enterprise cousins. After all, business is business: Whether … Continue reading The Differences Between BI for Enterprises and SMBs