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 »

I am going through an exercise where I’m trying to find a way to compute stock metrics (technical indicators). What I need is a way to iterate over the rows in a database, computing each technical indicator, then putting that value into the table’s row for that date.

I found an example, and modified it to work on SQL SERVER 2008 R2. I hope you, too, find this solution extremely interesting:

DROP TABLE #google_stock
GO
create table #google_stock
(
quote_date [datetime],
open_price [decimal](6,2),
close_price [decimal](6,2),
high_price [decimal](6,2),
low_price [decimal](6,2)
)
GO

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 »

I couldn’t believe that I had to install Adobe’s FF/IE based installer to be able to then download/install the reader. I remember the time, not long ago, when the reader was a reader (just like the Flash Player, remember? Now you need Flash dev sw to get it).

I dug around, and found the link for all of us. The link is here.

Another moment of silence for the Macromedia Empire. You are still missed.

http://dns.tmcnet.com/topics/internet-security/articles/96805-web-sites-protected-using-an-ai-engine.htm

“No updates are required, a feature that provides protection against so-called zero-day attacks. The software package, which is sold by subscription within the SaaS ( News – Alert) model, is compatible with al websites and web servers. The platform is operated and managed at BinarySEC data centers and any website can be protected in minutes.”