SCOM : Logical Disk Free Space Monitor

To Change the Logical disk threshold value

Please check this below url

http://blogs.technet.com/b/jonathanalmquist/archive/2009/04/04/logical-disk-free-space-monitor.aspx

ASP.NET - MaintainScrollPositionOnPostback

The MaintainScrollPositionOnPostback page directive attribute allows to do that.

This feature is useful for large pages where scrolling is necessary to view input controls down further on the page.

There are three ways of applying the property to a web page.

1. You can set it programmatically
   Page.MaintainScrollPositionOnPostBack = true;
2. In the page declaration
   <%@ Page MaintainScrollPositionOnPostback="true" %>
3. Or in the web.configs <system.web> section.
   <pages maintainScrollPositionOnPostBack="true" />

This feature is an absolute must-have on large web pages built for postback scenarios.

A simple but very useful feature.

Smartnavigation = true  implemented the same feature in 1.1 framework 

SQL : Query for View SQL License Information

select SERVERPROPERTY('Edition') as [Edition],
SERVERPROPERTY('LicenseType') as [License Type],
SERVERPROPERTY('NumLicenses') as [# of Licenses]

QlikView Error : Access denied! The server (QVS) has no USER CAL for your account. Please contact your system administrator!

Error :
QlikView Error : Access denied! The server (QVS) has no USER CAL for your account. Please contact your system administrator!

Solution
Goto QMSC -> Document -> User Documents -> Select the document -> Document CALs -> Check the Allow Dynamic CAL Assignment -> And increase the Number of CALs allocated

DB2 : Add New Column in Existing Table

Example:

ALTER TABLE
                DB2ADMIN.SUMMARY_1
ADD
              QlikViewScreenName VARCHAR(70)

DB2 : Alter Column Name

Example:

ALTER TABLE
                DB2ADMIN.ESERVICES_LIST
RENAME COLUMN
                SCREEN_MODULE_NAME TO QlikViewScreenName;

QlikView : Variable with SQL Statement

table1:
LET start=Today();          //Current Date
LET end=Today();          //Current Date
SQL SelectRegistrationStatisticsByDate '$(start)' , '$(end)';


Let day1 = peek('RegistrationStatus',0,'table1');
Let day2 = peek('RegistrationStatus',1,'table1');

Let day3 = peek('RegistrationCount',0,'table1');
Let day4 = peek('RegistrationCount',1,'table1');


SQL INSERT INTO tbl_Kiosk_Statistics VALUES($(day4),$(day3));