SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Zora's SQL Tips

Hi! I am Zora Stalin, an IT geek and a passionate learner of technology. Besides my job as an Information Technology Analyst, I love searching and sharing new things that excite me help for others.

Archives: February 2016

A Guide for Decrypting SQL Server Database Objects


The SQL Server 2005 and SQL Server 2008 provide a new feature for encrypting data to protect it from unauthorized access or hacker’s attacks. To make the data accessible, it needs to be decrypted with the use of key or password. It is necessary to encrypt critical SQL Server… Read more

0 comments, 2,009 reads

Posted in Zora's SQL Tips on 16 February 2016

Are SQL Server 2014 Table Variables Different From Temporary Tables?

What are the Table Variables in SQL Server?

In our previous blog we have discussed How to find free space In SQL Server database. Now, in this section we will elaborate about SQL Server 2014 Table Variables. SQL Server support features that allow users to work with temporary data… Read more

1 comments, 3,455 reads

Posted in Zora's SQL Tips on 4 February 2016