Loading Large CSV Files Using Oracle External Tables
October, 31 2022
After millions of rows, thousands of files, and hundreds of hours, we've learned a thing or two about working with big data sources, especially files...
Read More
SQL Server 2022 Backup & Restore to AWS S3-compatible Object Storage
October, 24 2022
SQL Server 2022 (16.x) is now in preview, and it introduces a bunch of new features. One of the coolest features I found is the backup and restore to...
Read More
Find the Gap
October, 14 2022
A client’s Data Guard environment fell out of sync when archive logs went missing from the standby. A number of factors played a part:
Read More
Saving an Interactive Grid Cell on Change
October, 14 2022
Have you ever been caught off guard by a co-worker that comes to talk to you about that show that everyone was watching this week and totally forgot...
Read More
Code Syntax Highlighting in HubSpot
October, 13 2022
As a developer myself, I look for code online literally every single day. One of the worst things you can find is an ill-written blog, with actual...
Read More
Provisioning an Application Server in OCI using ORDS for an Oracle Database System
September, 30 2022
In this Blog, we will be configuring an application server for APEX 22.1 using ORDS 22.2.
Read More
Configuring Linked Servers Between Two Azure SQL VMs in Different Virtual Networks
September, 19 2022
Linked Server is a very useful feature that allows you to connect to another database instance from the SQL Server Database Engine. It enables the...
Read More
Configuring an Azure Private DNS Resolver Service Using PowerShell
September, 16 2022
When you work with Azure VMs in the same virtual network, the name resolution between them is automatically made by the Azure-provided name...
Read More