SQL Reporting – IT Living Lab

This project was done for a not-for-profit organization. They wanted to move their current database that is in FileMakerPro to Microsoft SQL Server. They also wanted to know what applications they could use to write reports for the system. The student recommended SQL Server Reporting Services (SSRS) because it was easy to use and free. It would also be easy to upgrade to that system.

Project Student: Brad Robbins

Testimonials

The Living Lab experience has helped me see what it can be like in the real world. David C. Bryant

The Living Lab has taught me that not all projects will go as planned. You will run into problems and situations that frustrate you. I have, however, learned a great deal about logs and log management. I gained confidence in my problem-solving skills and overcoming obstacles when it comes to IT projects . Samuel J. Jacobs

The Living Lab is like having an IT job in the field. You are pushed and pulled in many different directions with many different projects. You are thrown into situations that need to be figured out. The guidance is there, but nothing beats that feeling of figuring it out by yourself. Aaron Hook

The Living Lab has given me vital insight into what a career in the IT field could potentially look like. From learning to manage my time, deal with unforseen problems, and work with others, to completing group projects and meeting deadlines, the Living Lab has provided me an opportunity to learn and grow as a future IT professional. Matthew Smerdel

FreeNAS is an open-source, Linux based freeBSD, network storage operating system. It can be installed on virtually any hardware platform that allows it to share data over a network. In this project, FreeNAS is being used to house multiple virtual machines for a virtual training program. FreeNAS utilizes a Web-GUI that enables a remote connection through a browser using the assign IP address for the FreeNAS server. This connection is initially insecure and needs a certificate of authority to be e… Read more Creating a secure CA connection for FreeNAS to use with ESXi 6 Virtual Environment

Living Lab was a last-minute choice for me, and now I feel it should be the first choice anyone makes. The hands-on experience I have gained has helped me tremendously. I’ve definitely stepped out of my comfort zone numerous times and loved every moment of it. The instructors are extremely helpful, and my fellow classmates have also been teachers to me as well. Eugene Gephart

I have gained a lot of useful experience with Mac OS X administration, such as performance monitoring, maintenance, user and group creation, remote and command line administration, and load testing. It has challenged my skill set, and it will be very beneficial for me in the future. Joseph Warren Balazs

The Living Lab provided me with a unique, real-world experience that other classes cannot. This class enabled me to use the skills that I have acquired from my previous classes and apply them to a real-world setting. Kris Westermann

The Living Lab has been an enjoyable experience. It has provided new skills while strengthening old ones and has given me insight into the technical workplace. Wendell Matthew Klene

Throughout this class, I have learned a great deal of information. It gave me an idea of how how the IT world runs and prepared us for it. Abdulrahman Jassem M. Alzaman