Dear Readers Hope you all are doing well! This is in continuation to the post https://pamwritings.blogspot.com/2026/08/medical-capital-of-india.html . Five years ago, due to many reasons, I started feeling irritation while urinating. unfortunately, it intensified further and I immediately visited a local doctor who is supposed to be an experienced doctor with MD qualification. Later on, one medical shop revealed the truth that he is not an allopathic professional and still prescribing allopathic medicines. He told me to take the tablet he prescribed for the first 2 days, can continue if required. This is the first time I listen to an advice like this and was doubtful. After taking the tablet for 2 days, infection further worsened and I started almost bleeding, a reddish color I could see. My friend near my hom...
Greetings to all the readers!! Yes, it is possible to load 1 million of records in 1 minute time from one SQL server to another. Create an SSIS package with a Script task. Add logging for ease of debugging and make all the connections configurable to make it re-usable. In the script task, we have to use .net script given below. We can define the batch size and timeout. By Default, Identity in the destination is reset, in case you have to preserve it, amend the code accordingly. In my task, I used SQL Server 2017, SSIS 2017 and the source system is SQL 2008 R2 C# using System.Data.SqlClient; class Program { static void Main() { string connectionString = GetConnectionString(); // Open a sourceConnection to the AdventureWorks database. using (SqlConnection sourceConnection = ...