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)’ »

42 Languages supported in Power BI :)

Hi Guys, Have you wondered how many languages are supported in Power BI UI ? Well, why dont you try yourself ūüôā And enjoy the Self Service BI experience in your language. Please check-out more on “Supported languages and countries/regions for Power BI“. 42 Languages¬†supported (As of July 19, 2017): Arabic Basque – Basque Bulgarian …

Continue reading ‘42 Languages supported in Power BI :)’ »

Recover Backed-up query files in SQL Server Management Studio

Hi guys, I just want to share quickly very handy tip regarding your SQL query sessions. When you open SQL queries in SSMS, you generally go on and work in newly opened pane/window but sometimes dont save that work. SSMS by default saves them in the event of pre-mature closure or crash of SSMS or …

Continue reading ‘Recover Backed-up query files in SQL Server Management Studio’ »

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 …

Continue reading ‘Retrieving id of inserted record: What to use @@IDENTITY or SCOPE_IDENTITY() or OUTPUT’ »

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’ »

Tracking Down Ghost Characters: WHERE Clause Does Not Work Properly In T-SQL Query

Hi guys, I would like to share an experience with you when I was working on 1 SSIS related issue. Scenario was: I have to exclude some records from Table A by matching some keys of Table B. ¬†Table A Year Month CustomerCode <Extra Columns> 2012 JAN CX1000 ¬† 2012 JAN CX2000 ¬† 2012 JAN …

Continue reading ‘Tracking Down Ghost Characters: WHERE Clause Does Not Work Properly In T-SQL Query’ »

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?’ »

E-Book Gallery for Microsoft Technologies

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

Features Supported by the Editions of SQL Server 2012

Hi all, I ran into a nice article which has a 1 consolidated list of all the features of SQL Server 2012 Editions. You can check the details for your infrastructure and solution planning whether what you wanted/needed is supported in SQL Server 2012 or not. And if supported then which edition? Rate this post

SSRS Chart – Displaying % sign on Y axis + Displaying % sign on Data Labels

Hi guys, Today i would like to show you the little trick for your SSRS graphs. Issue: I am displaying values (percentage values) in my bar charts as “Data Labels”. But the “Y” axis of my bar char still displays value without the “%” sign. What I need: The bar chart should display the “%” …

Continue reading ‘SSRS Chart – Displaying % sign on Y axis + Displaying % sign on Data Labels’ »