blogs.conchango.com

Friday’s community day was all geared towards collaboration. What I found fascinating was the ''speed dating''. Not real dating, mind. The format was the same, but the outcome was to encourage all the different disciplines that make up Conchango to get to know each other better. So I had 3 minutes apiece to talk to five or six people from the ...

According to InfoWorld, Bill Gates thinks that declarative modelling of business logic has not caught on because of "weak models". This is a surprise. E.F.Codd's earliest papers on the Relational Model described a relational calculus for the purpose of supporting declarative business logic. Even the SQL standards committee added ...

MERGE is a new DML statement in SQL Server 2008. Microsoft have implemented the ISO SQL 2003 and 2007 standard MERGE statement (as seen in Oracle and DB2) and added some extensions of their own. In a nutshell, MERGE allows you to perform simultaneous UPDATE, INSERT and/or DELETE operations on one table. There are new physical operators that ...

Following a few requests, here are some sites you may find useful for supporting your SQL learning: General http://www.stickyminds.com/  http://www.thefreecountry.com/documentation/onlinesql.shtml (free online tutorials) T-SQL http://sqlcourse.com/ (free online tutorial) http://www.w3schools.com/sql/default.asp (free online ...

If you are making changes to a linked object measure group after you have created the initial link, such as adding a new measure, you can come across the following error when you next deploy the solution. "Errors in the OLAP storage engine: The metadata for the statically linked measure group, with the name of XXX, cannot be verified against ...

On the off chance you haven't come across this one before: If you get the following error 'No mapping between account names and security IDs was done' when trying to deploy a cube project then check the membership of all the roles on your cube. Chances are one of the users listed has actually been removed from the Domain. Simply ...

According to Computerworld, Mike Stonebraker says "RDBMSes, are 'long in the tooth' and 'should be considered legacy technology'". Knowing Stonebraker's work and reputation that seemed like some pretty startling information! It was less of a surprise to find that Computerworld hadn't quite got it right ...

Today I was looking at a table with an apparantly empty column and discovered that the field is actually populated with blank spaces - Fortunately this field is of no interest to me and I noticed it purely by chance when I pasted an extract of the dat into excel and happened to notice the cell was unusually wide when I formatted the sheet. Anyway, ...

If you ever need to browse through a database, and dip in and out of tables to see what the data looks like, but you have very little data to go on, then you will be aware that simply running a select * against each table can be a time consuming and inefficient process. I am in this situation currently with a database that has no enforced ...

A colleague forwarded me this link today, which I thought would be beneficial to anyone who has to write a lot of SQL statements. The tool will automatically format the statements to 'beautify' them, so no more excuses for 'ugly' code! Check it out here James