Kevin Pirnie' Articles

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
UPDATE 2.0!!! Wow, just realized it's been awhile since i posted anything... well kiddies, time for some new code. Although I have grown up loveing, carressing, and mutilating Visual Basic, I have decided to take a stab at some C# since most of my projects lately have comes across in the form of PHP.  While I do love VB still, I am starting to fall hard for some C# sexyness (<- spelling). I have a VB version of what I am about to post as well, and though the language structure is different, there really aren't very many differences between the 2.  I thought I may get some sort of performance boost out of this "conversion" but alas, I was mistaken.  Both languages performed admirably… Read More
In building my MySQL Store Locator, I figured that it may be a good idea to do the same thing for MS SQL.   Since I have 2012 installed, I built this particularly for that version, and am unsure if it will work in previous versions.  I do know that the Geo datatypes have been severly refined and improved for 2012, so maybe you can keep that in mind when you try this out.Similar situation, I needed something like this built for a 'Store Locator', this time for a .Net site I was building.  I have since decided to add it into my personal webservices which you can see in action here: My Zip Code ServiceAll I'm going to show you is what I did,… Read More