Order Now

CFUNITED Session: SQL Server 2005 for ColdFusion Developers

Presenter: Jeremy Kadlec

Reviewed by Sheila Handler, JDT Technologies, Ltd.

The expected release date for SQL Server 2005 is 11/7/2005.

Jeremy Kadlec was filling in for a presenter who could not make it, and giving his session for him. There were a lot of buzz words here, but eventually we got to some interesting information.

From a programmer's point of view, the most important news was this:

1. SQL Server 2005 is a new platform. Query Analyzer is going away and all access to SQL server is through the same front end, which is a form of Visual Studio. Express will come packaged with a weaker version of Visual Studio that is only usable for SQL server.
2. You can now program stored procedures, or anything, in other languages than Transact-SQL (c#, asp).
3. Transact-SQL is getting better; it finally has a TRY/CATCH!
4. You can send email directly from SQL server.
5. There is new data encryption at a column level.

There was a lot of other information, such as XML handling. But I'm unfamiliar with how SQL Server does it now, so it was all over my head.

From a DataBase Administrator's point of view, much has changed in the underlying structure of sql server. There's something called a service broker. So I learned a new phrase, but couldn't tell you exactly what it is or does.

I learned that MicroSoft no longer uses the term "Beta". Now it's "CTP" for Community Technology Preview. How many more syllables is that?

Add Comments

del.icio.us | digg | Spurl | Simpy | Newsvine | BlinkList | Furl | reddit | BlogMarks | Yahoo! My Web | Ma.gnolia | Technorati

• Subscribe
• RSS

• Editorial
• Specials
• Community
• News
• Tech and Tags
• Views
• Reviews
• Techniques
• Security
• Best of ColdFusion Talk
• Knowledge Base
• Blog Watch

• Tipical Charlie

Quarterly Update