Setting Variables in Azure Data Factory Pipelines
(2018-Oct-15) Working with Azure Data Factory you always tend to compare its functionality with well established ETL packages in SSIS. Data...
2018-10-23 (first published: 2018-10-15)
13,917 reads
Data Adventures
Maps in Power BI. Do I really need them?
(2018-Aug-30) While preparing for a recent Power BI Toronto meetup session, I found a very valuable whitepaper on Maps in...
2018-08-30
1,100 reads
ArcGIS Maps for Power BI: Plus subscription (2nd part); What's in it for me?
(2018-July-29) My initial attempt to explore and test the ArcGIS Map paid version continued after receiving a response from the...
2018-07-29
393 reads
ArcGIS Maps for Power BI: Free vs. Paid version
(2018-July-25) I like the ESRI company slogan, "The Science of Where". Hopefully, it will help someone not to get lost in...
2018-08-14 (first published: 2018-07-25)
2,979 reads
SQL Server data flow into Excel template with Power Query function-based parameter
(2018-July-15) Your case is to create an Excel template with data extracted from a backend SQL Server database; it takes a...
2018-07-24 (first published: 2018-07-15)
2,490 reads
Power BI with Mapbox and Volcanic Ring of Fire
(2018-May-27) With recent Hawaiian volcano activity, it would be interesting to see how other similar events have shaped our Earth planet....
2018-06-06 (first published: 2018-05-27)
2,490 reads
Power BI with Maps: Choose Your Destination
(2018-May-20) A childhood dream to travel around the world fueled by reading Gulliver's Travels stories and Robinson Crusoe attempts to survive on a...
2018-05-29 (first published: 2018-05-20)
4,693 reads
Geometry Objects in SQL Server using Latitude/Longitude coordinates
(2018-Mat-31) Support for spatial geometry functions was initially introduced in SQL Server 2008 and then it was greatly improved in...
2018-03-31
3,690 reads
Power BI with different Network Visualizations
(2018-Feb-10) A few days ago Microsoft provided another update for its desktop version of the Power BI data analytical tool...
2018-02-21 (first published: 2018-02-10)
55,994 reads
Power BI with Azure Data Lake - where the water doesn't run dry
(2018-Feb-04) I've had a case working with very large data files as a source for my heat map visualizations in...
2018-02-04
715 reads
Blogs
The fundamental requirements of a reporting system
By ChrisJenkins
There are some fundamental boxes that your reporting system must tick. ✅ The figures...
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...
Check Power BI report interactions with Semantic Link Labs
It can be tedious to check what visual interactions have been configured in a...
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...
The Last Good DBCC Run
Comments posted to this topic are about the item The Last Good DBCC Run
count the number of NULLs in a row
Hi everyone I have a SP that finds the average based on 3 tables. ...
Question of the Day
The Last Good DBCC Run
I want to check when DBCC CHECKDB was last run on my Baseball database. What code should I use?
See possible answers