Q
Problem solve Get help with specific problems with your technologies, process and projects.

What are the best SMB databases?

Discover the best basic SMB database -- and learn when it's time for your SMB clients to upgrade.

What are the best SMB databases?

SMBs should consider using SQL Server Express as much as possible because it's free and has many of the same features as the other editions of SQL Server. However, as your client's trusted partner, you should be aware of the limitations of SQL Server Express.

If the needs of an SMB database exceed the limitations of SQL Server Express, the client should consider some of the other editions of SQL Server. The official Microsoft site linked above provides a list of limitations and features of the other editions of SQL Server.

Clients with a large number of users must purchase a per processor license for SQL Server, which can be more expensive than the hardware they are using. In general, I recommend that SMBs use database servers that will allow them to grow into and will provide optimal service for the lifetime of the applications using SQL Server. I normally recommend the 64-bit Enterprise Edition of SQL Server because its feature set scales to meet growing needs.

This was last published in December 2007

Dig Deeper on Database Management Products and Solutions

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

MicroscopeUK

SearchCloudProvider

SearchSecurity

SearchStorage

SearchNetworking

SearchCloudComputing

SearchDataManagement

SearchBusinessAnalytics

Close