Pubudu Dewagama

R Programming – FOR loops, WHILE loop & REPEAT loop

FOR loops For loops allow a certain operation to be repeated a fixed number of times and this is opposed to the While loop where the...

R Programming – FOR loops, WHILE loop & REPEAT loop

Reviewed by Pubudu Dewagama on 10:49:00 PM Rating: 5

R functions are OBJECTS and they do calculations for you R function structure: name function (argument) {statements} # the arguments s...

R Programming – Functions & IFELSE statement

Reviewed by Pubudu Dewagama on 9:50:00 PM Rating: 5

Basic Operators:- #basic operator 2+2 2-2 2*2 2/2 sqrt(2) 2^2 2**4 10 %% 3 ...

R Programming – Operators

Reviewed by Pubudu Dewagama on 1:56:00 AM Rating: 5

Pubudu Dewagama 10:45:00 PM

In the SQL Server ajent’s job execution history stored in the msdb system database. from the below query you can get the JobID, JobName, L...

How to get SQL Server scheduled Job status from system table.

Reviewed by Pubudu Dewagama on 10:45:00 PM Rating: 5

Pubudu Dewagama 10:37:00 PM

In the Data warhousing application, we have to update Data warehouse according to the source data. In the SQL Server wecan use the Merge qu...

SQL MERGE Query to Insert, Update and delete records in the destination table

Reviewed by Pubudu Dewagama on 10:37:00 PM Rating: 5

In this post, I am going to remove the duplicates rows of the below table. Step1 :- Drag and drop the Data Flow task to Control Flow. S...

SSIS 2017 :- How to remove duplicate records using SSIS package

Reviewed by Pubudu Dewagama on 9:25:00 PM Rating: 5

The following memory and processor requirements apply to all editions of SQL Server: Memory Minimum: Express Editions: 512 MB / All oth...

How to install SQL Server 2017 on windows 10 Environment

Reviewed by Pubudu Dewagama on 9:02:00 PM Rating: 5