Dear Readers Hope you all are doing well! Let's talk about Dr.Murali, Gastroenterologist, Tanjore today. In my view, he is a service minded, people-centric and highly talented Doctor I have ever met. Our experience with Dr started in the year 2015 when my father had some digestive problems. One of my uncles had been taking treatment from him for a very long time. You can understand his noble intentions just by looking at the consultation fee he is charging. It is just 50 Rs in 2015. To be frank, Others of his specialty were charging more than 200 at the same time . I asked him directly once about this low fee and he told me that many under-privileged patients from neighboring districts were travelling more than 2...
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 = ...