(Chris Webb) Following on from my last post on attaching manually-created Common Data Model folders in Power BI dataflows, I was asked whether defining relationships between entities in the model.json file of the CDM folder results in relationships being created between tables in a Power BI dataset.
Other News
How to get a SQL database restore history
(Rajendra Gupta) This article will review how to get information on your SQL database restore history, including the metadata in MSDB that can be queried, as well as value added tools and features to the group, sort, report and export this critical information.
Using sys.dm_db_index_physical_stats
(Hannes du Preez) Using dm_db_index_physical_stats returns size and fragmentation information for the data and indexes of the specified table or view in SQL Server.
Java 10 Immutable/Unmodifiable Stream API Collectors
(Grzegorz Piwowarek) Java 10 now allows you to collect Stream pipelines into immutable data structures.
HTTP Interceptors Are An Anti-Pattern That Create Hidden Dependencies And Unnecessary Complexity In Angular
(Ben Nadel) This morning, in my post about reporting a user’s Timezone with a custom HTTP header in an Angular application, one of my readers asked me why I was creating a custom HTTP Client instead of simply using an HTTP Interceptor to augment the outgoing HTTP headers collection.
Migrating Delegate.BeginInvoke Calls for .NET Core
(Mike) I recently worked with a couple customers migrating applications to .NET Core that had to make code changes to workaround BeginInvoke and EndInvoke methods on delegates not being supported on .NET Core.
Running Db2 Developer-C as Docker container
(Henrik Loeser) Last week I wanted to start testing some new Db2 features without going through the steps of installing that Db2 version.
Use REST APIs to access Azure DevOps (formerly VSTS)
(Gouri Sohoni) In this tutorial, you will learn to use REST APIs to connect to Azure DevOps, fetch data for work items and finally how to create work items.
Troubleshooting SQL Server 2017 backup/restore problems
Troubleshooting SQL Server 2017 backup/restore problems If you have problems with SQL Server 2017 backup/restore, review this troubleshooting checklist to find potential solutions. 1. Check that you have appropriate permissions to make backup/restore. To backup database or transaction log, you should have BACKUP DATABASE or BACKUP LOG permissions granted to you, or you should be a member of the sysadmin…...
SQL SERVER – Stretch Database – ERROR: The Provided Location is Not Available for Resource Group
(Pinal Dave) This was my first experiment with this feature called Stretch Database. I have started the wizard and encountered at the very end. Here is the error message.