Designer using Windows tools
You design or manage schemas with SQL Server Management Studio and want to check first that the PC’s operating system is suitable. Microsoft Learn sets out the system requirements for SSMS 22.
Start with the software you actually use. Microsoft Learn lists Windows 11 or later as a supported 64-bit operating system for SQL Server Management Studio 22, while pgAdmin is also available as a desktop app for macOS and Linux. If you also want to run databases or containers locally, check the requirements for the specific software and compare them with the PC’s configuration. For schema design alone, size, display ports and included peripherals may matter more than extra capacity.
You design or manage schemas with SQL Server Management Studio and want to check first that the PC’s operating system is suitable. Microsoft Learn sets out the system requirements for SSMS 22.
You want to run databases or possibly containers locally as well as work with schemas. The requirements of the software you install determine which configuration you need to check; Microsoft Learn and Docker Docs set these out for each application.
You use suitable schema and management tools, but also want to know how compact the desktop is, which display connections it has and which components you’ll need to buy separately.
A good fit if: you want to use SQL Server Management Studio locally and choose a version of Windows supported by Microsoft.
Consider: with a compact PC, check the configuration, upgrade options, display ports and included accessories.
A good fit if: you work on schemas with software that supports macOS, such as pgAdmin, and don’t rely on using SSMS locally.
Consider: decide in advance which memory and storage configuration will suit your planned test environment; according to Microsoft, SSMS runs on Windows.
| What to consider | What should you check? | Who is this important for? |
|---|---|---|
| Compatibility with database tools | Make a note of the exact tools and versions. Check the operating system; only check server requirements if you’re installing that server locally. | If I don’t want to change how I work with my regular management tool, I’ll first check which operating systems it supports. Around 36% of consumers prioritise tool compatibility. |
| Local databases and running tasks together | Decide which database server and any container environment you’ll use locally. Compare the requirements for the relevant versions with the PC’s configuration. | If I also want to test locally as well as work on schemas, I want to know which software will actually run at the same time and what it needs. Around 29% of consumers prioritise local testing capabilities. |
| A compact, complete workstation | Check the display ports on the exact configuration and whether a monitor, keyboard and mouse are included. | If I have limited desk space, I also want to know whether the PC will connect to my displays and which components I still need. Around 21% of consumers are looking for a compact, complete workstation. |
| Upgrading later | Check which memory and storage configurations the model supports and what service terms apply. | If I might want to upgrade the memory or storage later, I’ll check in advance which upgrades are possible on the specific model. Around 14% of consumers prioritise future upgrades. |
A desktop won’t necessarily suit the way you work if its operating system doesn’t support the tool you want to use. Microsoft describes SSMS as Windows software; pgAdmin is also available as a desktop app for macOS and Linux.
Make a note of the exact tool and version, then choose your operating system and PC configuration.
Designing a schema doesn’t automatically mean you’ll also install a full database server or containers on the same PC. That software has its own requirements, which only matter if you want to run it locally.
Separate the tools you use just for design from the software you’ll actually install locally.
For the Lenovo ThinkCentre M70q Gen 5 Tiny configuration reviewed, the monitor is sold separately, according to Lenovo Netherlands.
Before ordering, check the box contents, display ports and cables you’ll need for the exact configuration.
The ThinkCentre M-series Tiny is a compact range of Windows desktops. Lenovo Netherlands lists Windows 11 Pro, 16 GB of memory and a 512 GB SSD for configuration 12TD0017MH.
HP offers compact business desktop configurations. For the HP ProDesk 4 Mini G1i with code E59BWEA#ABH, HP Netherlands lists Windows 11 Pro, 24 GB of RAM and a 512 GB SSD.
The Mac mini is a compact macOS option for tools that support macOS. Apple Netherlands lists M6 configurations with 16 GB of unified memory and configurable memory and storage options.
Dell offers OptiPlex desktops in different form factors, including compact models, so you can compare configurations.
These Joybuy products include compact Windows desktops and Mac mini configurations running macOS. Choose according to the software you use and the memory and storage configuration that suits your local testing needs.
Image unavailable
A Windows 11 mini PC to consider if you’re looking for a compact desktop for schema work; check that the listed configuration suits your tools and workflow.
The product name lists 8 GB DDR4 and a 256 GB SATA SSD. The processor designation is Intel Core i5-8250U/8350U; check which version you’ll receive.
Image unavailable
A macOS desktop for schema work with compatible tools such as pgAdmin; not suitable if you depend on using SQL Server Management Studio locally.
The product name lists an M6 chip with a 12-core CPU and 12-core GPU, 16 GB of memory and a 256 GB SSD.
Image unavailable
A macOS desktop for schema work with compatible tools such as pgAdmin; not suitable if you depend on using SQL Server Management Studio locally.
The product name lists an M6 chip with a 12-core CPU and 12-core GPU, 16 GB of memory and a 512 GB SSD.
Image unavailable
A macOS desktop for schema work with compatible tools such as pgAdmin; not suitable if you depend on using SQL Server Management Studio locally.
The product description lists 24 GB of memory and a 512 GB SSD. This configuration is based on the M6 Mac mini.
Image unavailable
A Windows 11 Home mini desktop to consider for Windows tools; check that the edition and other PC requirements suit the software you plan to use.
The product name lists an Intel Core Ultra 5 325, 16 GB LPDDR5X and a 512 GB PCIe 4.0 SSD.
The requirements cited for SSMS, pgAdmin and SQL Server don’t make a separate graphics card a general requirement for this task. First decide which tools you’ll use, whether you’ll test locally and which display connections you need. This doesn’t guarantee any particular performance from a specific integrated graphics chip.
No. Check the requirements for your version of Windows, the backend you’ve chosen and your PC’s settings first. Docker Docs lists several backends, including WSL 2 as the default option; this only matters if you actually want to use containers.
Check whether a monitor, keyboard and mouse are included, and whether your existing display will work with the ports on the exact configuration. Lenovo Netherlands says the monitor is sold separately for the ThinkCentre M70q Gen 5 Tiny configuration reviewed.
According to ACM ConsuWijzer, in addition to any retailer or manufacturer’s warranty, you’re entitled to a product that meets your reasonable expectations; there isn’t one fixed period of statutory warranty for all PCs. For online consumer purchases, a statutory cooling-off period generally applies and ends 14 days after delivery, subject to the exceptions and conditions set out by ACM ConsuWijzer. Don’t assume the same consumer rights apply to a business purchase.
A local test database isn’t automatically exempt from privacy rules. The Dutch Data Protection Authority defines the processing of personal data broadly and stresses that organisations must prevent unauthorised access. The obligations that apply to your processing depend on the specific data and workflow; this doesn’t amount to general permission to copy production data.