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

SqlServerZest.com - SQL in simple style

Suresh Raavi is a database professional, with a zest for SQL Server specializing in Administration and performance tuning. Presently, he is a Sr. SQL Server DBA at the Microsoft Products and Services IT SQL team, taking part in various challenging projects, focusing mainly on performance tuning, database development, high availability and database design. He is passionate about database technologies and "data" in general. He has earned the MCITP Database Administrator 2008, and holds a Master of Science degree in Engineering. He provides insights from the field on his blog at http://SqlServerZest.com. His hobbies includes Running and Travelling. You can follow him on Twitter @SqlServerZest

Archives: October 2013

SQL Server – Understanding Allocation Units – In Row Data, LOB Data & Row Overflow Data

Before we get started on this topic, here is a quick fact..in SQL Server 2000, there used to be hard limit on the data that can be stored in a single row, which is 8,060 bytes. So, if the data exceeds this limit, the update or insert operation would fail!…

Read more

7 comments, 992 reads

Posted in SqlServerZest.com - SQL in simple style on 14 October 2013

SQL Server – Restoring a TDE Encrypted Database to a Different Server

In this article I will show you how to restore a database that is encrypted with Transparent Data Encryption (TDE) on to a different server. Let’s use the same database ‘TDE_Test’ that we have created in the previous post HERE Restoring a database to a different SQL Instance is usually…

Read more

7 comments, 913 reads

Posted in SqlServerZest.com - SQL in simple style on 3 October 2013

SQL Server –Encrypting and Securing Native Backups Using Transparent Data Encryption (TDE)

Being part of the database engineering team, we were given a task to setup disaster recovery program for some of our SQL Servers hosting critical applications. After a few discussions, we have planned to make use of log shipping to sync data between the two data centers. This requires us…

Read more

4 comments, 700 reads

Posted in SqlServerZest.com - SQL in simple style on 3 October 2013

SQL Server – How to Copy or Export an SSIS Package Using Command Prompt Utility – DTUTIL

The command prompt utility dtutil can be very handy when we want to quickly export an SSIS package from either file system to msdb or vice-versa. For a quick demo, I created a package called “ProductPrice” uder the file system C:\packages, as shown in the screenshot below Also, I created…

Read more

3 comments, 1,377 reads

Posted in SqlServerZest.com - SQL in simple style on 2 October 2013