Saturday, December 12, 2009

ENCRYPTING BUISNESS LOGIC IN THE BACK-END


Hi All,

Use the WITH ENCRYPTION Option in SQL Server when ever you want to hide the business- logic
in Views / Procedures / Functions. (Specially in Client sites when ever we use procedures).  
This is part of the application code, therefore please pay more attention to that.

Note : that you will not be able to regenerate the scripts from the server, if you use this option.

This is a sample

CREATE VIEW TEST
WITH ENCRYPTION
AS SELECT 'TEST' AS TI

populating one dropdown list according to the value of another dropdown list

Subject: populating one dropdown list according to the value of another dropdown list
  



Sunday, December 6, 2009

restart the IIS server from Bat File

@echo off
REM - File: iisrestart.bat
REM - Description: Restart's IIS (Web)
REM - Author: Thusith de silva from HBS
REM - ADD REM comments if you don't want to restart any
REM - of Services
echo Restarting IIS...
echo ======================================================
net stop "World Wide Web Publishing Service"
net start "World Wide Web Publishing Service"
echo ======================================================
echo IIS Restarted