With the release of SQL Server 2005, Microsoft has introduced the Express edition and the Workgroup edition to better meet the needs of each customer. The new line of SQL Server 2005 editions includes Express, Workgroup, Standard, and Enterprise Edition. The four new editions will offer a range of features including high availability, scalability, and business intelligence tools. The following table lists the various features in each edition:
| Β | Express | Workgroup | Standard | Enterprise |
|---|---|---|---|---|
| Number of CPUs | 1 | 2 | 4 | No Limit |
| RAM | 1 GB | 3 GB | No Limit | No Limit |
| Database Size | 4 GB | No Limit | No Limit | No Limit |
| Merge Replication | β | β | β | β |
| Transactional Replication | β | β | β | β |
| Report Server | β | β | β | β |
| Management Studio | Β | β | β | β |
| Report Builder | Β | β | β | β |
| Backup Log-shipping | Β | β | β | β |
| Full Text Search | Β | β | β | β |
| SQL Agent Job Scheduling | Β | β | β | β |
| Database Mirroring | Β | Β | β | β |
| Failover Clustering | Β | Β | β | β |
| Notification Services | Β | Β | β | β |
| Integration Services | Β | Β | β | β |
| Web Services (HTTP Endpoints) | Β | Β | β | β |
| Analysis Services | Β | Β | β | β |
| Data Mining | Β | Β | β | β |
| Database Tuning Advisor | Β | Β | β | β |
| Advanced Performance Tuning | Β | Β | Β | β |
Read more about SQL Server 2005 editions and featuresβ¦
Beekeeper Studio Is A Free & Open Source SQL Server GUI
Iβve upgraded from SQL Server and it was a smooth change β Beekeeper Studio enhanced my own workstream, offering a cleaner experience and better performance, as well as flexibility. - Aman Bhattarai
Beekeeper Studio is a fast, intuitive and easy to use SQL Server client. It supports loads of other databases too, and works great on Windows, Mac and Linux.
What SQL Server Users Say About Beekeeper Studio
So far the most comprehensive DB admin GUI out there. The only reason I havenβt given 5 stars is I cannot claim to have used it exhaustively only having discovered it two weeks ago. But so far, mySQL, MSSQL and Postgres in one tool is simply incredible.
Planning to purchase once pay day hits.
I had been using the free version of Beekeeper studio for a while, but when I needed to work with some MongoDB databases I upgraded to the paid version. And honestly, I was up and running in no time. Beekeeper is slick, fast, and it just works. Very intuitive, very easy to use. I work with MongoDB, Postgresql, SQL Server, and other databases in my job, and having one tool that can talk to them all is just wonderful.
Thank you, Matthew and team!