Going Freelance
Leaving the corporate world and going freelance.
A Comparison of Oracle and MySQL
MySQL is to Oracle as Linux is to Windows. Limiting Result Sets Oracle supports ROWNUM to limit the result Sets SELECT * FROM tablename WHERE rowmun < 10 MySql uses the LIMIT clause. SELECT * FROM tablename LIMIT 10 Bind Variables The latest versions of MySql supports bind variables, and Oracle has supported bind variables for a very long time. …
New Blog
This week I moved my blog away from the Simple PHP Blog that was a free open source product. It appeared to have too many security holes.
SQL Server 2005 Compatibility Level
SQL Server can run in a number of different compatibility levels, but how do you change it and how do you set it. These compatibility levels reflect the version of SQL server. 60 = SQL Server 6.0 65 = SQL Server 6.5 70 = SQL Server 7.0 80 = SQL Server 2000 90 = SQL Server 2005 Here is a …
Kauai Tunnel Hike
Wow, what a day, this was a fabulous adventure. We rented a SUV and the guy at the rental shop told us that we were not allowed to take it off of the pavement. I guess what he doesn’t know won’t hurt us. Our team today consisted of Steve, Marcia, Alex (8 years old), and Uncle Glenn (2nd time Geocaching). …
SQL server for Microsoft Great Plains
Installing, configuring and administering SQL Server for Microsoft Great Plains. What a bunch of crazy table names.
Oracle Today
Working in Oracle 8i, wishing I was using SQL Server. Uggg.
Starting at Amazon.com
Just started working at Amazon.com. Now I need to take everything that I know about SQL server and apply it to Oracle.
Working With SQL Server Again
Working on the Cyberprise project at Wall Data where we are utilizing Microsoft SQL server to create a corporate intranet product which includes connectivity to AS/400’s and manframes.
WinTech released to Microsoft Support Services
We just got the first version of WinTech a SQL Server based support services tool completed, and the team Supporting the Windows 3.0 product started using it.