Tags:
General, Coldfusion, ColdFusion 9, Hibernate, Database, CFORM
I have been meaning to write this up for some time now, and haven't had the time to do so. One of the things that I found when learning CF-ORM for the first time, was it was very over whelming to say the least and a lot of questions would come from trying to use it.
Now 2 years down the track and I can say that there are times to use it and times not to use it, and it all boils down to whether you want the application to be scalable or you just don't care, because you know the amount of traffic will never get that high to matter.
Either way I want to touch on some things that I did discover, where I quickly changed my thinking as I went along.
Tags:
General, Coldfusion, ColdFusion 9, Database
In my previous blog on this I made it very simple where all the data was a duplicate, someone pinged me and asked well that is well and good. But what if there is duplicate records, with only partial duplicate records.
Tags:
General, Coldfusion, ColdFusion 9, Database
A little while ago I had read an interesting blog about deleting duplicate records by Kumar Shah, now he used CTE to do his magic or Common Table Expressions, but failed to understand or deliver the real magic. As you can see by the comments on his blog, others don't seem to fully understand this magic either.
The other thing to point out before I go into depth, I started using CTE's a lot more and the OVER PARTITION and have to say it is really a great thing that has been added to MS SQL 2005.
So why is so great?
Tags:
Ant, Version Control, SQL Compare, Coldfusion, Database
In a previous post I showed how I use Red-Gate SQL Compare from Red-Gate to create SQL Scripts from my database, and today I will now show how you can then run these in an Ant script to recreate your database.
Tags:
Version Control, General, SQL Compare, Database
Today I am going to explain how to use Red-Gate's Compare tool to compare a database with a folder, in which you can then use to store in your version control system.