(Brendan Tierney) In previous posts I’ve shown how to use the DBMS_DATA_MINING.TRANSFORM function to transform data is various ways including, normalization and missing data.
Other News
Graceful shutdown of forked workers in Python and JavaScript running in Docker containers
(Maarten Smeets) You might encounter a situation where you want to fork a script during execution. For example if the amount of forks is dependent on user input or another specific situation.
SQL SERVER – What is Wait Type Parallel Backup Queue?
(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.
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.