SQL Server 2005 Mirroring – Client Redirection

I thought I had posted an article on this issue and have been saying so at my events, but no one has emailed me to tell me I haven’t!!!!!  Here’s what i thought I posted….sorry if anyone got frustrated looking for this (again i got this from the SQL 2005 Online books): To connect to…

0

Schema Separation in SQL Server 2005

I had some interesting discussion at my event in Elizabeth, NJ regarding how applications would work after the SQL2000 Server was upgraded to SQL Server 2005.  I had explained that applications would still work, based on the fact that the object owner name in SQL 2000 becomes the Schema Name in SQL Server 2005.  From…

0

Windows Server 2003 R2 Webcast Series

Windows Server 2003 R2 Webcast Series – Extend Connectivity and Control in Your Environment Did you know that there is a new version of Windows Server 2003 coming?  Did you know there are new features coming in Windows Server 2003 that will help you extend your connectivity and control your management costs?  Windows Server 2003…

0

SQL 2005 Index Size

Q:  In MS SQL 2000, there is a limitation of maximum length of index key to be 900 bytes. Would this limitation be revised to have it larger than 900 bytes in coming MS SQL 2005 release? A:  From the SQL 2005 CTP Books Online:  “SQL Server 2005 retains the 900-byte limit for the maximum…

0