Category: SQL

5 Reasons You Should Learn SQL

Let me tell you a story … In 2002, I was interviewing for a database support position and feeling pretty good about my chances. I’d been working with Microsoft Access for a few years, everyone at the last job knew me as the expert and general tech guru and...

New Video – Learning SQL with SQLite

An essential skill … If there is one programming language that I would recommend for everyone, it’s Structured Query Language (SQL). SQL (often pronounced “sequel”) is the main language used to communicate with databases including Oracle, SQL Server and Microsoft Access. It’s the set of commands used to write...

Recovering a Corrupted Table in Access With VBA

Recently, a client started experiencing errors, seemingly at random, in the database application I managed for them. The errors immediately started mentioning corruption and then these came through … Error 3167 – Record is Deleted Getting everyone out of the system and running a Compact / Repair seemed to...

How to Perform a Basic MySQL Installation in Windows

One of the nice features of MySQL as a database software is its noinstall option in which you download the files themselves and perform a manual installation that takes just under a gigabyte of space on your drive.  If you’re a developer or a student, this means you can...

How to Convert Between Decimal and Binary in T-SQL

For the past six months, I’ve been teaching night classes in database programming and my students are just about ready to take Microsoft’s 98-364 exam. Now, we’re transitioning over to C# programming¬†for the next phase of the program but I have to keep their SQL skills fresh for the...

Calculated Fields in CiviCRM

One of CiviCRM’s strengths is the ability to add custom fields to hold specific information about your contacts. One thing it doesn’t offer (yet) is a calculated field type that will present the results of calculations of other fields. ¬†While calculated fields are generally discouraged in relational database design,...

Importing Case Data into CiviCase

Migrating to CiviCase On a recent project, I setup CiviCRM and CiviCase to enable a local organization to better manage its client database. The old database had been developed in Borland Paradox and was quickly becoming unusable. As a free and open source solution, CiviCRM turned out to be just...

Data Analysis with Microsoft Access

Tackling the Data One of the strengths of Microsoft Access is its ability to import and link to data from different sources.  With Access you can also query and report on the data in ways that a spreadsheet program like Excel doesn’t readily provide.  This can come in handy...