Everyone writes about AI generating queries. Here are nine unusual ways my clients use AI with SQL Server, and I helped build every one.
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.
Oracle Number Data Types: The SQL Server Mapping Table
Oracle number data types need the right SQL Server match during a migration. Here is the full mapping as a table, and the implicit converts a safe bet of Int or BigInt caused for one product team.
Logical Architecture: Oracle and SQL Server Compared
Continuing my Oracle vs SQL Server series, I compare the logical architecture of both, using simple analogies to map what you know to what you don’t.
Comparison – Understanding Tables Between Oracle and SQL Server
Oracle and SQL Server table names can hide important differences. Compare storage, temporary-row visibility, external data and memory-focused features.