I started programming in 1970, and spent the 1970's and 1980's programming minicomputers. I started working with PCs and Macintoshes in the 1980's. By the early 1990's I was maintaining Novell Netware servers and MS-DOS PCs. I migrated my users to Windows 3.1, and shifted my programming to Microsoft Access and Visual Basic. In 1994 this was Visual Basic 3, by 1998 this had shifted to Visual Basic 6. During the 1990's I started working with SQL databases, which was initially Oracle and SQL ... [more]
SQL Server from 1999, PostGreSQL from 2010, stored procedures, ETL (data import), reporting (multiple tools). Major programming projects in manufacturing, oil and gas, warehousing, and consumer finance.
I have written a number of ASP.NET applications, one or two of which is described in my profile. One of my clients was (and still is) maintaining a CRM system that I customized for him circa 2010. I showed him how the scripting worked and what kind of constraints he had to follow to make the web pages work with the SQL data. I was working on an ASP.NET 2.0 'Wallet' payment system for a client recently, and we weren't getting the expected results. I had to demonstrate each functional block of code to the person responsible for dealing with the third parties, to show her what we were actually getting and what we should have been getting.
I taught two people how to process 'printer image files' into Microsoft Access records and tables. I had a boss in the 1990's that understood basic summary reporting, but was getting nowhere in understanding how 'Immediate If' statements worked, which he needed to properly display a particular column. Another client ran a furniture factory - I pointed out that he was better off using SQL Server rather than trying to share an Access .MDB among workstations. I showed him how to link the SQL Server tables to the Access forms. He would get stuck with other problems, and I would walk him through how those could be solved.