Ramblings of a DBA

Tara Kizer
posts - 165, comments - 832, trackbacks - 75

My Links

Advertisement

News

Subscribe
Search this Blog

Archives

Post Categories

Work

May 2006 Blog Posts

SQL Server 3rd Party Tools

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...

posted @ Thursday, May 25, 2006 4:53 PM | Feedback (5) | Filed Under [ SQL Server - General ]

Windows Group Access and SQL Server 2005 Management Studio

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...

posted @ Wednesday, May 24, 2006 4:31 PM | Feedback (0) | Filed Under [ SQL Server - Database Administration ]

64-bit server article in SQL Server Magazine

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. 

posted @ Friday, May 12, 2006 2:20 PM | Feedback (0) | Filed Under [ SQL Server - Database Administration ]

Powered by:
Powered By Subtext Powered By ASP.NET