Showing posts with label of. Show all posts

Sunday, March 1, 2015

SQL Server Message 6260 system overflowexception because of arithmetic overflow error caused by divison by 0

One of my C# SQLCLR table valued function started to throw an exception with some recently added data to the database:

SQL Server Message 6260
system.overflowexception Arithmetic Overflow

How-i-fixed-it:
It turned out to be caused by a divison by 0 happening at runtime because of bad records in the data. I added some code to check for this which fixed the problem of the arithemtic overlow.

Export parts of Firefox bookmarks to HTML or Trac

After searching around on the web for a while, i decided to write my own little conversion tool to export only parts of my firefox bookmarks, e.g. subfolders, to a HTML-File or in TRAC format.
Heres how i did it:
I added the OPML Addon to my firefox: https://addons.mozilla.org/de/firefox/addon/2625
I exported my bookmarks to an OPML-File, which is just XML.
Next i create a little XSL-Stylesheet that converts the OPML to the desired format.
To convert OPML to TRAC links the XSLT looks like this (OPML2TRAC.xsl):


<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
 <xsl:output method="text" encoding="utf-16"  media-type="text/plain" omit-xml-declaration="yes" indent="no"/>
 <xsl:variable name="exportRootFolderName">PlaceTheNameOfYourSubfolderHere</xsl:variable>
 <xsl:template match="/">
   <xsl:for-each select="//outline[@text=$exportRootFolderName]">
     <xsl:call-template name="outlineConvert"></xsl:call-template>
   </xsl:for-each>
 </xsl:template>
 <xsl:template name="outlineConvert">
   <xsl:for-each select="outline[@url != ]">
     <xsl:sort select="@text" />[<xsl:value-of select="./@url" disable-output-escaping="yes"/><xsl:text> </xsl:text><xsl:value-of select="./@text"/>]<xsl:text>
</xsl:text>
   </xsl:for-each>
 </xsl:template>
</xsl:stylesheet>

To convert OPML to HTML links the XSLT looks like this (OPML2HTML.xsl):


<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
 <xsl:output method="html" encoding="utf-16"  media-type="text/html" omit-xml-declaration="yes" indent="no"/>
 <xsl:variable name="exportRootFolderName">PlaceTheNameOfYourSubfolderHere</xsl:variable>
 <xsl:template match="/">
   <xsl:for-each select="//outline[@text=$exportRootFolderName]">
        <xsl:call-template name="outlineConvert"></xsl:call-template>
   </xsl:for-each>
 </xsl:template>
 <xsl:template name="outlineConvert">
   <html>
     <body>
       <h2>My Bookmarks</h2>
       <table border="1">
         <xsl:for-each select="outline[@url != ]">
           <xsl:sort select="@text" />
           <tr>
             <td>
               <a>
                 <xsl:attribute name="href">
                   <xsl:value-of select="./@url"/>
                 </xsl:attribute>
                 <xsl:value-of select="./@text"/>
               </a>
             </td>
           </tr>
         </xsl:for-each>
       </table>
     </body>
   </html>
 </xsl:template>
</xsl:stylesheet>

Replace the "PlaceTheNameOfYourSubfolderHere" value with the name of the Subfolder of your firefox bookmarks.

In the head of the OPML-File insert the reference to the XSL-File:


<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="opml2trac.xsl"?>
<opml version="1.0">
... Rest of the OPML file ...

Open the OPML in Firefox or Internet Explorer now. You should then see the converted result.

You can also use a XSLT-Processor, e.g. MSXSL to do the conversion.

How to change the name of a network connection in Windows 7

Windows 7 automatically names network connections like Connection 1 etc. I want to assign a name to the network connection myself, but theres no context menu or link in the network and share center. How i fixed it: Click on the network type symbol next to the name of the network at "Active Networks" in the network and share center. A dialog box opens to allow entering a name for the network and to choose the symbol to be displayed. Here are the screenshots for my german OS:

