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.

Dig Deeper on Database software management

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.