Timesheet Program

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?

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.


Microsoft Office Small Business Accounting 2006 [Old Version]


Microsoft Office Small Business Accounting 2006 [Old Version]


$49.99


Microsoft Small Business Accounting 2006 is a comprehensive financial management program designed for companies with up to 25 employees. It allows small business owners and office managers to manage their business financials using software that is easy to set up and has the familiar look and feel of Microsoft Office 2003. With Small Business Accounting 2006, companies with employees already famili…

Quickbooks POS: Pro Multistore 6.0


Quickbooks POS: Pro Multistore 6.0


$1,399.95


QB POS 6.0 PRO MULTISTORE RETAIL MNGMT SOFTWARE. Has all the features in Basic, plus the ability to manage up to ten stores from a single office….

TimeSheet downloadable Software


TimeSheet downloadable Software



TimeSheet provides a quick and easy way to enter time associated with a task or a client. Allows for breaks and tallies daily and weekly. Great little utility, indispensible for anyone who charges by the hour!…


Microsoft Project 98 Bible


Microsoft Project 98 Bible


$4.95


Project management software can be very complex, theoretical, and difficult to manage, but Microsoft Project 98 is probably the easiest software tool to use among the choices. IDG’s Microsoft Project 98 Bible is a systematic and comprehensive guide to the software, introducing the reader to using the software and digging in to get to the heart of the program’s potential. The book doesn’t spe…

Enterprise Java Programming with IBM WebSphere


Enterprise Java Programming with IBM WebSphere


$4.97


WebSphere is at the heart of IBM’s web strategy: a global Internet software platform that can support any e-business, from startup to megasite. IBM is investing $1 billion to build a WebSphere community that will be 5,000,000 developers strong. Now, there’s a comprehensive WebSphere programmer’s reference: a hands-on, solutions-focused exploration of every key element of WebSphere server-side prog…


Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!