Programming Archives - {coding}Sight https://codingsight.com/category/programming/ Blog for SQL Server DBAs and Developers Thu, 15 Jun 2023 07:46:37 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png Programming Archives - {coding}Sight https://codingsight.com/category/programming/ 32 32 Oracle Data Integrator (ODI) Tutorial: How to Import Files into Oracle Autonomous Data Warehouse (ADW) https://codingsight.com/importing-data-into-oracle-autonomous-data-warehouse-using-oracle-data-integrator/ Thu, 13 May 2021 08:25:47 +0000 http://codingsight.com/?p=13500 When you build an ETL / ELT enterprise system, you need the Data Integration tools, such as Microsoft SQL Server Integration Service, Oracle Data Integrator (ODI), Talend, etc. These tools help you to integrate, transform, and load data from the source to the destination location. The current article is the Oracle Data Integrator reference, which …

The post Oracle Data Integrator (ODI) Tutorial: How to Import Files into Oracle Autonomous Data Warehouse (ADW) appeared first on {coding}Sight.

]]> Your Ultimate Guide to SQL Join: CROSS JOIN – Part 3 https://codingsight.com/your-ultimate-guide-to-sql-join-cross-join/ Fri, 04 Dec 2020 10:30:44 +0000 https://codingsight.com/?p=11049 CROSS JOIN is in the spotlight. This article finishes our small series of SQL JOIN-related publications. If you missed the previous two articles, refer to them as follows:   Your Ultimate Guide to SQL Join – Part 1: INNER JOIN Your Ultimate Guide to SQL Join – Part 2: OUTER JOIN SQL Server CROSS JOIN …

The post Your Ultimate Guide to SQL Join: CROSS JOIN – Part 3 appeared first on {coding}Sight.

]]> DevOps Solutions for Database Development Automation https://codingsight.com/devops-solutions-for-database-development/ Thu, 21 Nov 2019 01:29:26 +0000 https://codingsight.com/?p=8229 What is DevOps? Database DevOps is a philosophy that comprises the following concepts: automating the development, deployment, documentation, testing, and monitoring processes between software developers and operations engineers integrating the development and operations processes to efficiently synchronize, validate, manage, and apply database changes The Database DevOps practice is focused on improving the efficiency of database …

The post DevOps Solutions for Database Development Automation appeared first on {coding}Sight.

]]>