Delete a Windows Service Using the Command Line Developing and debugging Windows Services in Visual Studio 2005 usually means creating setup projects to install and uninstall them. One of the quirks of using installers, however, is that sometimes the Windows service fails to uninstall.

Below is the manual way of deleting or uninstalling a Windows service using the command line in Windows Vista and XP. C:>sc delete [service name] The utility also has other functions relating to Windows Services. Check them out.

Advertisements

Music | Reviewing the Basix

November 26, 2009

Diving back into the basix of Music. . . great chance to review the fundamental make-up of sounds from the aspex of : notation/syntax, time signature, format.

Here’s a scanned copy of my notes. . . more will follow as I continue reviewing (and learning). So why the interest? Well I honestly grew up playing Brass (as 1st Slide Trombone) and played everything on the basis of slide placement and merely associating the notes by mere bi-produce of placement/sound/and visual placement of notes on the staff. You may laugh, but I could never tell you the difference between an A to Am on paper – only by playing. So I want to change that for (2) reasons.

I want to speak to what I’m playing in words, then the play/demonstrate approach. The other reason? So I can transition into the string-side of instruments. Particularly the Piano and Electric Guitar. Having both and not knowing how to play anything beyond chop stix or Mary-Had-A-Little Lamb disappoints me. I have wanted to play – the Mat Kearney, the Foo, and Ben Folds – for way to long, it’s time I learn to understand music once and for all.

Here’s to something new. . .    =    )

. . . and the update came sooner, than later. . .
I can now play the Mat Kearney Song ‘Chicago’ on the Piano.

  1. Verse (G, D, Am, and C) x 3
  2. Pre-Chorus : (G, D, Am) x 3 . . . then to C
  3. Chorus : (G, D, C) x 2
  4. Verse : (G, D, Am, and C) x 3
  5. Pre-Chorus : (G, D, Am) x 3 . . . then to C (repeat)
  6. Chorus (G, D, C) x 4
  7. Closing with G, D, Am, C

Look the lyrix up! And if you get a chance – catch one of his concerts. Just went to the HOB in San Diego (2) weeks back to watch him perform, along with opener – Vedera. Both artists will rock your sox off!

Enjoy    =   )    – J

It’s happening as we speak. . .  in email, fileshares, enterprise repositories, even social networks (FB or Twitter). People are exchanging data, information, ideas. And as we do – we likely give context, association, and meaning to user-to-user, or user-to-audience, collaboration. I’m talking about sharing data about data -> Metadata.

Facebook (FB) User ? A socially interactive form of metadata. Browse the People : status updates, friends/networks, pictures, and events. All the conversations, relationships, and interests are attributed to the content. Social metadata.

Business Scenario ? Glad you asked. If you’re delivering an email to your team you’re putting context around the message so the audience can understand what they have at the inbox : who is it from, the subject line, and what does the message body say about the attachment. All metadata? Kind of. Let’s break this down in a # of ways.

Information Breakdown

  1. Email Message – conversation from User to Audience
  2. Content – Metadata (who emailed it, subject, message body)
  3. Attachment – Unstructured Content (picture, excel file, etc)

These are all normal actions we understand and exercise on a daily basis.

Technology Breakdown

  1. Email Platform (lotus, exchange, gmail)
  2. Data Repository (hard drive, data file share, website)
  3. File Type (word, adobe, etc)

Fundamental compenents that make-up the communication process.

Now the big question. . . How would you manage that content : Delivery? Search? Share? Review the information breakdown(s) above and take a moment to think about it.

  1. How would I find a conversation buried in email? (Search by Sender, Subject line, or keyword and phrase)
  2. What about files that are stored on a team member’s workstation? What if he/she is out for the week on vaca? How will your team get that file, or know where it is?
  3. Welcome the new-hire. If he/she looks at a data file share they see a list of files and types. Where is that metadata, contextual meaning, and understanding? In those emails he/she never had.

You see how information breakdown works? Understand the technology layers involved? And how complex it is for users to retrieve the data about data?

