Author: joe

Get the Old Chrome Bookmark Manager Back

May 14, 2015 /

Get the Old Chrome Bookmark Manager Back

The newest version of Chrome features a fancy new bookmark manager and interface that’s all about thumbnails. If you’re not a fan of that snazz, Techdows points to a flag you can switch to get the old interface back.

Getting the old interface back is easy:

  1. Head to chrome://flags/#enhanced-bookmarks-experiment
  2. Change the setting to “Disabled” and click “Relaunch Now”

That’s it, when Chrome reopens, you’ll be back to the old view.

From: Lifehacker

How to Remove Auto-Publish from Excel Documents

February 11, 2015 /

How to Remove Auto-Publish on Excel 2007

by Kirk Bennet, Demand Media

You can use Microsoft Office Excel 2007 to create documents for Web publication. Excel also comes with an option to automatically publish the document whenever you change it. However, there are cases where you may not need the auto-publish feature, so you need to disable this feature. To accomplish this, you must save the document to get access to the auto-publish setting where you can disable it. You can also disable auto-publish for all other documents you have published in the past.

Step 1Launch Microsoft Office Excel 2007 and open the spreadsheet you want to remove the auto-publish feature from.

Step 2Click the “Office” button in the top-left corner of the Excel 2007 window.

Step 3Click “Save As” in the resulting menu.

Step 4Select “Web Page” in the Save As Type drop-down box.

Step 5Click “Publish” and the Publish As Web Page window pops up.

Step 6Remove the check-mark from the “AutoRepublish Every Time This Document Is Saved” option in the Publish As section to remove the auto-publish feature.

Step 7Click “Choose” and select “Previously Published Items” to start disabling auto-publish for more documents.

Step 8Select each document with the feature still active and click the “Remove” button.

Step 9Click “Close” to close the window.

Step 10Press “Ctrl” and “S” to save your spreadsheet.

 Tip
  • Select the “Enable AutoRepublish Feature” when you publish the workbook to enable the auto-publish feature.

Reproduced from http://smallbusiness.chron.com/remove-autopublish-excel-2007-40236.html

SQL Conditional Record Update

February 4, 2015 /

A Visual Basic example on how to update a record if it exists or insert it if it doesn’t.

Sub RecordStandardizedComputer(WS As String)
  Dim txt1 As String, txt2 As String, txt3 As String
  Dim xSQL As String

 txt3 = "SELECT ComputerID from LOG_ComputersStandardized" _
 & " where ComputerName = " & WS

 txt2 = "INSERT INTO LOG_ComputersStandardized (ComputerName, RunTime)" _
 & "VALUES (" & WS & "','" & Now.ToString & "')"

 txt1 = "UPDATE LOG_ComputersStandardized SET " _
   & " DateTime = '" & Now.ToString & "'" _
   & " WHERE ComputerName = '" & WS & "'"

 xSQL = "IF NOT EXISTS (" & txt3 & ")" & txt2 & " ELSE " & txt1
  ExecuteSqlCommand(xSQL)
  End Sub

Windows 7 taskbar not responding

December 29, 2014 /

Click Start

Type: CMD, from the results, right click CMD

Click ‘Run as Administrator’

At the Command Prompt, type: sfc/scannow

This will check for any integrity violations

Restart your system

  1. Insert the Windows 7 DVD
  2. Restart your computer
  3. When asked if you want to boot from your DVD drive, do so.
  4. Choose your language, click Next.
  5. Click ‘Repair your computer’
  6. Select operating system you want repair.

LDAP Active Directory User Object Properties/Attributes

July 28, 2014 /
LDAP Active Directory Properties/Attributes
LDAP Property Description
DN DN Stands for distinguisehd name. This is the unique identifier for any object in AD. An example value would be:

CN=Joe User, OU=Las Vegas, DC=mycompany,DC=com

Note that when identifying a DN value in your script you will likely be required to enclose the line above with double quotes (“) so it would look like this:

“CN=Joe User, OU=Las Vegas, DC=mycompany,DC=com“
CN CN = Joe User
CN stands for Common Name. This property is a combination of the givenName and SN attributes joined together
displayName displayName = Joe User
Note that displayName and CN are often confused for each other.
description Note that this is different from displayName
givenName The first name of the user
homeDrive Home Folder
name name = Joe User. The same as CN
ObjectClass objectClass = User
Identifies what type of object is selected. Other values are: Computer, orgnizationalUnit, container, group
objectCategory objectClass = Person
Defines what schema category that object belongs to.
physcialDeliveryOfficeName The office field of the user property
profilePath Roaming profile path: connect. Setup is a bit tricky
sAMAccountName sAMAAccountName = jUser
This is an old NT 4.0 logon ID. This value must be unique in the domain.
SN SN = User
This is the last name of the user. SN stands for surname
userAccountControl This property is used to enable or disable a user account. A value of 514 means that account is disabled. A value of 512 means the account is enabled.
userPrincipleName userPrincipleName = juser@lasvegas.com
This property is useful for logging in a large forest Active Directory architecutre. This is also a unique property throught the forest. This property is often abbreviated as UPN.
mail mail = juser@lasvegas.com
the email property of the user
C Country or Region
company Name of Company or Organization
department Department
homephone
l Location. Used mainly with printers
That is a lower case (L)
manager
mobile Cell phone or mobile phone number
OU Orgnizational Unit
postalCode Zip or post code
st State or province
streetAddress Street address, not including country or state
telephoneNumber Office Phone
dNSHostName
rID
url
uSNCreate
uSNChanged
tokenGroups A computed attribute that contains the list of SIDs due to a transitive group membership expansion operation on a given user or computer. Token Groups cannot be retrieved if no Global Catalog is present to retrieve the transitive reverse memberships.

More Info

.NET Active Directory – Understanding LDAP Active Directory User Object Properties/Attributes.