A little premature as it’s not releasing until Q1 2005 but the latest SQL Server offering from MS looks like it will have some real gems in it and offers some signicant reasons for upgrading.
The whole licensing surrounding MSDE (the developers edition) and whether it can be used as production Db server for small scale web sites, limited connection count and poor management has been replaced by SQL Server 2005 Express, which will come with proper user config tools and only minor restrictions; single processor only, 1GB RAM restricted and a single Db restriction of 4Gb is now licensed by MS for running on a live webserver- putting it directly up against MySQL.
The full version of SQL 2005 has some new fault tolerant features which enterprises will take interest in. You can now ‘mirror’ databases to a second well connected (LAN, ADSL etc) SQL 2005 server. One server will be defined as a live server which would pass executed transactions to the other SQL servers - much more efficient than traditional replication methods and doesn’t require expensive hardware. A third server can be introduced as a ‘witness’ server to resolve conflicts as and when they occur.
Something else which I like the sound of is the ability to turn a stored procedure into a webservice - enterprises will like this as it will allow them to move the responsbility of the webservice to the Db admin away from the web developer.
You can read more about SQL 2005 here as well as download a prerelease version of the product.
December 16th, 2005 at 10:23 am
john, good mornin’
have you been able to make cfmx 7 connect to the mirrored sql servers and elegantly handle a switchover between the boxes?
since they do not share name or ip address, how would coldfusion handle this like .NET does with the Failover parameter that you can specify in teh connection string…
the connection string was deprecated in cfmx 7, right?
thanks for any pointers.
December 16th, 2005 at 3:04 pm
I’ve not tried cfmx7 with mirrored servers just yet. At work we have clustered SQL servers so the cfmx boxes do talk to the shared IP address (i’m not a DBA remember :)) and effectively failover. I need to do some more experimenting although if you do want to be able to use connection strings then BlueDragon.NET does support them