bigator

Archive for the ‘Training’ Category

MERGE your knowledge from EXPERTS – “Project BOTTICELLI”

Hi guys, I am just about to write an introduction of “Project Botticelli” for you; but they gave their introduction in very nice and precise manner so I decided to extract that and put it here for your quick reference. (Excerpt from https://projectbotticelli.com/about-project-botticelli-ltd) “Project Botticelli Ltd is a small company offering online training by business […]

bigatorJune 6, 2014 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , , , , , ,  · Posted in: Business Intelligence, Data Mining, DMX, Excel, MDX, Pivot Table, Power Pivot, SQL Server, SSAS, Suggestion, Training

Retrieving id of inserted record: What to use @@IDENTITY or SCOPE_IDENTITY() or OUTPUT

Hi guys, This seems very basic information but need to know properly. Issue: I need to find out or have the id of the records which I inserted in table. Analysis: This requirement seems very simple but there could be various cases where you would not get the correct id just by using @@IDENTITY function. Think […]

bigatorFebruary 6, 2013 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , , , , , ,  · Posted in: Business Intelligence, Free, General, Interview QA, Quick Fix, Quick Tips, Script, SQL Server, SQL Server 2012, SQLServerPedia, T-SQL, Training, Tutorial

What is OLAP Database ? What is FASMI?

Hi guys, i was reading an article and came across this term “FASMI“. i have done a little bit of RnD to find out its head & tail. This is what it means: FASMI is an acronym of “Fast Analysis of Shared Multidimensional Information“. A database when called “OLAP Database” if it satisfies following FASMI […]

bigatorSeptember 7, 2012 · bigatorKhilitchandra Prajapati · bigator3 Comments
bigatorTags: , , , , , ,  · Posted in: Business Intelligence, Data Mining, DMX, General, Interview QA, MDX, Pivot Table, Power Pivot, Query Tuning, SQL Server, SQL Server 2012, SSAS, Training, Tutorial

E-Book Gallery for Microsoft Technologies

Hi guys, good morning !!! here is the list of cool FREE E-Books from Microsoft Press.

bigatorSeptember 7, 2012 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , , , , , , , , , , , , ,  · Posted in: Business Intelligence, E-Book, Free, General, Interview QA, New Features, Quick Tips, SharePoint, SQL Azure, SQL Server, SQL Server 2012, SSIS, SSRS, Training, Tutorial, Windows


bigator