CFUNITED Session: SQL Server 2005 for ColdFusion Developers

 
Jul 01, 2005
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?
Privacy | FAQ | Site Map | About | Guidelines | Contact | Advertising | What is ColdFusion?
House of Fusion | ColdFusion Jobs | Blog of Fusion | AHP Hosting