May 2006 Blog Posts
Which SQL Sever 3rd Party tools do you use?
We've been using Red Gate's SQL Compare and SQL Data Compare for a few years now. I rarely use the data compare tool though, but not because it's not a great tool. We also use Quest's SQL LiteSpeed product. It reduced our backup files and backup times by 75%! The disk savings on our SAN was huge.
We are considering purchasing a few Idera products. I've recommended their SQLschedule product to a group here that manages over 250 jobs across 2 database servers.
If you aren't using any 3rd Party tools, is...
Yesterday, a developer sent me an e-mail indicating he was having problems creating a table in SQL Server Management Studio. He was using the GUI rather than the CREATE TABLE T-SQL statement. When he tried to save his changes, he encountered the following error:
Property DefaultSchema is not available for Database '[DatabasName]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (SQLEditors)
We add developers to the db_owner role in each of the development databases, so I didn't think that permissions was the issue. I did some googling and found this.
You'll encounter this...
If you are considering using SQL Server 2005 on a 64-bit platform, then I'd highly suggest reading Michael Otey 's “The Essential Guide to 64-BIT Server” article in SQL Server Magazine's May 2006 issue.
I received a free subscription by attending a SQL Server 2005 seminar last year. While your subscription is active, you get online access to all previous issues.