Tuesday, September 27, 2016

Server Date Time Setting in CWP Panel

        ,       No comments    
Solution 1:-

In CWP Panel

in website php.ini and for server mysql set in my.cnf
and also in system.starup.php ---date_default_timezone_set("Asia/Kolkata");
date.timezone = Asia/Kolkata;

===============OR====================================

Solution 1:-

Time-zone Setting in Linux in centos command


[root@s$$-$$-$$$-$$$ server1]# ln -sf /usr/share/zoneinfo/Asia/Kolkata /etc/localtime
[root@s$$-$$-$$$-$$$ server1]# date
Sat Mar 19 15:48:53 IST 2016
[root@s$$-$$-$$$-$$$ server1]#

Create short URL - Google URL Shortener

              No comments    
Google URL Shortener at goo.gl is used by Google products to create short URLs that can be easily shared, tweeted, or emailed to friends.


What is a short URL?

 URL shortening is a technique on the World Wide Web in which a uniform resource locator (URL) may be made substantially shorter in length and still direct to the required page. This is achieved by using an redirect on a domain name that is short, which links to the web page that has a long URL.


What is the site Goo GL?

 http://goo.gl/ is a URL shortener, that is it is creating short URLs that redirect you to other, usually longer, URLs. As it can be used to create a redirect to any URL out there a goog.le link it may point to malicious or otherwise unwanted software.

How do you find the URL for a website?

 Here's how to find the exact URL of an image: Click the image that you locate in the image search results. Right-click View original image or Full size, and copy the link address. Paste the URL into a file or document, so it's available when you use the URL removal tool.

SQL Server Paging of Memory Identification - PowerShell

              No comments    
This blog and powershell script was a fall out of that engagement.


param (
    [string]$SqlServerName = "localhost"
)

Add-Type -Path "C:\Program Files\Microsoft SQL Server\130\SDK\Assemblies\Microsoft.SqlServer.Smo.dll"

$SqlServer = New-Object Microsoft.SqlServer.Management.Smo.Server($SqlServerName)

foreach ($LogArchiveNo in ($SqlServer.EnumErrorLogs() | Select-Object -ExpandProperty ArchiveNo)) {
    $SqlServer.ReadErrorLog($LogArchiveNo) |
        Where-Object {$_.Text -like "*process memory has been paged out*"}
}


The output of this script would look like below:




Why is this important?

If there is excessive memory pressure on SQL Server’s memory allocations causing memory to get paged out to disk, that could be a potentially large performance impact as it invites I/O latency to memory access. It is best practice to ensure that there is enough physical memory on the machine, as well as a well-designed memory infrastructure from SQL Server so that there isn’t overcommitting of memory in order to ensure that paging is not excessive. It is recommended that reevaluation of memory allocations and/or available physical memory is taken into account in order to relieve memory pressure for the current SQL Server instance.

Interfaces in C#

              No comments    
What is Interface?

An interface looks like a class, but has no implementation. The only thing it contains are declarations of events, indexers, methods and/or properties. The reason interfaces only provide declarations is because they are inherited by structs and classes, that must provide an implementation for each interface member declared.
Why Interface come in C#?
    public class Father
    {
       
    }

    public class Mother
    {

    }

    public class Son : Father,Mother
    {
          //C# doesn’t support multiple inheritances.
    }
Implicit Interface:
interface Father
    {
        void Display();
    }

    interface Mother
    {
        void DisplayMember();
    }

    public class Son : Father, Mother
    {
        void Display()
        {
           //Implemnt Interface
        }

        void DisplayMember()
        {
            ///Implemnt Interface
        }
    }
Explicit Interface:
interface Father
    {
        void Display();
    }

    interface Mother
    {
        void Display();
    }

    public class Son : Father, Mother
    {
        void Mother.Display()
        {
            //Implemnt Interface
        }

        void Father.Display()
        {
            //Implemnt Interface
        }

     
    }
Note: 1) Interface all method should be public by default.
      2) Interface don’t have constructor.