Displaying posts written in

November 2009

Nov
15
2009

List of Temp Tables in your SQL server

select create_date,modify_date,OBJECT_NAME(object_id) as TableName from tempdb.sys.objects where name like ‘%#%’

Nov
7
2009

Encryption in SQL SERVER using SSIS

I have been recently working on an Sql Server Encryption Project. It includes getting the data from a source and importing them into the Datawarehouse via the ETL(SSIS in this case) and then Encrypting it. I decided to blog on Encryption to share my experience. a. When you Encrypt the Data in SSIS make sure [...]