Filters:

  • Technologies

  • Instructors

  • Blog Author Archives: PeterAvila

    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?

    How to Implement Expand All/Collapse All for Drill-Down in SSRS

    While SSRS allows drill-down into individual groups in a Tablix, there is no built-in, direct support for an “expand all/collapse all” capability that would allow all groups to be simultaneously expanded or collapsed. No problem. We can create our own pretty easily. Here’s what it will do: The user will interact with two radio buttons. … Continue reading How to Implement Expand All/Collapse All for Drill-Down in SSRS

    How to Get SSMS to Recognize an Existing Object (Refreshing Lists in SSMS)

    Ever get this message in SQL Server Management Studio (SSMS) when you’re certain that the object exists? Then it proves you right when you go ahead and execute the command anyway? Why does SSMS complain that the object doesn’t exist when it obviously does? This happens because SSMS does not monitor database changes made in … Continue reading How to Get SSMS to Recognize an Existing Object (Refreshing Lists in SSMS)