Neville
Silverman

Visual Basic Programmer, Sydney
Microsoft Access Database Programmer

Custom Built Software
System Optimisation
Office Automation
Phone Australia
(02) 9453-0456

Microsoft SQL Server Database features

Microsoft SQL Server Database featuresThe Microsoft SQL Server Database is clearly established as an industry standard, with millions of licences sold – and Microsoft SQL Server's popularity continues to grow.

The Microsoft SQL Server Database is easy to program and maintain, easy to add or change data, and can be used by a wide variety of data aware applications. And a Microsoft Access Front End database can easily be combined with a SQL Server Back End database.

  • The Microsoft SQL Server Database has been designed for medium to large sized businesses that cannot afford to spend a lot of time maintaining their computer systems.
  • The Microsoft SQL Server Database is designed to provide optimum performance even during peak load times and ensures mission-critical reliability.
  • Microsoft SQL Server Database has an engine that scales from hand-held Windows Mobile devices to managing terabyte symmetric multiprocessor clusters.

The easiest implementation is to use a Microsoft Access Front-End. The system would then have the power of Microsoft Access and the performance and security of SQL Server.

Microsoft SQL Server Features

  • On-line backup – An automatic scheduler can be used to back up the SQL Server Database, without having to exclude all users.
  • Durable transactions – SQL Server logs transactions so that updates made within a transaction can always be recovered or rolled back to the last consistent state, if either the Client or the Server computer fails.
  • Better Reliability and Data Protection – It is extremely rare that a crash will cause any loss of data with Microsoft SQL Server.
  • Faster Query Processing – SQL Server runs queries on a Server, which is typically a more powerful computer than the Client workstations. Running queries on the Server increases the load on the Server more than would happen with a Microsoft Access File-Server solution, but it can reduce the network traffic substantially – especially if users are selecting small subsets of data.
  • Advanced Hardware Support – Uninterruptible power supplies, hot-swappable disk drives, and multiple processors can all be added to the Server with no changes to the Client workstations.
  • Integrated Windows Security – SQL Server supports Windows security accounts to authenticate users who are logging on to a Database. This means that if users are already logged onto a Windows network, their existing Windows security groups and accounts can be used to define permissions.
  • Advanced Server-side programming – Microsoft SQL Server supports an SQL dialect called Transact-SQL. Used in conjunction with features such as constraints and triggers, Transact-SQL allows business and security rules to be defined on the Server. Transact-SQL can also be used to create stored procedures that run on the Server to provide flexible and secure access.
  • Free Test Software – The Visual Basic programmer can download the free version of SQL Server 2014 Developer Edition. It has the same feature set as the SQL Server 2014 Enterprise edition.

SQL Server and the use of Visual Basic

  • With Common Language Runtime (CLR) integration, it is possible to code Stored Procedures, Functions, and Triggers in Visual Basic.
  • Tasks that were difficult to create in Transact-SQL can be easily done using Visual Basic.
  • Visual Basic provides extensive support for string handling and regular expressions.
  • Visual Basic code compiles to native code with significant performance improvements.
  • Visual Basic provides thousands of classes and methods that can be used on the Server side.

Microsoft Azure SQL Database features

The Azure Database is a cloud-based Internet service from Microsoft. The database can be shared with others in the cloud. Azure SQL Database is robust, provides high availability, reliability and security on a database located in the Microsoft data centre – at a fraction of current costs.

The features of the Azure SQL Database would be costly to duplicate locally. Email, Transaction logs and query optimisation are not supported.