SQL Server 2005 Tidbit 009Ooops.. missed a day.  Well.. let’s get back into these!I got this from my coworker and friend, Matt Hester...Q: Can you upgrade Small Business Server SQL 2000 to SQL 2005?A:  The feedback I have gotten is that technically you can upgrade to SQL 2005 but it is not supported!.  However, Windows … Continue reading SQL Server 2005 Tidbit 009

SQL Server 2005 Tidbit 008Tidbit #8This tidbit comes as a result of a question an attendee from one one of our live TechNet Events emailed me." —“Database mirroring, or parts of it, is available in Standard Edition of Yukon.  What's the difference between what you get with Enterprise Edition and Standard Edition?”Mirroring is supported in both … Continue reading SQL Server 2005 Tidbit 008

SQL Server 2005 Tidbit 007Number 7 comin’ atcha!This tidbit comes as a result of a question an attendee from one one of our live TechNet Events emailed me."Can backups, etc, generated from a maintenance plan in Yukon have the same file name instead of a unique name?”I can't find any information on this specifically, although … Continue reading SQL Server 2005 Tidbit 007

SQL Server 2005 Tidbit 006SQL Server 2005 Tidbit 6...This tidbit comes as a result of a question an attendee from one one of our live TechNet Events emailed me.—"Will linked servers work between different versions of SQL Server?  i.e. SQL Server 2000 and Yukon and vice versa.”Yes.—Got an IT question?  Give me a comment, or … Continue reading SQL Server 2005 Tidbit 006

SQL Server 2005 Tidbit 005SQL Server 2005 Tidbit number FIVE..This tidbit comes as a result of a question an attendee from one one of our live TechNet Events emailed me.—"Can 2005 Express be part of the multiserver environment?  In SQL Server 2000, target servers running MSDE cannot be enlisted.”According to the SQL Server 2005 Express … Continue reading SQL Server 2005 Tidbit 005

SQL Server 2005 Tidbit 004Another one!  Number four…This tidbit comes as a result of a question an attendee from one of our live TechNet Events emailed me."We have a multiserver environment with one master server and twenty-four instances of SQL Server as target servers.  Will multiserver work in a multi-versioned environment?  In other words, if … Continue reading SQL Server 2005 Tidbit 004

SQL Server 2005 Tidbit 003Tidbit time!  Number 3…This tidbit comes as a result of a question an attendee from one of our live TechNet Events emailed me."Can SQL Server 7.0 be upgraded directly to Yukon?  Or does 7.0 need to be upgraded to SQL Server 2000 first?  And what are my options with MSDE 7.0?”No, … Continue reading SQL Server 2005 Tidbit 003

SQL Server 2005 Tidbit 002Ready for another tidbit?This tidbit comes as a result of a question an attendee from one of our live TechNet Events emailed me."Are online restore and online index only available in Enterprise Edition?  Do you have a document that lists which features are available in each edition?”  Online Restore and Online … Continue reading SQL Server 2005 Tidbit 002

SQL Server 2005 Tidbit 001Hello all you DBAs!Yes, this is the first of what promises to be over 100 tidbits of information on the new version of SQL Server (formerly codename: Yukon) coming out the first week of November, 2005.  Some of these tidbits (like today’s) will point to cool resources found online.  Others will … Continue reading SQL Server 2005 Tidbit 001