(Martin Bach) In my previous post I showed you that Oracle’s SQL loader (sqlldr) utility has a built-in timeout of 30 seconds waiting for locked resources before returning SQL*Loader-951/ORA-604/ORA-54 errors and failing to load data.
Other News
Coalesce Partition and Subpartition
(Jagruti Jasleniya) As we saw in previous posts by just defining number of partitions we can create partitions in HASH partition or *-hash subpartitions paritioning type.
Oracle EBS 12.2 on-prem is now certified with Oracle 19c – and will become a PDB
(Mike.Dietrich) Great news – and I’m just putting the pieces together. Oracle EBS 12.2 on-prem is now certified with Oracle 19c.
Azure Data Factory Control Flow Activities Overview
(Fikrat Azizov) In these series of posts, I am going to explore Azure Data Factory (ADF), compare its features against SQL Server Integration Services (SSIS) and show how to use it towards real-life data integration problems.
Learn Angular 8 Step By Step in 10 Days – Data Binding (Day 3)
(Debasis Saha) Google released the new version of Angular, i.e., Angular 8 just a month ago. This new release of Angular contains many upgrades and new features. So, with the help of this learning series, we will explain how to learn Angular 8 from the beginning. Today in this article, we will discu
Troubleshooting Upgrading to SQL Server 2017
Troubleshooting Upgrading to SQL Server 2017 Should you have problems with upgrading to SQL Server 2017, review this troubleshooting checklist to find potential solutions. 1. Check the hardware requirements. To upgrade to SQL Server 2017, you should have the following hardware: – Intel or compatible platform with processor speed: 1.4 GHz minimum for a 64-bit x64 2.0 GHz or faster...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
With Privacy Laws Come New and Different Storage Requirements
It’s a pretty commonplace thing now to be meeting with a client and talking through their requirements, the tossing in the “what about data privacy and ownership – what are your requirements there,” question. It’s not a small thing, and it’s something that has been morphing over time. I think the morphing part comes from uncertainty and fear. Uncertainty because […]
DMV with SQL Server Service info (including the service accounts)
(Kenneth Fisher) I recently found this DMV and couldn’t wait to share.
Nested Loops Joins and Performance Spools
(Paul White) Performance spools are lazy spools added by the optimizer to reduce the estimated cost of the inner side of nested loops joins.
Creating Data Reduction Pools
(Frank Enders and Sergey Kubin) A cheat sheet approach to creating Data Reduction Pools.