Category Archives: SQL Server DBA

How to control windows services from SQL Server?

Posted on March 19, 2013 by uday arumilli

How to control windows services from SQL Server? For a SQL Server DBA there are scenarios where he/she needs to deal with Windows services from SQL Server when there is no direct access to Windows server and only have access … Continue reading →

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

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