(Marlon Ribunal) This is the third installment of our Getting Started With Power BI Desktop series. The first post is about installation and the second is about getting data. In this post, let’s see how easy it is to create visualization on Power BI Desktop. If you’re quite familiar with creating gr

(Pinal Dave) One of my blog readers asked me “Is there a way to extract only the number after the decimal point?”. For example, in decimal number 45.90, 45 is the precision and 90 is the scale value.

(Jason Thomas) Yesterday was a terrific day for all of Microsoft Power BI fans. Microsoft released updates for Power BI Service, Power BI Mobile and Power BI Desktop (with an unbelievable 44 new features) – which basically means no matter whether you are a developer, BI professional or an end user,

(Arshad Ali) With the recent acquisition of Datazen by Microsoft, if you have SQL Server 2008 Enterprise Edition or later with Software Assurance, you can leverage (download and use) Datazen to create visually appealing dashboards for mobile devices across all the major platforms at no additional co

(Jack Vamvas) One of my favourite utilities for Production SQL Server troubleshooting is the sp_WhoIsActive utility.

(Daniel Calbimonte) I am working on both SQL Server and Oracle databases. I know many of the concepts are the same, but I am not sure how to build the code I need to complete my daily tasks. Can you provide some insight into SQL Server vs. Oracle?

(Dwain Camps) Relational databases go out of their way to execute SQL, however bad the crimes against Codd and relational theory within the query. The ‘conditional join’, can be executed but at great cost. As always, it is much better to sit back and restate the problem in a set-based way. The resu

(Jack Vamvas) One of my favourite utilities for Production SQL Server troubleshooting is the sp_WhoIsActive utility.

(Daniel Calbimonte) I am working on both SQL Server and Oracle databases. I know many of the concepts are the same, but I am not sure how to build the code I need to complete my daily tasks. Can you provide some insight into SQL Server vs. Oracle?

(Dwain Camps) Relational databases go out of their way to execute SQL, however bad the crimes against Codd and relational theory within the query. The ‘conditional join’, can be executed but at great cost. As always, it is much better to sit back and restate the problem in a set-based way. The resu