Cloud databases
1. Simpification of creating and editing cloud databases
- We give advice and assist you in creating cloud SQL databases.
- We will help and advise you on paying as little as possible. Microsoft are trying to push businesses to use more expensive databases like Dataverse.
- Azure SQL can mount up costs, so we advise using other platforms. That is unless you would like to keep or build everything in Microsoft Azure
2. "Simple SQL Editor & Reports - Excel Add-in"
- Our 'Simple SQL Editor & Reports' Excel Add-in is a low cost tool that allows you to interact with SQL database data.
- Connect to your SQL database(s) in one click.
- Edit SQL data directly in Excel and save the changes directly to SQL.
- Data is automatically saved into a folder to reverse changes.
- Over a million rows of SQL can be edited at once.
- Use familiar Excel data types rather than having to understand the more complex ones.
- Data validation is done before editing data or adding it to your database.
- Use database tables to filter data and save these filers to re-use in the built in reports.
- You can see more on our 'Simple SQL Editor' in the videos below.
3. Simple SQL Table Creator - Excel Add-in
- Create SQL tables very easily in Excel
- Use familiar Excel data types to create SQL table columns.
- Delete columns from existing SQL tables
- Add columns to SQL tables
- Edit the data types of SQL columns
