Author Archives: uday arumilli

Automate database restore procedure SQL Server

Posted on October 22, 2012 by uday arumilli

Automate database restore procedure SQL Server Make sure that the stored procedure “[dbo].[DB_Restore]” is available at Target Instance master database.  Connect to target server instance and open a new query window from SSMS Why Database Restore Automation? It reduce the … Continue reading →

Posted in SQL Scripts, SQL Server DBA | Tagged , , , , , , , , , , , , , , , | 4 Comments

How to Encrypt and Decrypt String in Sql Server

Posted on October 18, 2012 by uday arumilli

How to Encrypt and Decrypt String in Sql Server I recently got a request to obfuscate data at Dev environment.  Most of the times these kind of requests come in environments where dealing with sensitive data. We usually do dev … Continue reading →

Posted in SQL Development, SQL Server DBA | Tagged , , , , , | Leave a comment

Cumulative update package 4 for SQL Server 2012 is available

Posted on October 16, 2012 by uday arumilli

      Cumulative update package 4 for SQL Server 2012 is available How to obtain Cumulative Update 4 for SQL Server 2012 A supported cumulative update package is now available from Microsoft. However, it is intended to correct only … Continue reading →

Posted in Miscellaneous | Tagged , , , | 1 Comment