The Sales Engineer

I was looking for a way to have all my tables have a unique GUID (Globally Unique ID) as well as a “Last Updated” column that would automatically update both on INSERT and on UPDATE.

Through a few hours of experimentation, I created the following:

CREATE TABLE dbo.testing
    (guid            uniqueidentifier    NOT NULL DEFAULT NEWID(),
     lastUpdated     datetime2(7)        NOT NULL DEFAULT GETDATE(),
     col1            nchar(10)           NULL,
     col2            nchar(10)           NULL)
GO
CREATE TRIGGER dbo.trLastUpdatedTesting
ON dbo.testing
AFTER UPDATE -- not insert!
AS
BEGIN

More »

GMail recently took away the ability to have an RSS feed create signatures for us. Luckily I’ve been using Wisestamp (http://www.wisestamp.com) for years, and it is just the thing you need. With it, you can take the output of any RSS feed and put the text at the bottom of your signature in every email you send out.

http://blog.atcp.us/wp-admin/post.php?post=3049&action=edit&message=1

Above, I’ve created a simple signature in Wisestamp, and when you do this in the editor, you have some really diverse choices below. More »

A fast one for everyone.

If you have occasion to use POSIX based systems like Linux, UNIX, and yes, even Macintosh, then you will end up using cron eventually to schedule things to be done on your behalf. Cron is the tool built into these operating systems, and can seem intimidating to a new user/admin. Here are two quick tips to making cron immediately useful.

1. Generate a cron template.

2. Generate a local copy of your cron jobs.

Create a file in your home directory called cronjobs. Copy and paste the below template, and use it when needed to make a cronjobs file for another user: More »