Tuesday, July 17, 2012

Use Database Publishing Wizard tool in VS 2010

In Visual Studio 2010, "SQL Database Publishing Wizard" feature should be installed as one component named Microsoft SQL Publishing Wizard 1.4 during the installation.

It should be located at the path:  
C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Publishing\1.4\SqlPubWiz.exe

If not exist, you can extract the SQL Database Publishing Wizard tool in the WCU\SQLPub folder in the installation media and then try the installation of tool by clicking on the SqlPubWiz.msi file.

Friday, April 27, 2012

Fix 5 Common SEO problems using URLRewrite module and Web.config

There are an example code used to fix top 5 common problems for SEO, to get unique urls, improve ranking on Search Engine likes Google, Bing, Yaoo

This example is run on example.com

<rewrite>
                <rules>
                    <!--Fix 5 Common SEO problems using URLRewrite module and Web.config-->
                    <rule name="No-slash to slash">
                        <match url="http://example.com"/>
                        <action type="Redirect" url="http://example.com/" redirectType="Permanent"/>
                    </rule>
                    <rule name="www to non-www">
                        <match url="(.*)"/>
                        <conditions>
                            <add input="{HTTP_HOST}" pattern="^example\.com$" negate="true"/>
                        </conditions>
                        <action type="Redirect" url="http://example.com/{R:1}" redirectType="Permanent"/>
                    </rule>
                    <rule name="No Default.aspx" stopProcessing="true">
                        <match url="(.*?)/?Default\.aspx$"/>
                        <action type="Redirect" url="{R:1}/" redirectType="Permanent"/>
                    </rule>
                    <rule name="No .aspx" stopProcessing="true">
                        <match url="(.*?)\.aspx$"/>
                        <action type="Redirect" url="{R:1}.html" redirectType="Permanent"/>
                    </rule>
                    <rule name="Lower Case URLs" stopProcessing="true">
                        <match url="[A-Z]" ignoreCase="false"/>
                        <conditions logicalGrouping="MatchAll" trackAllCaptures="false">
                            <add input="{URL}" pattern="WebResource.axd" negate="true"/>
                        </conditions>
                        <action type="Redirect" url="{ToLower:{URL}}" redirectType="Permanent"/>
                    </rule>

                    <!--End Fix 5 Common SEO problems using URLRewrite module and Web.config-->
                </rules>
            </rewrite>

Place at between:
<system.webserver>
....
</system.webserver>


Lai

Tuesday, April 24, 2012

RESOLVED: The solutions for addition s1600 to image at Picasa

Recently, Picasa has changed their privacy and default size for images when you upload using API to be 512px. Mean of smaller than the original size of every images. Big problem, if your websites have embedded these images.

Picasa support give a solution like addition "s1600/Filename.jpg" instead of old name in every image urls. But I can't modify every post when my blog/websites have had more than hundreds or thousands post. Too much, to modify by hand :(

My solutions as the following hope to resolve this if you have same problems.

Solution 1: (update data in column containing image url by update query, tested for SQL Server)


update [e_Image] set
imageurl= replace(imageurl,reverse(left(reverse(imageurl), charindex('/', reverse(imageurl)) -1)),
's1600/'+ reverse(left(reverse(imageurl), charindex('/', reverse(imageurl)) -1))) 


Execute, and see the results.

Solution 2:  (use javascript to replace old file name with new name contain "s1600/" when page load)


This solution is coded  by youself. 


Lai.

Query to get FileName from URL (in SQL Server)

There are queries to get the file name from a column named: 'ImageUrl' containing list of image Url.

SELECT imageurl
  ,reverse(left(reverse(imageurl), charindex('/', reverse(imageurl)) -1)) as 'File Name'
 from [e_Image]

And result as the following: