Everyone writes about AI generating queries. Here are nine unusual ways my clients use AI with SQL Server, and I helped build every one.
SharePlex – Efficient and High Performance Replication from Oracle to Kafka
Ask a DBA what stops their dream setup: budget first, then a good tool. Here is how SharePlex replicates data from Oracle to Kafka quickly and efficiently.
Oracle to SQL Server Data Migration and Replication – Budget and ROI
Every CEO and CTO worries about budget and ROI. I look at why Oracle Enterprise Edition feels hard to leave and how migration and replication to SQL Server help.
SQL SERVER 2019 – Oracle JRE 7 Update 51 (64 Bit) or Higher is Required
Installing SQL Server 2019 CTP with all features, setup stopped me with: Oracle JRE 7 Update 51 (64-bit) or higher is required for PolyBase. I explain why it asks.
SQL SERVER – FIX: Number Data Type from Oracle Linked Sever Shown in Scientific Notation
A client saw numbers from an Oracle linked server shown in scientific notation in SQL Server. Here is the query that shows the issue and how to fix it.
How is Oracle Temporary Table Different from SQL Server? – Interview Question of the Week #133
How is an Oracle temporary table different from SQL Server temp tables? A question from our hiring interviews, with the syntax on both sides.
Oracle to SQL SERVER Migration – Triggers Used While Migration
Moving from Oracle to SQL Server is like switching phones: old habits come along. A client tuning case about the triggers used during the migration.