VSTSDBE RC0 Post 2

November 3, 2008 at 4:01 pm (nHibernate, Tools) (, , )

There is no joy in Mudville.

The install of RC0 went smoothly. I was able to create a new server project and deploy it. I was able to reverse engineer AdventureWorks into a new project and deploy that. When I went to create a new compound project, combining the output from the two… deployment failed. I got an arcane error about something in the Microsoft.Data.Schema.SchemaModel.ModelSerializationException erroring out. Useful. So, at this point, the functionality I had in my demo for the PASS Summit isn’t working. Yikes. I’ve got two weeks… no pressure…

I posted a note about it over at the MSDN discussion site. If you have a solution, swing by and drop it off.

Permalink Leave a Comment

Great Article on DBA-Developer Conflict

November 3, 2008 at 10:12 am (nHibernate, Object Relational Mapping, TSQL) ()

What a great way to phrase the issue. I love the concept of the people-people impedence mismatch. We’re going through it pretty regularly where I work. Our developers are convinced that using an ORM tool, in this case nHibernate, they’re eliminating all the problems with the database because they’re taking complete control of the database through nHibernate. All code will be on their side of the fence, no more messy stored procedures. All data structures will look like their objects, no more having to figure out those silly JOINS. Best of all, by setting all this up, no more messing with those stupid and obnoxious DBA’s.

Unfortunately, they’re still planning on object persistance (don’t call it data storage) inside of a SQL Server database… Um, guys, you haven’t eliminated a single problem. You’re storing your data in a less efficient manner and you’re using lowest common demoninator TSQL to access it… Performance is going to be a BIG issue. Scalability will also be a serious problem. All the problems that have been encountered are still there plus new ones. They seriously believe that not worrying about the idea of set based operations will just make the issues around data sets go away.

I understand why they want to do what they’re doing. I support the concept. Making development more efficient is a good and worthy goal. My problem isn’t with developers or their needs. It is hard to learn two different languages, TSQL & C# or VB, and understanding set based operations is a pain the bottom. I really don’t have any issues with the business and its needs. We need to create more flexible applications, faster to respond to changing business requirements. My problem is with this concept that by ignoring the database functionality it will suddenly, somehow, function better… It’s nuts.

Permalink 4 Comments