02 Nov 2011 @ 10:10 PM 

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 »

Posted By: Bogus Exception
Last Edit: 11 Nov 2011 @ 05:20 PM

EmailPermalinkComments (0)
Tags
Categories: Events, Statistics, SysAdmin
 02 Nov 2011 @ 9:51 PM 

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 »

Posted By: Bogus Exception
Last Edit: 02 Nov 2011 @ 10:21 PM

EmailPermalinkComments (0)
Tags
Categories: Events, Statistics
 14 Aug 2011 @ 5:23 PM 

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 »

Posted By: Pat
Last Edit: 11 Nov 2011 @ 05:06 PM

EmailPermalinkComments (0)
Tags
Categories: Prog, SysAdmin, Technology
 24 Apr 2011 @ 11:01 AM 

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.

Posted By: Pat
Last Edit: 25 Apr 2011 @ 01:49 PM

EmailPermalinkComments (0)
Tags
Categories: Flash, Technology
 25 Aug 2010 @ 12:52 PM 

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.”

Posted By: Bogus Exception
Last Edit: 25 Aug 2010 @ 12:52 PM

EmailPermalinkComments (0)
Tags
Categories: Prog, Random, Technology

 Last 50 Posts
 Back
 Back
Change Theme...
  • Users » 50
  • Posts/Pages » 174
  • Comments » 61
Change Theme...
  • VoidVoid « Default
  • LifeLife
  • EarthEarth
  • WindWind
  • WaterWater
  • FireFire
  • LightLight

ATCP, LLC



    No Child Pages.

Factoid



    No Child Pages.