For those of you interested in SQL Server 2005 (Express Edition will be a core component of SBS 2003 R2), there is a great podcast available at Michael J. Murphy’s blog. It’s a short (20 minute) interview with Bill Zack discussing SQL 2005, extended stored procedures, database mirroring and other enhancements.
I’m really excited about this becoming part of the core SBS 2003 product. If you’ve ever had to manage a database solely through OSQL, you’ll really appreciate the GUI components available for all SQL 2005 distributions (even the free SQL Server 2005 Express Edition which is the replacement for MSDE going forward).
(Before anyone asks, we don’t have an official stance on whether any of the SBS components will support database mirroring yet.)
Direct download for the IT Heroes: Stories from the Trenches mp3 file here.
You can get a free 180-day trial of SQL Server 2005 here.
(Edit – Express Edition is the core component. Workgroup Edition will only be available in Premium).