Michael Meissner's challenge was to convince us that choosing SQL Server as database server is a right choice.
The challenge is simple. He summed up the different tools you have inside the SQL Server suite:
Next big thing about SQL Server is the high availability:
It wasn't very well explained .. But it' obvious ... SQL Server can offer much more than C/SIDE datbase.
All of this comes together in the SQL Server Management Studio. It is actually an "integrated management".
To sum up the scalability and performance:
Number of CPU
64 bit support
How does it run today:
Michael assured that they are constantly benchmarking. The results are compared and it seemed that SQL2005 is much better and more stable. My assumption is that this can only be the case after tuning the database.
He also assured us that they are working on taking advantage of new SQL Server functionality. That is very important, of course, but as some of us know, a lot can be improved towards the future... .
Michael recommended to upgrade/migrate to SQL Server to benefit the most out of it (see the above). If you're planning to do this, and you're coming to Directions, there is going to be a session about the steps that are needed for migrating to SQL Server. I reviewed the contents and commented on this session myself (will be presented by Mark Brummel) and it is going to be very interesting and complete, I promise you . Anyway, the migration process was presented here as a simple project , but my experience tells me there are quite many things to think about ... .
Small remark, in the new version of SQL Server (2008), there is going to be a new possibility to store performance monitoring data out-of-the-box. He didn't go deep into it, but it sounds great!
... I'll have to stop soon, because my battery is dead ...
I was hoping he would say something about the advantages of 64 bit, but nothing :(.
For me, there was nothing new in this session, unfortunately. It was more marketing fluff to recommend SQL Server (I could have known by looking at the title ...). Useful for customers, may be useful for partners, not useful for developers... .
That's what I call cross-selling. Anyway: Thanks for the interesting blog.