The next meeting will be on Thursday November 18th here at Asckey Data Services Ltd.
Using MS SQL Server for real
Running VDF with server databases has been possible for well over ten years, and is now becoming standard practice, especially with the "Express", no cost versions of the major databases. As well as providing a much more "bullet proof" database capable of handling very large numbers of users, SQL databases can offer both significant increases in performance and new functionality that would be difficult to achieve with reasonable response times with the traditional shared file, record by record accessed embedded DataFlex database. And VDF makes it so easy to use any of the SQL databases with usually no code changes needed to get started - even though you will want to make those changes when you see the kinds of performance gains that you can achieve..
We will be putting on a one day course going into some depth on using SQL Server based on our experiences when converting our Eclipse-fm® system to MS SQL Server.
Going beyond the simple database conversion you can get huge performance benefits with embedded SQL, but you can also fall into big holes if you don’t know some of the SQL tricks!
Outline content
Introduction
What makes server databases so imperative?
A basic "as is" conversion
- What problems might you run into (date/time, orphans, .....?)
- How much re-coding is necessary (99.9% of the time, none!)
Installation and management.
- The minimum of what you can survive with if nothing but a VDF database converted as is.
- Other SQL Server management tools and where to get them
Starting to use the database
- Roll back - atomic transactions
- Benefits, code changes needed
Making Selections at the server
- Limitations of VDF code
- Introduction to Embedded SQL
Advanced SQL - what you could do
An "ideas" session, not detailed hands on instruction, and based on some of our application development. Including using SQL in Codejock Grids which can speed up loading selected records from large databases by a factor of ten or more.
What you will need
Apart from the last session, this will be hands on, so you will need to come with a PC with VDF on it (make it V16, why not?!), and MS SQL Express (or the full version). Get the SQL Express version from http://www.microsoft.com/express/database/
We have some interest expressed in this already, and numbers are limited, so please let us know soon if you would be interested.
|
Date:-
Venue:-
Cost:-
Reservation: -
|
Thursday 18 November
Asckey Data Services Ltd
Free! This is a VDF SIG training day.
Email sales@asckey.com or call 0845 2707747
|
VDF SIG November 2010