Short article on database backup options in SQL Server 2014.
Thursday, August 21, 2014
Thursday, July 31, 2014
Grouping is something we naturally do in our day to day life. We group foods depending on taste, we group friends depending on their different attributes.
Clustering is an algorithm which finds natural groupings inside your data when these groupings are not obvious. It finds the hidden variable that accurately classifies your data.
Read the article on Clustering here.
Monday, July 28, 2014
When executing a backup from a t-sql command, it is difficult to know what percentage has completed and when the backup will be complete. This FAQ tells how to do it.
Wednesday, July 23, 2014
I got this error in SSIS when I try to open Execute SQL Task.
Then I tried to open already configured Execute SQL Task in some other SSIS packages. Still the error exists. I was wondering this is an error in SQL Server 2014 so I installed SQL Server 2012 and tried but it was no difference.
So the work around is by clicking F4 and enter the configuration values in the Properties box.