Getting WordPress installed on windows 8

September 4, 2013

I started of using the web platform installer, it installs everything so even though it says can’t find MySql server don’t worry it will install it as part of the process.

I then got this error.

HTTP Error 500.21 – Internal Server Error

Handler “PHP54_via_FastCGI” has a bad module “FastCgiModule” in its module list

I installed CGI

HTTP Error 500.0 – Internal Server Error

File monitoring is enabled for a file which could not be found

I then enabled 32bit Applications in the Advanced Settings of the application pool.


And I was then able to finish the install by going to:

http://localhost/wordpress/wp-admin/install.php


Encrypting connection strings

June 27, 2013

aspnet_regiis -site “SiteName” -app “/” -pe “connectionStrings”


Log Parser studio

June 24, 2013

Uses log parser 2.2 to query your iis log files

http://gallery.technet.microsoft.com/office/Log-Parser-Studio-cd458765


Reserved properties in msbuild 4.0

May 30, 2013

http://sedodream.com/2010/03/11/MSBuild40ReservedProperties.aspx

MSBuild
•    MSBuildBinPath
•    MSBuildExtensionsPath
•    MSBuildExtensionsPath32
•    MSBuildExtensionsPath64
•    MSBuildLastTaskResult
•    MSBuildNodeCount
•    MSBuildOverrideTasksPath
•    MSBuildProgramFiles32
•    MSBuildProjectDefaultTargets
•    MSBuildProjectDirectory
•    MSBuildProjectDirectoryNoRoot
•    MSBuildProjectExtension
•    MSBuildProjectFile
•    MSBuildProjectFullPath
•    MSBuildProjectName
•    MSBuildStartupDirectory
•    MSBuildThisFile
•    MSBuildThisFileDirectory
•    MSBuildThisFileDirectoryNoRoot
•    MSBuildThisFileExtension
•    MSBuildThisFileFullPath
•    MSBuildThisFileName
•    MSBuildToolsPath
•    MSBuildToolsVersion

 


MSBuild at sign and dollar sign and percentage sign

May 14, 2013

I found this great article that describes how these symbols works in Msmbuild

http://rationalgeek.com/blog/msbuild-propertygroup-itemgroup-item-metadata-and-crazy-syntax/

 


Searching all your functions and stored procedures

March 1, 2013

I found the INFORMATION_SCHEMA.ROUTINES truncates the data.

This however does the trick

select OBJECT_NAME(id) from sys.syscomments

where [text] like ‘%YourSearchString%’


Getting statistics on SQL queries for optimization

February 28, 2013

CHECKPOINT;
GO
DBCC DROPCLEANBUFFERS;
GO

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

SET STATISTICS TIME ON


Follow

Get every new post delivered to your Inbox.