Archive

Archive for August, 2015

Install WordPress on Windows

August 29, 2015 Leave a comment

Install WordPress from below link

 

http://www.microsoft.com/web/wordpress/

 

You can also download it from Microsoft Web Platform Installer

 

image

Categories: Uncategorized

BULK Insert from text file

August 23, 2015 Leave a comment
CREATE TABLE #_txtrow  (_txtrow varchar(5000));


BULK INSERT #_txtrow From 'H:\ApacheCassandra\Monitoring\OutputLog\compactionstats\192_168_0_45\9.txt' 
WITH(DATAFILETYPE = 'char',ROWTERMINATOR = '\n');

SELECT * FROM #_txtrow

DROP TABLE #_txtrow
Categories: T-SQL-Scripts

Setting up PowerShell Remoting using winrm quickconfig or Enable-PSRemoting fails

August 1, 2015 Leave a comment

 

PowerShell Remoting configuration will fail because the system is connected to a public network. The advice is to change the network from public to private, unfortunately this is not always possible because of WiFi connections.

 

image

 

Resolution

Enable-PSRemoting -SkipNetworkProfileCheck -Force

 

image

Categories: PowerShell