Allow everybody to see metadata

Since SQL Server 2005, a user/DBA can see definition of only those objects that he has permission to. Earlier versions of SQL Server were much more liberal in that respect. If you prefer that type of behavior on you server, you can issue a following command:

grant view any definition to public

Now, everybody can investigate all objects in a current database.

This may be a way to allow developers to investigate a production database without giving them ability to change anything. (It is better to do this then to make them database owners.)

ShareThis

Microsoft SQL Server 2008 R2 Release Date

May 21

SQL Server on Amazon EC2

• Currently SQL Server 2005 Standard
• Default drives are slow. You will want to allocate additional SAN space for it.
• You can move SAN space from one server (instance) to another - for example to use it with bigger instance.
• Use Junk Drive (Amazon S3) to store backups.

Full SQL Server in Cloud

You are not limited to SQL Server Azure (limited/cloud version of SQL Server) if you are locking for hosting solution. Some companies offer full version of SQL Server:

• Amazon EC2

• VMWare vCloud

• TerreMark

Technorati Tags: SQL Server,Azure,SQL Server Azure,virtual server,hosted SQL Server

Intro

A little bit of everything… TSQL code, server configurations, ideas…