// services / mssql
Microsoft SQL Server (MSSQL)
We design, manage and integrate SQL Server databases — so your data is captured once and is correct everywhere.
// what we do
SQL Server services
From a new database built from scratch to cleaning up and integrating a database that has been running for years.
Database design
Tables, primary and foreign keys, relationships and indexes — designed properly from the start, so the data stays clean.
Queries and stored procedures
T-SQL queries, views, functions and stored procedures that do the work inside the database, fast and reliably.
Linking systems
Link tables and systems together: Access front ends, web applications, Excel, Power BI and other databases.
Migration
Move data from Access, Excel or MySQL to SQL Server — with checks that every record came across.
Speed and clean-up
Slow queries, missing indexes and duplicate data found and fixed.
Security and backup
Users and permissions, backup plans and restore tests, so your data is safe.
// a typical project
Three places, one truth
A business's data often lives in three places: an Access application at the office, Excel files on site and a bookkeeping package. Each place has its own version of the numbers.
We build a SQL Server database in the middle, connect the existing screens to it so people keep working the same way, and build reports that pull the numbers from all three together. The result: one version of the truth.
// in practice
Proven on major projects
Our databases carried the costs of major construction projects such as the Coega harbour and OR Tambo's second terminal — with monthly management reports and comparisons against the BOQ.
// faq
Frequently asked questions
Do you work with SQL Server Express?
Yes. The free Express edition is enough for many small and medium-sized businesses. We will tell you when you need a larger edition.
Can my Access application be linked to SQL Server?
Yes. The data moves to SQL Server, and your people keep working on the Access screens they know. This makes the system faster, safer and suitable for more users. See Access modernisation.
Can you fix my existing database without starting over?
Usually, yes. We first examine the structure and queries, then make targeted improvements — indexes, relationships, slow queries — without interrupting the system.
Does the database have to be in the cloud?
Not necessarily. SQL Server can run on a server at your office or in the cloud. We help you choose what best fits your business and budget.
// contact
Let's talk about your system
Tell us briefly what you need. The first conversation is free, and we usually reply within one working day.