Saturday, July 9, 2011

Recommended method of installing PHP on IIS (using fast cgi IIS module)

http://learn.iis.net/page.aspx/247/using-fastcgi-to-host-php-applications-on-iis-60/


Choose the manual php zip method and configure the fast cgi to use the php.

Monday, July 4, 2011

בשורה לעצמאים ! תשלום מעמ אחרי קבלת הכסף ודמי אבטלה

סוף סוף הולכים בכוון הנכון נגד אפלית עצמאים ועסקים קטנים

למרות שדמי האבטלה עדיין לא משולמים מביטוח לאומי (אפילו שעצמאים מפרישים 16% לעומת 10% לשכירים) זה מראה צעד בכוון הנכון.

לינק לכתבה


Sunday, April 10, 2011

How to close all explorer windows in one click

A great util called nircmd lets you control many aspects of windows via command line:

http://www.nirsoft.net/utils/nircmd.html

download and create a batch file with this line -

nircmd.exe win close class "CabinetWClass"

Monday, March 28, 2011

Restoring an MSSQL DB but user can't log in (SQL Server authentication)

Very common and typical problem when using SQL server auth mode (instead of windows auth mode).

In MSSQL you have a server user entity that is mapped to a specific DB user entity.
When you restore a DB for the first time, you need to create an MSSQL user and map it to your DB's user.
When you restore a DB in the following times (not the first time), you just need to re-map the MSSQL user to the DB user.

Creating an MSSQL user is pretty straight forward - just go to the security node of the server (not of the DB) and create a user with the same name that you have in the DB.

Mapping/Re-Mapping the user can be done using this script (for example we will use the db "mydb" and user "myuser"):

USE mydb
GO
EXEC sp_change_users_login 'Update_One', 'myuser', 'myuser';
GO
EXEC sp_changedbowner 'myuser'
GO