Archive for June, 2009
SQL Server Agent issue – delay_between_response attribute (10 sec) of alert (9) is less
Posted by Mitch in Database, Network Admin on June 18, 2009
Agent was stopped so performance plan wasn’t running. Errors in Agent Log: delay_between_response attribute (10 sec) of alert (9) is less than poll interval for this alert (20 sec) Research led to http://www.sqlservercentral.com/articles/Administration/3177/ and CTRL+A copy/pasted the solution into notepad. Changed this registry key: EventLogPeekInterval from hex 14 to hex a which in decimal equals [...]
Blue Screen flashes too quick for me to read it!
Posted by Mitch in Network Admin on June 15, 2009
I had a computer that was blue-screening with a flash of a message that was way too quick to read. First thing I did was to whip out a digital camera with Video capability. I recorded the screen flash and then played it back and paused on the message. In my case it said “Unmountable [...]
Extract a Hyperlink from a Cell in an Excel Spreadsheet
Posted by Mitch in Internet, Web Development on June 9, 2009
Sometimes you might copy a group of links from the internet and want to get the underlying URL to save in a database or something. In order to get Excel to give up the URL you’ll have to use a Macro. Below is a function that you can include in your spreadsheet to extract the [...]