Since you can no longer see any databases, can you grant permission to view/list individual databases? After denying "view all databases", I can't see any databases other than master and tempdb. Opening a new query, I can explicitly issues "USE [Hid...

Why wouldn't you use the Snipping Tool that ships within Windows? This way you can do screen capture from within the RDP session, outside the RDP session, or both....

I appreciate the acknowledgement that my points focus on real-world scenarios. But my questions were: I've often seen frequently accessed data stored on suboptimal storage (SATA drives instead of SAS, FC or SSD). Under your definitions, would this b...

This is solving a minor architecture issue by introducing a major security hole....

Datta, this mixture of access patterns and storage media capability is pretty artificial; almost to the point of uselessness. I've often seen frequently accessed data stored on suboptimal storage (SATA drives instead of SAS, FC or SSD). Under your d...

If you need trailing spaces, use DATALENGTH() instead of LEN()...

SQL Server doesn't support putting data or transaction log files on compressed drives or setting the Compressed attribute unless the Filegroup is marked as read-only. Have you tried restoring a database backup where the filegroups were marked readonly ...

I think that Windows 8 needs to decide what its going to be: a desktop OS or a tablet/touch OS. I did like it when Microsoft merged their consumer OS (Win 9x) with their "business" OS (Windows 2000). It just made sense. Microsoft is now chasin...

It's a study in extremes: Either use a completely modern (and somewhat obscure) "gesture"-based method to close an application (oh, where is File/Exit when you need it?) or a keyboard shortcut that goes all the way back to Windows 2.11. I'm *NOT* a ...

I don't believe you can copy-and-paste calculated columns in the manner you did it. You'll have to create the calculated column in the target PowerPivot by copy-and-pasting the DAX query, not the data....