With all the focus on SQL Server 2005 our team has been doing lately, I was very glad to find this web site. The team that builds the SQL Server engine has a blog of their own: SQL Server Engine Tips.One post in general got my attention – the team is requesting your feedback on … Continue reading Mirror, Mirror…
SQL Server 2005 Tidbit 017Number 17 Tidbit here…Wouldn’t you like to have the installable ‘books online’ for the next version of SQL, Microsoft SQL Server 2005, installed and available on your local workstation?“Absolutely!”Your wish is granted! You can download and install the Books Online from the SQL Server 2005 June CTP. Here is the link.And … Continue reading SQL Server 2005 Tidbit 017
One of the last times I posted something about Windows Vista my blog got lots and lots of hits. I also used the same animated graphic in that post. So… either Windows Vista is hot, or this picture is. Anyway… I’m working on a Windows Vista presentation. I have one hour to convince folks not only … Continue reading Vista? Microsoft Windows Vista? It’s cool. What else would you like to know?
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
Absolutely Full of I.T. 