pamwritings

 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 =       ...

Greetings to all the readers!! This particular mistake is a common one, even fluent English speakers do that sometimes. If you talk to someone, you are the first person and the person you talk to is the second person. Suppose your conversation is about another person or things, that is called as third person. To be frank, all these terms were like latin(something unknown) words to me till i complete my graduation 10 years back. If your discussion is about a single person or thing, about the current event, and it is time to you use 's' with verb. Example He walks. She runs. It sleeps. It rains and so on. what if your sentence is negative or question, then Negative He does not walk. She does not run. It does not sleep. Yes or No Question  Does he walk? Does she run? Does it sleep? WH Question Where does he walk? When does she run? How does it sleep?

Good wishes to all the readers!! When it comes to patta, there are two types of patta as far as i know. Type 1 If the piece of land you own is fresh, recently divided from a parent property, below method will apply. 1. Go to the nearest e-service center with Aadhar card and Registration documents. 2. They will fill up the online form for you with the details you have shared in the documents.     once application is submitted, they will give you print out or acknowledgement of your application.     Charge for this service is less than 100 Rs when i applied 3 years ago. 3. You have to get the surveyor of your land contact details. you need to check with them       for their availability to submit this acknowledgement original copy along with all the registration              history of your land.       I submitted a book of records that show registration details of the land from t...

I have had the blessing of doing Girivalam in Thiruvannamalai quite a few times. It is close to 14 km walk around the Tiruvannamalai mountain. It is unbelievable to see many aged people with ailments take part in the Giri valam without any worry, On the day of Chitra Pournami, it is amazing to witness lakhs of people doing this spiritual walk in tiruvannamalai. When you walk in the girivalam path, you will see eight small temples located in different places on the way. They are namely Vayu Lingam Niruthi Lingam Varuna Lingam Yema Lingam Indira Lingam Eesanya Lingam Agni Lingam Kubera Lingam And Finally, Annamalaiyar the main deity in the main temple Another must visit place is Ramana Maharishi Asrham. It is located in the start of the Giri Valam path in which you will see the things used by Ramanar and his meditation room. Though he passed away long back, still lot of his followers across the globe visit the place and perform meditation in the hall. Behind the Ashram, His meditation ro...