Search:
Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in SQL Server Reporting Services (SSRS)

Interview Question :: What should I know as a SQL Server systems administrator

My background is in accounting and I am a CPA.

On Monday, the IT Department told my boss that they would prefer that I become the system administrator for our ERP system called Vision. Its a program used company-wide to process everything from Timesheets to Accounts Payable to Marketing Opportunities.

I have no training in IT. I do know how to run TSQL queries and have created some useful stored procedures for the database. I have also created some reports using SQL Reporting Services.

What type of training/certification do you recommend?

Answers to "What should I know as a SQL Server systems administrator"

RE: What should I know as a SQL Server systems administrator?
It depends on exactly what your role is going to be, you'll need to be sure what the IT department are actually handing you. If you're responsible for actually keeping the application up and running you're immediate focus wants to be on system health monitoring, performing backups and making sure you know how to recover from errors. For these you want to be looking for courses that lead you to the Microsoft Certified Technology Specialist (MCTS) in SQL Server. If on the other hand, the IT department are going to continue looking after the servers, and want you to handle the general administration of Vision, then you're more likely to need to know how to set up users, control permissions, and when to implement version upgrades etc. These I'd expect are going to be handled by Vision specific functions rather than SQL Server, so you'd need to be looking at training offered by the Vision suppliers.
Vote for this answer ::

RE: What should I know as a SQL Server systems administrator?
oracle certificate perl , bash , python shell scripting
Vote for this answer ::

Notify me whenever an answer is posted for this question Update Alert Setting

Top Tags

- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers

Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in SQL Server Reporting Services (SSRS)

Interview Question :: What should I know as a SQL Server systems administrator

Top Tags