Category: Articles

The Accidental Teacher, Part II

What happens when you take a first-year teacher and put him in charge of designing a software engineering program?...

How to Get Started Writing Your Own Book

It Seems Like I’ve Been Here Before … People seem fairly impressed when I mention that I’ve written a couple of books on databases and software. I try not to make a big deal of it, just mentioning it in passing as appropriate, because I actually don’t consider it...

Deploying MS-Access Table Design Changes to Remote Files

A New Challenge for Access I designed a Microsoft Access database for one of my clients and it’s split into two files – a front-end file with all the forms, reports and code and a back-end file with the tables. That’s pretty standard. During the development process, I needed...

Unplugging to Reconnect – The Technology Sabbath

It Started With a Game … By now, you’re probably familiar with Pokemon Go, the game where people search for Pokemon characters around town with their smartphones. In 2015, I played a forerunner of this game called Ingress. The basic idea was the same – run around town accessing game...

ASP.NET for Beginners

If you’ve been wanting to learn how to design websites with ASP.NET, here’s your chance! Check out my latest three-part series on OcalaITPros.com where I explain the basics of Microsoft’s ASP.NET framework and how it’s used to create dynamic websites. This series will guide you through creating and publishing...

8 Questions to Ask When Starting Your Meetup Group

Updated July 29, 2019 Introduction Unlike much of social media, sites such as Meetup.com and EventBrite actually focus on bringing people together in person and helping them find other like-minded people they might never have met otherwise. These sites provide a set of tools that make it easy for...

Learning a New Language Online

Learning a new language has always been a challenging task whether you’re satisfying a class requirement in school, moving to a new country or adding a new language for work or recreation. The fact is that we take years to become proficient with our first languages from the time...

SQL Server for Beginners: Part V – Using SQL Server 2012 LocalDB

In a previous chapter, I described the installation process for SQL Server 2012 Express which included all the bells and whistles of the advanced services package. While it’s great to have all the tools at your disposal to learn from, some people might not want such a large installation...

SQL Server for Beginners: Part IV – The AdventureWorks Database

In the last part of this series I wrote about SQL Server Management Studio (SSMS), the interface that enables you to work with SQL Server objects such as databases and tables. The program enables you to do quite a bit with a SQL Server installation. You can create entire...

SQL Server for Beginners: Part III – SQL Server Management Studio

Once you have SQL Server and all the necessary updates installed, the next step is to learn how to create databases and work with them. The easiest interface available to the beginner is Microsoft SQL Server Management Studio (SSMS), a graphical environment where you can view and manipulate all...