October 18, 2012

SQLBase

Filed under: Uncategorized — Tags: , — Arne Joris @ 12:10 pm

SQLTalkIconOne 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 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 :-)

(more…)

October 8, 2012

Extract list of Oracle schema names from dump file

Filed under: Oracle — Tags: , , , — Darrin Maidlow @ 8:00 am

Recently I was tasked with extracting some data from an server and converting it to 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

September 6, 2012

Amazingly detailed craftsmanship – three wooden replicas of heavy equipment

Filed under: General — Tags: — Darrin Maidlow @ 1:14 pm

The 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

August 13, 2012

Unique number counter system using SQL Server identity fields and Fluent NHibernate

Filed under: Development,NHibernate,SQL Server — Tags: , , — Darrin Maidlow @ 6:00 am

**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:

(more…)

August 6, 2012

Crane on a mountain top

Filed under: General — Tags: — Darrin Maidlow @ 10:30 am

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 on top of this rock, 7350 feet above sea level, near the edge of the cliff and share it with the world. 

SAM_1621

Keep Reading

June 13, 2012

Boo to you MadisonSeating

Filed under: General — Tags: , , — Darrin Maidlow @ 12:56 pm

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!

Keep Reading

June 4, 2012

FLAMEd

Filed under: General — Tags: — Darrin Maidlow @ 10:25 pm

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 .  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.

Talk soon! ;)

January 25, 2012

Like father like daughter–AKA Alienware is purrty

Filed under: General — Tags: , — Darrin Maidlow @ 8:33 pm

My six month old daughter LOVES my notebook…

SAM_1389

Keep Reading

January 15, 2012

SWTOR Hack–Re-install without the 20GB+ Download

Filed under: Gaming — Tags: — Darrin Maidlow @ 1:24 am

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

January 13, 2012

Using Log4Net with Visual Lisp

Filed under: AutoCAD,Development — Tags: , , , — Darrin Maidlow @ 1:07 pm

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 .  There is also a really good chance that you know I still have a special place in my heart for .  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

« Newer PostsOlder Posts »

Powered by WordPress

Switch to our mobile site