This solution was not perfect, as it didn’t properly handle columns with spaces or that used reserved words in their names.  Luckily someone else had fixed this and placed the solution in the comments.  There is still one drawback that it handles empty columns as NULLs, but it still handles 90% of the work.  If I have the time, I’ll try to work that out and post an updated solution.

SQL Code and usage after the jump.

Usage:

Past the code below in Query Analyzer, replacing the line

and name like 'AMEX%'

with the appropriate where clause to find your tables.  You should then be able to run it and it will generate your SQL.

SQL Code:

create table #tmp (
SQLText varchar(8000) )

create table #tmp2 (
Id int identity,
SQLText varchar(8000) )

set nocount on

delete #tmp
delete #tmp2

declare @vsSQL varchar(8000),
@vsCols varchar(8000),
@vsTableName varchar(40)

declare csrTables cursor for
select name
from sysobjects
where type in ('u')
and name like 'AMEX%'
order by name

open csrTables
fetch next from csrTables into @vsTableName

while (@@fetch_status = 0)
begin

select @vsSQL = '',
@vsCols = ''
select @vsSQL = @vsSQL +
CASE when sc.type in (39,47,61,111) then
'''''''''+' + 'isnull(rtrim(replace(['+ sc.name + '],'''''''','''''''''''')),'''')' + '+'''''',''+'
when sc.type = 35 then
'''''''''+' + 'isnull(rtrim(replace(substring(['+ sc.name + '],1,1000),'''''''','''''''''''')),'''')' + '+'''''',''+'
else
'isnull(convert(varchar,[' + sc.name + ']),''null'')+'',''+'
end
from syscolumns sc
where sc.id = object_id(@vsTableName)
order by ColID

select @vsCols = @vsCols + quotename(sc.name,'[') + ','
from syscolumns sc
where sc.id = object_id(@vsTableName)
order by ColID

select @vsSQL = substring(@vsSQL,1,datalength(@vsSQL)-1)

select @vsCols = substring(@vsCols,1,datalength(@vsCols)-1)

insert #tmp
exec ('select ' + @vsSQL + ' from ' + @vsTableName)

update #tmp
set sqltext = 'insert ' + @vsTableName + '(' + @vsCols + ') values(' + substring(sqltext,1,datalength(sqltext)-1) + ')'

insert #tmp2
select 'DELETE from ' + @vsTableName

insert #tmp2 values ('GO')

if (select count(id) from syscolumns where id = object_id(@vsTableName) and ((status & 128) = 128) ) = 1
begin
insert #tmp2
select 'set identity_insert ' + @vsTableName + ' on'
end

insert #tmp2
select * from #tmp

if (select count(id) from syscolumns where id = object_id(@vsTableName) and ((status & 128) = 128) ) = 1
begin
insert #tmp2
select 'set identity_insert ' + @vsTableName + ' off'
end

insert #tmp2 values ('GO')

insert #tmp2
select 'update statistics ' + @vsTableName

insert #tmp2 values ('GO')

delete #tmp

fetch next from csrTables into @vsTableName

end

close csrTables
deallocate csrTables

update #tmp2
set sqltext = substring(sqltext,1,charindex(',)',sqltext)-1) + ',NULL)'
where not(charindex(',)',sqltext) = 0)

update #tmp2
set sqltext = replace(sqltext, ',''''',',null')
where not (charindex(',''''',sqltext) = 0)

update #tmp2
set sqltext = replace(sqltext, '(''''',',null')
where not (charindex('(''''',sqltext) = 0)

set nocount off

select sqltext from #tmp2 order by id

go

drop table #tmp
drop table #tmp2

Tweet This Post Digg This Post Facebook

<?xml version="1.0" encoding="UTF-8"?>
<transformations>
  <!-- VBScript String Adds leading and trailing quotes,
    escapes internal quotes and handles crlf's-->
  <transformation name="VB-STRING">
    <prefix>"</prefix>
    <replacements>
      <replace from="&quot;" to="&quot;&quot;"/>
      <replace from="&#x000d;&#x000a;" to="&quot; &amp; vbcrlf &amp; &quot;"/>
    </replacements>
    <postfix>"</postfix>
    <seperator> &amp; "," &amp; </seperator>
  </transformation>
</transformations>

Tweet This Post Digg This Post Facebook

Less than three months after joining the OpenID Foundation’s board as a sustaining corporate member (i.e. putting its weight and financial support behind OpenID), Facebook has just announced at the “technology tasting” event this afternoon at its Palo Alto headquarters that users will soon be able to log in to Facebook with their OpenID.

This is a big win that gives OpenID mainstream support and acceptance.  Hopefully it will lead to more provider support, as well as greater user adoption.

Now I’ll be able to log on to Facebook using my iPhone as a virtual token.

Tweet This Post Digg This Post Facebook

The security app offers two-factor identification designed to strengthen protection on e-commerce site and with other online accounts. As of today’s launch, Verisign (NASDAQ: VRSN) said it has signed up over 40 Web sites as participating members of its VIP Network, including eBay (NASDAQ: EBAY), PayPal and AOL.

I personally think this is a great thing.  I previously used a Verisign token to protect my OpenID account at pip.verisignlabs.com.  It was always a pain in the you-know-what to carry around, so I never extended it to be used with my PayPal or Ebay accounts.  I ALWAYS have my handy iPhone nearby, so I immediately downloaded the app, activated it, and tied it to my PIP account.  It worked like a charm.  Next is setting it up with paypal, ebay, etc.

Anyone else have experience with these virtual tokens?  Any cons that I should be aware of?

Tweet This Post Digg This Post Facebook

I’m also trying to figure out all of this social media stuff (Twitter, Facebook, Yammer, etc), and how that might all fit in here.  If you have any suggestions, I’m all ears!

Tweet This Post Digg This Post Facebook

I’ve been lucky in my career. I’ve worked with terrific sales people, and had very few occasions where they made a promise we couldn’t deliver on.  Here are the things I think they’ve done well:

1. They communicate with Implementation (and possibly Support) during the sales process.  This is particularly important if they are new to the company, or the product.  If there is something they are unsure about, they should always check with Implementation/Support before agreeing it can be done.  This also includes handing over any information they may have already discovered.  Customers hate being asked for the same information twice.
2. They set customer expectations.  This really just boils down to the fact that they don’t make promises the delivery team can’t deliver on.  They give of an overview of the implementation process as well as the philosophy behind it.  This lets the customer know exactly what to expect at kickoff.
3. They aren’t afraid to say “no”.  This goes back to setting expectations, and not promising something that can’t be delivered on.

I also want to add one more thing that isn’t really a quality of the person.  As Rod pointed out in his comments, a technical sales person should report to services rather than sales.  This keeps his/her interests aligned with services, and thus, helps ensure they strive for sales that lead to successful implementations.

Are there other things to add to this list, or maybe some things you don’t think are as important?  Please leave any feedback in the comments.

Tweet This Post Digg This Post Facebook

Obviously you need people who can close deals and bring revenue to the company.  Any technical sales person should have technical aptitude, and be honest and personable.  What other qualities should they have?

Please leave your thoughts in the comments.  I’ll post my opinion later this week.

Tweet This Post Digg This Post Facebook

To give a brief overview, a POC (Proof of Concept), at least in my experience, basically consists of a sales guy, and a sales engineer.  They spend a couple of days with a client, and build a solution to prove they can integrate with the customer’s technology.  Ash came up with 3 major complaints:

1. A typical POC is just a glorified demo.
2. The success of the post-POC demo is highly dependent on 2 individuals on the vendor team: the Sales Engineer (the guy who duck-taped together the POC) and the POC-demo-guy
3. A POC is typical technology focused. Most IdM deployments are business process centric.

I have a 4th and major complaint, coming from the point of view of a integrator who must implement the solution after the deal has been sold:

POCs typically stretch the system to its technical limits, and are able to do so because they are built in a very controlled environment.  When it comes time to scale, the demoed solution won’t work. This leads to unreasonable expectations.

This can create a lot of problems for the consultant/engineer implementing the final solution.  I consider one of my most important jobs to be managing the customer’s expectations.   A typical overly elaborate POC make this job extremely difficult.

The sales folks may not realize it, but the customer remembers more about the POC than you think.  They remember how pretty the screens were.  They remember how seamlessly all the pieces fit together, and how quickly each task executes.  What they don’t realize is that all of the data is massaged and simplified.  Of course the POC could do these things!  It has 3 users with 4 roles to choose from, and doesn’t include any of the “exceptions” often found in the customer’s environment.  When it comes time to actually implement this feature with 30,000 users things can (and do) get quite a bit more complex.

Has anyone else had bad experiences due to a POC?  If so, let us know by leaving a comment.

Tweet This Post Digg This Post Facebook

Identity management is the management of the identity life cycle of entities (subjects or objects). An identity management system:

1. Establishes the identity
   1. Links a name (or number) with the subject or object;
   2. Re-establishes the identity (i.e. links a new or additional name, or number, with the subject or object);
2. Describes the identity:
   1. Optionally assigns one or more attributes applicable to the particular subject or object to the identity;
   2. Re-describes the identity (i.e. changes one or more attributes applicable to the particular subject or object);
3. Destroys the identity

I also got a couple of comments from readers, including:

You help businesses be sure they know who is doing what with their computer systems.

and:

*Streamlining all user accounts (anyone who has 10 sets of ids at their workplace can relate to the benefit of this)
*being able to do a master reset on pw (save IT staff time)
*Being able to disable all accounts in one shot thus securing data from those who no longer should have access

Putting it all together, I’ve come up with the following pitch:

Identity Management solutions allow an organization to control and audit what its users can do.  This includes creating accounts for users when they are hired, modifying their accounts as they change jobs within the organization, and terminating a user’s access when they leave.  It also allows users to synchronize their password across the various computer systems they have access to.

Is there anything important I may have left out?  Is it simple enough for someone who isn’t technical to understand?

Tweet This Post Digg This Post Facebook

Any thoughts on a good pitch?  Put it in the comments.  I’ll post what I come up with on Friday (and I might even “borrow” from some of your comments).

Tweet This Post Digg This Post Facebook