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!Continue reading “CSSUG November 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.Continue reading “CSSUG October 2019 Meet”
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
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.Continue reading “Batch Script to Deploy Multiple SQL files (Version 2)”
Azure Cosmos database is one of the NoSQL database that is available in Microsoft Azure cloud platform. Azure Cosmos db is getting more popular compared to other NoSQL databases in the cloud market so many organisations started using Cosmos database with their organization. When we started incorporating Cosmos database into our project we provisioned it manually and continued with the development. Continue reading “Provisioning Azure Cosmos DB using Powershell”