Under certain conditions you might want to have records removed from a child table when a corresponding record is removed from the parent table. If you have foreign keys properly setup and you attempt to remove a record from the parent table and there exists a record in a child table you will receive an error. So now it becomes a two step process where you first have to track down all the records in the child table and delete those first and then move on to deleting the record in the parent table.
The two step process is tedious and depending on how many child tables have a foreign key to the parent table, you could end up missing one of them and have the error still occur. There is a column option called ON DELETE CASCADE that can make this task easier. Continue reading →
There are times when it is a good choice to implement a view. Some examples are for security purposes, reduce complexity, and table structure changes. What I want to talk about today is being able to manipulate data through a view using Data Manipulation Language (DML) statements such as INSERT, UPDATE, and DELETE. Continue reading →
One of the cool things about being a developer is getting the opportunity to give back and donate your time to help charities and nonprofits. The Colorado GiveCamp is an event where you can do just that. This was my first time taking part in a GiveCamp and I am so glad I was able to participate.
GiveCamp is a weekend long event that starts on a Friday evening and finishes up in the early afternoon on Sunday. There is a good mix of designers, developers, DBA’s, and project managers who offer their expertise. Usually there are about a half-dozen charities and nonprofits that need help and the IT professionals get broken up into groups for each organization. I was placed in the group doing work for Get Smart Schools, a nonprofit whose mission is to improve schools in Colorado’s urban communities. Continue reading →
One of the biggest, if not the biggest database event happens only once a year and this time it took place in Seattle, Washington. I am talking about the PASS Summit. The best way I can describe it is 5 straight days of SQL Saturday’s, but on overdrive. I was very fortunate that my company was able to send me to this year’s event, which was the best conference I have ever been to. Continue reading →
SQL Saturday #172 in Portland, Oregon started off a full week of SQL Server for me. I flew out from Denver and arrived on Friday evening with enough time to make it to the speaker dinner. It was great seeing some familiar faces as well as getting introduced to SQL folk from the northwest region. Continue reading →
SQL Saturday #153 in Salt Lake City, UT finished up my crazy schedule for October and was another great SQL Saturday to be a part of. Just like the rest of the SQL Saturday’s I have attended in 2012, I decided to do another road trip out to Utah. Continue reading →
I mentioned yesterday that I had a presentation malfunction prior to the start of my SQL Saturday session. Up until this point I never had an issue when presenting. My laptop worked, the demos did not crash, presentation remote’s batteries had enough power, etc… I knew in the back of my head that something can and will eventually go wrong with a presentation, and it finally happened. The issue I ended up experiencing was that my MacBook Air laptop running Boot Camp did not recognize the VGA projector and I had to figure out what to do quickly. Continue reading →