Monthly Archives: September 2016

TSQL to generate JSON insert script for a collection with name same as sql server table

Hello, I was trying to migrate a SQLServer database to a MongoDB database with SSIS and to do this the SSIS transform expects an empty row in each collection in mongodb. I found this challenging because I had 50+ tables … Continue reading

Posted in SQL Server DBA Stuff | Tagged , , , , , , , | Leave a comment

SQL Server 2012 SE Cluster: SAN Upgrade Steps

Hello every one. Hope all is well. Its been a while since my last post. Today I am going to write about SAN upgrade for one of my test sqlserver cluster instances. I am using SQL Server 2012 SE Active … Continue reading

Posted in SQL Server DBA Stuff | Tagged , , , , , , , , | 1 Comment