That’s why I think solutions like Sharepoint will change the course for many users in the business environment. It enhances how we collaborate, centralizes the data, and helps that new user understand the data captured with context, association, and meaning. It changes our Technology Breakdown. Returning the purpose of email into a messaging system (not a content repository), you’re capturing metadata around a document (otherwise lost in email conversations that aren’t captured in the file repository), and the ability to find those and share those require pairing up emails with fileshare documents; there is no easy way to auto-connect the metadata and unstructured content (files) together.

Let’s take a document library for example. You have the ability to add columns (metadata categories) used to attribute characteristics to a document. (assuming the fields are required vs optional). When you upload documents into the library you are then requested to attribute the upload with context. (name, activity, strategic function, assigned to, versioning, etc). It’s no different than uploading a pix to a photo album on facebook, describing the album, adding captions to the pictures, and then tagging people in them.

In the instance that you’re a company uploading (tranferring) documents from a data fileshare, you are mostly applying a metadata framework with all your files. Think about how you’re storing content on the file share. You probably organize your folders by year, business area, projects, departments, etc. If you drill down through these folders to a particular file, take note of the folders you went through to find that file. If you want through something like this . . .

Customer > Operations > Department > Team > Project > Phase I > project_plan.pdf

Each Folder would be an example of a Sharepoint List Column you would create to translate the metadata principle into a function of filtering/sorting all files in a single list. I strongly encourage you to adopt this approach and DO NOT create folders in document library lists because you will cripple the intent and purpose of a sharepoint list in the first place.

You now have consolidation of content, captured metadata, and greater efficiency to finding (and learning) about the business you work in. And remember – It’s happening as we speak. . .  in email, fileshares, enterprise repositories, even social networks (FB or Twitter).

Think about how Sharepoint will help People exchange data, information,  and ideas. Embrace the technology and fabricate your collaboration framework into a solution that you can apply greater context, association, and meaning to collaboration. I’m talking about Sharepoint. Metadata. Folders vs Columns.

Another great article on metadata is with @maish at -> http://www.shareesblog.com/?p=199

– J. Wright

`10 Commandments to a Rave`

October 31, 2009

  1. Location, Location, Location – That’s Dead Right
  2. Carpe Diem
  3. It’s not where you’re from, it’s where you’re going
  4. Fear Nothing
  5. Send the word out to all that believe it
  6. Stand-Up. Make your voice heard
  7. Reject the Mainstream
  8. Never Fail
  9. Make the Music Beat. You can’t have a revolution if the music isn’t right
  10. It’s your choice. Find Your Own!

Thanx Deadmau5 & Kaskade – J

And couple more for all you Clubin’ MoFo’s!

Looking to consume SAS data via Sharepoint ? Look no further. SAS recently released v1.1 webparts for Microsoft Sharepoint. Allowing sharepoint site owners to present SAS Dashboards and Analytix on your site(s).

You have (2) webparts included :

  1. BI Dashboard Web Part
  2. Stored Process Web Part

If I understood the SAS Admin correctly, in order to use the BI Dashboard Web Part the company should own the SAS BI Dashboard Server. I would like to see this functionality and hear the advantages of this web part (e.g. drill downs, interactive behaviors, etc) since I do not have the luxury to try this.

However, the Store Procedure web part appears to be working great with the exception of one known problem – RSA Key Errors. Yet to determine if the issue is IIS or Sharepoint related. I’m not convinced this is not a SAS issue per se.

In the post-install config process you are instructed by SAS to modify key values in the webpartssetup.bat script which change the xml settings defined in the web.config file located at x:\inetpub\ . . * . . .\virtualdirectories\80 – After configuring the *.bat file, you execute it to the settings.

. . . Back to Sharepoint you pick/create your site collection – add your web part(s), modify shared webpart, and you should see the server settings reflected from the userdefined settings you defined for the web.config. In the web part control panel I choose an available web part and then exited edit page mode.

Over time. . . say daily . . . I try with a standard user account – to access the site and the web parts render an error saying :

