In SSMS I'd like the delete and refresh buttons to not be right next to eachother. I'd like a confirmation in ssms before a db or table can be...

Can you isolate the database on a different machine and treat it like a machine on the other size of the dmz?

The only bad thing I can think of is how easy it is to run a query against all of the servers at the same time. But you should...

Here you go.

http://www.sqlskills.com/blogs/paul/missing-index-dmvs-bug-that-could-cost-your-sanity/[/url]

Just as with the performance tuning wizard you should take the recommended indexes as a suggestion, not as a rule. You still need to verify that the...

So far you have a couple options.

Snapshot Replication

Restore backup

Script out the objects

Export Data Teir Application

VMWare software is excellent, but I haven't found virtualization software easier to get up and running on a dev desktop faster than Oracle's VirtualBox.

They all have their use cases,...

Snapshot replication is great for this, but is there a reason why you couldn't just automate a restore of the database backups. That way you can also verify the...

Are there going to be any other machines running on the host? How critical is this vm? The way to guarantee resources in VMWare is with reservations. ...

I wouldn't throw the metric out entirely, but rather use it and others with a knowledge of the workload and your environment, to determine if you have a problem.

A sabbatical with guidelines, tasks and a requirement of a yield (no matter how soft the requirement and openly defined) is kind of losing the meaning of the word.

I won't disagree with that at all, depending on the task some localized tasks are way easier with a gui.

Just pointing out that RDP isn't a necessity, it...

I don't think RDP access is necessary, but it helps. Almost everything you need RDP for you can do with SSMS or Powershell.

Do you have access to powershell?

http://www.powershellmagazine.com/2013/04/24/pstip-enumerate-all-sql-server-instances-in-a-network/[/url]

[Microsoft.SqlServer.Management.Smo.SmoApplication]::EnumAvailableSqlServers($false)

Or you could check the services like so:

get-service -computername NAME

I have a feeling you have huge async network io waits during this.

Unfortunately Access can be terrible for accessing data from SQL Server. Here's a thread with...

😉