Fix for index corruption issue || SQL Server 2012 Service Pack 2

ISSUE : FIX for Data loss in clustered index occurs when you run online build index in SQL Server 2012
Microsoft release...

SQL Server 2012 || Contained Database

Contained databases are the new feature in SQL Server 2012 and are defined on BOL (http://technet.microsoft.com/en-us/library/ff929071.aspx) as below :
A contained...

ColumnStore Indexe with SQL Server 2012 & 2014

ColumnStore Indexes (Run By Microsoft’s VertiPaq technology) as described by BOL (http://msdn.microsoft.com/en-IN/library/gg492088(v=sql.110).aspx) :
“An xVelocity memory optimized ColumnStore index, groups and...

Happy Anniversary!

Today, http://mssqlfun.com/ completed 2 precious years with your support & acknowledgment. It’s wonderful time enriched with fun & learning.
Please keep liking us...

Mainstream Support Ending Soon || SQL Server 2008 and SQL Server 2008 R2

Microsoft declares to release last & final service packs for SQL Server 2008 and SQL Server 2008 R2 very soon.
Mainstream Support...

SQL Server 2012 Service Pack 2 (SP2) RTM Is Now Available !

SQL Server 2012 Service Pack 2 (SP2) RTM is now available for download at the Microsoft Support site. Service Pack...

SQL Server 2014 – How to Add node to failover cluster ?

Steps for SQL Server 2014 Cluster Installation – Add Node to Failover Cluster:-
1) Lunch SQL Server Installation Center

2) Enter Product Key

3)...

SQL Server 2014 Cluster Installation Steps

Steps for SQL Server 2014 Cluster Installation :-
1) Lunch SQL Server Installation Center

2) Enter Product Key

3) Accept License

4) Check Global...

Database Backup Encryption with SQL Server 2014

A brand new & long awaited feature “Backup Encryption” along with SQL Server 2014. Microsoft reveled this upcoming feature in PASS...

How Database Mail works in SQL Server ?

Database Mail is email feature in SQL Server from SQL Server 2005 onwards. This feature used for mailing alerts, notification,...