Cryptography - Encrptiion - Decryption - Cipher - CipherText.

In cryptography, encryption is the process of encoding a message or information in such a way that only authorized parties can access it and those who are not authorized cannot. 

Encryption does not itself prevent interference but denies the intelligible content to a would-be interceptor. 

In an encryption scheme, the intended information or message, referred to as plaintext, is encrypted using an encryption algorithm – a cipher – generating ciphertext that can be read only if decrypted. 

Adsense - Ad units disappear

The ads stop showing because ad unit goes idle. Means it won't show up in your Adsense account unless you click the 'advanced filters' link and then select the option to show idle ad units.

The review process usually takes at least three weeks, and during that phase ads, don't show up, so relevant units are supposed to go idle (and thus disappear from default view in your account). 

If Google decide, after the review, that your site is suitable for Adsense, then they will begin to show up again. 

SharePoint - KPI Traffic Light - RAG Indicator

Copy and Paste Below


="<DIV style='font-weight:bold; font-size:24px; font-size:24px; color:"&CHOOSE(LEFT(Status,1),"Green","Red","yellow")&";'>•</DIV>"


To Center Align the contents use below


="<DIV style='font-weight:bold; font-size:24px; font-size:24px;text-align: center; color:"&CHOOSE(LEFT(Status,1),"Green","Red","yellow")&";'>•</DIV>"

NTFS Missing Free Space- Windows

Quick Solution.

The issue was Shadow Copy Storage in my case.

Run the following command on command prompt.

VSSADMIN LIST SHADOWSTORAGE

Go to step 3 below for more information.



NTFS Missing Free Space- Windows

There could be various reasons which could account for Free disk space usage calculation discrepancy.

First

check to see if your files are all actually visible with the current user account and Explorer settings.  Uncheck the “Hide protected operating system files” and select “Show hidden files and folders”.  When this is completed, look at the disk size again.


Does this accounts for the missing space No, try Step 2.


Second

Run CHKDSK and save the output.  The summary information at the end is what we want to see.

Based on above CHKDSK output we can account for metadata usage by adding up the following.

Still missing Space Yes, then Try step 3

Third)

Is Volume Shadow Copy enabled on ANY of the volumes?
Run the following command on command prompt.

VSSADMIN LIST SHADOWSTORAGE

For above output, you could see that C drive is blocking around 82 GB of disk space to store Shadow Copy on G drive.

This was the issues that I was facing.

How to get Host name and SQL Instance Name in T-SQL

Run

SELECT SERVERPROPERTY('MachineName') AS [ServerName],
       SERVERPROPERTY('ServerName') AS [ServerInstanceName],
       SERVERPROPERTY('InstanceName') AS [Instance],
       SERVERPROPERTY('Edition') AS [Edition],
       SERVERPROPERTY('ProductVersion') AS [ProductVersion],
       Left(@@VERSION, Charindex('-', @@VERSION) - 2) AS VersionName

or

SELECT @@SERVERNAME

How do I identify the particular Linux flavor via command line?

Try the below command.... It worked for me...

cat /proc/version

Once you know that you are running Red Hat for example, you can get to the point with:

cat /etc/redhat-release

Or on Debian:

cat /etc/debian_version

or in general :

cat /etc/*-release

Also you could use the following command

cat /etc/issue

T-SQL Insert Into with CTE

CTE doesn't work with Insert into in nested queries.

With AS has be the first line of query.

and Insert Into can only work if the query finally ends with Insert into clause.

Work around is to split the query in 2 parts.

Where store one set of results in Global temp table.

like

select * into ##ramit from( select * from ----) as temp;