(Pinal Dave) Recently one of my blog readers contacted me and ask if I knew about wait type parallel_backup_queue. I have often got the same question during the Comprehensive Database Performance Health Check.
Community
Testing Production API Endpoints with xUnit
(Steve Smith) I’m a big fan of unit tests and integration tests and have written about them frequently. I also authored the original docs on writing integration tests in ASP.NET Core using TestHost and related types.
Database Automation with Puppet: Deploying MySQL & MariaDB Galera Cluster
(Ashraf Sharif) In the previous blog post, we showed you some basic steps to deploy and manage a standalone MySQL server as well as MySQL Replication setup using the MySQL Puppet module.
ORA-03297: file contains used data beyond requested RESIZE value
(Anuradha Mudgal) Today we are talking about the steps we use to solve the “error ORA-03297: file contains used data beyond requested RESIZE value”
SQL Server Data Masking with DbDefence
(Jeremy Kadlec) Data breaches are becoming too common place with some accounts reporting more than 1000 breaches per year with close to 50 million records exposed yearly in the financial, business, education, government and healthcare industries.
Generate And Download Excel File In Angular 7
(Faisal Pathan) In here, we will learn how we can read data from JSON using API and download it in Excel format in Angular 7.
Top SQL Server migration questions
(James Serra) Below are the top 12 questions I am seeing from customers looking to migrate on-prem SQL Server to Azure, and the blogs that I have wrote that try to answer each question (I have updated most of these blogs):
SQL Server database design best practices and tips for DBAs
(Lindsay Moore) Knowing what you want from SQL Server is probably the biggest step toward running it successfully in business applications, according to consultant Koen Verbeeck.
A (Very) Quick Intro to Cloud Computing
(Craig S. Mullins) Cloud computing refers to storing and accessing data and programs over the Internet instead of on your own computers. The “cloud” is a metaphor for the Internet.
Unit testing of ADF Application using JUnit
(Ashish Awasthi) JUnit is a unit testing package for Java language and can be used to test Oracle ADF application as ADF is built on top of the J2EE framework.