Power BI – World Tour (7 cities across the world)

The “Power BI User Group” (PUG) is going to run the “Power BI World Tour” with access to premium Power BI content designed by your local industry experts. Starting in August, the tour will visit seven cities throughout the World. Hurry up and register before 7 August to get discounted rates for this 2 days event. …

Continue reading ‘Power BI – World Tour (7 cities across the world)’ »

Power BI Certification: 70-778 – Analyzing and Visualizing Data with Microsoft Power BI (beta)

Hi Guys, I have been waiting for an official certification from Microsoft on Power BI. And finally I saw the exam opened up. 🙂 Even though it is still marked in Beta but you can go-ahead and schedule if you want. Or you can start gearing up with necessary technical knowledge to complete the certification. …

Continue reading ‘Power BI Certification: 70-778 – Analyzing and Visualizing Data with Microsoft Power BI (beta)’ »

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 …

Continue reading ‘MERGE your knowledge from EXPERTS – “Project BOTTICELLI”’ »

The Story of Precision, Scale, and Length in SQL Server

Hi guys, Did you ever faced issues with BIG mathematical figures – related to either overflow or any  other arithmetic errors. This may be applicable to SQL arithmetic operations or arithmetic  operations you do with SQL table in SSIS etc. Well, check 1 more time, if you have any issues in your database design related …

Continue reading ‘The Story of Precision, Scale, and Length in SQL Server’ »

MSSQL: Find total records of each Table in given Database

hi guys, i wanted to do a quick post on how you can find total number of records in each table of the database. here is the script you can use: USE <Your Database Name> GO ;WITH CTE_DATABASETABLESIZE (DATABASENAME, SCHEMANAME, TABLENAME, TOTALROWS) AS ( SELECT  DB_NAME(), SCHEMA_NAME(SO.UID), SO.NAME, SI.ROWS FROM  SYSOBJECTS SO  INNER JOIN SYSINDEXES …

Continue reading ‘MSSQL: Find total records of each Table in given Database’ »

Microsoft SSAS Solution: Cube Design Considerations

Hi guys, today i read James Serra’ post – whether 1 single BIG cube is good as comapred to multiple small cubes. Check out the advantages and disadvantages with both design approaches. he made a pretty nifty list of both of these. i would also recommend you to read this post. here is the link: …

Continue reading ‘Microsoft SSAS Solution: Cube Design Considerations’ »

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 …

Continue reading ‘What is OLAP Database ? What is FASMI?’ »

Behavior Changes to Analysis Services Features in SQL Server 2012

Hi all, I would like to draw your attention to the few modifications in SSAS behaviors in SQL 2012. The most important difference you will find is the “Cube Browser”. Yes, it’s totally changed. According to Microsoft “The cube browser control that let you drag and drop fields onto a PivotTable structure in Management Studio …

Continue reading ‘Behavior Changes to Analysis Services Features in SQL Server 2012’ »

Spot/Highlight Minimum and Maximum value(s) in each row in Matrix report in SSRS :)

Hi all, How are you doing? Today I would show you; how you can highlight minimum and maximum values in an each row of matrix report in SSRS. Again, “there are lots of ways“, but that depends on what is your solution framework. If you are using standard T-SQL queries for reporting, then it’s easier …

Continue reading ‘Spot/Highlight Minimum and Maximum value(s) in each row in Matrix report in SSRS :)’ »