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