“Quick Insights” feature in Power BI

What is it? How does it work? How it can be helpful? Power BI quickly searches different subsets of your dataset while applying a set of sophisticated algorithms to discover potentially-interesting insights. Power BI scans as much of a dataset as possible in an allotted amount of time. You can run Quick Insights against a …

Continue reading ‘“Quick Insights” feature in Power BI’ »

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

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

SSRS Report is asking for Username and Password while executing

Hi all, I want to bring to your focus a very minor detail which could eat-up your time when it happens. This is the case when your SSRS report is deployed on ReportServer and you are accessing thru any application or interface e.g. SharePoint. Your SSRS report is using Integrated Security and hence no need …

Continue reading ‘SSRS Report is asking for Username and Password while executing’ »

Best Practices : Writing Stored Procedures

Hi All, I would like to share a handy list which I found today from my old collection during files clean-up. These are few quick tips that every developer should bear in mind while writing T-SQL codes particularly Stored Procedures. It’s always hard to find the best version of such list but we can definitely …

Continue reading ‘Best Practices : Writing Stored Procedures’ »

Passing Multiple Parameter Values from Parent Package to Child Package

Hi All, I would like to bring to your attention a potential improvement in SSIS. When we need to pass parameter value from parent package to child package, we mostly use “Parent package variable” configuration type in child package. But when we need to read multiple values from parent package, we need to create multiple …

Continue reading ‘Passing Multiple Parameter Values from Parent Package to Child Package’ »

Demo Site is ready with full featured “SQL Server 2012 RC0” to play with

Note: This site requires Windows 7, Windows Vista with SP1/SP2 or Windows XP wth SP3 to have the correct RDP client to use this site. Go to this site http://fs.mssalesdemos.com/, Login with your live ID. Select the “Catalog” tab. Select “New SQL Server 2012-RC0 fully integrated Demo“. The new SQL Server 2012-RC0 demo is fully …

Continue reading ‘Demo Site is ready with full featured “SQL Server 2012 RC0” to play with’ »

When my SQL table was updated???

Here is very tiny SQL query which will help you find out when the tables are modified in the SQL server database. First you try the * (get all the columns) and then choose the selected ones. — List all the tables updated in SQL Server (in desc order) Use your Database Name Select * …

Continue reading ‘When my SQL table was updated???’ »

Select records from one table which are not available in another table

Hi guys. I have seen people having hard time when they try to achieve similar functionality which is provided by “Except” keyword in T-SQL. I am talking about the case when people need to select those records from one table which are not available in another table. Well, if both these tables are in one …

Continue reading ‘Select records from one table which are not available in another table’ »