Shalini's Knowledge Share

In my 8 years as a software engineer, I have not been in a lot of projects. 4 years in a single telecommunication project reduces that by half, and then a financial, 1 airline, 1 manufacturing and 2 healthcare projects that adds up to 6 projects total. Out of which the airline and 1 healthcare Continue reading

Following example demonstrates dimensional modelling for the following requirement of an invoicing application Requirement: A dashboard to display the following: Invoices against delivery method Number of Invoices by month Total dry Items against delivery method Total Chiller Items against delivery method Total Number of Invoices by Sales Person Following dimensions have to be used for Continue reading

There are different types of dimensional modelling, facts and dimensions. Most of the terms are quite similar and the definitions are overlapping across them.Star Schema and Fact Constellation is one such example which is explained below: 1. Star Schema Traditional dimensional modelling that has a large fact table that relates to multiple dimensions. Simple design Continue reading

Decrypt data in a column in a table residing in a MS SQL database. 1. Create a class library project 2. Write the code with a SQL Function annotation as below. namespace DecryptionProject{     public class ScriptMain    {              [SqlFunction(DataAccess = DataAccessKind.Read)]        public static String Continue reading