Tag Archives: T-SQL

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

Case Sensitive Search in sql query

Posted on September 5, 2012 by uday arumilli

Case Sensitive Search in sql query Case Sensitive Query Search – SQL Server I have got a request to write a select query to get data by matching a column with case sensitive and I should not suppose to use … Continue reading →

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

SQL Server database mirroring with screenshots

Posted on August 28, 2012 by uday arumilli

   SQL Server Database Mirroring With Screenshots   Introduction: This post takes you through SQL Server Database Mirroring with screenshots in both the ways using T-SQL script and management studio. Also you will learn components involved in SQL Server database … Continue reading →

Posted in High Availability, SQL Server DBA | Tagged , , , , , , , , , | 14 Comments