Category Archives: General Tech Info

SQL Function – Get Current Person ID

The platform our church uses to help us manage information and relationships has a great feature to merge duplicate records. Unfortunately, this feature causes a new ID to be generated for a person. That can make is difficult to integrate with other custom features, systems, etc. I wrote this simple function to keep person links between integrated systems no matter what.

How To USE. 

Add [dbo].[cust_fn_getcurrent_person_id](YourPersonIDInCustTable) in your join clause.  Comment if you would like more explanation on how to use.

Function Code

USE [YourDataBase]
GO
/****** Object: UserDefinedFunction [dbo].[cust_fn_getcurrent_person_id] Script Date: 11/1/2014 9:21:12 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE function [dbo].[cust_fn_getcurrent_person_id](@CCPID int)
RETURNS varchar(50)
AS
BEGIN

DECLARE @PersonID as int
SET @PersonID =

(Select Top 1 lt.current_person_id From
(SELECT cpm.new_person_id AS current_person_id, cpm.old_person_id AS old_person_id
FROM core_person_merged cpm INNER JOIN
core_person cp ON cpm.new_person_id = cp.person_id
UNION
SELECT cp2.person_id AS current_person_id, cp2.person_id AS old_person_id
FROM core_person cp2) LT
Where lt.old_person_id = @CCPID)

RETURN @PersonID
END

 

Virtual Server Platform Survey (Results)

I recently asked posted an informal survey asking a few friends about which virtualization platform they prefer. I only received a few responses, however, I still found the information helpful since the responses I did receive came from a relatively wide range of organizational types and sizes. I expected a higher number of people voting for HyperV, and I suspect that if I would have pushed a little harder for responses from some of my peers I would have seen a higher percentage of people who are pro HyperV. Nevertheless, The results seem to loosely tie to a current ongoing tech debate on the subject hosted by Network World so I am satisfied with the results. I will probably write more on this in the future, since I, of course have my own opinions on the subject. However, I won’t bore you with that now. For now, I’ll just post the results I have below.

Results

Screen Shot 2013-01-30 at 7.40.41 AM

Why?

Not everyone took the time to explain why they preferred their platform of choice. Those who did wrote the following:

  • Mature Platform…Great experience with it [VMWare]…Very rich set of tools .
  • Experience, stability, its what we know [VMWare], the freeware is an option for some but not others.
  • Hyper-V might be a great choice in your situation. The value proposition is great: rich feature set and cheap.  In spite of this, VMWare is still a great choice because of the availability of consultants and trained experts. There’s a lot to be said for sticking to what you know and what is the most easily supported.
  • I tried HyperV 2012 and it works fine in a small environment.  But, once you connect iSCSI to it and start getting more professional.  It wasn’t passing its own tests.  I was trying to connect it with FreeNAS.  I even rebuilt my storage into windows 2008 R2 with a SCSI initiator…  I switched back to VMWare 5.x and bam!  Fast and nice and stable!
  • excellent stability, tools, and support [VMWare].
  • We have clients who use all of them.  The stability in VMWare is unsurpassed.  We have had nightmare issues with Hyper-V and avoid it if at all possible.
  • [HyperV] Built into the product, better mgmt across apps, much lower cost.
  • Market share Reliability Stability  [VMWare

 

Other demographic Information

Industry

Please Note: In this questions that other category was represented by Consultants and value added resellers.

Screen Shot 2013-01-30 at 7.40.34 AM

 

 

Things I Learned from
Dr. John Perkins – Part 1

June, 2005. I remember the day was hot and very humid. I can’t remember what Southern City we were staying at that day during our Justice Journey. All I remember from that day was sitting in a small conference room at a regional hotel chain listening to one of many amazing talks that I had heard from Dr. Perkins. That was when he said those words, “Christ is the only way we will ever have true racial reconciliation with each other. Christ is the way.”

We had already been traveling a few days together. 25 people from a primarily white church and 25 people from a primarily African American church learning about history, Godly Justice and about…well…each other.  Our seven day journey together was an intense day of truth, passion, revelation and above all…love. So after a while, I lost track of the days and became lost in the conversations, the new relationships, and the new hope that was born through everything we had learned together. The power of Christ to bring about reconciliation, mutual love, and true community is overwhelmingly real.

One of the greatest blessings of that journey and great blessings of my life was to meet and learn from Dr. John M. Perkins. I don’t know of many people who have walked on this earth who have embodied and portrayed the love of Christ more then this man.  I learned countless things from that man in our short time together. Over the next few days I want to finally write down my thoughts about just a few things I have learned from Dr. Perkins as a living reminder that I experienced the love of Christ “with skin on” when I met him and as an exhortation to carry on his legacy.

In the mean time…Here is some info to introduce you to this Kingdom Hero.

Two of my favorite books:

 Other Info

Free I.T. Availability Management Calculator

I recently created a simple tool to help me effectively calculate the Availability, Reliability and Maintainability of I.T. Services. I find that such tools offer some helpful objectivity to the often chaotic world of Non-profit organizational management I work in.  I hope that this tool helps people learn and apply these simple disciplines to their own I.T. management processes.

The tool itself is just an Excel spreadsheet that contains ITILv3 Availability Management formulas. I like to manage I.T. Availability down to the second. But you can change to tool to fit your needs.

Hopefully the tool is self explanatory. Just let me know if you have any questions.

Related Information

 

I.T. Solutions For Really Small Churches

I have not taken to opportunity to write about technology for some time. There are so many people writing on the subject, I guess I really didn’t think that I had anything to offer that would add value to the already overwhelming flow of information out there on the subject. Nevertheless, over the past several years I have had the opportunity to work with very small churches and other organizations who have very little or no budget and expertise to leverage I.T. resources to support their initiatives. These churches may have a desktop computer for the office and the paster may have a notebook. However, they don’t have money to hire consultants and they don’t know where else to turn. In these cases I do my best to volunteer some time to get them started up in such a way that their need for any additional I.T. expertise is minimal. The good news is, with a little initiative and a willingness to learn some basic consumer computer skills, there are some great options out there for even the smallest organizations to gain access to technology services that, in the past, have only been available to larger companies. This post offers an overview of some of solutions that I have used successfully over the years.

The Big Disclaimer…

I mention various brand name service providers in this post for the purposes of providing examples. However, please do not consider any of these examples to be an official recommendations for these brands. While I have had a measure of success with the services I have used, I just want to be clear that I attempting to sell these services in this post.

Prerequisites

This post presumes the following:

  • You already have at least one computer.
    It doesn’t matter if it is PC or Mac. There are pro and cons to both platforms. The Mac offers my personal favorite set of features that balances out great, easy to use, tools for communicating, administrating and leading organizations. The downside of Mac in my opinion is that it is expensive. You’ll be hard pressed to find a Macbook for under $1000.00.  You can get a great deal of value on the PC side. I recently purchase a really nice little Asus notebook for a church in Chicago with a full multi-year “accidental damage” warranty for quite a bit less than 1000.00. Whichever direction you go, you will need at least one computer, preferably a notebook, as opposed to desktop to get anything out of this post.
  • Wireless Network Interface Controller (WNIC) – Commonly called a WiFi adapter – When you go to purchase your computer. You will want to make sure it has a WNIC or WiFi adapter. You don’t need to know all the details about how it works at this point. However, the wireless adapter is the little device that connects your computer to the world. Most newer computers have them these days. You just want to be sure yours has one. In my opinion, 90% of the value offered through your computer with be because of this connection.
  • A note about tablets and other…
    There is a blinding amount of options when it comes to personal computing options in this day and age. I do believe that more and more real business and productivity solutions are moving into packages that fit in the palm of your hand. Mobile, cloud connected technology is the future, and for many, that future is now. However, if you are just starting out today, you will get the most value from a notebook computer with a display that is not smaller than 13 inches. You’ll be using this thing for everything from managing church expenses to writing sermons to posting a video message to Vimeo to updating your churches Facebook page. You need something that offers mobility, versatility, computing power and the option of installing some traditional applications. A notebook is still the best option for this; especially if, as the pastor of your church, you are the only official staff member.

Technology Options

OK…now that we have all the disclaimers and prerequisites out of the way let’s dive into some technology options for that really small church who doesn’t have access to a lot of technology resources.

 

# 1-  Starbucks

Here’s the scenario. You are just getting started. You may have internet at home and you may not. You need to place that doesn’t have the distractions of home, yet you can’t afford an office space…enter Starbucks. Most Starbucks offer free WiFi. I know it is not for everyone. However, even though I have access to a tremendous amount of computer resources, I still prefer to work at Starbucks from time to time. Get yourself a nice cup of coffee, or tea, a snack,  find a comfortable place to sit and there you have it; a nice little work space complete with an internet connection.  Now you can access your email, share information, do research for sermons, etc.

 #2 – Internet Connection

Depending on where you live you can acquire internet service for your church for somewhere between $15 and $100 dollars a month. I realize that even $15.00 a month can be a great deal of money when your church is very small or when you are just starting out, however, out of all the technology choices available today, I rank an internet connection among the highest priorities of any organization’s expenses. The internet is the Roman’s Road of the 21st century. Through this connection to the world, you have countless resources at your disposal. Since this global network is also interactive, you have the opportunity to interact with broader circles of people than ever before in history. Furthermore, the internet is not some fluffy white “cloud.” It can be quite dark and stormy in places, even dangerous; full of things that are good, bad and very ugly. Like any other dark place in our world, This cloud, as it is referred to, needs our presence. I can only imagine how Paul might have used the internet to distribute his epistles to churches in his day if he was not limited to the relatively closed 55,000 mile network of Roman Roads and Shipping routes.

#3 – Internet Hosting & Cloud Services

Not long ago, internet hosting was really something people only thought of to host websites on the internet. Today with a relatively small monthly fee hosting providers offer a great deal more value for the money. The buzz word for all of this is “Cloud Services.” This can include a wide range of services from email and file storage to even complex networking and software services like domain name services, church management services, database platforms and even application development platforms. In Short, small churches can gain access to many of the complex network infrastructure services that larger organizations use to operate their organizations. The difference is, where larger organizations pay hundreds, thousands and more to operate services locally, your costs can start at between $5 and $15 a month. The fees for these “cloud” services are becoming so cost effective that even large companies have started to migrate toward them. As an example, I have used 1and1.com to provide services to small and large organizations for several years now. For around $10/month I get access to unlimited webspace, unlimited monthly web traffic, email service, 1000 email addresses, a registered domain name, website hosting tools, unlimited files storage, one free SSL certificate to secure a website and much more. I even get secure access to create up to 50 databases along with access to several standard open source developer platforms. It is like having access to an entire technology infrastructure at the click of a mouse.

#4 Google Apps

If I was writing this a year ago, I would probably be more enthusiastic about sharing information about free products like Google Apps. I have had a good measure of success rolling this product out to small churches and other organizations. Let’s face it, exchange is expensive and complicated to roll out. However, it does have a really nice offering to non-profits; even if they are faith based. Nevertheless, Google’s offering of 10 free named users is hard to beat. Especially if have little or no local network storage to speak of, or little or to office space to work in. Google Apps gives you a nice set of productivity tools to edit and share documents, calendars, contacts and more. In my opinion, it is easy enough to set up