Graph Ping Time with Microsoft LogParser

Found this cool little piece while searching for log parsers for a project.

ping -n 15 www.yahoo.com | logparser "SELECT TO_INT(REPLACE_STR(EXTRACT_VALUE(Text,'time',' '),'ms','')) AS Response INTO Ping.gif FROM stdin WHERE Text LIKE '%%Reply%%' GROUP BY Response" -i textline -legend off -chartTitle "Ping Times" -view

This is from Ken Shaefer’s blog from 2005!

Error 0135: Fan Failure

WARNING: There has been a recall on certain M90z and M70z all-in-one Lenovo systems due to a fire hazard.

Please visit CPSC for more information.

Glad this was documented on Lenovo’s site for the A70z (all-in-one) system.

They have other systems also and you can find them here:  http://support.lenovo.com/en_US/SupportSearchResults.page?searchText=fan+locations+based+on+POST+error+code

It specifies to review the “HMM” (Hardware Maintenance Manual) for the FRU to re-order.  The HMM can be found:  http://support.lenovo.com/en_US/guides-and-manuals/detail.page?LegacyDocID=TCTR-HMM

Fan locations based on POST error codes – ThinkCentre A70z

Symptom

A fan error occurs during POST but the user is unsure which of the three fan locations the error code references.

Affected configurations

The above symptom may occur on the following systems:

  • All ThinkCentre A70z

Additional Information:

Error Message
Fan # in BIOS
Physical Location
0135: CPU Fan fail Fan 1 Fan closest to CPU
0135: System Fan 1 fail Fan 2 Fan closest to HDD
0135: System Fan 2 fail Fan 3 Fan attached to planar cover
Solution

See the picture below for fan designations, System Board Fan – Fan2, CPUFan1, and SYSFAN1.

Refer to the HMM for correct FRU number and FRU replacement information.

 

Microsoft SQL Database-level Roles

Database-level role names

from http://msdn.microsoft.com/en-us/library/ms189121(SQL.100).aspx

db_accessadmin

Members of the db_accessadmin fixed database role can add or remove access to the database for Windows logins, Windows groups, and SQL Server logins.

db_backupoperator

Members of the db_backupoperator fixed database role can back up the database.

db_datareader

Members of the db_datareader fixed database role can read all data from all user tables.

db_datawriter

Members of the db_datawriter fixed database role can add, delete, or change data in all user tables.

db_ddladmin

Members of the db_ddladmin fixed database role can run any Data Definition Language (DDL) command in a database.

db_denydatareader

Members of the db_denydatareader fixed database role cannot read any data in the user tables within a database.

db_denydatawriter

Members of the db_denydatawriter fixed database role cannot add, modify, or delete any data in the user tables within a database.

db_owner

Members of the db_owner fixed database role can perform all configuration and maintenance activities on the database, and can also drop the database.

db_securityadmin

Members of the db_securityadmin fixed database role can modify role membership and manage permissions. Adding principals to this role could enable unintended privilege escalation.

 

In theory, a user who can do nearly everything but modify access and security permissions: