As a follow up to last week’s article on error handling in stored procedures, this week we are sharing a video of a presentation by Linda Claussen of Themis Education. Linda details several additional ways to think about error handling.
IBM’s Data Studio holds a lot of features that are not commonly known by the DB2 audience. Many regard it as the replacement of the old Control Center. IBM Data Studio has got a lot of goodies not included in Control Center. In this article we will focus on the usage of physical data models.
Come take a look at the next generation tooling platform that IBM® rolled out in March 2015 to help optimize database performance, detect and solve performance problems, easily administer instances, database objects, and manage data server configurations.
April 2015 “Fun with SQL” third Challenge
This month on the Content Committee blog we’ll be doing an online version of the “Fun with SQL” dojo. Each week we’ll present an SQL challenge and request the community to solve it.
Some DBAs end up creating dozens of views on the same table just to manage the security requirements. It can be difficult to track the purpose of all these views and manage them accordingly. Row and column access control may be used as an alternative to views to manage security requirements.