Video Programming for IT Professionals Career management advice, coaching and much more. We discuss making the best of your professional development, provide specific tips and ideas for advancing your career and even answer questions from field.
Other News
Simulating Add Column if Not Exists in MySQL With Common_schema
(Ike Walker) Some MySQL DDL commands such as CREATE TABLE and DROP TABLE support an IF [NOT] EXISTS option which allows you to downgrade the error to a warning if you try to create something that already exists or drop something that doesn’t exist.
Commit scalability
(Bobby Durrett) I am learning about how well commits scale on Oracle 11.2 and so far they seem to scale surprisingly well.
How to check reclaimable space enabled on DB2 tablespace with MON_GET_TABLESPACE
(Jack Vamvas) Question: How can I check if a DB2 database tablespace has reclaimable space enabled?
XML Strategies to Improve Test Organization
(E. Scott McFadden) Typically, a XML data structure design is simple and to the point. It only contains business related data. In production, this is just fine because the business purpose of the transaction is clear.
It’s Simple!! Or Psuedo Simple Anyway.
(David Dye) MSDN documents the log chain as: A continuous sequence of log backups is called a log chain. A log chain starts with a full backup of the database. Usually, a new log chain is only started when the database is backed up for the first time or after the recovery model is switched from s
Windows Forms TabControl: Restoring a Removed TabPage
(Ged Mead) In an earlier post, I showed a couple of ways to remove a TabPage from a TabControl. Sometimes you’ll want this removal to be only temporary. In that case, you’ll need to change the code so that a copy of the removed TabPage is stored in a way that it can be reinstated. That’s what I’l
Using sysbench 0.5 for performing MySQL benchmarks
(Michael Coburn) Given the recent excitement & interest around OpenStack I wanted to make sure I was ready to conduct appropriate evaluations of system performance. I generally turn to sysbench since it comes with a variety of different tests (accessed via –test= option interface), including:
Viewing ASM trace files in VIM: Which Way Do You Use?
(flashdba) A couple of people have asked me recently about a classic problem that most DBAs know: how to view ASM trace files in the VIM editor when the filenames start with a + character. To my surprise, there are actually quite a few different ways of doing it. Since it’s come up, I thought I’d li
Data Parsing SQL to JSON
(Abhishek Jaiswal) This article explains how to convert one type of data into another then again repeat the procedure for converting that type of data into another form.