Future DBA Wanna Be....Should I learn C#?

already know T-SQL if you're going to specialize in ms sql server?

And I thought I knew sql but have been reading up and found alot of complicated features I didn't know. plus do you know the m$ extensions? and despite claiming you want to be ms sql dba, you are likely to encounter db2 and oracle, even if just extracting data from them for DW.

Nowadays, the OLTP system is usually canned so minimal dba use there but the dw may need a dba. of course some co's want pgmr / dba to create quick apps to support the biz so still needed. learn all you can about struc of dw and datamarts, perhaps prods like ssis, ssrs, ssas.. or bo as you would be doing dba like stuff for those jobs setting up views or universes.

help that much either. If I was you I'd look at another DBMS, MySQl, PostGreSQl, even Oracle. The implementation differences are very instructive.

but that mostly depends on what you want to use it for.
The CLR makes it handy for creating custom functions but you need to careful that you don't end up overloading things.
I'd recommend mastering T-SQL before getting into C# too much.

No, c# will not help your job performance as a DBA.
Learn all you can about SQL Server configuration, T-SQL, and dig deep!

DBA roles are limited. A lot of the positions out there are looking for someone who also has other skills. SQL Server is not easy, but easier and less complex (from management's perspective) than Oracle. I don't want to start a flame war or anything, I work in both environments, but that is the perception. I think SQL Server has come a long way to making up the difference.

If you are handling SQL Server, you are also potentially handling either, another database, or if its a MS shop, then you are working with Sharepoint and anything else that has a database backend. In many cases, in smaller shops, you're also handling the server or programming for the web site which is often in ASP.NEt.

To decide on where to go and with what, I'd recommend that you search dice for jobs with SQL server in them. See what most other people are including in the requirements. I see a lot with the .Net framework because of the SSIS packages.

OLAP is also popular. To be a good dba, you'll need to know as much as possible about the root database and be familiar with the different types of schemas (start, relational, etc) that are commonly used in SQL Server. Another thing to consider is XML. There is a lot of transfer of data via web services now adays. That means either a csv file or xml. Most often its xml.

Good luck.