All posts by VidhyaSagar

Query Editor – Azure Portal

An interesting new tool (in preview) added to Azure SQL database. Now Azure portal provides flexibility to query azure sql database from a browser!! Interesting! you can simply connect to Azure portal from any browser, view the database and then launch this tool to get connected to the database.  When you are in support this is nice to have feature. If you are not in front of your system you can connect to the database to perform health, connectivity check etc. Continue reading Query Editor – Azure Portal

Always Encrypted – An Over View – Part 1

Always encrypted is a new feature introduced to encrypt the  in rest as well as during transport. It’s been quite long time the feature has been released to general public. In this encryption method the encryption will be done at the client side. Encryption keys can be stored in Azure vault, Windows certificate store in client server or in hardware module. Since the encryption keys doesn’t sit in the database engine it doesn’t reveal the actual data and even this is applicable for an administrators.  Continue reading Always Encrypted – An Over View – Part 1

March 2017 CSSUG Meet

We are back in action for next month. Thanks to all the participants who visited last event.

We are pleased to update you all that this month UG is scheduled on 04th March 2017. Thanks to Guna and Madhi for volunteering themselves for this month UG. Now we have a new speaker Hari , who is an certified trainer & a database consultant.  Welcome Hari, we hope you will continue with your great sessions every month.

All CSSUG members please register at www.sqlpass.org and select Chennai SQL Server user group as your chapter to get benefited from content and notifications about the event in CSSUG.

Facebook Group – https://www.facebook.com/groups/cssug/
WhatsApp Group – Join Group by Yourself

Continue reading March 2017 CSSUG Meet

February 2017 CSSUG Meet

Happy New Year wishes to everyone. Hope it will be another great year to all.

We took a long break in 2016 and back in action. We are pleased to announce the first UG meet in 2017 will be held on 04th of February. Thanks to Madi and Guna for volunteering them self as a speaker.  Request everyone to share this with your friends and colleagues to make use of this event.

All CSSUG members please register at www.sqlpass.org and select Chennai SQL Server user group as your chapter to get benefited from content and notifications about the event in CSSUG.

Facebook Group – https://www.facebook.com/groups/cssug/
WhatsApp Group – Join Group by Yourself

Continue reading February 2017 CSSUG Meet

SSIS 2014 Exectuion Error while validating Script Component

It’s been so long after my last article. Looks like I been lazy for few years now 🙂

I assume lot of people using  SSIS package deployment utility after they support project deployment model. I always use the ispac for easier deployment though it doesn’t support environments variables in deployment. Today we deployed a project to our environment which contains new package and no modifications to the existing packages were made. New package worked fine but some of the old packages started failing, I checked internal versions of the package and couldn’t find any changes. Errors were happening in Script Task. Continue reading SSIS 2014 Exectuion Error while validating Script Component