(Chris Webb) Recently, a new set of endpoints in the Power BI REST API for exporting Power BI reports and paginated reports to files went into public preview (see the main announcement here and the paginated reports announcement here).
Other News
PART II: Deadlock and Starvation in DBMS
Deadlock Avoidance If a database is in a deadlock, it is always better to avoid the deadlock than to restart or abandon the database. The blocking prevention method is suitable for small databases, while the blocking prevention method is suitable for large databases. One way to avoid deadlocks is to use logic that is consistent with the application. In the...
React, Axios and Redux: Asynchronously Fetch and Save Data to Local Storage
(Ahmed Bouchefra) In this tutorial, we’ll learn about many Redux concepts by creating a simple React application from scratch using React, Redux and Axios to asynchronously fetch and save data to Local Storage.
Conditional Column in Power BI
(Aveek Das) In this article, I’m going to discuss how to create a conditional column in Power BI. A conditional column is just another column that is generated based on a condition imposed on an existing column.
MySQL Security – Random Password Generation
(Olivier Dasini) When thinking about security within a MySQL installation, you can consider a wide range of possible procedures / best practices and how they affect the security of your MySQL server and related applications.
Add git tags and versioning to mark Deployments in Azure DevOps Pipelines
(damienbod) This post shows how to tag to a git repository after a successful deployment or release. The tag is created using the version number of the build. The version number can be changed or set using Nerdbank.GitVersioning.
Configuring AOP as Print Server in Oracle APEX 20.1
(Dimitri Gielis) One of the new features in Oracle Application Express (APEX) 20.1 is the integration with APEX Office Print (AOP).
Combine XML And Json Requests And Responses In ASP.NET Core Web API
(Sarathlal Saseendran) By default, ASP.NET Core Web API application supports Json data in requests and responses without any additional code. We can add simple code to support XML requests and responses in Web API.
SQL SERVER – Blocking Tree – Identifying Blocking Chain Using SQL Scripts
(Pinal Dave) When I start working on the Comprehensive Database Performance Health Check with my client, I usually have no idea where will I end up while looking for the root cause of the performance problem for my client.
Evaluating Percona XtraDB Cluster 8.0 Scaling Capabilities
(Vadim Tkachenko) Percona XtraDB Cluster 8.0 is on the final stretch before GA release, and we have pre-release packages available for testing.