Great point. Fortunately, in my specific case, I have a reporting environment that I keep regularly backed up. Backups are...

Gianluca Sartori (9/17/2009)

---

I coded a tool to track dependencies between code and database. It comes vey handy when you have your house keeping to do, but it's even more useful...

Ben Moorhouse (9/17/2009)

---

Apologies Jason - I meant that I knew we could log changes to objects and data. It's the ability to log select statements which would be incredibly helpful...

Ben Moorhouse (9/17/2009)

---

I'd love to see (and please let me know if it already exists!) a way to find out when a table was last selected from. We can set...

Nicole Bowman (8/19/2009)

---

As others have mentioned, moonlighting needs to be okayed with your current employer or it can be a sackable offence. It would not be appropriate particularly if it...

Robert Frasca (8/19/2009)

---

The good news is that I found a relatively vibrant job market. The bad news is that everyone wants a candidate to be an expert in every...

Seems odd, the notion of probation periods in new hires. All most all of the positions I've seen offered in the past few years have been contract to hire,...

Not sure what you're looking for...

But...

Name: ...

They are connecting in a number of ways, each fails.

I'm testing it using

"EXECUTE AS LOGIN = 'DOMAIN\UserX'

blah blah...

When a 'real' user tries SQL Management Studio, it fails with the same...

SELECT name ,size/128.0 AS Size, CAST(FILEPROPERTY(name, 'SpaceUsed') AS int)/128.0 AS InUse, size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS int)/128.0 AS AvailableSpaceInMB, CONVERT( dec(5, 2), 100.0 * ( size - CAST(FILEPROPERTY(name, 'SpaceUsed') AS...

It's not actually blocking itself. What you're witnessing is sp_who is reporting on waits for (I think) page IO Latches...

There's a page out there describing the differences in sp_who...

I understand the "taking it to extremes". In a...

The standard here is Steelcase's Leap Chair...

http://www.steelcase.com/na/leap_products.aspx?f=11852

IMHO, a very good chair. I'm particularly fond of the chair because the seat is adjustable in length/depth as well as...

jpowers (7/24/2009)

---

But haven't we learned from recent legal history that it is almost impossible to completely get rid of emails and other supposedly ephemeral transmissions? Somewhere, there will be some...

Similar to...