SQL Server 2005 Tidbit 016(Warning: Old song reference)“You (up)load 16 tidbits… whaddya get?…”Credit for this one goes to my friend and teammate Matt Hester...Q: How do you resync in a peer to Peer replication?A: There is a restarable synch capability built into the replication engine,  There is a great Q/A log here:http://msdn.microsoft.com/SQL/2005/2005Webcasts/ReplicationQandA.aspxAlso you can view an … Continue reading SQL Server 2005 Tidbit 016

SQL Server 2005 Tidbit 015Fifteen.  It’s a one, followed by a 5.  15.  Credit for this one goes to my friend and teammate Matt Hester...Q: Can you rename the SQL 2005 SA account?A: Yes, as a matter of fact, you can!  With the new security model there are some great ways to really secure the SQL … Continue reading SQL Server 2005 Tidbit 015

SQL Server 2005 Tidbit 014Number 14Credit for this one goes to my friend and teammate Matt Hester...Q:  What if I do no want to give SQL 2005 Management Studio to my Developers how to I give them access to the databases?A:  Matt was talking with some of his event attendees, and they recommend that you … Continue reading SQL Server 2005 Tidbit 014

SQL Server 2005 Tidbit 013Unlucky 13!Credit for this one goes to my friend and teammate Matt Hester...  Q: How do I upgrade SQL 2005 beta to the Full SQL 2005?A:  There will not be a setup-based upgrade from preRTM to RTM. You will need to un install the preRTM and then install RTM. The un install … Continue reading SQL Server 2005 Tidbit 013

SQL Server 2005 Tidbit 012An even dozen Tidbits.Credit for this one goes to my friend and teammate Matt Hester... Q: In Mirroring with automatic failover, how do the SQL Client applications fail over when the mirror fails?A: It really depends on the client application and how it was written.  Client applications written using ADO.NET 2.0 will automatically … Continue reading SQL Server 2005 Tidbit 012

SQL Server 2005 Tidbit 011SQL Tidbits Galore!Credit for this one goes to my friend and teammate Matt Hester...Q: Can I put Visual Source Safe components into SQL 2005?A: Yes.  If you have installed the Microsoft Visual SourceSafe 6.0 client components on your machine, SQL Server 2005 Management Studio will automatically detect that the VSS plug-in … Continue reading SQL Server 2005 Tidbit 011

SQL Server 2005 Tidbit 010Number Ten!  Credit for this one goes to my friend and teammate Matt Hester...Q: How does SQL 2005 handle online databases during the upgrade, what about the applications that are in use?A: This questions was very interesting to me so I did some checking.  The best bet to see how this … Continue reading SQL Server 2005 Tidbit 010

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