Setting SharePoint Tile Background Color

<style type='text/css'>
div.ms-tileview-tile-content {
 background-color: White;
}
</style>

Remove Hyperlink for SharePoint Webparts

We use different web-parts and try to show  different lists or document library in one web-part.But we get the hyperlink for the list or document library

Solution:
Edit Web-part and go to Advance Option replace your "Title URL" with "#"

Creating View for SharePoint 2013 Survey List

1.Select Survey Settings from Settings option and copy the url from the browser

_layouts/15/survedit.aspx?List=%7B86FBDF00%2D50E1%2D4DB3%2DB605%2D2EF47EADDF90%7D

2.Replace the "Survedit.aspx" to "viewtype.aspx"

layouts/15/survedit.aspx?List=%7B86FBDF00%2D50E1%2D4DB3%2DB605%2D2EF47EADDF90%7D

Hiding the Tiles Button

/*hiding the arrow buttons */

Insert the code in script editor to hide the arrow buttons of tiles




<style>

.ms-promlink-header{

display:none;

}

</style

SharePoint Tiles in Rows and Columns

Using script editor we can use below code to display tiles in 3 Rows and Columns





<style>

.ms-promlink-body {

      width: 480px;

}

</style>

/*The Below CSS shows the Tiles in 2 Rows

<style>

.ms-promlink-body {

      width: 420px;

}

</style>

configuring the BLOB cache SharePoint Performance

BLOB cache needs to be enabled in the front end web server(IIS) and once configured; the frequent files used in sharepoint will be retrieved from the database and stored in a directory under Front end web server (IIS). This reduces the network traffic/load on the database server as the frequent files will be stored into disk .Got to WebApplication web.config file search for <BlobCache>

<BlobCache location="C:\BlobCache\14" path="\.(gif|jpg|jpeg|jpe|jfif|bmp|dib|tif|tiff|themedbmp|themedcss|themedgif|themedjpg|
themedpng|ico|png|wdp|hdp|css|js|asf|avi|flv|m4v|mov|mp3|mp4|mpeg|mpg|rm|rmvb|wma
|wmv|ogg|ogv|oga|webm|xap)$" maxSize="100" enabled="false" />

Sql Command to find product version and Edition

I was goggling for to find the current product version of Sql server several times in my environment .And I was the forget the query several times being human. So decided to save on web
SELECT
            SERVERPROPERTY('ProductVersion') AS ProductVersion,
            SERVERPROPERTY('ProductLevel') AS ProductLevel,
            SERVERPROPERTY('Edition') AS Edition,
            SERVERPROPERTY('ResourceLastUpdateDateTime') AS 'ResourceLastUpdateDateTime',
            SERVERPROPERTY('ResourceVersion') AS 'ResourceVersion' 
GO