What Is The Point of Versioning? Now, I’m not talking about version control, I am talking about stamping your database with a version number so you can keep track of how many modifications may be made in an environment not completely in your control. I have used this concept in the past in a development environment where I had a …
or: Learning to Not Look a Gift Horse in the Mouth The stars seem to have aligned. I am sitting in my hotel room in Seattle waiting for the Microsoft MVP Summit to start as a precursor to the PASS Summit later this week. Just a few months ago I never thought I’d be in this position. The back half …
Why Worry About The Server Name In SQL? When the name of the actual host machine’s server name does not match the server name stored in SQL Server a lot of things can start to go wrong. Reporting services can break, Connections denied, maintenance plans fail. Generally chaos can happen, but not always right away. How does these names get …
What Are Database Triggers? Triggers can be implemented to enforce business rules or referential data integrity in database applications. There are even triggers that allow data modifications to multiple base tables of a view. I have actually used this in the past when working with 3rd party encryption tools prior to SQL 2005’s native encryption options. Triggers are quite capable …
What is a Foreign Key? A foreign key is a link between 2 tables that is used to enforce referential integrity in the database. For example, if you have an order and a customer table, there is probably a logical relationship between the 2 tables. An order can’t exist without being linked to a customer record. When trusted, these …
I am extremely excited to announce that I have just received the Microsoft MVP award for SQL Server for 2014. For those that know what this whole MVP thing is there isn’t much more to say other than the headline:
