Thanks for all the replies, seems like a good cross section.

Has anyone found any bigger scale polls that address this issue - do you reckon MS and the...

Could be the autocomplete stuff? Find that dbname.. becomes quite painful if you have a few 1000 objects.

Aye, ta. Also worth knowing about the runas /netonly command, which will allow you to use your local ssms to connect and windows authenticate to servers on a different...

I'm asking because of the situation I find myself in, locked away behind firewalls, very little access.

Multiple domains that can't see each other, tools that can't connect up... etc. ...

How about joined aggregate values?

Also, you missed out the rather handy ability to use variables in the set.

eg

set @Variable = column = @variable + stuff

etc

Interesting, well done.

Very concerned about that stats time issue.

Have you tried looking at these with a server side trace? I'd be very curious to know whether that can have...

Wouldn't it be easier to have an admin server in your datacenter hooked up with Terminal Services and a copy of 2012 on it? You could then also use...

So, er, is that not fraud...?

:pinch:

Blast from the past eh?

While most of the article is quite sensible, and occasionally useful, I am somewhat concerned towards the end where it suddenly veers into general hacking advice... Surely the American...

Slight weakness for mount points rather than explicit drive letters though.

Yeah, its a pain in the nads.

Now got it locked off by our load balancing software.

A cheat, but it kind of works!

Any idea what the performance of these things is like?

Uh, hang on. So what you are saying is different parts of a datetime will represent different parts of the system?

Why not just create a composite key that does...

Nevermind - my ****up, different server entirely.