Categories
CSSUG

CSSUG January 2020 Meet

Excited to announce the first Chennai SQL Server User group meet in 2020. We are happy to see now the user group is really driven by community. Appreciate all the speakers volunteered themselves to the user group. Thanks to Madhivanan for organising and coordinating the event.

Categories
CSSUG

CSSUG November 2019 Meet

Thanks for the participants who were able to make it last month. Madhivanan managed to come up with new schedule for next month. YAY! in November we are going to meet you again with couple of topics!

Categories
CSSUG

CSSUG October 2019 Meet

We are proud to share CSSUG is getting resumed after couple of years. All the hard work and initiation is done by Madhivanan. Thanks to Madhi for volunteering and driving CSSUG event.

Categories
Troubleshooting

Dropping a Subscriber from AG Publisher

Today one of my colleague reached out to me for an help to drop a subscriber from an publisher which is participating in Always On. We seen same behavior in UI and in T-SQL statement. As a start I was looking online for help to resolve this issue. I found an KB article from Microsoft which describes this is an known issue and fixed in the below versions of SQL Server.
*) SQL Server 2016 SP2 CU1 and above
*) SQL Server 2017 RTM CU7 and above

Categories
Powershell

Batch Script to Deploy Multiple SQL files (Version 2)

I took very long break to keep the site up to date with my learning. Few years back I wrote an article to deploy multiple scripts using batch files. Refer http://sql-articles.com/scripts/batch-script-to-deploy-multiple-sql-files/ for the older version in command prompt. Thanks for all the users and lot of comments for improvements.