>>Superusers can do Power Pivot in Excel.
>
>This is interesting. I'll check on that.
>
>But, is TSQL still in used or this has made its time? And, while at it, is that Power Pivot thing in Excel superceeds the old TSQL approach?

I don't know how does it work in every company. I know that in our company most of the people can always run queries directly in SSMS. For most of our clients we also have an easy access to SSMS (and I assume the users of these companies sometimes do as well). Finally, in our seminars we even have T-SQL classes offered.