Database
There are 10 entries for the tag
Database
We’ve used dbdeploy.net on a number of projects and have found it to be a useful tool, especially around CI environments. We recently started a Windows Azure project that uses SQL Server and discovered that DbDeploy.Net didn’t work. There have been a few nagging issues with DbDeploy.Net as well, like the lack of support for recursive script directories, and when we looked into the code base, we discovered that it’s not really written to modern software development standards, and that getting it there...
He who fails to plan, plans to fail. – unknown In many ways, one of the most dreaded tasks of every iteration is the Sprint Planning Meeting. This meeting is a very important meeting, but many, many things can go wrong and make this meeting a very long and very painful experience. However, this meeting is critical to the success of the team. If the team doesn’t know what they’re doing at the beginning of the iteration, how can they commit to getting the work done? To hopefully help ease the pain...
I promised I’d have a simpler mechanism for rebuilding the database. Below is a complete MSBuild targets file for rebuilding the database from scratch. I don’t know if I’ve explained the rational for this. The reason why you’d WANT to do this is so that each developer has a clean version of the database on their local machine. This also includes the continuous integration environment. Basically, you can do whatever you want to the database without fear, and in a minute or two, have a completely rebuilt...
In part 1, I showed a complicated mechanism for performing a clean database build. There’s an easier way. The easier way is to use the msbuild extension tasks out on codeplex. While you’ll still need to forcibly take the database offline (ALTER DATABASE [mydb] SET OFFLINE WITH ROLLBACK IMMEDIATE), the other msbuild tasks more easily allow you to create and delete the database. Eventually, I’ll post an example. Technorati Tags: MSBuild...
So I’m taking a break from writing about other Agile stuff for a post. :) I’m still going to get back to the other subjects, but this is fun too. Something I’ve done quite a bit of is MSBuild and CI work. I’m experimenting with ways to improve what I’ve done in the past, particularly around database CI. Today, I developed a mechanism for starting from scratch with your database. By scratch, I mean blowing away the existing database and creating it again from a single command line call. I’m a firm...
I’m going to write my history with Agile here. That way, in future posts, I can refer back to it, instead of typing it out in the post that contains information you may actually want to read. Note that I’m actually a pretty senior developer, and do lots of technical interviews. I’m an Agile fan because of the difference it makes in peoples lives and the improvement in quality it brings, and I’ll sacrifice my technological advance to help teams. Management History I started management pretty early...
Well, we've gone and done it. We're no longer using Nettiers. It was good while we were, but the overhead of it eventually became way too much, and since we were doing mostly generic CRUD operations, it no longer made sense. Instead, we're going to write a custom DAL. Here's why: We're working with a LARGE database with some pretty complex data structures, which required quite a bit of customization of Nettiers to make it understand the structures. The knowntypes enumeration in WCF was killing us....
We're writing an app for a client and we're using WCF and Nettiers together in the app. One of the requirements of app is very good auditing. Every time data is picked up in the system, we need to audit it and let people know what happened. We wanted this to be transparent to the users, which meant that it should probably go into the DAL somewhere. We thought about Triggers (no user information, so you'd have to pass the user to everything), and finally settled on putting it in the save, update,...
Call me an anti-java, oracle biggot, but these technologies are driving me crazy. First, Oracle's licensing plans are EXPENSIVE and COMPLEX. As updated January 11th, they now consider different hardware platforms cores to rate at different levels. For example, AMD/Intel cores are rated at .50 of a processor. Have a four core chip? You need two oracle processor licenses, and depending on the version of db you get, that means big bucks ($40,000 per processor for the enterprise version, YIKES!). DB2...
We decided that we had to have a US image map out on our web page. In searching for maps, I found a lot of the same type of map on people's web pages, but no source of where the map came from. It appears that many people are just “borrowing” the same map from each other's websites, which is fundamentally sick and wrong. We found a resource that we really like: www.mapresources.com. At first, we purchased their North American Continent map--oops no Hawaii, so we ended up purchasing just...