Kevin Pirnie' Articles

By: Kevin On: May 15, 2015

Posted In: Development Server Management Software SQL Server SQL Server Windows development hosting mssql web hosting

This procedure and script are meant for use in situations where your SQL server may not have SQL Agent installed. Whether it is because it's SQL Express being use, or because it simply was not an option at the time of install. First thing you will need to do is login to the SQL server using SQL Management Studio.  Make sure your login is able to create stored procedures at the system level, and add the following to the 'master' database USE [master] GO /****** Object: StoredProcedure [dbo].[sp_BackupDatabases] Script Date: 08/17/2011 10:55:54 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: Microsoft -- Create date: 2010-02-06 -- Description: Backup Databases for SQLExpress -- Parameter1: databaseName -- Parameter2: backupType F=full, D=differential, L=log… Read More

By: Kevin On: May 12, 2015

Posted In: Hosting Linux nGinx Security Server Management Software Updates hosting nginx speed up the web web hosting

Do it Because They Do WordPress.com is the cloud version of WordPress that is hosted and supported by Automattic.WordPress.com serves more than 33 million sites attracting over 339 million people and 3.4 billion pages each month. Since April 2008, WordPress.com has experienced about 4.4 times growth in page views. WordPress.com VIP hosts many popular sites including CNN’s Political Ticker, NFL, Time Inc’s The Page, People Magazine’s Style Watch, corporate blogs for Flickr and KROQ, and many more. Automattic operates two thousand servers in twelve, globally distributed, data centers. WordPress.com customer data is instantly replicated between different locations to provide an extremely reliable and fast web experience for hundreds of millions of visitors. Problem WordPress.com, which began in 2005, started on shared hosting, much like all of the WordPress.org sites. It was… Read More

By: Kevin On: April 22, 2015

Posted In: Apache CPanel Hosting Security Server Management Updates bash centos cpanel shell shell scripting

Every new site wants to get their piece of Google, Yahoo, & Alexa.  Yes I said it, Alexa ;)There is a bit of a risk when allowing these bots to traverse your endless universe of pages, posts, and other niceties that you want to get out there an noticed.  Keep in mind, these 3 Search Engines arent the only ones looking for your site and content.  There are millions of bots out there just sniffin around, and while most are harmless "Let's get your site listed in my directory" variety, there are some that look to do harm.  Trust me when I tell you, you don't want them finding out you've left a massive back-door open to your site's shopping cart.Here is how to protect… Read More

By: Kevin On: March 12, 2015

Posted In: CPanel Security Server Management Software bash centos shell shell scripting

Since I use cPanel and CentOS alot now a days, I want to make sure that I have a handy place I can keep and search for anything I might need for configuring or managing the servers. Without any further ado, I present you the most comprehensive list of cPanel Stuff, I have ever seen ;) Configurations and Services They Are Tied To CPanel Configuration File: cpanel.config Path: /var/cpanel/cpanel.config Service: cpanel Apache Default Port: 80 Configuration File: httpd.conf Path: /etc/httpd/conf/httpd.conf Or /usr/local/apache/conf/httpd.conf Service: httpd Exim Configuration File: exim.conf Path: /etc/exim.conf Service: exim Bind Default Port: 53 Configuration File: named.conf Path: /etc/named.conf Service: named DB location: /var/named FTP server proftp Default Port: 20, 21 Configuration File: proftpd.conf Path: /etc/proftpd.conf Service: proftpd pureftp Default Port: 20, 21… Read More

By: Kevin On: December 17, 2014

Posted In: CPanel Development Linux Security Server Management Software bash centos hosting shell shell scripting web hosting

These are the step that I took to create a SVN server using CentOS 7, while attaching drives as repositories instead of creating a monstrous system drive and importing everything there. If you follow to a "T", you too can have the play-ground I have =) I will lay out my exact steps, including creating the virtual machine I used for this.  If you are currently using a VM or dedicated machine then you can skip those steps.  I imagine this would work on CentOS 5 and up, but don't quote me on that. 1.       Create VirtualBox Virtual Machine a.       Have a CentOS ISO ready                                                                i.      I chose v7 as the latest b.      Setup with 20G hard disk, Bridged Networking, 4G Ram, 2 Processors,… Read More