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
“OOoo!” We’ve extended support for Software Update Services 1.0.Originally the drop-dead end of support was going to be at the end of June next year, but due to the timing and customer needs, the date has moved to December 6. In fact, as of a couple days ago, you could no longer download SUS.“My brain … Continue reading SUS 1.0 Support Extended
Greetings! Here is the promised “Best of” Q&A from the webcast I delivered yesterday (Aug 24, 2005) on Windows Server 2003 System Administration (Part 2 of 2). A huge THANK YOU to Harold Wong and Kelley DuBois for handling the Q&A. They get most of the credit for these awesome answers. Cheers!-Kevin—“The website for MBSA … Continue reading Q&A from the “Windows Server 2003 Administration Webcast (Part 2 of 2)”
Absolutely Full of I.T. 