One of the perks of doing software development for small- and medium sized organisations is that you get involved in all aspects of IT. In our projects at ChasmX we have done backup, workstation and router configuration, printer troubleshooting, mail merge support and, of course, database maintenance.
Database administration skills are a must when you develop line-of-business applications, and most of us know our way around the usual suspects: Orace, SQL Server, MySql and sometimes even DB2, Informix or PostgreSQL.
When you specialize in legacy application renewal, you sometimes come across more exotic database varieties. In this article, I’ll share my knowledge of SQLBase , a variety I came across earlier this year.
SQL what now ?
Gupta SQLBase was one of the first relational databases for the PC in the 80s. It has changed owners several times in its 30 years, but currently it seems to target embedded platforms, claiming to be a ‘no maintenance’ RDBMS. But back in the mid to late 90s, SqlBase was still a very popular relational database technology for PC platforms, which is why some of the older legacy apps still use them.
I have been helping a client out with DBA services for an aging 7.6.1 release of SQLBase. To give you an idea of how old that is: the hardware requirements state that you need at least 24MB of RAM available on Windows 95, 98, NT or windows 2000
Recently I was tasked with extracting some data from an Oracle 10gR2 server and converting it to SQL Server 2008. I could not get very much information about the Oracle server other than a sys password and the location of the nightly backup dump files. The server was serving two applications with very little vendor support – but they were working. The icing on the cake was that the the Oracle EM web app was not working – so I was also running a little blind. I didn’t want to break anything so I opted to leave the EM non-functional and I decided to import a recent dump into a fresh scratch Oracle instance. I would do my export to SQL server from there – zero risk of an oops.
The dumps were full system dumps and were tens of GB in size. I needed to know the names of the schemas being backed up so I could selectively restore the schemas to my new Oracle instance. In my messing around I accidentally loaded one of the dumps into a text editor (that was smart enough to deal with large files) and noticed it was mostly text. Keep Reading
The ChasmX team has been working onsite at the head office of a trade union for the year or so. One the very first day I started onsite my partner Arne (who had been there for a few months) met me outside. One of the first things he pointed out to me as he led me to our office were these machines. One of the members had built these amazing wooden replicas of three big machines. Click on the pictures to get a larger more detailed image. Amazing! See the pics
**UPDATE – As we moved forward with our project this method turned out to be a little less awesome than I thought when I put it together. I’ve left this post here though as I am not ashamed of my failures! There is also some neat stuff in here with setting up the identity fields using nHibernate.
Recently I needed to create a generic re-usable system to generate system wide unique counters using SQL server tables and identity fields to handle the number generation. One of the key requirements was to be able to specify the identity seed, but in a re-usable way of course.
Generic Class and Class Map
So lets start this off with a base class to define the counter object:
My wife and I recently took a mini vacation and spent a few nights in Banff, Alberta. Man I’ve missed that town… We took the gondola up to the top of Suplhur mountain and there amongst the clouds at the end of the top of the mountain hike I found this large hunk of rock near the edge of a cliff. Being a P90X/2 junky I felt compelled to Crane on top of this rock, 7350 feet above sea level, near the edge of the cliff and share it with the world.
I would like to send a big thumbs down and a boo to madison seating for misleading advertising. They sent me an e-mail yesterday advertising their big sale on Aeron chairs. My current Aeron is almost a decade old and squeaks / creaks / groans when I sit down - so I figured this would be a great time to get a new one! I jump on their site configure the chair and place my order for a couple chairs.
Look – free shipping, ships to Canada and a great price!
The hackers that made the FLAME virus have published a secret login console on flamer.com. It’s top secret but maybe you already know the login and password…. http://www.flamer.com
But seriously folks. I have not been in a place to write much this year. We’ve been insanely busy improving workforce productivity with automation over at ChasmX – . I’ve also been helping my wife launch her new CPR instruction business Dr. Bones CPR. On top of that our daughter has become mobile and is keeping us on our toes. That said – I’ve got a half dozen cool topics in the works. I’m hoping to get some good posts laid down here in the coming weeks.
My six month old daughter LOVES my notebook…
I’ve been having a lot problem with my notebook since a bit before Christmas. I’ve had to re-install Windows like 3 times now (and yes I was using RAID and had backups…long store). Anyhow, the first couple of times I went through the 20GB+ download for Star Wars The Old Republic and my internet out here is not great. The entire download process takes 12+ hours. Tonight I was determined to find a better way…
Well I found it. Keep Reading
If you’ve worked with me or talked technical with me in the past there is a good chance you area already very aware that I love Log4Net. There is also a really good chance that you know I still have a special place in my heart for Visual Lisp. Not only did I spend what may have been the “best years of my life” buried in VLIDE (or hey, maybe all those 30+ hour days and passing out under my desk were the best years of my life? =)) , I still firmly believe that Lisp is one of the most effective way to bang out even a relatively complex operation in AutoCAD when it comes to data manipulation. ObjectARX (both original and .NET) is great – but the time and effort overhead is pretty high when you just need to bang out a quick routine.
<3 Visual Lisp
Even the quick routines need a little error handling and logging can make a huge difference in documenting the results or diagnosing problems. Keep Reading