Click on the network symbol to open the dialog:

Nokia Lumia 920 WindowsPhone 8 WP8 Battery drain because of background tasks

Over the last days, the battery of my Lumia 920 was empty much faster than i was used to. Usually it lasted y couple of days, but now its empty after 1 day.

How-i-fixed-it:
I found the right hints here: http://answers.microsoft.com/en-us/winphone/forum/wp8-wpupdate/lumia-920-battery-issues/94655503-118c-4dfe-b433-08c23b8140c6

I fixed it by disabled a couple of background tasks. I also found out, that some of those Background tasks were added by recently installed apps.

Go to Settings->Apps->Background Tasks to see the list of apps that work in the background and choose the ones the disable.

Auf Deutsch:
Der Akku meines Nokia Lumia 920 wird schnell leer aufgrund von aktiven Hintergrundanwendungen.

What to do for iPhone 5 and 4S random drop of network and data signal connection

iPhone loosing network and data connection: Many of iPhone 5 and 4S users are suffering from random loss of call network and data service. An iphone suffering from the issue in context will suddenly find feature e.g. call, SMS, and 3G Internet facility non-functional, even though shown signal quality/strength may be good.

The issue may be with SIM cards; some people have reported success after disabling a SIM PIN, or else changing cards. Few user has eliminated the glitch by doing a full restore of their device.

Apple is though aware of errors, and working with carriers provider on the error. The firmware was, for instance, supposed to fix other issue like recurring battery life problems, but these have continued for some users even as other people have had them solved.

According to few user, the root cause for the reception issue may lie with the way the SIM Card is aligned on the SIM tray.
One way to overcome this is to disable the SIM PIN. Go to Settings > Phone Menu > Turn SIM PIN off.
Try Toggling Airplane mode. Or Turn your phone off, then wait five minutes, then turn your phone back on again, then wait five more minutes and try using it as normal.

Hope these steps might have helped you.

Automatic Batch Rebuild of Adobe Acrobat Index Files

If you create an index of Adobe Acrobat files for fast searching, you may want to create a scheduled task that updates the index every night.
Adobe didnt have any pages that told me what should be in the BPDX file, but after some serious googling I was able to find a sample.

Here is a sample:

#--------------BatchUpdateCertIndex.bpdx------
c:Document ArchivesMy Index.pdx /rebuild
#-----------------------------------------

When I call the BPDX file from Task Scheduler I use this command line:
"C:Program Files (x86)AdobeAcrobat 10.0AcrobatAcrobat.exe" "c:scriptsBatchUpdate.bpdx"

Acrobat will not close on its own, but since I run this every night on a server, I just leave it running and it fires off again the next day in the same dialog box without opening new sessions.

This is the Help (or lack of it) from the Adobe Website on how to use the BPDX:

Use the Catalog feature and a catalog batch PDX file (.bpdx) to schedule when and how often to automatically build, rebuild, update, and purge an index. A BPDX file is a text file that contains a list of platform-dependent catalog index file paths and flags. You use a scheduling application, such as Windows Scheduler, to display the BPDX file in Acrobat. Acrobat then re-creates the index according to the flags in the BPDX file.

For more information on scheduling an indexing update, search for BPDX at www.adobe.com/support.

Note: To use BPDX files, in the Preferences dialog box under Catalog, select Allow Catalog Batch Files (.bpdx) To Be Run.

How can i change move re locate the local temp folder of Microsoft OneDrive Skydrive to a different location

I wanted to move the local temp folder of OneDrive to a different harddrive on my computer.

How-I-fixed-it:

I found the right hints here: http://answers.microsoft.com/en-us/onedrive/wiki/sdoptions-sdfileset/change-the-onedrive-folder-location/147dade2-830b-46ee-bf7e-36a8eab9446a

Change the OneDrive Folder Location

Technical Level : Basic

