Identify R Package Dependencies Using miniCRAN
Installing R packages in SQL Server 2017 is a breeze with the stored procedure sp_execute_external_script. But so far, it is limited...
2018-03-20
445 reads
Blog Posts
Migrate SSRS 2017 to Power BI Report Server
UPDATE: The blog post doesn’t make this exactly clear, but fiddling around with the report database to get the upgrade...
2018-03-20 (first published: 2018-03-08)
3,892 reads
Power BI Custom Visuals Class (Module 93 – Mapbox Visual)
In this module you will learn how to use the Mapbox Visual. The Mapbox Visual allows you to visualize geographical...
2018-03-20 (first published: 2018-03-09)
2,664 reads
Validating SMO security bugs with Pester
SQL Server Management Objects (SMO) are the .NET classes underpinning Management Studio and all good PowerShell that interfaces with SQL...
2018-03-20
56 reads
# Not the GDPR News
# Not the GDPR News
Mark Williams and myself will delivering a seminar called #Not the GDPR news in Cardiff on the...
2018-03-19
377 reads
“The report server Web Portal URLs and Web Service URLs don’t match”
A client recently upgraded a server, and then started receiving this error when they tried to access the SSRS Reports...
2018-03-19
1,122 reads
Adding a Downloadable Calendar Event File to WordPress without a Plugin
Let’s say you’ll be doing an event soon — say a Facebook Live event– and you want to create a calendar reminder for folks to download. Lots of us...
2018-03-19
8 reads
Book Review: SQL Server 2017 Machine Learning Services With R
Disclaimer: I’m one of the Technical Reviewers for this book.
With the rising demand for cloud computing and wide adaptation of...
2018-03-19 (first published: 2018-03-06)
2,696 reads
GDPR – After the restore
I joined in on an interesting conversation the other day on twitter. It was about some unusual ramifications of GDPR...
2018-03-19
400 reads
Simply Debugging
Debugging is a life skill. Yes, the term comes from IT (literally removing a bug from a computer believe it...
2018-03-19 (first published: 2018-03-07)
2,061 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers