Transactional DBA Vs Analysis DBA | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Transactional DBA Vs Analysis DBA

What are the differences between OLTP DBA and OLAP DBA in terms of:<br /><br />Area of skills require<br />Job responsibility<br />Using their current expertise into other<br /><br /><br />Whether they require distinct skill sets? If yes… as an OLTP DBA, where have to concentrate more to acquire OLAP knowledge?<br /><br />Thanks in advance for your valuable thoughts [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />/* SKChandra */
I don’t know about others, but I have to be both. The skill sets aren’t distinct or different, there is much overlap, and since Analysis Services is part of the SQL Server product range, OLAP skills I’d say are a subset of the DBA’s general skill set. Tom Pullen
DBA, Oxfam GB
I believe for OLAP you must be efficient and well versed with TSQL and for OLTP DBA it is not mandatory and TSQL knowledge would be sufficient. REfer to the OLAP Operatins guide for further information on internals of OLAP. I feel Tom and Raulie in this forum are OLAP gurus. If you are a beginner, and learning SQL Server, it is okay to play around with Enterprise Manager. But if you are responsible for real production systems, and want complete control over the stuff you are doing, T-SQL commands/scripting is the way to go. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.