One of the developers I support recently came across the following error message in Microsoft SQL Server 2000 (SP4): Server: Msg 8104, Level 16, State 2, Line 1The current user is not the database or object owner of table ‘table_name’. Cannot perform SET operation. Unfortunately, there’s little out on the interwebs about this beyond references to a [...]
Oh dear. History appears to be repeating itself. Some years ago Sun bought the Clustra database product. I was a big fan, and had a great relationship with the company. The sale made sense, but Sun just didn’t know what it had bought, and buried it deep inside another product. I held out a bit of hope [...]
A list of freely available Classic texts - not least my personal favourites The Unix Time Sharing System, by Ritchie and Thompson and the awesome A Relational Model of Data for Large Shared Data Banks.
So there I am, with a mysql replication setup, with one box getting ready to take over from another as the live database server. Beforehand though we wanted to get it running replication, staying in sync, and also replicating to the new backup database server. So I needed a slave to replicate on, as a [...]
There are more Sun rumours circulating that they’re considering a move into the database market (the so-called “Sun DB”), but that this time “we are looking at PostgreSQL” (in the words of a senior VP). I’m still convinced^whopeful it’s Clustra, and that this PostgreSQL is nothing more than smoke and mirrors, not least that I’ve used [...]
You could have been forgiven for thinking that not much had happened at Sybase in the last few years, as they’ve seen their market share dwindle and dwindle in the face of opposition from Microsoft (with it’s sister (of sorts) product to ASE), IBM and Oracle. The low single digits are about the best Sybase [...]
I just received this in my e-mail, which whilst hardly major, is still quite a nice compliment: This is to inform you that the website leap.sourceforge.net has been designated a Cool Site in the Netscape Open Directory Computers/Software/Databases/Relational/Implementations/Quasi-relational It’s also just past the tenth anniversary of LEAP’s first hesitating release, in May 1995. I had a [...]
I get a number of queries and e-mails hitting the website on all manner of topics, one of the most common items being simple questions regarding management of transaction logs in Microsoft SQL Server 2000. I thought it might be useful therefore to put together a few posts on simple technology issues that might be [...]
The last few weeks have seen a number of very strange and very weird problems with a Microsoft SQL Server installation I support. Over the course of the weeks I’ve seen a number of very horrible errors, culminating last week with a SQL Assertion error (Error 3624), and repeated 17883 errors (Scheduler problems).
The performance tuning myth
A school of thought exists in many database and system administrators that performance tuning is the highest of arts, the greatest of skills, and the loftiest of aims. Buy any system and tune it well - so goes the theory - and it will perform to a level unanticipated by your peers. You will receive [...]