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