An error occurred while attempting to access the Stored Process Web Application. Details : Failed to decrypt using provider ‘RsaProtectedConfigurationProvider’. Error message from the provider : The RSA key container could not be opened. (web.config line xyz)

 I’m not convinced that this is a SAS related issue, but how the RSA key is to contact Microsoft and decrypted the web.config settings? If our SAS admin touches the sharepoint site, he gets this error. If I used a sysadmin account to touch the sharepoint site – it seems to repair the underlining issue (again unknown) that will allow webpart(s) to stop failing. . . but tomorrow – back to the same error.

I’m scratching my head. . . Any thoughts SAS or Microsoft? Anyone?

Thanx – J

If you’re an administrator of BMC Service Desk Express 9.x , you might find these SQL Statements helpful for retrieving the following SDE ticket types.

–INCIDENT Type

SELECT COUNT(*) FROM _SMDBA_._TELMASTE_

–PROBLEM Type

SELECT COUNT(*) FROM _SMDBA_._PROBMGMT_

–CHANGE Type

SELECT COUNT(*) FROM _SMDBA_._CHANGE_

–WORK ORDER Type

SELECT COUNT(*) FROM _SMDBA_._WORKORD_

Expand upon the statements as you need to introduce JOIN or WHERE Clauses. . . The above will get you started anyway. If you need help – just ask.

Thanx – J

 

Incase you’re looking to find a value tucked within the database but can’t remember the table, let alone the field, you can introduce this ‘SEARCHALLTABLES’ stored procedure (see the following). It will take a search string as an input parameter, goes to search the following column types.

IMPORTANT NOTE : this will only search “ALMOST ALL” tables. It will search the tables that all users that have current access to the database. User created tables & System Tables are excluded from this procedure.

char, varchar, nchar – owned by ALL users within the current database. If you want to modify the DATA_TYPEs you can introduce those in the WHILE LOOP of the Stored Procedure.

Look for this –> AND DATA_TYPE IN (‘char’, ‘varchar’, ‘nchar’, ‘nvarchar’ , [new data type] )

Here’s the SQL Procedure

CREATE PROC SearchAllTables
(
@SearchStr nvarchar(100)
)
AS
BEGIN

CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630))

SET NOCOUNT ON

DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110)
SET  @TableName = ”
SET @SearchStr2 = QUOTENAME(‘%’ + @SearchStr + ‘%’,””)

WHILE @TableName IS NOT NULL
BEGIN
SET @ColumnName = ”
SET @TableName =
(
SELECT MIN(QUOTENAME(TABLE_SCHEMA) + ‘.’ + QUOTENAME(TABLE_NAME))
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = ‘BASE TABLE’
AND QUOTENAME(TABLE_SCHEMA) + ‘.’ + QUOTENAME(TABLE_NAME) > @TableName
AND OBJECTPROPERTY(
OBJECT_ID(
QUOTENAME(TABLE_SCHEMA) + ‘.’ + QUOTENAME(TABLE_NAME)
), ‘IsMSShipped’
       ) = 0
)

WHILE (@TableName IS NOT NULL) AND (@ColumnName IS NOT NULL)
BEGIN
SET @ColumnName =
(
SELECT MIN(QUOTENAME(COLUMN_NAME))
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = PARSENAME(@TableName, 2)
AND TABLE_NAME = PARSENAME(@TableName, 1)
AND DATA_TYPE IN (‘char’, ‘varchar’, ‘nchar’, ‘nvarchar’)
AND QUOTENAME(COLUMN_NAME) > @ColumnName
)

IF @ColumnName IS NOT NULL
BEGIN
INSERT INTO #Results
EXEC
(
‘SELECT ”’ + @TableName + ‘.’ + @ColumnName + ”’, LEFT(‘ + @ColumnName + ‘, 3630)
FROM ‘ + @TableName + ‘ (NOLOCK) ‘ +
‘ WHERE ‘ + @ColumnName + ‘ LIKE ‘ + @SearchStr2
)
END
END
END

SELECT ColumnName, ColumnValue FROM #Results
END

Once the STORED PROC is created you can execute the following . . .

