Improved Online Operations in SQL Server 2014

Online indexing rebuilding was a major breakthrough from SQL Server to support users re-indexing while the clustered index (or table) and other indexes are available during the index rebuild operation.   However, in real world there are multiple issues with these online operations as it does not have much flexibility. In SQL Server 2014, there are few options included for these online operations which is discussed in this article.

Workshop on Data Mining

I will be doing the session on Microsoft.

Viewing Execution Plans While Queries are Running

Analyzing execution plans is a key tool when analyzing query performance. As most of you are aware there are two ways of analyzing query plans, namely ‘Include Actual Execution Plan’ and ‘Display Estimated Query Plan’

The Include Actual Execution Plan option will provide the execution plan after the completion of the query. However, this option is not very useful when dealing with long running queries.

Read more here

Using QUOTENAME() to Protect Against SQLInjection

This short article describes you to simple way of protecting from SQLInjection.

http://www.sql-server-performance.com/2014/using-quotename-protect-sqlinjection/

Bobby Tables: A guide to preventing SQL injection

 

Source: http://bobby-tables.com/

New Database Backup Options in SQL Server 2014

Short article on database backup options in SQL Server 2014.

Data Mining Cluster Analysis in SQL Server

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.

Report SQL Server Percentage Backup Completion and Time Completion

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.

Cannot show the editor for this task.

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.

Difference Between LEN and DATALENGTH

DATALENGTH - Returns the number of bytes used to represent any expression.

LEN - Returns the number of characters of the specified string expression, excluding trailing blanks

Output is 30, 3.

Important point to remember is is LEN function does not depend on the data type and it is storage mechanism. LEN function total depends on the number of string characters.

Output is 8 and 3.

So DATALENGTH is depends on the storage but not the LEN function.