What is SSIS? SQL Server Integration Services(SSIS) is a platform that performs wide range of data integration and data transformation tasks. SSIS is a component of Microsoft SQL Server and is the evolution of a SQL Server module previously called Data Transformation Services (DTS). SSIS features a data warehousing tool that allows to develop data … Continue reading SSIS and its Uses
Difference between OLTP and OLAP
What is OLTP? OLTP stands for On-line Transaction Processing involves frequent data updates containing more current data and limited historical data. OLTP represents considerable amount of short on-line transactions (INSERT, UPDATE, DELETE). It includes itemized day to day transaction data that keeps changing on daily basis and widens the customer base by simplifying the individual … Continue reading Difference between OLTP and OLAP
Sample Solution for Creating Stored Procedure using Search, Sort and Pagination with Parameters
CREATE PROCEDURE SP_OwnersListing ( @OwnersId int = NULL ,@SearchString nvarchar(max) = NULL ,@SortString nvarchar(max) = ' ' ,@PageNumber int = 1 ) AS BEGIN DECLARE @OLSortString nvarchar(max), @PageSize int SET @OLSortString = @SortString SET @PageSize = 10 SET @SearchString = LTRIM(RTRIM(@SearchString)) SELECT Owners.Id As OwnerID, RL.PropertyId, RL.Id As ListingId, Concat(A.Number,',',A.Street,',',A.Suburb,',',A.City)As Location, P.Bedroom, P.Bathroom, P.ParkingSpace, RL.Title, … Continue reading Sample Solution for Creating Stored Procedure using Search, Sort and Pagination with Parameters
Business Intelligence Overview
Business Intelligence also known as BI is an act of transforming raw data into meaningful information for business analysis. It is an action contributing to the growth and success of an organization. BI requires methods to collect and structure these data and present this reliable and significant information to enhance decision making process. Business Intelligence … Continue reading Business Intelligence Overview
Basic SQL Joins
Basic Joins in SQL Generally, tables are related to each other using Foreign Key constraints. Joins in SQL combines records from two related tables to retrieve the data Different types of Joins Inner Join or Join: Returns only the matching rows from both the tables Outer Join: Outer Joins are of 3 types Full Outer … Continue reading Basic SQL Joins