Analyzing David and Goliath datasets on a same chart; Dual Axis in Excel, Power BI and SSRS
[2016-May-31] Two different metrics, two different datasets, one may represent a very high value and the other one is very low....
2016-05-31
1,687 reads
Data Adventures
Power BI Box and Whisker visualization vs. Box Plot chart in SSRS
[2016-Apr-30] I don't work with box plot charts very often, however when I do then it becomes a very interesting experience. First,...
2016-04-30
4,348 reads
Excel Power Map vs. Power BI Globe Map visualization
[2016-02-02] PowerMap in Excel is a great tool with good design and comprehensive user experience. I’ve started using it about...
2016-02-09 (first published: 2016-02-02)
5,851 reads
Specifying Paths to External Items (Report Builder and SSRS) in SharePoint with PowerShell
[2015-Dec-24] My story: two SSRS items (main report and its sub-report) need to be deployed to SharePoint. Trivial task, and...
2015-12-24
1,770 reads
PowerMap with Custom Region shapefiles - Demystified
[2015-Nov-18] Today is a global GIS Day (http://www.gisday.com/) where people across the globe celebrate and promote the use of various geo...
2015-11-25 (first published: 2015-11-18)
10,597 reads
Too Big To Be Visible - SQL Server vs. Oracle data in SSRS reporting
[2015-Oct-20] A sourcing system failed to return correct results (returned value was a very high figure with double digit number...
2015-10-26 (first published: 2015-10-20)
2,270 reads
Why I still like Excel PowerPivot models in SharePoint however Tabular solutions in SSAS are better
[2015-Aug-12] It’s quite obvious that in present time there is a growing audience for all the latest changes and updates...
2015-08-12
1,290 reads
Single value filters and custom error messages in Power BI
"Let me be the one for you, otherwise we need to work on communication". Basically this was a very brief...
2015-07-27
1,121 reads
Setting specific colors for PowerView charts
I was listening for Phil Collins' "True Colors" song in my car audio this morning and it reminded me about...
2015-07-21
5,380 reads
Updating PowerPivot model and PowerView report with PowerShell
Before I start describing a problem that my PowerShell script helps to resolve, these are a few blog posts of...
2015-06-18
4,787 reads
Blogs
Seeing the Bigger Picture: How A Monitoring Tool Changed My Approach to Estate Management
By Chris Yates
When it comes to managing complex database environments, having the right monitoring solution is...
A New Word: Foilsick
By Steve Jones
foilsick – adj. feeling ashamed after revealing a little too much of yourself to...
Accelerated Database Recovery for tempdb in SQL Server 2025
Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
count the number of NULLs in a row
Hi everyone I have a SP that finds the average based on 3 tables. ...
Deleting data in large table
I have a large table with 17M+ rows for our package record audits. I've...