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
The SBS Support team has launched their own blog, with the promise of doing a podcast in the near future, too.And here is their first post.Of course you might also want to subscribe to the “SBS Diva”.
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
Absolutely Full of I.T. 