I don’t know about you, but the first time that I got my approval to go to IDUG’s technical conference – I actually stood up on my desk, did a small jig, clouds parted, and angels sang. I really did. Don’t look at me like that. Prove me wrong. Once I came down off the [...]
{ 0 comments }
DBA’s have egos. We like to say “Look what I created,” “Check out this huge database I fixed,” or “I McGyver-ed a solution at 3am in a War-Room hyped up on my 8th cup of coffee.” Then the bragging really begins. “I fixed a 1.2 T Data Warehouse!” Which receives a quick response of “Oh [...]
{ 0 comments }
One question I frequently get is “How do you find the time to blog?”. I have a full-time plus job as a DBA and a family with two young kids to boot. The truth is that most of the time, it’s not that hard. I have the world’s most supportive husband, and at least one [...]
{ 0 comments }
Go-lives bring all kinds of opportunities to find problem SQL. A new site going live or a new site design going live can put a completely different load of SQL on a database. Depending on the level of load testing done, there can be some problems still to find. This post is an example of [...]
{ 6 comments }
IBM announced on April 3rd a new version of DB2. I tend to be stuck a few versions back due to what WebSphere Commerce certifies with, but I’m constantly learning about and drooling over new versions. I think many DBAs end up stuck a version or two back for longer than they would like. I [...]
{ 3 comments }
As with the other entries in my DB2 Basics series, this entry does not cover everything about triggers. Instead, I’m covering the basics and a few important points. DB2 triggers are sometimes over-used and over-complicated. Basically, triggers are actions(SQL) that take place when a triggering action occurs. Triggering Actions For DB2, the valid triggering actions [...]
{ 0 comments }
It is the final vote of DB2′s Got Talent 2013. I highly recommend you listen to all of the presentations (hour long show) for yourself. There’s such great content there. You can download the show at: http://www.dbisoftware.com/blog/db2nightshow.php?id=429 That’s also the link for voting. Simply scroll down to the bottom of the page, and fill out [...]
{ 0 comments }
You’ve got your database code page set as UTF-8, what more do you need to know, right? DB2 automatically handles all that conversion stuff for you, right? I’ve been dealing with significant amounts of data using UTF-8 characters that differ from the unix/linux standard code page(in the US) of 819 for the first time in [...]
{ 3 comments }
Today is Susan Visser’s Birthday! Happy Birthday, Susan! Susan is a prolific blogger on Information Management education and skills. I read her blog regularly and recommend that you do too. Her blog is: https://www.ibm.com/developerworks/mydeveloperworks/blogs/SusanVisser/?lang=en_us Susan has been in various roles with IBM – technical writing, support, managing the certification program for DB2, and now as [...]
{ 0 comments }
To go with today’s presentation on the DB2′s Got Talent competition, I wanted to write about blogging and getting involved in the DB2 community. Blogging has brought me great benefits, and just about everyone could contribute to the DB2 community by writing about their own experiences. Benefits For me, the benefits of engaging in the [...]
{ 0 comments }
