Since receiving a high blood pressure warning from my doctor 2 years ago, I have tracked every step I take during the day, every bit of food (with rare exception)...

Alrighty then, consider it taken...

It this hasn't been claimed yet, I'd like to take it. I'm working quite a bit with Powershell and formatted output right now, this would fit nicely...

Depends on the role I'm playing.

To function purely as a DBA, I don't need anything more than SSMS. In fact, for years I thumbed my nose at any third-party tools,...

TravisDBA (1/19/2012)

---

How many db servers are you reponsible for? That sounds like a slow-paced static shop that doesn't have alot of changes occuring, either in the hardware environment or in...

Marios Philippopoulos (1/18/2012)

---

I have been following this discussion and get the feeling some of you are on call "all the time"?!

How is that possible without ending up in a burnout?...

Rather than scramble to keep up with all of the new, sometimes obscure, features that new versions of SQL Server bring, I've worked to position my self as the guy...

I've actually used INTERSECT and EXCEPT quite a bit, not as a replacement for inner joins as some of these comments imply, but to simplify the comparison of two complex...

To connect to it from within Query Analyzer, have a look at OPENROWSET. If this will be a permanent need, also look into using a linked server.

Is the domain account that SQL is using in the same domain as the logins that are attempting to connect to it?

Very easy to do...

CREATE TABLE #temp (

vchFileName VARCHAR(255)

)

INSERT INTO #temp

EXEC master..xp_cmdshell 'DIR /B C:\WINDOWS'

SELECT * FROM #temp

Model railroading!