Which Package To Buy?
Posted on 2011-10-24
As you read this, please keep your cringe reflexes to a minimum. :)
I'm not a DBA, although I am an application developer that have had several years of experience in working with SQL Server.
The company I am currently with has an installation of SQL Server that came with an accounting/business (CRM) package. I've been using it to write reports based on the data within. The bosses have been adequately impressed to the point where they want to expand the data capabilities beyond what the accounting package allows. To that end, they want to buy a SQL Server Package license, since what they currently have is, technically, only to be used with the package noted above (even though I can create new databases).
So, since I'm not a DBA, I'll be pretty much faking it (ala "SQL Server For Dummies"). But I need to know which package I will need. There are so many different options, I'm not sure if what I'm thinking, is the correct option.
What I'm thinking about is sold by CRW as "Microsoft SQL Server 2008 R2 Standard - complete package (~$2500.00)". It is described as "Complete package - 1 server, 10 CALs - DVD - Win - English - 32/64-bit"
Where I have a question is the 10 CALs. I will be the only one creating/modifying the databases (and the tables within), all others will only view/add/modify/delete data. So, are the 10 CALs for just the developers (me and potentially a future staff) and the users are clear to use, or do the 10 CALs mean that only 10 people can have user "Logins"?
So I guess, ultimately, what are your suggestions (be nice), and why you suggest what you do.