EXEC SearchAllTables ‘[search string]’
GO

 

Aiming to reduce fat, gain muscle, and earn endurance this summer. With rowing on the mon-wed-saturday schedule, I needed an alternative, low-impact sport on the off-row days.  I’ve decide to start at 10+ miles  per/off-row days for the next (2) weeks before I bump the distance at increments of (2) per week following – until I can sustain a 50+ miles per/off-row day ride. A cake-walk for some, but I don’t want to burn out too early.

So here’s the plan. . . and hold me to it.

  • Cycle = (mi)les
  • Row = (m)eters

July 7th – 1st Run (mapped route)

1st wk

  • Jul 13th – 8,500 m (R)
  • Jul 14th – 8+ mi (C)
  • Jul 15th – 8,500 m (R)
  • Jul 16th – 10+ mi (C)
  • Jul 17th – Relax
  • Jul 18th – 10,000 m (R)

2nd wk

  • Jul 20th – 10,000 m
  • Jul 21st – 10+ mi
  • Jul 22nd – 10,000 m
  • Jul 23rd – 10+ mi
  • Jul 24th – Relax
  • Jul 25th – 10,000 m
  • Jul 26th – 10+ mi

 3rd wk

  • Jul 27th – 10,000 m
  • Jul 28th – 12+ mi
  • Jul 29th – 10,000 m
  • Jul 30th – 12+ mi
  • Jul 31st – Relax
  • Aug 1st- 10,000 m
  • Aug 2nd – 12+ mi

4th wk

  • Aug 3rd – 10,000 m
  • Aug 4th – 12+ mi
  • Aug 5th – 10,000 m
  • Aug 6th – 12+ mi
  • Aug 7th – Relax
  • Aug 8th – 10,000 m
  • Aug 9th – 12+ mi

5th wk

  • Aug 10th – 10,000 m
  • Aug 11th – 12+ mi
  • Aug 12th – 10,000 m
  • Aug13th – 12+ mi
  • Aug14th – Relax
  • Aug 15th – 10,000 m
  • Aug 16th – 12+ mi

6th wk

  • Aug 17th – 10,000 m
  • Aug 18th – 14+ mi
  • Aug 19th – 10,000 m
  • Aug 20th – 14+ mi
  • Aug 21st – Relax
  • Aug 22nd – 10,000 m
  • Aug 23rd – 14+ mi

.

.

.

.

and so on – – – I may increase the pace of distance if the goal doesn’t seem challenging enough.

 

<iframe src=”http://js.mapmyfitness.com/embed/blogview.html?r=263f198eec64121b9b16c7e876033d57&u=e&t=ride” height=”700px” width=”100%” frameborder=”0″><a href=”http://www.mapmyride.com/ride/united-states/ks/-lenexa/903124775734563169″>07/16/2009 Route</a><br/><a href=”http://www.mapmyride.com/find-ride/united-states/ks/-lenexa”>Find more Bike Rides in  Lenexa, Kansas</a></iframe><!– MMF PARTNER TOOL –>

I recently spoke with a Sharepoint Admin (Justin) from Transatlantic RE (transre.com) regarding a migration issue of content within any type of sharepoint list containing a field using “People or Group” type data. A value entered into this field is validated against WinAD which can be in the format of inital, name, sid, or email.

Justin mentions a problem in that the list, for example a project task list, contains this field called Assigned-To that takes the “People & Group” value type. In the process migrating from one site collection to another using the export/import method the list field is empty. (see below)

  • stsadm -o export -url -filename [file name]
  • stsadm -o import -url [destination url addy] -filename [file name]

After trying the above steps, I achieved the same problem; no value was retained during the above migration steps.

The only option I found feasible was the backup/restore methods what retains the list values for the individual(s) assigned within the list. Use these commands . . .

  • stsadm -o backup -url -filename [file name]
  • stsadm -o restore -url [destination url addy] -filename [file name] -overwrite

To understand when to use export/import vs backup/restore logic, look here : http://sharepointcoding.wordpress.com/2009/03/17/moss-2007wss-30-backup-restore-limitations/