Enabling Pretty Permalinks in WordPress

This walkthrough describes how to enable “Pretty Permalinks” for blog posts in the WordPress blog engine that is installed on IIS 7 and above. Typically, without URL rewriting functionality on a Web server, WordPress users must use “Almost Pretty” URLs, for example, http://contoso.com/index.php/yyyy/mm/dd/post-name/. By using the URL Rewrite module, you can use “Pretty Permalinks,” for example, http://example.com/year/month/day/post-name/, for WordPress blogs that are hosted on IIS.Prerequisites This walkthrough requires the following prerequisites: IIS 7 or above with FastCGI and PHP installed. If you need to install PHP, follow the instructions in this article.WordPress installed. If you need to install WordPress, follow …

Continue Reading

Sendy.co

Send newsletters, 100x cheaper. Sendy is a self hosted email newsletter application that lets you send trackable emails via Amazon Simple Email Service (SES). Complete with reports, subscriber and list management. Amazon SES allows you to send authenticated bulk emails at an insanely low price (just 10 cents per THOUSAND emails). Compared to other emailing services, Amazon SES is 100x cheaper (or more), yet with no loss of quality in terms of deliverability. www.Sendy.co

Continue Reading

Change product key in windows server 2012 or windows 8

1. Use slmgr Open an elevated command prompt and type the following commands: slmgr -upk This will remove the key first slmgr -ipk xyzyx-xyzyx-xyzyx-xyzyx-xyzyx This will add your key. Of course replace the xyzyx-xyzyx with your own real key. Activate Windows (you will probably have popups already during this process) 2. Use slui.exe Swipe in from the right edge of the screen, and then tap Search. Or, if you are using a mouse, point to the lower-right corner of the screen, and then click Search. In the search box, type Slui.exe 0x3. Tap or click the Slui.exe 0x3 icon. Type …

Continue Reading

SQL Server, Common Table Expressions

A common table expression (CTE) can be thought of as a temporary result set that is defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. A CTE is similar to a derived table in that it is not stored as an object and lasts only for the duration of the query. Unlike a derived table, a CTE can be self-referencing and can be referenced multiple times in the same query. A CTE can be used to: Create a recursive query. For more information, see Recursive Queries Using Common Table Expressions. Substitute for a …

Continue Reading

Recursive Queries using Common Table Expressions (CTE) in SQL Server

Given the example , hierarchical data structures, organizational charts and other parent-child table relationship reports can easily benefit from the use of recursive CTEs. Common Table Expression is just one of those T-SQL enhancements available for SQL Server 2005. CTEs bring us the chance to create much more complex queries while retaining a much simpler syntax. They also can lessen the administrative burden of creating and testing views for situations where the view will not be reused. Syntax Sample (from Root nodes to Leaf  noes) Sample (From Leaf nodes to Root nodes), where u must specifie the leaves to include/use. !Importante …

Continue Reading