SQL 2008 Questions from Users Group

Thanks to everyone who attended the SQL Ireland Users group. We discussed some of the main new features in SQL 2008:

  • compression
  • encryption
  • business continuity
  • Resource Governor
  • Entity Data Model
  • Synchronisation Framework
  • DWH Improvements
  • Change Data Capture
  • New Data Type

Overall the favourite feature was probably filestream data type. This promises to allow us to work with huge unstructured data properly and allow us to retire all those monstrosity blob systems. written a few myself ;-)

I'll try and answer some questions raised:

Q) What about support for DTS?

A) SQL 2008 will support DTS much as SQL 2005 did with run time and design time support. See https://msdn2.microsoft.com/en-us/library/bb500440(SQL.100).aspx

Q) Can we use Change Data Capture or Database Encryption with Express Edition ?

A) No, both these are EE only features. See https://blogs.msdn.com/sqlexpress/archive/2007/11/19/what-s-new-in-sql-express-2008-november-ctp.aspx