Categories
CSSUG

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

Categories
BI

SSIS 2014 Execution 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.

Categories
Azure

Clear Procedure Cache in SQL Azure database

When we were working on performance baseline or performance improvement we might be clearing down the procedure cache to get the exact statistics of the stored procedure. Many of them are already aware how to do it in hosue SQL Server. We might be using anyone of the below command to clear the procedure cache.

Categories
CSSUG

May 2016 CSSUG Meet

After a long long break we are back in action but with short notice. This time we are with two different series. . Hope to you see you all in the meet, please pass this information to all your friends and colleagues so that we can see new faces.

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.

Thanks to Ram and Madhi for accepting the Invitations.

Facebook Group – https://www.facebook.com/groups/cssug/
WhatsApp Group – CSSUG
Hike Group – CSSUG

Send an SMS to me, Ram or Madhi to get you added to the group.

Categories
DBA

SQL Server 2016 – Truncate Table Supports Partitioning

It’s been a month after the new year started. Hope everyone is having a wonderful time.

This is my first post for this year and it’s a simple one but most of them are looking around for this option quite from SQL Server 2012.