Automating Tasks By Programming

Visual Studio

If you plan on or even if you are working in the technology field you need to learn and have an understanding of programming. It really does not matter which language you want to learn as long as you have a good understanding of how to automate tasks. I have been writing custom code and automating tasks for nearly 20 years. I have found a use for this talent in every job I have had in the technology field. Even working at a school district recently I was able to automate importing new students into the library software from the student information system. Once I had the connection up and running I was told that no one else has been able to do this. They were asking for this to be done for 10 years. The reason I tell you this story is because once you learn how a process works and if you can write some code you to will be able to automate a process.

I am currently writing a large project to automate build SQL statements. Right now the job is done by hand each time the database needs to be updated or split I am asked to run my SQL UPDATE query by hand on the SQL database server. This is time-consuming so it is a great time to automate this process. I will keep you updated on this process. The bottom line is not to be afraid of programming and take your time. You will hit snags once in a while but take it from me you will be saving hours of manual coding in the future.

If you have a process and you do not want to program it please contact me. If you can show me what the process is and what you need it to do I will be happy to contact writing the program for you.

Share

Upgrading My Home Server with VMWare 6.7

VMWare

I spend some time upgrading my home server to the newest VMWare 6.7. We have been using this new version at work and I wanted to dig into more if the features. At home, I like to run to servers for testing. I run Windows Server 2012 as well as Ubuntu Server.

I have spent most of my weekend setting up a new VM of Ubuntu Server and preparing it for testing out automation scripts. I want to create my scripts using Ruby. I am using the IDE called Ruby Mine from JetBrains.

If you have any projects that you are working on or need assistance with any of your servers or need new scripts please let me know. I am also always available for remote training.

Share

Swift Programming for IOS

Swift Programming

If you are in the computer field in today’s World you can never stop learning new and exciting computer topics. As you can see from the title I am currently taking a course on writing code for IOS. I have a few projects in mind for the iPhone and the iPad. I have been coding for Windows for years. You can see from my past blog posts that I have also been writing bash and power shell scripts for Windows and Linux Servers.

I have also spent a lot of time programming MySQL and MSSQL Databases and writing front end programs in both Visual Basic and PHP for Web Development. The simple truth is once you get one programming language down and learn how to debug syntax other programming languages are not hard to follow. Well back to the lessons.

Share

Writing and Coding Scripts

Scripting

The words I truly enjoy at work is when I am told that no one could get this automated program or connection to a database to work. They feel it can not be done? I have been connecting programs and automating software programs for years. I also enjoy writing automated scripts for our servers.

When you are learning how to work with scripting languages I would advise you to choose a few different ones. Just as there are many tools in a toolbox you will find there are many different scripting tools to get the job done right. I would also advise you to comment your work as you go. You should also keep clear notes on the process that you used to build the script. This is really handy if you ever have to go back and change something as programs or servers change. Or you never know if you get promoted you might have to hand off the scripts you wrote to someone else?

The truth is if you are working in the IT field and are responsible for software or servers you will want to learn and be the best you can be with scripting. When you can automate a program or process you will have more time to work on other projects.

If you have a process or a daily software task that you would like to be automated look me up. I might be able to give you some guidance and be able to share my knowledge with you.

Share

Ubuntu Server

Ubuntu Server

I was once asked on an interview what do you know about Linux? Of course, I responded with the answer that I can get around the OS pretty well. I am a long time Windows Server person like many of you out there. But the simple truth is that when you work as an IT Director or a Network Administrator you have to work in many types of server environments.

I was asked once in another interview years ago what I knew about Novell Netware? My response was that I have never seen Novell but I have heard of it. I then followed up with if they had a book lying around I am sure I can do what they needed me to do with the OS. Well, I got the job and my first day they wanted me to create some file shares. They handed me a book on Novell and within an hour I came back and said the file shares were ready to use.

What I have told many interns that I have trained over the years is that you can never be scared of any Server OS. Every time you come upon a new system go into it as a learning experience. Also if you can go home and set up a VM with the OS and begin poking around. And when you are learning to take the time to take notes on what you learned, they will come in handy down the road.

Once you do get the feeling for a new Server OS is to remember to revisit it and keep brushing up on your skills. You never know when you might take an interview and be asked questions about one of these systems.

Share

Programming for IOS

X Code

I have always wanted to start programming for IOS for both the iPhone and the iPad. I have plans designed to take some if not all business from some Pittsburgh based companies. I have always wanted to design this system I am working on and I figure if I can build the right team this will be a great part-time work. I still really enjoy where I am working now and I work for a great company. But it is time to take this project to the masses. First I have to learn more about programming using Xcode.

I have been a Visual Basic as well as a PHP programmer for years now. For this project I am working on it will require the use of the iPad. If you are reading this and you feel you would like to be a part of this start-up please get in touch with me.

Share

Collaborative Learning

collaborative-learning

Collaborative learning is a great way to teach for the 21st century. Today’s largest companies create and move their businesses by using collaborative meetings. Companies such as Google, Apple and Microsoft have teams that meet often to come up with the next big thing. Even programming companies work on large code projects with many programmers coming up with ideas and each writing a piece of the code.

Today’s education, for the most part, is leading this new way of educating children from elementary to high school and even in the college setting. With the help of great tools such as interactive whiteboards, Google Suite and Office 365 and much more. Smartphones can also be a great collaborative learning tool. The focus is getting students to learn together much like the businesses of today.

I enjoy walking into a classroom and seeing a teacher walking around the room and assisting the students in learning in group settings. The day’s of the teacher standing in front of the classroom and lecturing have been put back into the dark ages of education.

If you do teach or even lead teams in a business find ways to have each person or student contribute to the overall lesson. You will find great rewards when you see how much your students or staff know.

Share