Summary

Learn how to change the OneDrive folder location. This is useful if you have a limited storage capacity main drive but a separate storage drive and you want your OneDrive content synced to the separate drive. This is not for OneDrive for Business.

Details

Many people use two separate drives on their computers: a main drive like an SSD to run the operating system and other programs, and a regular hard drive to store the bulk of their content. OneDrive defaults to the C:UserOneDrive location, however you can change it wherever you want.

Change the OneDrive Location in Windows 8 and Previous

To change the OneDrive folder location in Windows 8 and previous versions, you have unlink OneDrive from your account and then repeat the setup process:

Right-click on the OneDrive icon in the notification area and then select Settings
Select "Settings" and then select "Unlink OneDrive"
Follow the setup process again and ensure to select the new drive or location to have OneDrive sync to; you must wait for your files to download again to the new location

Please note: if youve connected your Windows 8 user account with your Microsoft account, OneDrive wont let you unlink the application. Youll have to unlink your Microsoft account from your Windows account first.

Change the OneDrive Location in Windows 8.1

To change the OneDrive folder location in Windows 8.1, you can simply change the location directly through the Properties menu of the OneDrive folder:

Open File Explorer, right-click on the OneDrive folder in the navigation pane (left-hand side), and then select Properties
Click the "Location" tab and then select "Move"
Select the location where you want OneDrive to sync to and then click OK

OneDrive will move all of your OneDrive files from the default location to the new location; you dont have to wait for files to download again.

Fix Computer Blue Screen of Death With My Way

Blue Screen of Death is a problem that often - often encountered in Windows XP operating system. Perhaps many thought when a computer is exposed to the BSOD we need to reinstall the operating system and some have had to buy a new computer. whereas many ways to fix the BSOD. Although usually BSOD problems most often encountered in the software, but there are less problems in the hardware related BSOD. And maybe this is some of my tips to avoid BSOD:

1.Check that minimum amount of free space available on your Windows partition (C :) is usaually. Blue Screen of Death can happen if there is not enough free space on your Windows partition.

2 Run anti-virus and anti-spyware. You should run your Adware program to check that your computer is clean of adware or spyware Some viruses can cause a Blue Screen of Death, especially those that infect the master boot record (MBR) or boot sector. Anti-virus software you have to be up to date at all times.

3.Update Windows. Microsoft released patches and service packs for the operating system they may contain fixes for the cause of the Blue Screen of Death. Missing updates can be a source of error stopped.

4.Check driver. Update drivers for your hardware, because of the high percent of Blue Screens of Death is a hardware or driver related so that a driver update can fix the cause of the STOP error. If you have recently updated a driver, you may be able to use the driver rollback to return to the previous driver version.

5.Return hardware settings to default in the Device Manager. Unless you have a specific reason to do so, the system resources that a single piece of hardware is set up to use the Device Manager should be set to default. Non-standard hardware settings can cause a Blue Screen of Death.

6.Check BIOS. Load BIOS default values. One of the BIOS settings can cause resource conflicts and timing issues. Maybe you need to update the BIOS after adding new hardware can help to fix your PC. A BIOS overclock or not properly configured can cause all kinds of random issues, including BSODs. In this case you need to revert to the default BIOS.

7 Repair your Windows Registry. Run the registry cleaner software to scan the registry, and fix errors. Blue screen error can be related to Windows registry problems. Blue Screen of Death can be caused by, invalid registry entries that are broken and dangerous.

8.Check all internal cables, cards, and other components. They need to be installed and seated properly. Hardware that is not securely in place may cause a Blue Screen of Death so try reseating the following and then examine the STOP message again:
Replace all internal data and power cables
Replace the memory module
Replace any expansion cards

9.Run memory test to check your computers RAM. Memory errors can cause a BSOD, so see if your RAM is error free. Vista and Windows 7 have a built-in option to test memor

Windows blue screen fix