Microsoft SQL Server
Cloud Street develop software applications in Microsoft SQL Server when a solution needs to cope with significant complexity, larger data volumes, increased performance or wider scope for adaptability. MS SQL Server development also allows for the addition of online functionality now, or in future project phases. (Smaller scale projects may be more suited to Microsoft Access.)
We work with clients to develop tailor-made applications, specifically to meet the requirements of their business. We don’t have an off-the-shelf, standard package, but our extensive experience does mean that we come with good ideas for common needs or problems. We adapt and integrate these with build-from-scratch approaches for more specific requirements, to come out with a custom solution each time.
Typical uses for Microsoft SQL Server databases include:
- Relationship management for customers, funders, suppliers or participants, who may interact with multiple people inside the organisation
- Planning and scheduling of orders, jobs, tasks or meetings, which may include task assignment or organisation across several team members
- Managing catalogues of products, services, specifications and prices, which might also need to be viewable on a sales website
- Generating customer quotes, statements of account or invoices for standard or customised products and package deals
- Tracking or auditing of timesheets, training, certification or equipment inspections, which might require different levels of security or access for different users
- Upload (or download) of information from external sources in to the company database, eg from supplier catalogues, third-party information sources, real-time exchange rate providers, etc.
Systems built with Microsoft SQL Server can:
- Allow users to log-in and use them over the web from remote locations
- Provide back-office systems to support ‘data-driven’ websites – e.g. sites that display large, complex product catalogues, or allow significant user interaction
- Automate processes for customers or suppliers by allowing them to access or interface with parts of internal company systems
Options with Microsoft SQL Server:
But you are certainly not limited to these lists – SQL Server can provide a solution to support the very particular requirements of your business. See our case studies for more details and client testimonials.
We can build SQL Server applications that interface with other business software or desktop programmes such as Excel, Word, or Outlook – e.g. an invoicing system that creates PDF invoices for printing, or planning system that will generate reminder emails for suppliers. We can build applications that interface with supplier systems or legacy systems.
MS SQL Server can also be used in combination with MS Access for intermediate size internal business systems. Often, this means a MS Access ‘front end’ (the part of the software that users see) with a MS SQL Server ‘back end’ (the part of the software that holds the data, performs manipulation etc).
To support our software, you will need to have Microsoft SQL Server installed on your PCs/servers. We will discuss the specific software requirements with you at the outset of the project.
- Microsoft now offer a FREE version of SQL Server which is suitable for many SME applications.
Call us now on 0845 643 0851 for a discussion of your particular needs – or complete a contact form and we’ll call you.
